I just did try it with a memo field. Made no difference. BTW, I get 48 for SYS(2029), with or without a memo field. 245 is not VFP6 table, it's some other version.


>Create the table with a memo. Maybe that's part of the problem.
>I'll email the tables.
>
>>If you do, I won't be able to look at them until later. I can't access that email address from work.
>>
>>>These are all free tables.
>>>Can I email you the files? :)
>>>
>>>Dan
>>>
>>>>Are your table already part of a some other database? If that's the case, you'll have to free them before you can add them to your new database.
>>>>
>>>>
>>>>>You still have to be opening the table somehow.
>>>>>
>>>>>I just did the same program and created the tables in VFP6, and run just the add table part in VFP9, and no messages.
>>>>>
>>>>>
>>>>>>Fred-
>>>>>>
>>>>>>I just tried one table.
>>>>>>
>>>>>>I copied the table that was created in VFP 6.0 to a DataTest folder.
>>>>>>In the command window I typed
>>>>>>
>>>>>>CLOSE ALL
>>>>>>CLEAR ALL
>>>>>>CREATE DATABASE Test
>>>>>>ADD TABLE WsCans
>>>>>>The error still occured.
>>>>>>The problem with the code below is that I would be creating the tables in VFP 9.0 not in VFP 6.0.
>>>>>>
>>>>>>If you don't mind I can email you the three files for this one table.
>>>>>>Then we can verify the error on your side.
>>>>>>
>>>>>>Dan
>>>>>>
>>>>>>
>>>>>>>Then you must be opening the tables in some other manner. Does this work without error for you? It does for me.
>>>>>>>
>>>>>>>

CLOSE DATABASES ALL
>>>>>>>
>>>>>>>CREATE TABLE t1 (f1 c(1))
>>>>>>>USE IN SELECT("t1")
>>>>>>>CREATE TABLE t2 (f1 c(1))
>>>>>>>USE IN SELECT("t2")
>>>>>>>CREATE TABLE t3 (f1 c(1))
>>>>>>>USE IN SELECT("t3")
>>>>>>>CREATE TABLE t4 (f1 c(1))
>>>>>>>USE IN SELECT("t4")
>>>>>>>CREATE TABLE t5 (f1 c(1))
>>>>>>>USE IN SELECT("t5")
>>>>>>>
>>>>>>>CREATE DATABASE test
>>>>>>>
>>>>>>>ADD TABLE t1
>>>>>>>ADD TABLE t2
>>>>>>>ADD TABLE t3
>>>>>>>ADD TABLE t4
>>>>>>>ADD TABLE t5
>>>>>>>
>>>>>>>

>>>>>>>
>>>>>>>>Fred-
>>>>>>< snip >