I created a temporary table using a procedure called from VB. The
table contains int8 and text data. I display the data contained in the
temporary table 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 have 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
data). I did not know if this was a known problem.
Marc Breneiser
|