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?


Tai SC


>OK. I went back to my trust FPW2.6a to run the same thing.
>
>Using FPW2.6a's Query Designer and forcing it to cross-tab,
>gives you the following SQL code:
>
>SELECT *;
> FROM Size;
> GROUP BY Size.code, Size.size;
> ORDER BY Size.code, Size.size;
> INTO CURSOR SYS(2015)
> DO (_GENXTAB) WITH 'Query'
>BROWSE NOMODIFY PREFERENCE Query
>
>AND it gives you the following data output:
>
>Code C_1 C_2 C_3
>========== ========== ========== ==========
>001 S M L
>002 M L
>003 XS S L
>
>This is identical in output to what I showed you in VFP 5.0a.
>FPW2.6a only has slightly different, but unimportant, differences
>in the SQL code. It's identical.
>
>It does use the program GENXTAB that may or may not be setup
>correctly for your installation. Just make sure the system
>memory variable "_GENXTAB" has something other than the null
>value where the actual value string is a legitimate reference
>to where GENXTAB.prg is located. For example,
>_GENXTAB= "C:\fpw26\genxtab.prg". If it doesn't have any
>value, make sure to permanently put it in your CONFIG.FP(W)
>file so this never occurs again.
>
>Hope some of this gets where you want to go!