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).