- Mon Jun 22, 2009 5:54 pm
#3100
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
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