Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBGETPROP(cfield,field,defaultvalue) returns []
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01034939
Message ID:
01035019
Vues:
14
Hi Daniel,

It's strange.

You can use PDM LINK: http://www.levelextreme.com/wconnect/wc.dll?LevelExtreme~2,54,33,9428 for creating html about your table or use my package for DBC low level
SET PROCEDURE TO DFO.PRG
#INCLUDE "dbc.h"
LOCAL lcAlias,liID,luValue

* Open DBC as table
lcDBC="c:\temp\xxd001.dbc"
lcAlias=SYS(2015)
USE (lcDBC) IN 0 ALIAS (lcAlias)

* Get object's ID for field (table/view)
liID=DBC_GetIDObject(lcAlias,_DBC_Field,"xxt001.pol1")

* Get value
=DBC_GetProperty(lcAlias,liID,_DBCID_InputMask,@luValue)
?luValue

* Set Value
=DBC_SetProperty(lcAlias,liID,_DBCID_InputMask,"99999999")

* Clear Value
=DBC_ClearProperty(lcAlias,liID,_DBCID_InputMask)

* Get all propeties of object
DIME laProps(1)
liCount=DBC_EnumProperty(lcAlias,liID,@laProps)
?"Name","Value"
FOR lii=1 to liCount
    ?laProps(lii,1),laProps(lii,2)
NEXT
MartinJ

>Hello all,
>
>The default value for a table in a DB is: GetproperValue('eqmtlist').
>If I say
>? DBGETPROP("eqmtlist.iid", "Field", "DefaultValue" ) it returns ""
>
>Another table has the default value of: GetproperValue('eqmtprocess')
>If I say
>? DBGETPROP("eqmtprocess.iid", "Field", "DefaultValue" ) it returns
> "GetproperValue('eqmtprocess')"
>
>But if I modify the default value for EqmtProcess to something like
>GetproperValue('eqmtprocess5') then say
>? DBGETPROP("eqmtprocess.iid", "Field", "DefaultValue" ) it returns
> "GetproperValue('eqmtprocess')" once again.
>
>I've recompiled the db as well.
>DB's in other have no problem with this...
>
>go figure.. lol
>Thanks,
>Daniel
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform