"Let me know if I'm answering something other than the question you're asking! ;)"
No, this is great - I just have a couple of questions. I am not that familar with DDE (before my time) but I will get up to speed on it if that is the only way. The questions I have are related to my current select statement below:
I currently open my connection to Goldmine (to read in the contacts) using the following:
Set oConnection = CreateObject("ADODB.Connec
oConnection.Open "DSN=Goldmine;OLE DB Services=-2"
I then open a second connection to the external database and run the select statement on a table in the second database:
Set oConnection = CreateObject("ADODB.Connec
oCon
For lCnt = 1 To UBound(asFName)
sSQL = "SELECT * FROM Customer WHERE FirstName <> '" & asFName(lCnt) & "' and LastName <> '" & asLName(lCnt) & "'"
Set oRecordset = CreateObject("ADODB.Record
oRecordset.CursorType = 2
oRecordset.LockType = 3
oRecordset.Open sSQL, oConnection
To get the values from Goldmine to compare to the second database I use vb form that is populated with contact information from Goldmine into textfields on the form - these fields assign values to variables used to write Goldmine data to the second database.
So would I use the select statement ("select company,contact,address1,c
I will review the API documentation - thanks for the quick response.
by: stevengraffPosted on 2009-09-18 at 12:32:32ID: 25369218
You need a query like:
select company,contact,address1,c
And the only way I know of to get the current record's accountno is to use a dde function. I apologize if I'm just repeating what you already know, but I don't see any way around it. As far as firing off the dde command to fetch the current record's accountno, it's pretty well documented in the GoldMine API. Let me know if I'm answering something other than the question you're asking! ;)