Re: [GENERAL] 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@