General information
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only