Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax for Calling SQL View using CursorAdapter
Message
De
23/02/2005 16:47:07
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
00989846
Message ID:
00989861
Vues:
30
>>Hi All,
>>
>>What do I need to put in the 'SelectCmd' property of a CursorAdapter to use a SQL View?
>>
>>Aloha,
>>
>>James
>
>James put by Example:
>
>select customer.id, customer.name from customers
>
.

Hey Vladimir,

Sorry I should have been more specific. I am looking for what the syntax is to call a SQL view stored in a SQL Server database.

I know that to call a stored procedure you store the following in the CursorAdapter's SelectCmd:
Exec <StoredProcName>
How do I call a view stored in my SQL database?

Aloha,

James
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform