Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01002645
Message ID:
01003363
Views:
29
>>I just tried Walter's Meester Tax RIBuilder and it works very fast. I need to test bad conditions, though.
>
>Well, it is not working either. In the long Case statement the right part of the expression is in proper case while the left part is in the lower case. Weird.


To be fair to Walter I later found, that it was actually my fault. Since I ran his builder on the tables with existing _ri_handler, it inserted his stuff and added the old trigerrs code. So I had some code to remove the old triggers. That code converted the original triggers to the lower case. When I re-ran his builder, it was in the proper case. I still was able to put the bad code, but I think it's because our RI were not defined for that code. I didn't test it more thoroughly, though, because I think I'm going to work on NewRI procedure instead.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform