ODBC with FileMaker

[Jack]

I have to write to a Filemaker database.
I install the ODBC driver from Filemaker and make some test with SQL .
The questions are :
How to know the number of record with a select clause :

oODBC := TOdbc():New("NEPHRO", "admin", "123")

oDbf := oOdbc:execute("SELECT IPP FROM PATREC where IPP='25' )
How to check the number of records ??


oDbf := oOdbc:execute("INSERT INTO test (NOM,PRENOM) VALUES ('TEST SQL','essai')" )
How to check that the INSERT is properly executed ?

Thanks

[Antonio Linares]

Jack,

You should use ADO to manage it.

There are many ADO examples in these forums. Please make a search for "ADODB.Connection", thanks

[Jack]

Antonio,
Do you mean it is better to use ADO in place of ODBC ?
Why ?
Is ADO faster or more robust ?

Thanks for your help .

[Antonio Linares]

Jack,

Yes, ADO is the more recent Microsoft solution:

"It is positioned as a successor to Microsoft's earlier object layers for accessing data sources"

http://en.wikipedia.org/wiki/ActiveX_Data_Objects