ODBC Filemaker Query

Databases
17

[code] dim sql as string
dim rs as RecordSet

sql="SELECT CompanyID_kprime , CompanyName FROM Companies"
rs=FMPDB.SQLSelect(sql)
If FMPDB.Error Then MsgBox FMPDB.ErrorMessage
MsgBox str(rs.RecordCount())
rs.Close[/code]

returns nilobj

but return records in FM using this same statement now. the FROM having to be on a separate line. (syntax)

SELECT CompanyID_kprime, CompanyName FROM Companies

so i tried doing it in xojo, cause i was curious.

[code] dim sql as string
dim rs as RecordSet

sql="SELECT CompanyID_kprime , CompanyName" + EndOfLine + "FROM Companies"
rs=FMPDB.SQLSelect(sql)
If FMPDB.Error Then MsgBox FMPDB.ErrorMessage
MsgBox str(rs.RecordCount())
rs.Close

[/code]

still nadda. nilobj