Thread: psqlODBC

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