Delphi 2010 exception "cannot convert type" for text field

jcanepa · Post by **jcanepa** » Mon 09 Nov 2009 20:52

Using PostgreSQL 8.3.3
Delphi 2010
PGDatatype: text

Using the evaluation version of pgDAC 1.20

I keep getting "cannot convert type" when I try to post a memo field.

Any ideas?

Plash · Post by **Plash** » Tue 10 Nov 2009 08:29

This is a bug of Trial version. It doesn't exist in non-Trial versions. We'll fix this problem in the next PgDAC build.

jcanepa · Post by **jcanepa** » Thu 12 Nov 2009 13:45

Full version works as advertised. Thanks!!!

worldwalker · Post by **worldwalker** » Tue 17 Nov 2009 11:53

I installed the latest version and I still have the same error.
PgDAC 1.20.12 Trial
D2010 Pro
Note that I didn't uninstall the older version of pgDAC 1.20.11 cause I don't want to loose my trial period.
Do I have to do a fresh install? If yes will I loose my trial period?
Thanks for your reply

Plash · Post by **Plash** » Tue 17 Nov 2009 12:07

I cannot reproduce the problem. Please describe how to reproduce it.

If you didn't uninstall the older version, the new version overwrites the files. So you have the same result as if you have uninstalled the old version. The trial period will not be changed in any case.

worldwalker · Post by **worldwalker** » Tue 17 Nov 2009 17:24

it happens everytime I try to edit or post to a ByteA whether it's text or binary, if I query the table from commad prompt I could load the data and in this case I can only delete it using PgDAC in my app, here a sample code i'm using
Query.Active := True;
BlobField := Query.FieldByName(sFileClass) AS TBlobField;
try
Query.Edit;
BlobField.LoadFromStream(fs);
Query.Post
finally
fs.Free;
end;

Plash · Post by **Plash** » Wed 18 Nov 2009 10:35

Make sure that you have installed version 1.20.0.12. Open PostgreSQL | About PgDAC in the Delphi menu and look up the version.

worldwalker · Post by **worldwalker** » Wed 18 Nov 2009 11:52

Hello,
Yes sure I did that it's 1.20.0.12, I recompiled the PgDacDemo (It didn't work with the older version) and now it's working fine the "Pictures demo", don't know what's wrong with my code.
Thank you anyway