[RBG7-L] - Re: NOTE FIELD

[A. Razzak Memon]

At 02:31 PM 8/11/2004 -0400, Bill Owens wrote:
I think I know what the problem might be..The first field is a
text field and the other 3 are notes.
Can I do this update into one note field with 1 text field and
3 note fields?
Yes, you CAN!
Example:
UPDATE tablename SET AllNotes = (note1col&Textcol&note2col&note3col)
-- Substitute the tablename, NOTE and TEXT columns accordingly.
Have fun!
Very Best R:egards,
Razzak.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak
Memon
Sent: Wednesday, August 11, 2004 1:43 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: NOTE FIELD
At 01:30 PM 8/11/2004 -0400, Bill Owens wrote:
>Razzak
>I tried this and i got a message something to the effect that i
>wasn't allowed to use expression with note fields
Are you sure about that, Bill? <g>
To test the scenario, try the following steps:
01. Make a backup copy of your dtabase.
02. CONNECT dbname
03. RBDEFINE tablename
04. Add a new column at the end of that table, such as AllNotes
     and use the data type NOTE.
05. Save the table.
06. At the R> prompt:
     UPDATE tablename SET AllNotes = (note1col&note2col&note3col&note4col)
     -- substitute dbname with the actual database name
     -- substitute tablename with the actual table name in that database
     -- substitute note1col with the actual first NOTE column name in that
table
     -- substitute note2col with the actual second NOTE column name in that
table
     -- substitute note3col with the actual third NOTE column name in that
table
     -- substitute note4col with the actual fourth NOTE column name in that
table
What do you get?
Very Best R:egards,
Razzak.