General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Chung
You see the DBSETPROP command can be used to set a property just for that particular field. The width of the numeric field is being defined in a manner you don't want presumably when you run CREATE VIEW SQL command. After that command runs you use DBSETPROP('myView.myField','Field','DataType','N(5,2)'). So, you see it really is 1 line of code. I just rarely use the code, so I had to look it up.
eView is a tool for you use, not to be distributed to your clients or users. It is merely a better visual tool than the standard VFP one to edit views. It also generates good code.
Wally
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only