運行
with sfc600c do begin
if active then close;
sql.Clear ;
sql.add('select * from RSFC600C where MOVE_TYPE='601'
and DOCU_DATE>=TO_DATE('2003/8/9','yyyy/mm/dd') and DOCU_DATE<=TO_DATE('2003/9/9','yyyy/mm/dd') ');
open;
end;出現capability not suproted 究竟是甚麼問題阿
在數局庫執行語句
select * from RSFC600C where MOVE_TYPE='601'
and DOCU_DATE>=TO_DATE('2003/8/9','yyyy/mm/dd') and DOCU_DATE<=TO_DATE('2003/9/9','yyyy/mm/dd')
沒有問題阿如何解決阿
with sfc600c do begin
if active then close;
sql.Clear ;
sql.add('select * from RSFC600C where MOVE_TYPE='601'
and DOCU_DATE>=TO_DATE('2003/8/9','yyyy/mm/dd') and DOCU_DATE<=TO_DATE('2003/9/9','yyyy/mm/dd') ');
open;
end;出現capability not suproted 究竟是甚麼問題阿
在數局庫執行語句
select * from RSFC600C where MOVE_TYPE='601'
and DOCU_DATE>=TO_DATE('2003/8/9','yyyy/mm/dd') and DOCU_DATE<=TO_DATE('2003/9/9','yyyy/mm/dd')
沒有問題阿如何解決阿
然后再format(['2003/8/9','2003/9/9'])
大概就这样吧
and DOCU_DATE>=TO_DATE('2003/8/9','yyyy/mm/dd') and DOCU_DATE<=TO_DATE('2003/9/9','yyyy/mm/dd') ');delphi在sql中,您的 '' 用兩個表示一個
sql.add('select * from RSFC600C where MOVE_TYPE=''601''
and DOCU_DATE>=TO_DATE(''2003/8/9'',''yyyy/mm/dd'') and DOCU_DATE<=TO_DATE(''2003/9/9'',''yyyy/mm/dd'') ');就ok了.