Importing of data into Pervasive table

[hedgracer]

I am running Pervasive 2000i. I have set up a table with data types of char, decimal and double. The char data imports just fine but the decimal and double data will not import. I am trying to import using the import wizard and am importing using a standard comma delimited text. Any suggestions? Thanks.

Dave Christman

 

[Pervasivite]

I would download the SDK or SDK docs from Pervasive's site and check the definitions for Decimal and Double in both the ODBC reference (or the SQL ref) and how that matches up with the Btrieve data type because I suspect that there may be some mismatch between what you are importing and what the engine is expecting. Are there any errors that you see? You should also contact Pervasive support for that if you haven't used up your 30 days complementary support - or maybe even if you have. You can also use Pervasive's DevTalk forum to run this across several PVSW employees.

Pervasivite