Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

#827017
Hi,

I would like to populate a GRID with data from a database.

The GRID form detail is as follows:
Code: Select all
ID : exchangeRateGrid
Field 1 id : ID   type: textbox
Field 2 id : date   type: date
Field 3 id : from_currency   type: dropdown   value & text : 3-character currency code
Field 4 id : to_currency   type: dropdown   value & text : 3-character currency code
Field 5 id : rate   type: textbox
Below is my sample data:
Code: Select all
Table Name : PMT_FOREX
+----+------------+---------------+-------------+-------------+
| ID | EDATE      | FROM_CURRENCY | TO_CURRENCY | ERATE       |
+----+------------+---------------+-------------+-------------+
|  1 | 2019-11-26 | ABC           | DEF         | 0.326382000 |
|  2 | 2019-11-26 | DEF           | ABC         | 3.063900000 |
+----+------------+---------------+-------------+-------------+
Note :  FROM_CURRENCY & TO_CURRENCY are 3-character currency code
Here is my trigger code:
Code: Select all
$dbConnection = 'workflow'; //set to ID of the DB Connection if using an external DB
$tableName = 'PMT_FOREX'; //set to table name

$sql = " SELECT * FROM  $tableName WHERE 1 ORDER BY ID ASC"; 
$result = executeQuery($sql,  $dbConnection); 
@@exchangeRateGrid = array();
$idx = 0;
foreach ($result as $row){
    ++$idx;
    @@exchangeRateGrid[$idx]['ID'] = $row['ID'];
    @@exchangeRateGrid[$idx]['date'] = $row['edate'];
    @@exchangeRateGrid[$idx]['from_currency'] = $row['from_currency'];
    @@exchangeRateGrid[$idx]['to_currency'] = $row['to_currency'];
    @@exchangeRateGrid[$idx]['rate'] = $row['erate'];
}
With the above, I only manage to populate Field 1 (ID). I am very sure that I have missed something here.

Please assist.

Thank you.
#827020
Hi,
Your code looks right and should work properly
Please also test the following code:
Code: Select all
$sql = " SELECT * FROM `PMT_FOREX` WHERE 1 ORDER BY ID ASC"; 
$result = executeQuery($sql); 
@=exchangeRateGrid = array();
$idx = 1;
foreach ($result as $row){
    @=exchangeRateGrid[$idx]['ID'] = $row['ID'];
    @=exchangeRateGrid[$idx]['date'] = $row['edate'];
    @=exchangeRateGrid[$idx]['from_currency'] = $row['from_currency'];
    @=exchangeRateGrid[$idx]['to_currency'] = $row['to_currency'];
    @=exchangeRateGrid[$idx]['rate'] = $row['erate'];
	$idx++;
}
https://www.youtube.com/channel/UCYiyz1 ... jMXodwH1iw
Thanks
#827021
Hi,

Thank you for helping. Sorry to inform that the code does not work as expected. I am still getting the same result.

Below is the form after the trigger executed:

Image
Img URL : https://drive.google.com/file/d/1HlqF-l ... WdRa0/view


I would also try to explore if the following could be done as an alternative to the above:
1) Use a trigger to load data and create a JSON object.
2) Iterate the JSON object and populate the GRID fields using JavaSccript

Thanks again.
Last edited by mfaisel on Wed Nov 27, 2019 1:52 am, edited 1 time in total.
#827024
Hi,

Following your suggestion, I have rename the 'date' & 'rate' fields to follwo the fields name in DB. As shown below.
Code: Select all
$dbConnection = 'workflow'; //set to ID of the DB Connection if using an external DB
$tableName = 'PMT_FOREX'; //set to table name

$sql = " SELECT * FROM  $tableName WHERE 1 ORDER BY ID ASC"; 
$result = executeQuery($sql,  $dbConnection); 
@@exchangeRateGrid = array();
$idx = 1;
foreach ($result as $row){
    @@exchangeRateGrid[$idx]['ID'] = $row['ID'];
    @@exchangeRateGrid[$idx]['edate'] = $row['edate'];
    @@exchangeRateGrid[$idx]['from_currency'] = $row['from_currency'];
    @@exchangeRateGrid[$idx]['to_currency'] = $row['to_currency'];
    @@exchangeRateGrid[$idx]['erate'] = $row['erate'];
    $idx++;
}

Still the same result as shown in this picture (https://drive.google.com/file/d/1HlqF-l ... WdRa0/view)


Here, I would also try to explore if the following could be done as an alternative :
1) Use a trigger to load data and create a JSON object.
2) Iterate the JSON object and populate the GRID fields using JavaScript


Thank you
#827029
The code has been updated
Code: Select all
$sql = " SELECT * FROM  PMT_FOREX WHERE 1 ORDER BY ID ASC"; 
$result = executeQuery($sql); 
@=exchangeRateGrid = array();
$idx = 1;
foreach ($result as $row){
    @=exchangeRateGrid[$idx]['ID'] = $row['ID'];
    @=exchangeRateGrid[$idx]['edate'] = $row['edate'];
    @=exchangeRateGrid[$idx]['from_currency'] = $row['from_currency'];
    @=exchangeRateGrid[$idx]['to_currency'] = $row['to_currency'];
    @=exchangeRateGrid[$idx]['erate'] = $row['erate'];
    $idx++;
}
However, no changes to the output.
#827034
Debug mode enabled. Belwo is the exchangeRateGrid value
Code: Select all
Array (
    [1] => Array ( 
      [ID] => 1 
      [edate] => 
      [from_currency] => 
      [to_currency] => [erate] => 
   ) 
   [2] => Array ( 
      [ID] => 2 
      [edate] => 
      [from_currency] => 
      [to_currency] => 
      [erate] => 
   ) 
)
From the debugger, I found that only 'ID' has value, the rest of the fileds have no value. Somehow the trigger did not successfully pass all values into GRID fields.

Please advise.

Hi. Have you tried to use JavaScript on your Dyn[…]

Hi Please, could you send information about the c[…]

Dashboard issue

Can you show me what you were trying to do in orde[…]

I want to make the Jalali calendar in all of[…]