Re: How do I edit a field using VisData?

From: John K.Eason (john_at_jeasonNoSpam.cix.co.uk)
Date: 05/28/04 

Date: Fri, 28 May 2004 12:03 +0100 (BST)

In article <9Bwtc.1797$_k3.37539@bgtnsc05-news.ops.worldnet.att.net>,
j.s.yablonsky@NOSPAMatt.net (Jim Y) wrote:

> I created a database using VisData and want to change the size of
> several fields. In it six fields have Size = 50. How do I use VisData
> or SQL to change each of those fields to Size = 150 or more?
> When I click on "Design", the Size block is not enabled - faint in
> color. Although I searched, I cannot find how to edit any of the
> fields. I can add or delete fields, but have no idea on how to
> edit one that has been created.

 You can't once it's been appended to the Fields collection! The size of a
field is read-only once created, which is why that parameter is disabled
in VisData. The only way to get round it is to create new fields of the
correct width, transfer any records you've already entered, and delete the
old fields.
 Note though that you can't change the *name* of a field either once it's
been appended, so you can't rename the new field once the old one's been
deleted.
 Your new fields will also be in a different ordinal position within the
collection, which can be another problem if your code accesses the fields
by ordinal number rather than name, so it can be better to create a
complete new database with the correct field widths and then transfer all
the data over programmatically.

Regards
       John (john@jeasonNoSpam.cix.co.uk) Remove the obvious to reply...

Loading