Return to FileMaker.com
Can anyone see whats wrong with this, its returning ?
ExecuteSQL ( "Select emailAddr from dbo.suppliers where ID = ?"; ""; ""; $supplierID )
$supplierID has a numeric value.
dbo.suppliers is a shadow table using an external datasourse (MS SQL) DSN.
Any ideas? Can I use ExecuteSQL on shadow tables or do i need to use Execute SQL?
If i have to use Execute SQL how do i get the returned value into a variable? Basically im trying to get more detail about a supplier based on the supplierID value selected in a Pop Up menu.
"Select emailAddr from \"dbo.suppliers\" where \"ID\" = ?"
Retrieving data ...