|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|
||||||||
|
|||||||||
|
|
|
|
Company
|
|
 SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
ORACLE / DELPHI SQL passthrough technique using single
quotes. *Double quotes around the string will force Oracle
to think that the string is a column name*.
Delphi example:
procedure TForm1.Button1Click(Sender: TObject);
begin
edit1.text:='''%Uni%''';
with query1 do
begin
close;
sql.clear;
sql.add('SELECT * FROM DELPHI1.CUSTOMER C');
sql.add('WHERE C."Name" LIKE '+edit1.text);
memo1.lines:=query1.sql;
query1.open;
{
SELECT * FROM DELPHI1.CUSTOMER C
WHERE C."Name" LIKE '%Uni%'
}
end;
PUB
ORA ANY TECH
BC
|
|
||
|
|
|
|||
|
|||||
|
|
||||
 |
|||||
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 16:27:06 PST |
|||||
