Sample fpODBC process

Kenneth Brody kenbrody at spamcop.net
Sat Apr 13 14:22:14 PDT 2013


On 4/13/2013 9:55 AM, Richard Hane wrote:
> To all those who requested that I post a sample of my ODBC processing, here it is.
[...]
>   17  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:                                                                   ◄
>         Then: recordset = new ODBC(connection, stemp)                           ◄
>   18  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:                                                                   ◄
>         Then: odbc recordset query stemp                                        ◄
[...]

As I recall, because you passed a query to NEW ODBC(), there is no need to 
explicitly execute the ODBC...QUERY on the next line.  In fact, doing so 
causes the query to be executed twice.

-- 
Kenneth Brody


More information about the Filepro-list mailing list