Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Binary Index Weirdness
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01005602
Message ID:
01005621
Views:
16
Thanks, Sergey.

It's too bad. It's the perfect solution for what I need in this case. It's a table for tracking timeclock punches - one record for each in / out pair. If the 'Out' field is NULL, then the employee is assumed punched in. The table will contain a lot of records, and the majority of the records will not have a NULL value in the 'Out' field.

In your view, would I be better off using something like this?
INDEX ON pk_employee FOR ISNULL(out) TAG InEmps

Thanks.

-Matt
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform