if (checkbox1.state=cbchecked)or (checkbox2.state=cbchecked) then begin add('select * from jiben_account'); add('select * from yiban_account'); add('select * from temp_account'); add('select * from zuanyong_account'); add('select * from qita_account'); add('number<>'''''); add('where (strtodate(kaihui_date)<=t2.date) and(strtodate(kaihui_date)>=t1.date) '); end; 怎麼会沒错? 你有看見這樣的sql語句嗎? add('select * from jiben_accountselect * from yiban_accountselect * from temp_account.....') 看不懂你要做甚麼,每個sql語句先要清空;再添加sql語句;再執行語句,
你的SQL不就是这样吗? 'select * from table1'+ 'select * from table2'+ 'select * from table3'+... 这样的SQL怎么会不错呀? 说出你的目的
begin
add('select * from jiben_account');
add('select * from yiban_account');
add('select * from temp_account');
add('select * from zuanyong_account');
add('select * from qita_account');
add('number<>''''');
add('where (strtodate(kaihui_date)<=t2.date) and(strtodate(kaihui_date)>=t1.date) ');
end;
怎麼会沒错?
你有看見這樣的sql語句嗎?
add('select * from jiben_accountselect * from yiban_accountselect * from temp_account.....')
看不懂你要做甚麼,每個sql語句先要清空;再添加sql語句;再執行語句,
'select * from table1'+
'select * from table2'+
'select * from table3'+...
这样的SQL怎么会不错呀?
说出你的目的