insert statment
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@
Have you tried
Insert into product values('p001' , 'ASS\'Y' , 'o');
Greg
Show quoted text
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@