Devart Forums

Hello, sorry for late reply; the mail with sample is on your way.
Thank you!

Hello, after upgrading from 3.5.7 to 3.7.10 I am having troubles with accentuated characters.
Settings of my postgresql 9.5 database are encoding UTF8 and locale C.
If for example in my database I have character à it is retrieved as  Ã
I've done some tests and write operations are not affected, only retrieval.

Reverting back to previous release solve the issue.

Please let me know if you need more details to reproduce.

Thank you.

Hello,

someone tested if this behaviour does affect recent versions of plain simple pgdac too?

great! thank you

Hello,

does the current version of driver works with PG 9.4?
thanks...

That was!! I was convinced I've already installed the hotfix, but was in another virtual machine.... All ok now, thanks a lot...

Hi all,

I've tried to setup pgdac latest release 3.5.9 on my XE2 installation (all upgrades and hotfixes applied). But trying to start Delphi it does tell me that is unable to upload dlcpgdac160.bpl because fmx163.bpl is missing (???). So I uninstalled 3.5.9 and I tried installing previous release 3.2.8 but I obtained the same error.
What's wrong???

Everything can be done... simply it does cost me too much effort... uninstall and reinstall all the components etc... no thanks, I wait next build of pgdac... next time before experimenting myself is better I wait a little bit and let someone else do the test for me....

...I have no alternative but to wait... sorry no money to upgrade right now, and this hotfix cannot be rolled back (it's clearly stated in readme)..... I hope this post can be useful for someone else, at least.....

Hi,

I've installed the Delphi XE2 4.1 hotfix, but now when I start the IDE it does complain that dacfmx160.bpl, dclpgdac160.bpl and pgdacfmx160.bpl should be recompiled; I think a new recompiled release of PgDac is required... too bad hotfix cannot be installed, so the new release is pretty urgent

Thanks...

That was!!! Thanks a lot

Hello, this is the first time I try to use macro, but I'm having a problem...

sql of a pgquery component is declared this way:

select * from table where field in &IN

then in code I prepare my string like this: S := '(1, 2, 3)' and assign S to the macro with pgquery1.macrobyname('IN').AsString := S

but when I try to open pgquery1 I receive an error.

Looking through dbmonitor I can see that macro get quoted inside SQL statement, so what is passed to postgresql is:

select * from table where field in '(1, 2, 3')'

I've tried to assign macro with AnsiDequotedStr(S) but (as I expected, by the way) didn't work.

Thanks for help......

dear sirs,

here's what I've found:

environment:

postgresql 9.1; database UTF-8
D2006 w all patches; last release of dbexpress driver used

Issue found:

updating a table using parametrized query if there’s a text field to update all goes well if the parameter is set to null or some non-empty string;
if the parameter is set to empty string we receive error ‘insufficient data left in message’in case of unicode on in connection; access violation if unicode is off (but probably because of twidememo datatype in param, didn’t check with ftmemo simple)

In case you need more details pls ask me

to speed up things I've already sent test case zipped file to alexp..

best regards
Roberto Icardi

Thanks for the answer.. There's a sqlmonitor in my app, in fact, but I think it was inactive. I'll take a look..

Hello,

error in subject is what I see at every db operation. This error is visible only while debugging (directly launching the application the error is probably
trapped inside driver and not seen outside). Honestly today is the first time
I see this error...
Rather annoying, I ended up telling Delphi to ignore that exception class...
But I'd like to know where does come from...

My environment: Delphi 2006 and Postgres 8.3 last release of driver.

Thanks!