Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
An alternative to the view designer
Message
From
22/12/1998 17:43:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
An alternative to the view designer
Miscellaneous
Thread ID:
00169860
Message ID:
00169860
Views:
50
I have just uploaded my eview utility to the files section here (VFP in General)

eView was written to be a replacement for the VFP view designer. From the readme file:

eView allows you to:
- set the view as updatable or not
- edit the keyfield property for view fields
- edit the updatable property for view fields
- View each field's updatename property
- specify how the WHERE clause is constructed for updatable views
- specify whether rows are updated using UPDATE, or DELETE and then INSERT
- edit extended properties for view fields including:
- Validation Rule Expression
- Rule Text (Message)
- Default Value
- Caption
- Format
- Input mask
- Comment
- Display class
- Display class library

- View and edit properties pertaining to Remote views including;
- Fetch memo
- Prepared
- Offline
- Share Connection
- Compare memo
- Fetch as needed
- Memo size
- Fetch size
- Max records
- Batch update count

- View (not edit) the SQL used to construct the view

In addition to these functions, eview has utilities to:
- Generate a prg that will completely recreate the view from scratch (this is the same as my GenView utility)
- Copy all field properties from underlying tables (ie caption, input mask, etc)


I have already found this to be of great help to me, and if you maintain views that are uneditable in the VFP view designer, I think you will find this indispensible.

Please download and give comments and suggestions. There a a couple of quirks that I am aware of, but they involve views that are already broken. I am still working on it. Please inform me of any problems.
Erik Moore
Clientelligence
Reply
Map
View

Click here to load this message in the networking platform