Gentlefolk,
Environment: Linux Mint 19.2, Laz 2.02, IBX 2.3.2, Firebird 3.0.....
On the open of a IBX.IBDataSet with the SelectSQL property set to
'Select A.EVENTNUM, A.EVENTGENDER, A.EVENTTYPE, ......... From E VENTDATA A where A.EVENTCOMPETITION = :EVENTCOMPETITION and A.EVENTTYPE = :EVENTTYPE order....... ';
an exception occurs.
SQL Param No. 1 (EVENTTYPE) is uninitialsed.
EVENTTYPE is varchar(3). All records in the table 'A' have EVENTTYPE with a non NUL value.
No parameters are set on the IBX.IBDataSet.
An open on IBX.IBDataSet with the SelectSQL property set to
'Select A.EVENTNUM, A.EVENTGENDER, A.EVENTTYPE,....... From EVENTDATA A where A.EVENTCOMPETITION = :EVENTCOMPETITION order.........';
works correctly with all records matching EVENTCOMPETITION displayed in a grid.
Any help/ideas/suggestions appreciated, Ian.
I reviewed the above and it prompted me to check some semi forgotten 'brilliant' code in the IBX.IBDataSetBeforeOpen routine.
Problem solved, Ian.