Uniloader(from VirtualTable to Firebird) SQL error code=-842

softwestteam · Post by **softwestteam** » Mon 01 Nov 2010 06:44

Hi,

I have a problem with Tuniloader. When I use another database like MySQL or SQLite it work's fine but when I use Firebird I get this error

Dynamic SQL error
SQL error code=-842
Pisitive value expected

I'm missing something..?

Thanks

AndreyZ · Post by **AndreyZ** » Mon 01 Nov 2010 14:28

Hello,

This is a Firebird error. It means that you are trying to input an inappropriate value for some column of the table. Please specify the Firebird table structure and the code you are using for data transfer from VirtualTable to the Firebird table.

softwestteam · Post by **softwestteam** » Mon 01 Nov 2010 14:59

It's something very simple.
This is the table structure from Firebird

CREATE TABLE TASSE (
CODFAST VARCHAR(100) CHARACTER SET NONE DEFAULT NULL COLLATE NONE,
QUANT FLOAT DEFAULT NULL,
IMPORTO FLOAT DEFAULT NULL,
ALIQUOTA FLOAT DEFAULT NULL,
DESCRI VARCHAR(100) CHARACTER SET NONE DEFAULT NULL COLLATE NONE,
TIPO VARCHAR(100) CHARACTER SET NONE DEFAULT NULL COLLATE NONE);

and the virtualtable have the same columns....

the code:
....
virtualtable_TabTasse.open;

{populate virtualtable_TabTasse}
.....

uniloader_tasse.LoadFromDataSet(virtualtable_TabTasse);
...

I change the all columns to VARCHAR and I made a small test.....I inserted in the VirtualTable a record and try to use Uniloader...but I get the same error ...

I try even with TUniTable instead TVirtualTable...but it's the same..

AndreyZ · Post by **AndreyZ** » Mon 01 Nov 2010 16:14

I couldn't reproduce the problem. Please try composing a small sample to demonstrate the problem and send it to andreyz*devart*com.

AndreyZ · Post by **AndreyZ** » Wed 03 Nov 2010 14:20

You have to put columns into the TUniLoader.Columns property. For that you can clear the TUniLoader.TableName property and set it again to TASSE (in design-time).