Information générale
Forum:
Microsoft SQL Server
Thanks Sergey,
I am been assigned to FoxPro again!
Good to hear from you again.
Jim
>>I am creating a report in Visual Foxpro 6.0 based on an SQL 2000 view. I would like the view to ask the user for a sales order number and then run the view for just that sales number. Can an SQL view do this?
>>
>>Thanks
>>Jim
>
>Jim,
>
>Sql Server doesn't have parameterized views. You can create remote view based on that Sql Server view or use SPT (SQLEXEC()) with parameterized WHERE clause. You can use INPUTBOX() function to get order number from user.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement