If I have a master field aliased with a space and so it is double quoted then link detail query to the aliased field via a double quoted parameter to match the field I get an AV when opening query. The AV occurs in GETMEM.INC at function SysGetMem(Size: NativeInt): Pointer;
qryMaster_.SQL.Text := 'select ordernumber as "Order Number" from salesheader where ordernumber = ''SO301160''';
qryDetail_.SQL.Text := 'select linenumber as Line_No from saleslines where saleslines.ordernumber = :"Order Number"';
qryMaster_.Open; //error occurs here
qryDetail_.Open;
We have users that have written custom queries in this way and would work ok previously with FIB