Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Custom Query Criteria dialog
Message
 
 
To
08/09/2009 10:31:33
General information
Forum:
Visual FoxPro
Category:
Visual ProMatrix
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01422473
Message ID:
01423075
Views:
30
>>Jack,
>>
>>I was thinking about how to structure this table. Say, if I want to use some custom criteria for several forms, should it be multiple records table?
>>
>>Can you please elaborate a bit more of how did you implement it?
>>
>>Thanks a lot again.
>
>
>I just added all the fields in all my custom query screens to the sxxxdmvu table. There are couple of ways to use this table. You can create a view of the table for your custom query form. Open the view in the report, append a record, display the form, use the values then throw away the data. This will keep the dmvu table from growing. Or you can add real records to the dmvu table or recycle records. Or you can just the dmvu table as a builder for the form and use all memory variables. Just different ways of doing it.
>
>In answer to your other question, Promatrix does not have a date range control, but of course you can build one easily.

I'm looking at all tables in Data Manager (running it from the application itself) and I don't see DMVU table at all.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform