Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FOUND() not evaluating correctly in function from SQL
Message
From
11/05/2004 17:37:38
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00902996
Message ID:
00903003
Views:
17
Hey Sergey,

UT ought to start paying you. That was worth the price of admission for me right there. As usual, Thanks!


>The FOUND() function w/o parameters reports result for the current work area which, I guess, is different from the one you're doing SEEK in. It's better to use SEEK function which returns result.
IF SEEK(tPlanID, "crsPlanCount", "PlanID")
>
>>The following is part of a function that is called from a SQL statement. If I check the record pointer of the crsPlanCount cursor before the SEEK and immediately after the SEEK I can see that it found the correct record, but the FOUND() evaluates to .F., which is wrong. Anyone know why?
>>
>>
>>SEEK tPlanID ORDER PlanID IN crsPlanCount
>>
>>IF FOUND()
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform