Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
100's of DataSessions ~ Can't CLOSE DATABASES
Message
De
02/10/2008 16:03:09
 
 
À
30/09/2008 17:29:14
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 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01351935
Message ID:
01352390
Vues:
26
The problem was finally resolved.
Our regime conditionally runs auxiliary code via EXECSCRIPT() in an independent DataSession.
In one set of circumstance, it did a SCATTER NAME to a property of the business object.
Because of this a dangling reference remained (the assigned property) and hence the intransigent DataSession.

The fix was to move back to the default DataSession just long enough to:
 THIS.ADDPROPERTY("PropertyName",CREATEOBJECT("EMPTY"))
Then return to the independent DataSession and…
    FOR nThisColumn = 1 TO FCOUNT("AliasName")
      ADDPROPERTY(THIS.PropertyName ,FIELD(nThisColumn), EVALUATE(FIELD(nThisColumn)) )
    ENDFOR
Thanks to David Frankenbach and Mike Yearwood for their help.

Regards to all,
Thank you,
- Frank
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform