is this dataset table select correct"

  • Thread starter Thread starter GS
  • Start date Start date
G

GS

If I want to find in the row of "codetable" with codeTblName like
"mypattern%" and Code like "abc%"
MyDataSet.codetable.select("codeTblName like 'mypattern%' and Code like
'abc%'")

does the above have the select parameter in the correct format?
 
Short answer for this question Yes

Please note that the select statement wil return a datarow array and not a
datatable

so if yiou want to loopt through the results you can do this

for each dr as datarow in MyDataSet.codetable.select("codeTblName like
'mypattern%' and Code like 'abc%'")

--- do your stuff


next

regards

Michel Posseth [MCP]
 
thx, I will give another shot.

somehow I got nothing in dr while I do see the data in the studio preview.
Michel Posseth said:
Short answer for this question Yes

Please note that the select statement wil return a datarow array and not a
datatable

so if yiou want to loopt through the results you can do this

for each dr as datarow in MyDataSet.codetable.select("codeTblName like
'mypattern%' and Code like 'abc%'")

--- do your stuff


next

regards

Michel Posseth [MCP]

GS said:
If I want to find in the row of "codetable" with codeTblName like
"mypattern%" and Code like "abc%"
MyDataSet.codetable.select("codeTblName like 'mypattern%' and Code like
'abc%'")

does the above have the select parameter in the correct format?
Click to expand...
Click to expand...
 
Back
Top