Subject Re: [ib-support] Re: How to add to string constant?
Author Andrew Guts
mp527 wrote:

Well, and now do it in SQL, not Object Pascal.
Thanks anyway.

>with myquery do
>begin
>transaction.starttransaction;
>try
>sql.add('insert into table1 (field1)values (:thestring)');
>parambyname('thestring').asstring:= 'mystring'+#10+#13;
>execsql;
>transaction.commit;
>except
> if transaction.active then
> transaction.rollback;
>end;
>end;
>
>
>
>>Hello IB Support.
>>
>>I need something like that:
>>
>>insert into Table1 (Field1)
>>values ('String\n')
>>
>>I mean characters like ASCII 13 or ASCII 10. How to do that?.
>>
>>Thanks ahead.
>>
>>Andrew
>>
>>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>