Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Control for number of records
Message
De
25/05/1999 06:49:24
 
 
À
25/05/1999 06:39:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00222377
Message ID:
00222381
Vues:
21
Hi Vlad ----

A good bulletproof way to do it is:

Create a view in your database:

CREATE SQL VIEW vueRecCount AS SELECT CNT(*) AS mytablerecs FROM mytable

Add this view to the DE of the Form where you want. To show it, add a TextBox and bind it to vueRecCount.mytablerecs. If an Add or Delete changes the record count, then a simple =REQUERY('vueRecCount') resets the total records.

>Is there any control which I can place on a form and it will show the number of records in one table from the DE ?
>
>Thanks in advance !
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform