[duffman]

Hi

I am trying to populate a grid from an external (Oracle) database but I am having no luck. The query returns exactly the right data, and the correct number of rows are added to the grid but all the fields are blank. If I do a query from the local PM database and populate the grid using the same code then it works fine, but if I get data from the external Oracle database then all the fields are blank.

Does anyone have any ideas? I've tried every different way of doing this but still get the same result every time.

Thanks

[duffman]

The trigger looks like this...

Code: Select all

$db = '95186247251dw223d2116d6053248454'; // UID for the database connection

$result = executeQuery("select Field1, Field2, Field3 from TABLE where PARAM = 'ABC'",$db);

$i = count($result);

for ($x=1; $x<=$i; $x++){

@=GridChars[$x]['Field1'] = $result[$x]['Field1']);
@=GridChars[$x]['Field2'] = $result[$x]['Field2']);
@=GridChars[$x]['Field3'] = $result[$x]['Field3']);
  
}

[duffman]

Just tried upgrading to version 3.0.1.7 and still get the same problem.