the word "update"

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 456,559 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,457 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 932 | Replies: 0

•

Join Date: Oct 2007

Posts: 1

Reputation: ddezwart is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ddezwart

Offline

Newbie Poster

the word "update"

Oct 23rd, 2007

I am using SQL to write to an MS Access db via JDBC. Whenever the word or word-portion "update" occurs within a text string I am trying to store, I get an error message that "update" is a reserved word, even though it has been correctly delimited (such as 'xxx ... udated ...xxx'). I have no trouble with other reserved words contained within text strings and also no trouble writing to an Oracle DB. To overcome the problem, I perform a checkWord function and insert a hyphen (viz. up-date); it greatly complicates things as this affects off-sets and I need to keep a count of the number of hyphens inserted.

Can anyone explain why this happens?