Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting RECNO() in an SQL-Select statement
Message
De
23/02/2000 15:23:22
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00336045
Message ID:
00336262
Vues:
23
You can use the fonction Count() function

It is suppose to be something like this
Select Count(*) From Table1


>I need to filter based on the recno() of a certain table. This works fine when selecting from one table, but with a join recno() looks at the wrong table and recno('myTable') just returns the current location of the record pointer. Is this possible? Or how about a select statement that show the recno() for each table in a join:
>
>SELECT recno('table1'),recno('table2') from table 1 join table2 ....
>
>I know this won't work, but is there a way to get what I'm looking for in one SQL statement?
>
>Thanks,
>Marcus.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform