Insert fails from VB only when table is empty...? - Mailing list pgsql-odbc

From LaBranche, Kevin
Subject Insert fails from VB only when table is empty...?
Date
Msg-id 2A0342ED68CDD41191EF00034708357CB7DC33@KACHINA
Whole thread Raw
Responses Re: Insert fails from VB only when table is empty...?
List pgsql-odbc

I am brand new to pgsql... J  I have a VB program inserting records into a fairly simple table (without a PK) and I notice that when the table is empty I get a "row out of range" error.  This only happens when the table is empty.  If I insert a record from psql then run the program everything is fine.  Any ideas as to what may be wrong?

 

I am using ADO to connect and recordset.addnew / recordset.update to insert records.

 

Thanks,

Kevin

 

 

pgsql-odbc by date:

Previous
From: "Booth, Robert"
Date:
Subject: Access problems
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: Insert fails from VB only when table is empty...?