I am trying to insert a new contact via Maximizer ODBC. I keep on getting that the Client_ID does not exist in the Company table.

I then tried to a small script to see if the Company does exist in the Company ODBC table, and it does. What can be wrong?

Tobie

I dunno, the simplest case...

INSERT INTO PEOPLE ( Client_Id, Last_Name )
SELECT '040809000021010294922C' AS Expr1, 'AnotherLastName' AS Expr2

...works for me.

This VBScript works, too:

Option Explicit

Dim oCon 
Set oCon = CreateObject("ADODB.Connection")
oCon.Open("DSN=CampaignTest;UID=MASTER;PWD=control;")

Dim oCmd
Set oCmd = CreateObject("ADODB.Command")
Set oCmd.ActiveConnection = oCon

Dim RecCount

oCmd.CommandText = _
   "INSERT INTO PEOPLE (Client_Id, Last_Name) " & _
      "VALUES ('040809000021010294922C', 'YetAnotherLastName');"
oCmd.Execute RecCount
Wscript.Echo RecCount & " Contact record(s) inserted"

Set oCmd = Nothing
oCon.Close
Set oCon = Nothing

Gord, is your CampaignTest DSN use the Maximizer ODBC Driver ? We've got 8.0 Enterprise, and Im looking to fill a datagrid (.net) with data from the people table.

My understanding is that the Maximizer ODBC driver simplifies what you could otherwise do with Pervasive's ODBC driver. From the queries I've seen, Maximizer's ODBC driver is almost a go-between with Pervasive's driver.

>is your CampaignTest DSN use the Maximizer ODBC Driver ?

Yes.

>My understanding is that the Maximizer ODBC driver simplifies what
>you could otherwise do with Pervasive's ODBC driver.

The Maximizer ODBC driver is designed to manipulate Maximizer data. The Pervasive ODBC driver can manipulate Pervasive data tables but it doesn't know anything about Maximizer specifically, so it can't do things like enforce referential integrity or make changes that can be synchronized via MaxExchange.