1. °³¹ß/½ÇÇà Ç÷§Æû
(1) OS : windows
(2) °³¹ßÅø : delphi6
(3) »ç¿ë Database : ¸¶¸®¾ÆDB
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥
3. Áú¹® ³»¿ë
¸¶¸®¾Æ DB¿¬µ¿À» À§ÇØ MS-SQL¿¡¼ OPENQUERY»ç¿ëÇØ ¿¬µ¿ ±îÁöÀº Çß½À´Ï´Ù.
±×·±µ¥ Where¹®¿¡¼ ¿À·ù°¡ °è¼Ó ¹ß»ýÇØ ¾î¶»°Ô ÇØ¾ß µÇ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù.
¢Ñ¼Ò ½º
¿À·ù¸Þ¼¼Áö : OWPQuery1 : Parameter 'WK_DT' not found.
with Comnhcmf.OWPQuery1 do
Begin
Close;
sql.Clear;
sql.Add('SELECT * FROM OPENQUERY(MARIADB, '' SELECT * FROM DB_OWPHEECHANG.OWP_JOBORDER WHERE WORK_PLAN_DT =:WK_DT '') ');
¿À·ù=> parameters.ParamByName('WK_DT').value := fo_date;
open;
First;
while not eof do
Begin
Table1.Append;
Table1.FieldByName('tp_stem').AsString := FieldByName('work_TEAM').AsString;
Table1.Post;
Next;
end;
end;