Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiuser app, second instance losing grid bindings
Message
De
20/11/2008 02:36:15
 
 
À
20/11/2008 01:56:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01361877
Message ID:
01363064
Vues:
13
You must change the line Append From CaseSQL_X into Append From dbf('CaseSQL_X')

>Yea, I thought of the NoFilter. Added to make sure but still the same.
>
>I tested an old system and it is working fine.
>
>Grid RecordSource is set to "CaseSQL"
>
>The initialize function in LOAD method of the form is:
>
>
>Select * from Event Where .F. into Cursor CaseSQL READWRITE NOFILTER       && create blank cursor
>
>Select * from Event Into Cursor CaseSQL_X NOFILTER                                        && Get new values for cursor
>
>Select CaseSQL
>ZAP                                                                                                                  && clear out cursor
>Append From CaseSQL_X                                                                                  && append new records
>Use in CaseSQL_X                                                                                             && destroy temp cursor
>
>
>Subsequent requeries use the same method of Selecting into a temp cursor (CaseSQL_X) and zapping and appending into the CaseSQL cursor.
>
>Again, first run works fine. Second instance the Grid loses its columns (now I see that even Column1 does not exist).
>
>Also, I am retracing an old system where this exact code is working on the same network.
>
>Very confused.......
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform