Postgres Pro
Downloads
Home   >   mailing lists

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

From Hiroshi Inoue
Subject Re: Insert fails from VB only when table is empty...?
Date
Msg-id 002d01c2f5a5$ce890390$0e283ddb@PbgX
Whole thread Raw
In response to Insert fails from VB only when table is empty...?  ("LaBranche, Kevin" <klabranche@co.coconino.az.us>)
List pgsql-odbc
Tree view
How do you open the recordset ?
 
regards,
Hiroshi Inoue
-----Original Message-----
From: LaBranche, Kevin

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: "LaBranche, Kevin"
Date:
Subject: Insert fails from VB only when table is empty...?
Next
From: "Sol M. Ferrer"
Date:
Subject: HELP