psqlODBC - Mailing list pgsql-bugs

From mbreneiser@whgrp.com (Marc Breneiser)
Subject psqlODBC
Date
Msg-id 001801c1b706$591723a0$c901a8c0@whg01
Whole thread Raw
List pgsql-bugs
I created a temporary table using a procedure called from VB.  The table co=
ntains int8 and text data.  I display the data contained in the temporary t=
able using a datagrid with the datasource set to a recordset that is opened=
 through code (no data control or data environment used).  The problem I ha=
ve is if I try to edit the data in the datagrid the int8 values are read as=
 text with trailing spaces and causes an error.  This does not happen when =
I use a permanent table.  The work around I have is to create the temporary=
 table using varchar datatypes instead of int8 and it works fine (a little =
extra manipulation when updating the permanent table with the temporary dat=
a).  I did not know if this was a known problem.

Marc Breneiser

pgsql-bugs by date:

Previous
From: "Chuck Handshy"
Date:
Subject: Possible Bug
Next
From: Alain Picard
Date:
Subject: Postgresql 7.1.3 not thread safe