TABLES and other matters

[Michael Steinwede-2]

Hi,

I have a couple of queries.

(1) I created a table with several fields.

A little time later, I decided that the fields should be different ...  
different names, different categories (alpha to longint and the like)

To my surprise, when I ran my program, using this changed table, I got  
strange results that indicated that the table had not 'changed its  
spots' so to speak.

My question is: one you name a table and classify its fields, can they  
never be changed?

(2) Can you ever delete those discarded forms and methods from the  
TRASH folder?

Any advise gratefully received.

Michael.

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************

[Josh Fletcher (4D, Inc.)]

Hi Michael,

Michael Steinwede wrote:

> (1) I created a table with several fields.
>
> A little time later, I decided that the fields should be different ...  
> different names, different categories (alpha to longint and the like)
>
> To my surprise, when I ran my program, using this changed table, I got  
> strange results that indicated that the table had not 'changed its  
> spots' so to speak.
>
> My question is: one you name a table and classify its fields, can they  
> never be changed?

You can change field types, but 4D does *not* alter the data.  After
all, how would 4D know what to change it to?  This also allows you to
change the field back, in case you change your mind, and the data will
be intact.

You need to specify values for any data that was already created with
the old field type.

> (2) Can you ever delete those discarded forms and methods from the  
> TRASH folder?

Right-click on the Trash folder icon.

Kind regards,

Josh Fletcher

--
Josh Fletcher
Technical Support Engineer
4D, Inc.

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************