Postgres and Views and Lazarus

[cpalx]

hello

i dont know how to make it work

i made a view in postgresql (create view Qty where ...) and then i make a select (select a,b,c from Qty), it works perfectly in Pgadmin, but when i make it in lazarus, it does not work, the error just says access violation. The sentences is in one block.

something like:  Query.Text:='create view Qty..; select a,b,c from Qty'

any ideas?

[Silvio Clécio]

I use, but with ZSQLProcessor.

Please, see this sample (with tables, but, is same):

http://www.silvioprog.com.br/downloads/MakeTablesInRuntime.zip

Good luck.