Update syntax for pSQL

[WalterHeisenberg]

Hello,

I'm hoping someone could help me out. Basically, I have been asked to run an update command for a client changing thousands of flags from off to on. The problem is, I've never used pSQL, in fact, I don't even own it! Is the syntax much different than MS-SQL? I plan to use:

 update table set field = 'on' where field = 'off'

If someone could confirm the syntax I'd greatly appreciate it. Thank you in advance.

 

[mirtheil]

That syntax looks right. I would suggest trying what you are trying then post any errors (along with the specific version of PSQL you are using).
The full syntax is available at Pervasive's web site:

http://www.pervasive.com/library/docs/psql/950/sqlref/index.html

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com