Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
eView is good indeed, at lease I can manipulate the SQL manually, thanks for that.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement