[RBASE-L] - Re: Long Varchar data - Rbase 6.5++ win

[A. Razzak Memon]

At 10:26 AM 2/21/2006, Chuck Lockwood wrote:

I am trying to transfer the data from a long varchar column to a note column
in another table.  No error, but no data either.  Is there a known method
for doing this successfully?

Chuck,

Here's how:

Example:

TableA:
ColumnA INTEGER
ColumnB VARCHAR

TableB:
ColumnA INTEGER
ColumnC NOTE

Routine to convert VARCHAR to NOTE Field:

INSERT INTO TableB (ColumnA, ColumnC) SELECT ColumnA, ColumnB FROM TableA

The resulting ColumnC in TableB will include the converted VARCHAR to NOTE.

That's all there is to it!

Have fun.

Very Best R:egards,

Razzak.