Addin a new field

[turbojack]

Re: Addin a new field

Have you tried adding the field before you added the records? May be problem with over 300 fields

[dparkins]

Re: Addin a new field

I can add the field if the table is blank. Also, I created a new table and appended approx 50k records each time to it. I was able to add a new field each time. I'm still trying everything I can think of but I'm running out of hope and time. Any other ideas?

Thanks,
Dave

[Al Buchholz]

Re: Addin a new field

Thanks Al. I'll try one of the options. It's our largest table with around 300 fields and over 140k records.

Dave

Dave

Have you had any luck with identifying the records with the bad data?

Re-reading.... So after you've appended all of the records back to the new table, you can add the fields?

[martinwcole]

Re: Addin a new field

post an example adb here, with some records, so we can see if we cann add the fields
also, post the script and the script location(or where it is run from)

and - IN PARTICULAR - if it is run from a form that has the table open when fired (which would be a 'no-no')

[turbojack]

Re: Addin a new field

I can add the field if the table is blank. Also, I created a new table and appended approx 50k records each time to it. I was able to add a new field each time. I'm still trying everything I can think of but I'm running out of hope and time. Any other ideas?

Thanks,
Dave

So when were you not able to add the field? With 50K, 100K, or 150K records?

[martinwcole]

Re: Addin a new field

if its really critical, hire Al to log on to your computer, and help you find the damaged record.

[dparkins]

Re: Addin a new field

I can't add the field to the full table, but could when I pieced it out. And I always open the table structure from the control panel to edit it. No forms are open.

Thanks,
Dave

[martinwcole]

Re: Addin a new field

make a new adb
copy the full table to the new adb
write a looping script to create a new table(incrmenting the name each time) to add small groups of records to it

find which table you cannot add fields to and wallah you can look for the bad record(s)

[Al Buchholz]

Re: Addin a new field

I can't add the field to the full table, but could when I pieced it out. And I always open the table structure from the control panel to edit it. No forms are open.

Thanks,
Dave

So does the new table have the same number of records in it?

Probably, so now find where the data is different.

Make a set where the orig table links to the new table via recno().

Then query where alltext(orig_table) <> alltext(new_table).

This will find differences when the number of records are the same or different.

If the number of records are the same it'll find a few records.
If there is a difference in total records, you'll see where the first record is missing and all records after it.

[martinwcole]

Re: Addin a new field

excellent idea, Al

[turbojack]

Re: Addin a new field

Al, I am taking it that he was able to add a field up until he had all the records from the old table in the new table. Thus now the new table can not add a field.

DP, How about adding a field in the new table then append the records. At least it will give you more time to figure out what is going on.

[G Gabriel]

Re: Addin a new field

Check the size of your table in KB. It is possible your reached the limit.

[dparkins]

Re: Addin a new field

The table size is 2,086,530kb

[csda1]

Re: Addin a new field

Hi Dave,

The table size is 2,086,530kb

Gabe asked the right question that you answered. You are at the 2 Gigabyte maximum limit for a dbf database. When you try to add a field, it will just try to make an even larger file.

The solution is to segment each memo field of the table into separate tables with links back to the main table holding alll the other non-memo fields. If you are exceeding 2 Gigabytes with the main dbf file, then separate fields into more than 1 table with a link.

Alternatively, use an SQL database if you are able to.

[dparkins]

Re: Addin a new field

Thanks to all for the answer.

I do have a couple more questions regarding it though.

1. If no new fields are added, will the table work ok and be able to accept more records?

2. Does alpha have any plans to enable that file to grow past 2gb?

I could work on separating many of the fields into a new table (which we may end up doing) but many operations, forms, and reports would have to be adjusted for that.

We may also try to remove many of the non-used records.

Thanks again,
Dave