Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ParameterList
Message
From
08/02/1999 22:49:16
 
 
To
08/02/1999 16:13:20
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00185087
Message ID:
00185381
Views:
25
In all of my adventures with VFP views (tool construction etc.) , I have never seen this work. Luckily, I have never had a need for it.

>Hi Sarosh ----
>
>Hmmmm.....I just tested it on a local view and on a remote (SQL Server) view and you are right, it is blank for both VFP5 *and* VFP6.....
>
>>
>>Any idea why the "ParameterList" cProperty of
>>DBGETPROP() is not returning the correct string?
>>
>>I have a P-View (Remote)
>>
>>DBGETPROP("v_customer", "view", "sql")returns the correct string
>>[SELECT * FROM customer Customer WHERE Customer.id_customer = ?m.id_customer]
>>
>>but DBGETPROP("v_customer", "view", "ParameterList") returns an empty string Why?
>>
>>According to help it should return ["m.id_customer","I"]
>>
>>*******An extract from Help
>>The WHERE clause parameters. The format for the parameters is ''ParameterName1, 'Type1'; ParameterName2, 'Type2'; ...'' where Type is a one of the following characters specifying the parameter type:
>>C - Character
>>D - Date
>>T - DateTime
>>N - Numeric
>>F - Floating
>>B - Double
>>I - Integer
>>Y - Currency
>>L - Logical
>>
>>For example, ''MyParam1, 'C' '' specifies a single character type parameter named MyParam1.
>>*******An extract from Help
>>
>>Thanks
>>
>>Sarosh
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform