Lantica User Forum - deleting 1 database from app Help Please

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › deleting 1 database from app Help Please

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

deleting 1 database from app Help Please (Read 1164 times)

billgordon Junior Member Offline No personal text Posts: 61 Joined: Dec 31^st, 2003	deleting 1 database from app Help Please Jun 21^st, 2005 at 10:41pm	Print Post
	I created an application that has: - main mainform -first one -second two -third three I deleted the form mainform under main and now want to delete main. If I trim main I lose them all How do I eliminate main and keep the rest Thanks


	IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: deleting 1 database from app Help Please Reply #1 - Jun 22^nd, 2005 at 12:54am	Print Post
	Edited comment: Ignore the proposed solution here. See the real simple solution that was subsequently provided by Carl. I guess you could export all of the data in each of the sub forms. And also export all of the programming. Rename the current databases and forms. Create the correct names at the higher level. Make new forms at the higher level, using the old forms opened up as a reference for position, fonts, colors, etc.. Then import the programming and the data. May have to modify some form/element names in the programming. Using a text editor you could do Search/Replace to simplify that part of the process. Confirm the imports were done correctlly, then you can delete main and all the sub forms with it. Will have to do this separately for first, second, third databases.
	« Last Edit: Jun 22^nd, 2005 at 2:25am by Bob_Hansen »
	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1350 Location: New Hampshire Joined: Mar 11^th, 2003	Re: deleting 1 database from app Help Please Reply #2 - Jun 22^nd, 2005 at 1:50am	Print Post
	I think there is an easier way than Bob's post. (Sorry, Bob. ) You should be able to simply go into "Manage Fields" under Manage A Database/Main. Under "Action", select "Delete Field". Under "Field Name", select the name that appears in the left column with "[SUBRECORD]" next to it. Click "Add Transaction To Batch", and "Run Batch". (Do this for each field that has "[SUBRECORD]" next to it.) After you exit the Field Manager, Main should no longer have other databases as children. The other databases should be on their own (i.e. not indented under Main in the command tree). You now should be able to delete the Main DB without losing the others. And of course, as always, try this out on a copy of the app first.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: deleting 1 database from app Help Please Reply #3 - Jun 22^nd, 2005 at 2:23am	Print Post
	Thanks Carl Works for me! Just tried it out with a test database. You may be sorry, but I am not. Learning something every day. Glad you pointed out that method. I have not had to perform that type of process before, and am glad you provided a method that was much easier than mine. I have edited my original posting to have it ignored.
	« Last Edit: Jun 22^nd, 2005 at 2:30pm by Bob_Hansen »
	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1350 Location: New Hampshire Joined: Mar 11^th, 2003	Re: deleting 1 database from app Help Please Reply #4 - Jun 22^nd, 2005 at 2:35am	Print Post
	Hi Bob, Didn't want you to feel that I was 'stepping on your toes'. Now, I just hope that we understood Bill's question correctly.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: deleting 1 database from app Help Please Reply #5 - Jun 22^nd, 2005 at 4:03am	Print Post
	Not on my toes.....I thought this was open forum for us to help one another. All ideas are welcome. Without your suggestion, and only mine, he would have thrown up his hands......I know I was doing that when trying to figure out how to do it...... See you in August at SANE?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1350 Location: New Hampshire Joined: Mar 11^th, 2003	Re: deleting 1 database from app Help Please Reply #6 - Jun 22^nd, 2005 at 11:51am	Print Post
	Quote: See you in August at SANE? I don't think I can make it, I'll be out of town on vacation on August 6th.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

billgordon Junior Member Offline No personal text Posts: 61 Joined: Dec 31^st, 2003	Re: deleting 1 database from app Help Please Reply #7 - Jun 22^nd, 2005 at 2:09pm	Print Post
	Thank you everyone for the help. Carl your method worked perfect. This would be impossible for me to achieve if not for the help of this forum and people I met from here who help get me past my stumbling blocks!


	IP Logged

Carl Underwood Senior Member Members Offline Posts: 1350 Location: New Hampshire Joined: Mar 11^th, 2003	Re: deleting 1 database from app Help Please Reply #8 - Jun 23^rd, 2005 at 2:47am	Print Post
	Quote: Carl your method worked perfect. Great! Glad to hear that.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›