Using FM7 Script to Execute SQL then "parse" data

[joemullins]

Hi , I have an Execute SQL item in Script with connection to Database and then a "Select * from table"

I want then to say "if table.field=1" then Do something...

Im able to click a field within the FM table and I get Database::Field

But i want to be able to query the returned Recordset from the SQL?

Any ideas??

[transpower]

IMHO, your best bet is to use MSQUERY external to FM.