View Single Post
  #5 (permalink)  
Old June 28th, 2009, 02:56 AM
peace95 peace95 is offline
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Willemt:

Just by "eyeballing" your update statement, I have a couple of suggestions:
  1. Oracle recognizes "||" for concatenation;
  2. Did not see the "FROM" keyword in UPDATE statement;
  3. Not knowing your Scheme Definition for field BSN, if BSN is character, it needs to be enclosed in single-quotes '12345'.
Remember to write your SELECT statement for ORACLE using Delphi, not the other way around. Just a suggestion.

Hope this helps.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Last edited by peace95; June 28th, 2009 at 03:02 AM..