Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASAP: do (_genxtab) problem
Message
 
 
To
28/01/2003 09:16:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00746165
Message ID:
00746195
Views:
30
This message has been marked as the solution to the initial question of the thread.
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform