🚀 go-pugleaf

Thanks for your help...

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote:
>ParseSQL converts :paramname syntax into ?. AnsiString is reference counted.
>S is changed because of S = ... newS has changed because it references the
>same string. Try add
>
>newS.Unique();
>
>before calling ParseSQL().
>
>//------------------------------------------
>Regards,
>Vassiliev V. V.
>http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
>ADO.Net
>http://www.oledbdirect.com - The fastest way to access MS SQL Server,
>MS Jet (Access) and Interbase (through OLEDB)
>
>"Niyazi Unugur" <unugurn@kentkart.com.tr> �������/�������� � ��������
>���������: news:41a1f912$1@newsgroups.borland.com...
>>
>> As described in help;
>>
>> AnsiString __fastcall ParseSQL(AnsiString SQL, bool DoCreate);
>>
>> TParameters ParseSQL has the above syntax;
>>
>> Below is my sample code for testing
>>
>> ...
>>
>> AnsiString S = "SELECT * FROM tableA  WHERE p1 = :param1 and p2 = :param2
>and p3 = :param3";
>> AnsiString newS = S;
>>
>> Query->Parameters->ParseSQL(S, true);
>>
>> please debug values S and newS
>>
>> you will see both S and newS has "? ? ?" values;
>>
>> How S can changed?
>> How newS changes !!!!
>>
>> What is the problem?
>>
>> Thanks,
>>
>> Niyazi Unugur
>>
>
>