Обсуждение: insert statment

Поиск

Список

Период

Сортировка

insert statment

От

Sharon Chow

Дата:

30 августа 1999 г., 05:38:24

Hello all!

I have a insert statement and I found problem with it!

The statement is:
Insert into product values('p001' , 'ASS'Y' , 'o')
The second field of the table is ASS'Y so the compiler found it is error!
I can not change the data but wnat to change the quota ' to ~.

so the insert statement should be :
insert into product values(~p001~ , ~ASS'Y~ , ~o~ )

I can not find the seting function for this environment change!

How can I change it???
Thank You in advance!

sharon

Sharon Chow
???
Regaltronic
MIS
<sharon@

Вложения

sharon.vcf

Re: [GENERAL] insert statment

От

Gregoire Thomas

Дата:

30 августа 1999 г., 05:51:25

Have you tried
Insert into product values('p001' , 'ASS\'Y' , 'o');
Greg

Hello all!
I have a insert statement and I found problem with it!
The statement is:
Insert into product values('p001'   , 'ASS'Y'   , 'o')
The second field of the table is ASS'Y so the compiler found it is error!
I can not change the data but wnat to change the quota ' to ~.
so the insert statement should be :
insert into product values(~p001~   , ~ASS'Y~   , ~o~ )
I can not find the seting function for this environment change!
How can I change it???
Thank You in advance!
sharon

Sharon Chow
???
Regaltronic
MIS
            <sharon@

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: insert statment

insert statment

Вложения

Re: [GENERAL] insert statment