Hi John.
>Thanks anyway. I'd try it with SQL passthrough, but I don't know how :)
It's really easy (much easier than using the COM API). Here's an example. This assumes you're using the dBase version of GoldMine; the SQL Server version just requires a different connection string. Change the path in the SQLSTRINGCONNECT() statement to the path for the GoldMine contact set on your system.
lnHandle = sqlstringconnect('driver=Microsoft dBase Driver (*.dbf);' + ;
'dbq=d:\program files\goldmine\common')
llOK = sqlexec(lnHandle, 'select * from contact1', 'contact1') > 0
if llOK
else
aerror(laError)
endif
>Anyway, since you have knowledge of the GMCOMApi, do you think the way I'm grabbing data seems safe enough, anyway? Thanks again,
My knowledge of the GMCOMAPI is fairly limited, since I normally use ODBC.
Doug