Thank you very much, Razzak.
Being very new to the RUN SELECT and the need for VARCHAR as the data type I
wanted to get myself on the right lines to start with or, at least, not too
far down the line.
I can now see why MikeB advocates it and it is another big plus for R:Base.
It's a good thing the rain keeps falling here in the UK at the moment - I
don't need an excuse to explore all these new features and work out how to
utilise them.
Regards,
Alastair.
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, January 15, 2008 4:38 PM
Subject: [RBASE-L] - Re: Data Types and File Gateway
At 03:48 AM 1/15/2008, Alastair Burr wrote:
My questions are firstly, does the use LONG VARCHAR have any effect on
the size or performance of the database compared to a (short) VARCHAR?
Alastair,
AFAIK, there is no effect on the performance of the database. However,
the size of .RB4 file will vary accordingly.
And, secondly, am I right in thinking that I can convert this column to
VARCHAR simply by removing the word LONG and adding the required length
in brackets to my unload file (and reload it)?
Correct!
Similar to the examples below:
-- Example 01
SET ERROR MESSAGE 2038 OFF
DROP TABLE InvestigationNotes
CREATE TABLE `InvestigationNotes` +
(`CID` INTEGER, `CNotes` LONG VARCHAR)
SET ERROR MESSAGE 2038 ON
RETURN
-- Example 02 based on example 01 above
ALTER TABLE `InvestigationNotes` +
ALTER `CNotes` VARCHAR (8000)
RETURN
-- Example 03:
SET ERROR MESSAGE 2038 OFF
DROP TABLE BriefNotes
CREATE TABLE `BriefNotes` +
(`CID` INTEGER, `BNotes` VARCHAR (7000))
SET ERROR MESSAGE 2038 ON
RETURN
Hope that explains!
Very Best R:egards,
Razzak.
--
No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.516 / Virus Database:
269.19.2/1224 - Release Date: 14/01/2008 17:39
