Re: Upgrading a database through patching

Stephane Potvin sez:

>Now I want to provide them with an update I have done to the DB.  
>However if I only send them a new structure file, they will loose all  
>the users information, and all the list items. How can I update the  
>DB without loosing all that?

Is the structure compiled? If not, you can sign on as Administrator and
save the Users and Groups. And you could save the lists using List To
Array, then exporting each array into a text file, then reverse the
process when you open the new structure.

This brings up your update then. You might want to add in List and User/
Group/Password data storage to your new structure before you send it to
them. It's pretty easy. I use Foundation which uses a table for Lists
and I generally a table each for Users and Groups. If you're interested
I can dig up the code for that. In fact I may put it on my
4thDimension.com website as a demo database as soon as the site's back up.

--
   ------------------------------------------------------------------
   Tom Dillon                                        900 S. Coors Dr.
   DataCraft                                       Lakewood, CO 80228
   TomDillon@...                           720/962-4880
   ------------------------------------------------------------------
      The focus of the pilot should not be on the dead fly stuck
      to the windshield. --- Sunastar
   ------------------------------------------------------------------



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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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