PostgreSQL variable error

Question

PostgreSQL variable error

Navigation

#1 by (2 votes)

2

I'm migrating a FireBird application to PostgreSQL, I was able to connect the PostgreSQL database with the help of the Devart tool, but now whenever I try to make some access in the application there is a variable format error, p>

IlookedinmyPostgreSQLdatabaseandthisvariableformatoptionFMTBcdFieldisnotavailable,ifyouhaveanyideaofwhatyoucanchange.

IwasabletofindoutwhereitwasdeterminedthattheCODEfieldshouldbeFMTBcdField:

However,whendeletingthefieldstoaddnewonesalreadyinthecorrectformatsassuggested,thefollowingerroroccurs:

ItriedaddingaSQLConnectiontogethertobeabletochangetheCLientDataSet,butwhenIdebugthefieldsandaddthenewfieldswhenIsavethechangesthefollowingerrormessageappears:

But I can not find this link so I can edit Fields

postgresql delphi-7

asked by anonymous 24.10.2016 / 15:52

1 answer

What is the best way to use Node dependencies? How to change the position of the bitmap button?

score 2 · Accepted Answer

This is usually DLL incompatibility (DBExpress version), look for the DLL DBExpint look at the version, switch to a previous one (the one in the 6 works).

Here you can find another solution that is to disable BCD by BDE.

If the Project is not too large, you can also remove the fields from the DataSets (If it's a component) and add them again! So the DataSet will add the Fields according to what the Provider provides.