Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
An Empty Table
Message
 
 
To
25/02/2012 12:47:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01536548
Message ID:
01536549
Views:
76
>how to check that the table is empty not a field a table
>I tried with empty but it works only with field
>Thank you
IF RECCOUNT() = 0
  * Table has no records at all
...


*If table can have deleted records (assuming SETE DELETED ON)
SELECT * FROM mytable TO SCREEEN NOCONSOLE 
IF _TALLY = 0
  * Table has no none-deleted records
...
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform