Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locked records in SQL statement.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00331985
Message ID:
00332011
Views:
16
As long as you have only one table in your SQL query, you can use the ISRLOCKED() function as one of you columns.
select *,isrlocked() as locked from mytable into cursor c_temp
However, do not use this with a multi-table query because aliases don't work consistently with SQL select statements and the ISRLOCKED() function will get confused without the alias.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform