adoquery 1

[kyriakos70]

And a last question, how can I add an edit.text as a value in an sql string?
eg 'select * from scan inner join Table1 on scan.id_2=Table1.id Where scan.id_2="edit1.text"'
I get an error invalid column name.

thank you
Kyriakos

 

[towerbase]

Try something like

'SELECT *
 FROM scan
 INNER JOIN Table1 ON scan.id=Table1.id
 WHERE scan.id_2 = ' 
+ QuotedStr(edit1.text)

Andrew
Hampshire, UK

 

[LucieLastic]

What may be a good idea is change it to uppercase. Check 'Upper' is acceptable in the database you're using

'SELECT *
 FROM scan
 INNER JOIN Table1 ON scan.id=Table1.id
 WHERE upper(scan.id_2) = '
+ QuotedStr(uppercase(trim(edit1.text)))

 

[towerbase]

Why?

Andrew
Hampshire, UK

 

[Programmer67]

what i can access to fields of database by CodeGear and then thay post to a value or array