Insert fails from VB only when table is empty...?

From: "LaBranche, Kevin" <klabranche(at)co(dot)coconino(dot)az(dot)us>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Insert fails from VB only when table is empty...?
Date: 2003-03-28 20:45:06
Message-ID: 2A0342ED68CDD41191EF00034708357CB7DC33@KACHINA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I am brand new to pgsql... :-) 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-03-29 03:46:39 Re: Insert fails from VB only when table is empty...?
Previous Message Epperson, Wade 2003-03-28 20:36:26 FW: errors syncing postgresql with pocketpc database