Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with tableupdate & remote views
Message
De
30/01/2002 10:44:42
 
 
À
30/01/2002 05:24:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00611955
Message ID:
00612743
Vues:
27
Actually, I came up with a different idea that works fine.

Instead of using a SQL Server view, I created the equivalent SQL call as a SQL server stored proc.

So now, instead of going through 3 layers, VFP SQLPT Cursor->SQLServer View
->SQL Server Table, it's straight from the VFP SQLPT Cursor to the SQLServer table, which seems to agree with VFP, since it now, with no further ado (?), produces the correct results.

Thank's people!

>before you make Insert/Replace, open a new SQL connection handle,
>and close the handle after made the operation.
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform