Reserved words used as column names

Forum for DBF Commander discussing.

Reserved words used as column names

Postby gcamps » Fri Jan 12, 2024 7:35 am

I have a table with a column called 'from'. Is there a way to run the following code without a message error?

UPDATE FILE_NAME SET FROM='Germany' WHERE MADE='VW'
gcamps
 
Posts: 2
Joined: Wed Jan 10, 2024 3:58 am

Re: Reserved words used as column names

Postby Admin » Fri Jan 12, 2024 9:08 pm

Yes, please use syntax as follows:
Code: Select all
UPDATE table1 SET table1.from = 'Germany' WHERE made='VW'
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 125
Joined: Wed Apr 21, 2010 7:27 pm

Re: Reserved words used as column names

Postby gcamps » Wed Jan 17, 2024 9:38 am

Thanks a lot, it worked
gcamps
 
Posts: 2
Joined: Wed Jan 10, 2024 3:58 am


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 1 guest

cron