Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odd List Stru Results?
Message
From
25/01/2002 15:45:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00610708
Message ID:
00610774
Views:
20
Thanks for clarifying Sergey - good answer!

>There's one bit reserved per NULL column per record. With 9 NULL columns you get 9 bits or two bytes.
>
>>
>>CREATE CURSOR temp ( ;
>>  c1 C(1) NULL ,;
>>  c2 C(1) NULL ,;
>>  c3 C(1) NULL ,;
>>  c4 c(1) NULL ,;
>>  c5 C(1) NULL ,;
>>  c6 C(1) NULL ,;
>>  c7 c(1) NULL ,;
>>  c8 c(1) NULL  ;
>>)
>>LIST stru
>>
>>
>>Total record length is 10 bytes (1 for delete, 1 for NULL)
>>
>>
>>CREATE CURSOR temp2 ( ;
>>  c1 C(1) NULL ,;
>>  c2 C(1) NULL ,;
>>  c3 C(1) NULL ,;
>>  c4 c(1) NULL ,;
>>  c5 C(1) NULL ,;
>>  c6 C(1) NULL ,;
>>  c7 c(1) NULL ,;
>>  c8 c(1) NULL ,;
>>  c9 c(1) NULL ;
>>)
>>LIST stru	
>>
>>
>>Added just one more column and instead of 11 bytes (9 + 1 for delete + 1 for NULL) it returns 12. Why? What is up with the extra byte?
Previous
Reply
Map
View

Click here to load this message in the networking platform