Hi,
I have a problem with zquery, I execute a select for some table system, for example pg_description an error
The code is:
ZQuery3.SQL.Text := 'SELECT * FROM pg_description WHERE objoid = '+
InttoStr(relid)+' AND objsubid = 0';
I extract a valid 'relid' of other tables, and the same sentence if it runs well on phppgadmin
use postgres 8.1.4, delphi 2006 and zeos 6.6.2 rc
Someone can help me?
thanks
sorry, because my english not very good.
select error in Zquery
Moderators: gto, cipto_kh, EgonHugeist, olehs
-
- Fresh Boarder
- Posts: 3
- Joined: 01.03.2008, 02:23
Hi,
In response to the first question, this is the consultation that is sent to the server:
2008-03-02 21:25:54 cat: Execute, proto: postgresql-8, msg: SELECT * FROM pg_description WHERE objoid = 32859 AND objsubid = 0
The same query:
SELECT * FROM pg_description WHERE objoid = 32859 AND objsubid = 0
runs either from the phpPgAdmin
In response to the second question, this is the error that occurs at run time to try running the query above:
"Access violation at address 00000000. Read of address 00000000"
Carlos
In response to the first question, this is the consultation that is sent to the server:
2008-03-02 21:25:54 cat: Execute, proto: postgresql-8, msg: SELECT * FROM pg_description WHERE objoid = 32859 AND objsubid = 0
The same query:
SELECT * FROM pg_description WHERE objoid = 32859 AND objsubid = 0
runs either from the phpPgAdmin
In response to the second question, this is the error that occurs at run time to try running the query above:
"Access violation at address 00000000. Read of address 00000000"
Carlos
-
- Expert Boarder
- Posts: 158
- Joined: 06.11.2005, 01:43
-
- Fresh Boarder
- Posts: 3
- Joined: 01.03.2008, 02:23
Hi sandeep_c24,
I have made a new application, very simple, just with a ZQuery and a ZConnection, but I have got the same exception again.
Could you post here your code to see if I am making any mistake? I would like you to post your code and the properties you have used in your ZQuery.
Thanks,
Carlos
I have made a new application, very simple, just with a ZQuery and a ZConnection, but I have got the same exception again.
Could you post here your code to see if I am making any mistake? I would like you to post your code and the properties you have used in your ZQuery.
Thanks,
Carlos