Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bug on CursorAdapter.UpdateType where i can report the b
Message
De
10/11/2002 10:51:07
 
 
À
07/11/2002 08:24:38
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00719735
Message ID:
00720754
Vues:
19
Hi Emanuele.

>I have some problem with UPDATETYPE properties on CursorObject.
>Infact even if i assign explicity UPDATETYPE=1 (should be default) the Cursor Adapter have the same behaviour as UPDATETYPE=2.

I can't reproduce this. When I created a CursorAdapter similar to yours, the BeforeUpdate method showed that the update command sent to SQL Server was:
UPDATE CUSTOMERS SET COMPANYNAME=?customer.companyname WHERE CUSTOMERID=?OLDVAL('customerid','customer') AND COMPANYNAME=?OLDVAL('companyname','customer')
In SQL Profiler, the command received was:
exec sp_executesql N'UPDATE CUSTOMERS SET COMPANYNAME=@P1  WHERE CUSTOMERID=@P2  AND COMPANYNAME=@P3 ', N'@P1 varchar(40),@P2 varchar(5),@P3 varchar(40)', 'Alfreds Futterkistee                    ', 'ALFKI', 'Alfreds Futterkiste                     '
Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform