Modify tabel structure without container

[michellq]

Dear VB users,

Can someone please tell me how to change the structure of a table.
When I double click in my explorer on a .dbf file, I can browse trough the table.
I don't see any possibillity to modify the structure.
I can do it when I put the .dbf file in a container.

When I place the .dbf file in a container, modify the structure and remove .dbf and container the executable is still searching to the container (what not exist).

Nice regards,

Michelle.

 

[weedz]

Hi Michelle,

Check out these items in the help file :

- ALTER TABEL
- MODIFY STRUCTURE

If you add a table to a container it holds a reference to that container. If you physically remove the container the reference remains.

HTH,

Weedz
veld4663@exact.nl

BTW: you stated 'Dear VB users'...be carefull with that ...;-)

 

[michellq]

Hello Weedz,

Thanks for the information.
I do understand it is better not to use a container.

Nice weekend,

Michelle

 

[weedz]

Hi Michelle,

I must say that using a DBC gives a lot of advantages (long fieldnames, referential integrity (stored procedures etc.)).

You can also alter a table that is in a DBC using the ALTER TABLE functionality.

HTH,

Prettig weekend,

Weedz
veld4663@exact.nl