Devart Forums

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

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.

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..

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

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).