1. °³¹ß/½ÇÇà Ç÷§Æû
(1) OS :
(2) °³¹ßÅø : Delphi7
(3) »ç¿ë Database : ÇöÀç Å×½ºÆ®Áß MSSQL
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥
3. Áú¹® ³»¿ë
Insert , Update, Select ½Ã¿¡ SQL¹® ³»¿¡ Á÷Á¢°ªÀ» ³ÖÀ¸¸é ¸ðµç ¹®ÀÚ¿ÀÌ ÀúÀåµË´Ï´Ù.
¿¹¸¦µé¾î
Values := "°¡³ª´Ù¶ó";
Á÷Á¢
Update TESTDB
Set TESTFD = '°¡³ª´Ù¶ó'
¶ó°í ÇßÀ»½Ã¿¡´Â "°¡³ª´Ù¶ó" °¡ Àû¿ëÀÌ µË´Ï´Ù ¸¸
Set TESTFD = :TESTFD
Params.paramByName('TESTFD').Value := '°¡³ª´Ù¶ó';
ÇÑ°æ¿ì "°¡³ª"¸¸ Àû¿ëÀÌ µË´Ï´Ù.
Á¶È¸½Ã¿¡¼
Select * From TESTDB
Where TESTFD Like '%°¡%'
·Î Çϸé Á¶È¸°¡ µÇÁö ¾Ê½À´Ï´Ù.
±×·¡¼ Wide·Î ±æÀ̸¦ ÀνÄÇϴ±¸³ª Çؼ
Select * From TESTDB
Where TESTFD Like '%°¡%%'
ÀϺη¯ %¸¦ Çϳª ´õºÙ¿©º¸´Ï °Ë»öÀÌ µË´Ï´Ù.
°á·ÐÀûÀ¸·Î Delphi7 Àº ±âº»ÀÌ Ansi Àε¥
Params »ç¿ë½Ã Wide ·Î ±æÀ̸¦ Àüü ¹Þ¾ÆµéÀÌÁö ¸øÇÏ´Â µí ÇÕ´Ï´Ù.
ÇÁ·Î±×·¥»ó Params µµ º´ÇàÇؼ »ç¿ëÇÏ´Â ºÎºÐÀ̶ó¼¿ä
À̸®Àú¸® Size µµ Áຸ°í Params[0] À¸·Îµµ Çغ¸°í ÇÑ´Ù°í Çغ¸´Âµ¥
Ȥ ÀÌ·¸°Ô ÇϽôԵéÀº ¾î¶»°Ô ÇØ°áÇϼ̴ÂÁö ±Ã±ÝÇÕ´Ï´Ù. ¤Ð¤Ð
¿äÁò ³¯¾¾ ÁÁÀºµ¥ ÁñÄÚ~ Çϼ¼¿ä~