Clay, a few quick syntax helpers;
1. At the R> prompt type "Help command name" and it will take you right to the
help screen for that command.
Example R> Help UPDATE
2. The <F5> key will template the command at the R> prompt, in the RBeditor
and also in the Entry Exit Procedures.
Examples:
UPDATE<F5> (no space between the command and the <F5>) will return
UPDATE [tblview] SET [colname] = [value]
DECLARE<F5> will return
DECLARE [cursor name] SCROLL CURSOR FOR SELECT [clause]
OPEN [cursor name]
WHILE SQLCODE <> 100 THEN
FETCH C1 INTO [varname] INDICATOR [ind_var]
IF SQLCODE = 100 THEN
BREAK
ENDIF
ENDW
DROP CURSOR C1
Just modify the template with your database information,
Jim
>>> "Clay Eisenbrand" [EMAIL PROTECTED]> 8/22/2008 3:45 PM >> ( mailto:[EMAIL
>>> PROTECTED]> )
1) Instead of...change column to value in table where column eq value
I used.........update column to value in table where column eq value
and software said "syntax is incorrect for the command UPDATE.
What is the correct syntax for update?
>
