Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Native RI Builder replacement
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
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00996358
Message ID:
00996459
Views:
14
Well, how this code is supposed to work:
* Update Trigger
      CASE lcTriggerType = "UPDATE" ;
          AND laRelations[i, PARENTCOL] = lcTable
What if I have Trans_Employees_Queues and Trans tables?

UPDATE. I take it back. It does have SET EXACT ON which I didn't notice.

>PMFJI but if it aren't broken ...
>
>>Thanks, Craig. Do you think it's a good idea to slightly improve the code? E.g. I glanced at it yesterday and noticed the loop through array of relations. In our current database we have 252 relations (sic!) So my thought was that we can use ascan instead. But I don't know if it's worth the effort or the code is executed fast enough anyway.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform