Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
From
11/04/2005 10:51:33
 
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:
01003366
Views:
26
>>>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.

Great !
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform