None of the table I tried works. It is strange.

In fact, I have also tried SELECT .... INTO TABLE XXXX and DO _GENXTAB WITH 'Query1'. The 'Query1' becomes a table where the structure is correct (with C_1 C(10), C_2 C(10).... ). I just don't seem to get any data in the table.

I will try on VFP later on. Many thx. for all the help.


Tai SC


>> Well, it is puzzling. If I change the third field to a numeric type, it
>> works. If the third field is a character type, it doesn't.
>>
>> I create a fresh table and it doesn't work. What can be the reason.
>>
>> My table is 'test' with fields ( test1 c(5), test2 c(1), test3 c(5) ). It
>
>> just doesn't work unless I change test3 to numeric type.
>>
>> Does it mean it only works in numeric type?
>>
>The results I got with the FPW2.6a Query Designer were with your
>initial data where no numeric fields were involved. It worked.
>
>Now, you're showing me yet another table that doesn't work for you.
>What happened to the first table called "Size" that you had defined?
>Did that work?