[RBG7-L] - Re: NOTE FIELD

[William Owens]

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?


-----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.