🚀 go-pugleaf

In article <361871B4.EC010A8C@northcoast.com>, jelogan@northcoast.com 
says...
> I was trying to copy dBase tables into an existing Interbase database.
> My commands were 'USE CHINCPUE' , and 'COPY TO :NEWINT2:CHINCPUE'.
> DBase fields that were originally numeric(8,2) became double(8) in the 
> Interbase table. The decimal portion was lost. What was wrong? How
> should I do this operation to not lose data?
> 
> 

I think you may find 'double' means a 64-bit double precision float (8 
bytes, not 8 digits) and the table column is capable of handling the 
decimal part of numbers.  It may be the decimals got dropped in software, 
not because the table couldn't handle them.

If you have the C/S version of VdB (you must have to get the SQL 
connection) look for the conversion utility.  It should allow you to 
change proposed datatypes before conversion.

If you want to do it manually try creating the Interbase table with the 
required structure 'the hard way' with CREATE TABLE then USE it and 
APPEND FROM your dBASE table.  I think it should work, but I can't 
remember trying this exact method.  If this doesn't work you could always 
write a short prog to open both tables and step through the records, 
passing data in automem or 'ordinary' named memvars.

-- 
Paul Franks (TeamB)