Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making SQL Pass-Through Cursor Updatable
Message
De
07/03/2003 02:30:24
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
06/03/2003 14:41:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00760620
Message ID:
00762603
Vues:
22
>Thanks for your reply! I modified your code to use my data source. It's still not saving the change I make to the field "Paginated". Am I crazy or what? The code is below for your review. Any help would be appreciated.
>
>lnHandle=Sqlstringconnect('DRIVER=SQL Server;SERVER=sqlserver;'+;
> 'DATABASE=MacroPro;Trusted_Connection=Yes')
>
>SQLExec(lnHandle,'select * from dbo.routes','v_routes')
>CursorSetProp('KeyFieldList','id','v_routes')
>CursorSetProp('WhereType',1,'v_routes')
>CursorSetProp('Tables','routes','v_routes')
>
>CursorSetProp("UpdateNameList", ;
> "paginated routes.paginated",'V_routes')
>
>CursorSetProp('UpdatableFieldList','paginated','v_routes')
>CursorSetProp('SendUpdates',.T.,'v_routes')
>CursorSetProp('Buffering',5,'v_routes')
>
>Browse title "before Update - edit"
>Tableupdate(2,.T.,'v_routes')
>SQLExec(lnHandle,'select * from dbo.routes','afterupdate')
>SQLDisconnect(lnHandle)
>Select afterupdate
>Browse title "After update"

I repeat :) Add keyfield to updatenamelist.
CursorSetProp("UpdateNameList", ;
 "id routes.id,paginated routes.paginated",'V_routes')
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform