Topic: hello Dmitriy..

i am using sqlquery for report ..
here edit 1 data is not stored in these tables.. but i need edit1.text in report designer data..

SQLQuery('select p.id,'+
         'p.Pump_Name,'+
         'g.Grade_Name,'+
         'sum(hd.Delivery_Volume),'+
         'sum(hd.Delivery_Value),'+
         'Min(hd.Hose_Meter_Volume)- hd.Delivery_Volume,'+
         'Max(hd.Hose_Meter_Volume),'+
         'h.Volume_Total_Current,'+
         '(Max(hd.Hose_Meter_Volume))- (Min(hd.Hose_Meter_Volume)-hd.Delivery_Volume),'+
         'sum(hd.Delivery_Volume)-(Max(hd.Hose_Meter_Volume)- (Min(hd.Hose_Meter_Volume)-hd.Delivery_Volume)),'+
         'min(hd.id),'+
         'h.id, '+
         'strftime( "%d/%m/%Y %H:%M:%S",' +  ShiftRecord.FromTimePicker.sqlDateTime + ') AS FromTimePicker, ' +
         'strftime( "%d/%m/%Y %H:%M:%S",' +  ShiftRecord.ToTimePicker.sqlDateTime + ') AS ToTimePicker, ' +
         ''+ShiftRecord.Edit1.Text+ ' as Edit1 ' + ///// this edit box is not connected with these tables
         'from tblHoseDelivery hd,tblPump p, tblhose h,tblGrade g '+
         'where p.id = hd.id_tblPump and g.id = hd.id_tblGrade and h.id = hd.id_tblHose '+
         'and hd.Completed_TS >= '+ShiftRecord.FromTimePicker.sqlDateTime+' '+
         'and hd.Completed_TS <= '+ShiftRecord.ToTimePicker.sqlDateTime+' ' +
         'group by h.id order by p.id',Results1);

Re: hello Dmitriy..

sorry.. solved by writing like this

'"'+ShiftRecord.Edit1.Text+'" as Edit1, ' +