>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.