the text output we see if we were using a pgsql shell, that's what I was asking if we can get it and put it into a memo box, if possible
I want to see if I can have the response also show in a Memo box
I don't think my question has to do how database components work, put perhaps more on how PostgreSQL engine works, specifically as to how it handles its output.
If I type "asdf" at the psql shell, PostgreSQL repliesERROR: syntax error at or near "asdfdf"LINE 1: asdfdf;
Ok. So I suppose your answer to my 1st question is redirect pgsql input/output. Note: have a look at the executing external processes wiki page: you could redirect the output directly to your program instead of dumping to file.However: you say you put the response from the server in a second memo box. Ok. That will be used to restrict SQL input from a user based on server response. But you already sent the SQL commands to the server???Never mind, I'm giving up - seems we just don't understand each other... no problem.
The main thing is to examine the query, by program control, BEFORE sending it.