Relative Content

Tag Archive for sqldelphi

Append string along with single quotes to create SQL query?

var strng,value,UserName : WideString; Query : Smplquery; begin strng := ‘table’; value := ‘column’; Username := ‘CN=ABC[EXT] XYZ, AB=HELLO EFG,AB=SDRTY0045,AB=DW,AB=BNKM,HB=SWCD,HB=4QW,HB=PKL’; Query := CreateSmplquery(); Query.SelectStatement:= format(‘select * from %s where CONVERT(VARCHAR,%s’+’) = (select convert(varchar,%s’+’))’,[strng, value, UserName]); Query.Run; end; On compiling this query in the Delphi IDE, an error occurs as this is creating a query as […]