| Subject | Re: How to add to string constant? |
|---|---|
| Author | mp527 |
| Post date | 2002-11-21T04:58:14Z |
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;
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