Yes, I can see the public methods and propeties of the go_SQL object with Intellisense, but I cannot see the code inside those methods - so I don't know what is happening. If I am missing something - let me know.

As for your 2nd suggestion... we are already doing something very similar to that when we add records to the recordsource table, and unfortunately it does not seem to help. Thanks for the tip though.

Mike C.


>We are using the ACCPAC go_SQL api to reference both FoxPro and SQL Server tables in >this application, and unfortunately I cannot see what is happening inside of the this >go_SQL object.
>Can the go_API object be instanciated in the command window? You should be able
>to see its guts through the autocomplete feature.

>Regarding the grid - I don't know if this will solve your issue - but - one trick is >to create an [empty] cursor with the same field definitions has the source data and >then append from or SCAN / APPEND into that cursor the necessary data. WHen complete - >just zap the cursor and append/scan the next data set (this only works if your are >repitively reusing the cursor structure).