Page 1 of 1
Delphi 2010 exception "cannot convert type" for text field
Posted: Mon 09 Nov 2009 20:52
by jcanepa
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?
Posted: Tue 10 Nov 2009 08:29
by Plash
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.
Thanks!
Posted: Thu 12 Nov 2009 13:45
by jcanepa
Full version works as advertised. Thanks!!!
Posted: Tue 17 Nov 2009 11:53
by worldwalker
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
Posted: Tue 17 Nov 2009 12:07
by Plash
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.
Posted: Tue 17 Nov 2009 17:24
by worldwalker
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;
Posted: Wed 18 Nov 2009 10:35
by Plash
Make sure that you have installed version 1.20.0.12. Open PostgreSQL | About PgDAC in the Delphi menu and look up the version.
Posted: Wed 18 Nov 2009 11:52
by worldwalker
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