>Who can help me?
>
>I use with the following syntax:
>
>do (_genxtab) with 'final1',.t.,.f.,.t.,1,2,3,.t.,0
>
>And I get cursor 'final1'.
>If the values for all the lines of specific category is 0, I don't get column for this category in the cursor.
>The problem is that if I try later to get data from this field (in code or report field) I get error message.
>How can I resolve the problem by forceing 'genxtab' to include columns even all the values is 0.
>Big thank you for helping me
You can not force GenXTab to include columns it has no data for. You either have to scan the cursor used by genxtab and insert records with these zero values so genxtab will have something to work with before you call genxtab, or you have to check the output 'Final1' cursor to see if all the columns exist. You can add any missing columns with the ALTER TABLE command. You will probably have to USE DBF('final1') AGAIN IN 0 ALIAS NEWFINAL1 in order to add missing columns to the NEWFINAL1 cursor.
Mark McCasland
Midlothian, TX USA