Fwd: Deleting Records Problem
|
View:
New views
12 Messages
—
Rating Filter:
Alert me
|
 |
|
|
|
Re: Deleting Records Problem
by tomrdillon
::
Rate this Message:
My next step would be to get the record number of the bum record and then
play arroud with trying to delete the record using the record number as reference. On Wed, May 27, 2009 at 3:24 AM, Michael Steinwede < michael.steinwede@...> wrote: > Hi Michel, > > On 26/05/2009, at 11:13 PM, michel wrote: >> >> I had similar problems in the past. If you haven't already try launching >> 4D Tools and run a repair/rebuild on your database. If there is a problem >> with your structure file, 4D Tools should be able to repair it. This method >> works for 99% of the time. >> > > I've tried a repair/rebuild, but the problem remains. > > >> >> If the above does not work, one option is to start with a new data file by >> trashing your current data file (file ending in .DD). However, keep in mind >> that you will lose all of your stored data if you trash your data file. I >> usually did this when everything else failed. >> > > Not sure if I understand this. Trash the Data file? How am I supposed to > get all my information back on the database? Am I missing something? > > > And Hi Tom,. > > On 26/05/2009, at 11:22 PM, Tom Dillon wrote: >> >> I would run 4D Tools and use it to check the database and then I would >> compact the database. This usually gets rid of these problems. >> >> > 4D Tools says the database is OK, but it's not! > Identical problems exist on two TABLES. One has one record I can't delete; > the other has 99 records I can't delete. > It's driving me insane. > > Even after I do a compact, file names change (originals have a "_" added, > new creations have "-2" added). > But when I try to run it, it says my log file is not compatible. > I don't the find manuals helpful in getting through the changes it makes > when making repairs and what to do in simple terms that amateurs like me can > understand. > > I'm thinking I may be forced to create two new tables with their forms etc > and relegate the corrupted tables to "invisible" and hope they don't > interfere with the database again. > > I prefer to solve the problem rather than do a fix around. > > Any further ideas? > > > Michael. > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Fwd: Deleting Records Problem
by Mehboob Alam
::
Rate this Message:
> Not sure if I understand this. Trash the Data file? How am I supposed to get all my information back on the database? Am I missing something? Try this technote, you can export all your current data out, throw away the datafile, create a new one, and bring all your data back in. http://kb.4d.com/search/assetid=41862 sincerely, mehboob alam Electricity is actually made up of extremely tiny particles called electrons, that you cannot see with the naked eye unless you have been drinking. - Dave Barry ----- Original Message ---- From: Michael Steinwede <michael.steinwede@...> To: 4D List <4DBasics@...> Sent: Wednesday, May 27, 2009 6:24:36 AM Subject: Fwd: Deleting Records Problem Hi Michel, > On 26/05/2009, at 11:13 PM, michel wrote: > > I had similar problems in the past. If you haven't already try launching 4D Tools and run a repair/rebuild on your database. If there is a problem with your structure file, 4D Tools should be able to repair it. This method works for 99% of the time. I've tried a repair/rebuild, but the problem remains. > > > If the above does not work, one option is to start with a new data file by trashing your current data file (file ending in .DD). However, keep in mind that you will lose all of your stored data if you trash your data file. I usually did this when everything else failed. Not sure if I understand this. Trash the Data file? How am I supposed to get all my information back on the database? Am I missing something? And Hi Tom,. > On 26/05/2009, at 11:22 PM, Tom Dillon wrote: > > I would run 4D Tools and use it to check the database and then I would > compact the database. This usually gets rid of these problems. > 4D Tools says the database is OK, but it's not! Identical problems exist on two TABLES. One has one record I can't delete; the other has 99 records I can't delete. It's driving me insane. Even after I do a compact, file names change (originals have a "_" added, new creations have "-2" added). But when I try to run it, it says my log file is not compatible. I don't the find manuals helpful in getting through the changes it makes when making repairs and what to do in simple terms that amateurs like me can understand. I'm thinking I may be forced to create two new tables with their forms etc and relegate the corrupted tables to "invisible" and hope they don't interfere with the database again. I prefer to solve the problem rather than do a fix around. Any further ideas? Michael. ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Fwd: Deleting Records Problem
by tomrdillon
::
Rate this Message:
How many tables do you have?
On Wed, May 27, 2009 at 9:24 AM, Mehboob Alam <media4d@...> wrote: > > > Not sure if I understand this. Trash the Data file? How am I supposed to > get all my information back on the database? Am I missing something? > > Try this technote, you can export all your current data out, throw away the > datafile, create a new one, and bring all your data back in. > http://kb.4d.com/search/assetid=41862 > > sincerely, > mehboob alam > > > > > Electricity is actually made up of extremely tiny particles called > electrons, that you cannot see with the naked eye unless you have been > drinking. - Dave Barry > > > > ----- Original Message ---- > From: Michael Steinwede <michael.steinwede@...> > To: 4D List <4DBasics@...> > Sent: Wednesday, May 27, 2009 6:24:36 AM > Subject: Fwd: Deleting Records Problem > > Hi Michel, > > > On 26/05/2009, at 11:13 PM, michel wrote: > > > > I had similar problems in the past. If you haven't already try launching > 4D Tools and run a repair/rebuild on your database. If there is a problem > with your structure file, 4D Tools should be able to repair it. This method > works for 99% of the time. > > I've tried a repair/rebuild, but the problem remains. > > > > > > > If the above does not work, one option is to start with a new data file > by trashing your current data file (file ending in .DD). However, keep in > mind that you will lose all of your stored data if you trash your data file. > I usually did this when everything else failed. > > Not sure if I understand this. Trash the Data file? How am I supposed to > get all my information back on the database? Am I missing something? > > > And Hi Tom,. > > > On 26/05/2009, at 11:22 PM, Tom Dillon wrote: > > > > I would run 4D Tools and use it to check the database and then I would > > compact the database. This usually gets rid of these problems. > > > > 4D Tools says the database is OK, but it's not! > Identical problems exist on two TABLES. One has one record I can't delete; > the other has 99 records I can't delete. > It's driving me insane. > > Even after I do a compact, file names change (originals have a "_" added, > new creations have "-2" added). > But when I try to run it, it says my log file is not compatible. > I don't the find manuals helpful in getting through the changes it makes > when making repairs and what to do in simple terms that amateurs like me can > understand. > > I'm thinking I may be forced to create two new tables with their forms etc > and relegate the corrupted tables to "invisible" and hope they don't > interfere with the database again. > > I prefer to solve the problem rather than do a fix around. > > Any further ideas? > > Michael. > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Deleting Records Problem
by Michael Steinwede-2
::
Rate this Message:
Hi Tom,
On 28/05/2009, at 5:22 AM, Tom Dillon wrote: > How many tables do you have? About 25 tables. Michael. > > > On Wed, May 27, 2009 at 9:24 AM, Mehboob Alam <media4d@...> > wrote: > >> >>> Not sure if I understand this. Trash the Data file? How am I >>> supposed to >> get all my information back on the database? Am I missing something? >> >> Try this technote, you can export all your current data out, throw >> away the >> datafile, create a new one, and bring all your data back in. >> http://kb.4d.com/search/assetid=41862 >> >> sincerely, >> mehboob alam >> >> >> >> >> Electricity is actually made up of extremely tiny particles called >> electrons, that you cannot see with the naked eye unless you have >> been >> drinking. - Dave Barry >> >> >> >> ----- Original Message ---- >> From: Michael Steinwede <michael.steinwede@...> >> To: 4D List <4DBasics@...> >> Sent: Wednesday, May 27, 2009 6:24:36 AM >> Subject: Fwd: Deleting Records Problem >> >> Hi Michel, >> >>> On 26/05/2009, at 11:13 PM, michel wrote: >>> >>> I had similar problems in the past. If you haven't already try >>> launching >> 4D Tools and run a repair/rebuild on your database. If there is a >> problem >> with your structure file, 4D Tools should be able to repair it. >> This method >> works for 99% of the time. >> >> I've tried a repair/rebuild, but the problem remains. >> >>> >>> >>> If the above does not work, one option is to start with a new data >>> file >> by trashing your current data file (file ending in .DD). However, >> keep in >> mind that you will lose all of your stored data if you trash your >> data file. >> I usually did this when everything else failed. >> >> Not sure if I understand this. Trash the Data file? How am I >> supposed to >> get all my information back on the database? Am I missing something? >> >> >> And Hi Tom,. >> >>> On 26/05/2009, at 11:22 PM, Tom Dillon wrote: >>> >>> I would run 4D Tools and use it to check the database and then I >>> would >>> compact the database. This usually gets rid of these problems. >>> >> >> 4D Tools says the database is OK, but it's not! >> Identical problems exist on two TABLES. One has one record I can't >> delete; >> the other has 99 records I can't delete. >> It's driving me insane. >> >> Even after I do a compact, file names change (originals have a "_" >> added, >> new creations have "-2" added). >> But when I try to run it, it says my log file is not compatible. >> I don't the find manuals helpful in getting through the changes it >> makes >> when making repairs and what to do in simple terms that amateurs >> like me can >> understand. >> >> I'm thinking I may be forced to create two new tables with their >> forms etc >> and relegate the corrupted tables to "invisible" and hope they don't >> interfere with the database again. >> >> I prefer to solve the problem rather than do a fix around. >> >> Any further ideas? >> >> Michael. >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/ >> <http://www.4d.com/> >> >> Register for 4D Summit 2009 Today >> Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit >> > >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> >> >> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www. >> 4D.com/<http://www.4d.com/> >> >> Register for 4D Summit 2009 Today >> Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit >> > >> >> To Unsubscribe: mailto:4DBasics-off@info. >> 4D.com >> ********************************************************************** >> >> >> > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Deleting Records Problem
by tomrdillon
::
Rate this Message:
I would just try exporting the bad table and make sure you then delete all
the records to see if it goes away. Make sure you have set the properties on the table to COMPLETELY DELETE. Then import the table and see what happens. If that fails then you are only left with a complete export import of each table. Also, be real carefull of your export form to make sure its perfictly alligned. Best to just create one from scratch and not use any form that already exists. Of course, make a complete copy of your database before trying anything. On Wed, May 27, 2009 at 2:22 PM, Michael Steinwede < michael.steinwede@...> wrote: > Hi Tom, > > > On 28/05/2009, at 5:22 AM, Tom Dillon wrote: > > How many tables do you have? >> > > About 25 tables. > > Michael. > > >> >> On Wed, May 27, 2009 at 9:24 AM, Mehboob Alam <media4d@...> wrote: >> >> >>> Not sure if I understand this. Trash the Data file? How am I supposed to >>>> >>> get all my information back on the database? Am I missing something? >>> >>> Try this technote, you can export all your current data out, throw away >>> the >>> datafile, create a new one, and bring all your data back in. >>> http://kb.4d.com/search/assetid=41862 >>> >>> sincerely, >>> mehboob alam >>> >>> >>> >>> >>> Electricity is actually made up of extremely tiny particles called >>> electrons, that you cannot see with the naked eye unless you have been >>> drinking. - Dave Barry >>> >>> >>> >>> ----- Original Message ---- >>> From: Michael Steinwede <michael.steinwede@...> >>> To: 4D List <4DBasics@...> >>> Sent: Wednesday, May 27, 2009 6:24:36 AM >>> Subject: Fwd: Deleting Records Problem >>> >>> Hi Michel, >>> >>> On 26/05/2009, at 11:13 PM, michel wrote: >>>> >>>> I had similar problems in the past. If you haven't already try launching >>>> >>> 4D Tools and run a repair/rebuild on your database. If there is a problem >>> with your structure file, 4D Tools should be able to repair it. This >>> method >>> works for 99% of the time. >>> >>> I've tried a repair/rebuild, but the problem remains. >>> >>> >>>> >>>> If the above does not work, one option is to start with a new data file >>>> >>> by trashing your current data file (file ending in .DD). However, keep in >>> mind that you will lose all of your stored data if you trash your data >>> file. >>> I usually did this when everything else failed. >>> >>> Not sure if I understand this. Trash the Data file? How am I supposed to >>> get all my information back on the database? Am I missing something? >>> >>> >>> And Hi Tom,. >>> >>> On 26/05/2009, at 11:22 PM, Tom Dillon wrote: >>>> >>>> I would run 4D Tools and use it to check the database and then I would >>>> compact the database. This usually gets rid of these problems. >>>> >>>> >>> 4D Tools says the database is OK, but it's not! >>> Identical problems exist on two TABLES. One has one record I can't >>> delete; >>> the other has 99 records I can't delete. >>> It's driving me insane. >>> >>> Even after I do a compact, file names change (originals have a "_" added, >>> new creations have "-2" added). >>> But when I try to run it, it says my log file is not compatible. >>> I don't the find manuals helpful in getting through the changes it makes >>> when making repairs and what to do in simple terms that amateurs like me >>> can >>> understand. >>> >>> I'm thinking I may be forced to create two new tables with their forms >>> etc >>> and relegate the corrupted tables to "invisible" and hope they don't >>> interfere with the database again. >>> >>> I prefer to solve the problem rather than do a fix around. >>> >>> Any further ideas? >>> >>> Michael. >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> >>> <http://www.4d.com/> >>> >>> Register for 4D Summit 2009 Today >>> Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> >>> <http://www.4d.com/summit> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >>> >>> >>> ********************************************************************** >>> 4D Basics hosted by 4D, Inc. http://www.4D.com/< >>> http://www.4d.com/> >>> >>> Register for 4D Summit 2009 Today >>> Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> >>> <http://www.4d.com/summit> >>> >>> To Unsubscribe: mailto:4DBasics-off@... >>> ********************************************************************** >>> >>> >>> >>> >> ********************************************************************** >> 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> >> >> Register for 4D Summit 2009 Today >> Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> >> >> To Unsubscribe: mailto:4DBasics-off@... >> ********************************************************************** >> >> >> > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Deleting Records Problem
by Michael Steinwede-2
::
Rate this Message:
Hi mehboob,
I've just sent an email to 4D addressed to Tom thinking he was the one who informed me about the technote. I apologise for the mix up. See what I wrote to Tom re-solving my problem. (Not the best way, perhaps, but it's done.) Warm regards, Michael On 28/05/2009, at 2:24 AM, Mehboob Alam wrote: > >> Not sure if I understand this. Trash the Data file? How am I >> supposed to get all my information back on the database? Am I >> missing something? > > Try this technote, you can export all your current data out, throw > away the datafile, create a new one, and bring all your data back in. > http://kb.4d.com/search/assetid=41862 > > sincerely, > mehboob alam > > > > > Electricity is actually made up of extremely tiny particles called > electrons, that you cannot see with the naked eye unless you have > been drinking. - Dave Barry > > > > ----- Original Message ---- > From: Michael Steinwede <michael.steinwede@...> > To: 4D List <4DBasics@...> > Sent: Wednesday, May 27, 2009 6:24:36 AM > Subject: Fwd: Deleting Records Problem > > Hi Michel, > >> On 26/05/2009, at 11:13 PM, michel wrote: >> >> I had similar problems in the past. If you haven't already try >> launching 4D Tools and run a repair/rebuild on your database. If >> there is a problem with your structure file, 4D Tools should be >> able to repair it. This method works for 99% of the time. > > I've tried a repair/rebuild, but the problem remains. > >> >> >> If the above does not work, one option is to start with a new data >> file by trashing your current data file (file ending in .DD). >> However, keep in mind that you will lose all of your stored data if >> you trash your data file. I usually did this when everything else >> failed. > > Not sure if I understand this. Trash the Data file? How am I > supposed to get all my information back on the database? Am I > missing something? > > > And Hi Tom,. > >> On 26/05/2009, at 11:22 PM, Tom Dillon wrote: >> >> I would run 4D Tools and use it to check the database and then I >> would >> compact the database. This usually gets rid of these problems. >> > > 4D Tools says the database is OK, but it's not! > Identical problems exist on two TABLES. One has one record I can't > delete; the other has 99 records I can't delete. > It's driving me insane. > > Even after I do a compact, file names change (originals have a "_" > added, new creations have "-2" added). > But when I try to run it, it says my log file is not compatible. > I don't the find manuals helpful in getting through the changes it > makes when making repairs and what to do in simple terms that > amateurs like me can understand. > > I'm thinking I may be forced to create two new tables with their > forms etc and relegate the corrupted tables to "invisible" and hope > they don't interfere with the database again. > > I prefer to solve the problem rather than do a fix around. > > Any further ideas? > > Michael. > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > > > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/ > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
|
|
|
Re: Deleting Records Problem
by tomrdillon
::
Rate this Message:
I have not used log files so can't help much on that. When you use the
tools and create a new database the new files will have -2 appended. When you open a 4D database if you hold down the control key it will prompt for database to use and then once you have selected it it will remember the association. On Wed, May 27, 2009 at 11:27 PM, Michael Steinwede < michael.steinwede@...> wrote: > > Hi Tom, > > Unfortunately, the first option didn't work. > > At this point in time, I wasn't sure really what to do with the complete > export import option. > > I read the article you suggested, but I just didn't feel confident to use > it. > > I have exported a good back up copy of the table and then imported that > back up into a newly created table. > > There was only one form to copy over and now it works. > > I removed the form from the old table so it would interfere with the new > one, but of course, the old table still exists and an annoying reminder. > > Thanks to yo and all who spent the time emailing me. > > Warm regards, > > Michael > > PS. Tom, If you wouldn't mind answering these questions ... > (1) How do you create a Log File of the Database. I've discovered that when > I change the data file, I can't use it because the Log File doesn't match or > something. > (2) When I fix an error via 4D Tools and the original data has a "-" at the > end of the name while the new data has "-2" attached to the end of the file > name. > How do I match the database with the new data created (as well as the log > file as mentioned above)? > > > > On 28/05/2009, at 9:39 AM, Tom Dillon wrote: > >> I would just try exporting the bad table and make sure you then delete all >> the records to see if it goes away. Make sure you have set the properties >> on the table to COMPLETELY DELETE. Then import the table and see what >> happens. If that fails then you are only left with a complete export >> import >> of each table. >> >> Also, be real carefull of your export form to make sure its perfictly >> alligned. Best to just create one from scratch and not use any form that >> already exists. Of course, make a complete copy of your database before >> trying anything. >> >> > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Deleting Records Problem
by Mehboob Alam
::
Rate this Message:
Just remove the originals, I usually ZIP them and delete the original files, to avoid 4D accidently (or intentionally) opening the previous version. Then just rename the repaird database files back to their original name that the structure is expecting to see. sincerely, mehboob alam Electricity is actually made up of extremely tiny particles called electrons, that you cannot see with the naked eye unless you have been drinking. - Dave Barry ----- Original Message ---- From: Tom Dillon <tomrdillon@...> To: 4D Basics List <4DBasics@...> Sent: Thursday, May 28, 2009 8:49:42 AM Subject: Re: Deleting Records Problem I have not used log files so can't help much on that. When you use the tools and create a new database the new files will have -2 appended. When you open a 4D database if you hold down the control key it will prompt for database to use and then once you have selected it it will remember the association. On Wed, May 27, 2009 at 11:27 PM, Michael Steinwede < michael.steinwede@...> wrote: > > Hi Tom, > > Unfortunately, the first option didn't work. > > At this point in time, I wasn't sure really what to do with the complete > export import option. > > I read the article you suggested, but I just didn't feel confident to use > it. > > I have exported a good back up copy of the table and then imported that > back up into a newly created table. > > There was only one form to copy over and now it works. > > I removed the form from the old table so it would interfere with the new > one, but of course, the old table still exists and an annoying reminder. > > Thanks to yo and all who spent the time emailing me. > > Warm regards, > > Michael > > PS. Tom, If you wouldn't mind answering these questions ... > (1) How do you create a Log File of the Database. I've discovered that when > I change the data file, I can't use it because the Log File doesn't match or > something. > (2) When I fix an error via 4D Tools and the original data has a "-" at the > end of the name while the new data has "-2" attached to the end of the file > name. > How do I match the database with the new data created (as well as the log > file as mentioned above)? > > > > On 28/05/2009, at 9:39 AM, Tom Dillon wrote: > >> I would just try exporting the bad table and make sure you then delete all >> the records to see if it goes away. Make sure you have set the properties >> on the table to COMPLETELY DELETE. Then import the table and see what >> happens. If that fails then you are only left with a complete export >> import >> of each table. >> >> Also, be real carefull of your export form to make sure its perfictly >> alligned. Best to just create one from scratch and not use any form that >> already exists. Of course, make a complete copy of your database before >> trying anything. >> >> > ********************************************************************** > 4D Basics hosted by 4D, Inc. http://www.4D.com/<http://www.4d.com/> > > Register for 4D Summit 2009 Today > Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit> > > To Unsubscribe: mailto:4DBasics-off@... > ********************************************************************** > > > ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Deleting Records Problem
by Michael Steinwede-2
::
Rate this Message:
Hi Tom,
I thought the log files were essential, that's why I've hung onto them for so long. They have always caused me issues whenever I had to make changes to a data file. I've now turned it off in preferences and hopefully I wont have to worry about it anymore. Thanks for your help. Michael On 28/05/2009, at 10:49 PM, Tom Dillon wrote: > I have not used log files so can't help much on that. When you use > the > tools and create a new database the new files will have -2 > appended. When > you open a 4D database if you hold down the control key it will > prompt for > database to use and then once you have selected it it will remember > the > association. ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
|
|
Re: Deleting Records Problem
by Michael Steinwede-2
::
Rate this Message:
Hi Mehboob,
it seems I have a couple of options now. Thanks for your input. Michael. On 28/05/2009, at 11:38 PM, Mehboob Alam wrote: > Just remove the originals, I usually ZIP them and delete the > original files, to avoid 4D accidently (or intentionally) opening > the previous version. > Then just rename the repaird database files back to their original > name that the structure is expecting to see. ********************************************************************** 4D Basics hosted by 4D, Inc. http://www.4D.com/ Register for 4D Summit 2009 Today Early Bird Pricing Ends August 28th - http://www.4D.com/summit To Unsubscribe: mailto:4DBasics-off@... ********************************************************************** |
| Free embeddable forum powered by Nabble | Forum Help |
