Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GoldMine GMCOMApi
Message
From
23/01/2004 10:47:40
 
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00868533
Message ID:
00869886
Views:
17
This message has been marked as the solution to the initial question of the thread.
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
* do whatever
else
  aerror(laError)
* figure out what went wrong
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform