Error of Postgresql variables

Asked

Viewed 185 times

2

I am migrating an application from Firebird to Postgresql, I was able to connect the Postgresql database with the help of Devart tool, but now whenever I try to make some access in the application there is error of format variable, follows an example of error:

inserir a descrição da imagem aqui

I looked in my Postgresql database and this variable format option FMTBcdField nor is available, if you have any idea of changing what you can do.

I was able to find out where the CODE field should be determined to be Fmtbcdfield:

inserir a descrição da imagem aqui

But when having Delete Fields to add the new ones already in the correct formats as it was suggested, the following error occurs:

inserir a descrição da imagem aqui

For what reasons this may be occurring, I have already taken the test to put the *.dll cited in the exe folder and also in the System32 folder, but the error persists, there is another possible test?

I tried to add a Sqlconnection together so I could change Clientdataset, but when I delete Fields and add new Fields when I save the changes the following error message appears:

inserir a descrição da imagem aqui

But I can’t find this link so I can edit the Fields

postgresql delphi-7

  • My friend, just as I commented there in my reply, the Sqlconnection Error is because this missing set the Connection Component in this property, which component is using for Dataset?

  • I edited the question to show that there is a link to my connection, but I can’t find this link to try to adjust the variable

  • So my dear, the solution I presented solves your problem, the one you are quoting in the last picture has nothing to do with the question, This new error is already related to another unit of your project! There he says o DataModulo CadEmpresa citado no DataModulo Database não esta adicionado ao projeto! Deseja remover a referencia? Just this, add dmCadEmpresa to the project that should stop the new error!

  • @Júniormoreira Sorry to bother you so much, but as I said I’m new to Delphi and to help this project is not mine, you could give me a help on how to add dmCadEmpresa to the project, because I thought it was already added

  • Shift-F11, search for Unit and open...

  • @I did what you asked and the following error appeared when I was adding the new Fields in some Clientdataset Acess violation at address 00A55EED in module 'designide70.bpl'. Read of adress 0000001C. What would be the reason for the mistake you could tell me

  • Let’s go continue this discussion in chat.

Show 2 more comments

1 answer

2


This is usually incompatibility of DLL (Dbexpress version), search for the DLL DBExpint look at the version, change it for an earlier one (the 6 works).

Here you can find one more solution which is to disable BCD by BDE.

If the Project is not too big you can also remove the Datasets fields (if it is a component) and add them again! So Dataset will add the Fields according to what the Provider provides.

  • I’m new in Delphi, but the project I’m working on is quite extensive, so how can I check these Datasets fields, remove them and add them again

  • Double-click Dataset (If it’s a component) it will open all fields. Select all of them and Delete, then right click... Add All Fields...

  • I did what you said and the following error appeared: SQLConnection property required for this operation

  • In the cited case the Dataset does not have a connection (connected to a Connection Component). See if it is the case of the DLL, or read the case of the BCD.

  • I believe that it is none of these cases, I did everything that was commented on but the error persists, but thanks for the help

Browser other questions tagged postgresql delphi-7

You are not signed in. Login or sign up in order to post.