Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
USE myview NODATA... and VFP ask for parameters???
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00313345
Message ID:
00314572
Views:
50
I see - I didn't realize it was on creation. Obviously a cursor will work if it doesn't need to be updateable, but couldn't you just assign an empty string to the parameter before creating the view?

MyParam = ''
CREATE view..... where Myfield = ?MyParam.....

Barbara

>Hi Barbara,
>
>The problem was on CRAETING the view!
>After i do CREATE SQL VIEW ....
>VFP returns me that message, asking for a parameter.
>
>I think i'll go for another way: create a cursor!
>Thanks, anyway!
>
>Everything OK?
>
>Ricardo
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform