Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem With EXE on Server
Message
De
16/11/2003 13:41:53
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
 
À
13/11/2003 10:48:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00849530
Message ID:
00850462
Vues:
17
It may be that the form is "finding" the wrong database. Try...

1) In the DE BeforeOpenTables method for each cursor object add...

This.CursorObjectName.Database="\\serverpath\dbcname.dbc"

2) Set the cursor's NoDataOnLoad property to .T.

3) Then when you need the data, set the paramaters and the issue a

lcParam1 = whatever1
lcParam1 = whatever2
=REQUERY('CursorAlias')

HTH,
Larry Long


>Hi
>
>Heres my problem.. I have an app that uses 2 remote sql server views to display some data in a grid.If i run the EXE locally it works fine however trying to run it from a mapped network drive it errors out loading the form with a 2005 error loading the data environment. So I know it has something to do with loading the view but not sure why. If I open the database on the server i can open and browse the remote view without any problem.
>
>Thanks,
>
>Paul
L.A.Long
ProgRes
lalong1@charter.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform