[fratoro]

I wish to populate data in a GRID with the following:

SELECT LNITMSEQ,ITEMNMBRFROM SOP10200 WHERE SOPNUMBE = ('ORD0040966')

I cant seem to get the trigger following to work

@@Data = executeQuery('SELECT LNITMSEQ,ITEMNMBRFROM SOP10200 WHERE SOPNUMBE = ('ORD0040966')', 'DataSource1');
@@LNITMSEQ = @@Data[1]['LNITMSEQ'];
@@ITEMNMBR = @@Data[1]['ITEMNMBR'];

What should I use? The returning data is 7 records, so the grid should have 7 records after the trigger loads the data

Thanks in advance

[Arturo]

see an example of A with data from a BD.

Populat GRID with SQL ( open with. RTF )

[harsh9]

Hi, I read the above give tutorial.
But on my setup the grid is not populated.

i have created a grid , theGrid. But its name does not appear in list of @@ variables window.
When i create a' temp' field and put some value in it through trigger, it works properly.

@@theGrid=executeQuery('select fname,lname,mobile from contact'); // does not work !!

somebody please help me with a step by step guide or any possible mistake I might have made....

[harsh9]

Hey I have found a problem here.
I tried to debug and found that I have contact table in rp_workflow but PM is trying to execute the query on wf_workflow.
Can anybody help me now ??

[medveolo]

Hey,

Try to change the sql connection for the correct table.

To do this go to process map, there is a link to database connections, there you can set up which database you want to connect to