Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBGETPROP('myview', 'View', 'ParameterList' )
Message
 
To
06/07/2002 16:49:48
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00674571
Message ID:
00675905
Views:
12
Jill,
Right you are. Also you can use the DBSETPROP to set them first. Problem for me was that with several 100 views I just didnt want to waste 3 or 4 days doing all that...soooooo what I did was run the gendbcx program to create a .prg of my database...then I made another program that reads in that .prg (text file) and figures out what all the parameters are and automaticly stuffs them all in there with the DBSETPROP command..heh..pretty slick, huh?


>Victor,
>
>It looks like you have to, in the View Designer, use the View Parameters option in the Query menu to tell VFP explicitly what kind of a parameter is expected.
>
>J
>
>>Ok...this doesnt work:
>>
>>DBGETPROP('myview', 'View', 'ParameterList' )
>>
>>Unless you've first done the matching DBSETPROP for it. I guess VFP doesn't do this for you automaticly I kinda wish it did.
>>Anyway - so now my problem is that I've got several 100 views that need to have their parameterlist filled. Does anyone know of a little gizmo/utility that will do this for me or am I stuck making something?
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform