I have TIBCQuery (qPAP) that returns some partner's data, and would like to filter this data out using TVirtualQuery:
Code: Select all
select
*
from qPAP
where
(ident = :IDENT) and
(sifra <> :SIFRA)
Code: Select all
object qPAPIDENT: TStringField
DisplayLabel = 'ID za DDV'
FieldName = 'IDENT'
ReadOnly = True
FixedChar = True
end
Code: Select all
object qPAPSIFRA: TIntegerField
DisplayLabel = #352'ifra FAW'
FieldName = 'SIFRA'
DisplayFormat = '0'
end
Code: Select all
ParamData = <
item
DataType = ftString
Name = 'IDENT'
ParamType = ptInput
Size = 20
Value = 'SI30154553'
end
item
DataType = ftInteger
Name = 'SIFRA'
ParamType = ptInput
Value = 1
end>
If I use only integer parameters, I get the data, but I need to compare character data.
How do I do it?
Thanks,
Davor.