Query1.SQL.Add('SELECT * FROM ZHAOWEI.BZGZ where NN = ''' + Form1.Query1.FieldByName('BH').AsString+''' and workdate=''' + DateToStr(now)+ ''' ');
//这样试试~嘿嘿~ where NN = ''' + Form1.Query1.FieldByName('BH').AsString+'''and workdate=''' + now+ ''' '
Query1.SQL.Add('SELECT * FROM ZHAOWEI.BZGZ where NN = ''' + Form1.Query1.FieldByName('BH').AsString+''',workdate=''' + formatdatetime('yyyy-mm-dd hh:mm:ss',now)+ ''' ');
哦,看错了, Query1.SQL.Add('SELECT * FROM ZHAOWEI.BZGZ where NN = ''' + Form1.Query1.FieldByName('BH').AsString+''' and workdate=''' + now+ ''' ');
真晕,这个是delphi里的语法,在sql里当然同不过了.把值先取出来,在写进去查
where NN = ''' + Form1.Query1.FieldByName('BH').AsString+'''and workdate=''' + now+ ''' '
Query1.SQL.Add('SELECT * FROM ZHAOWEI.BZGZ where NN = ''' + Form1.Query1.FieldByName('BH').AsString+''' and workdate=''' + now+ ''' ');