sql query

[abdellahmehdi 0]

get the result of a sql query in an edit

[Serge_G 87]

And question is ?

 

[Stano 143]

To take it literally: no results can be displayed during editing.

[Brian Evans 105]

There is no built-in query editor in Delphi for TDataSet descendants. Some third party components provide them and some include being able to run the query. One example is FireDac where it accessed by double left clicking or right clicking the component. The dbGo components provide no such editor.  

Edited June 8, 2022 by Brian Evans

[Serge_G 87]

2 hours ago, Stano said:

no results can be displayed during editing.

 

2 hours ago, Brian Evans said:

FireDac where it accessed by double left clicking or right clicking the component.

I didn't see it was ADOQuery until I zoom picture ! (I don't even understand how we can still use it, but I hate ADO  for a long time now) Firedac is my prefered set of database components 

[rvk 33]

First: Ieks. Extended ascii characters in a table name? I wouldn't do that.

 

Second: What is "FROM tablename := :A". Does that work in SQL?

Can you parameterize a tablename in a query in ADO?

 

Or did you mean "FROM tablename WHERE field := :A" ?

 

[Stano 143]

3 hours ago, Brian Evans said:

There is no built-in query editor in Delphi for TDataSet descendants. Some third party components provide them and some include being able to run the query. One example is FireDac where it accessed by double left clicking or right clicking the component. The dbGo components provide no such editor.  

I forgot about that. But in the editor, as I explained the question, it doesn't work.
I basically use a visual builder for SQL query text. It saves time and especially nerves