Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't update the input data finto the TABLE
Message
De
30/11/1999 05:10:53
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
29/11/1999 23:21:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00296296
Message ID:
00296754
Vues:
22
>Cetin, thanks for your advice. In the datasession, the buffering mode of the ODETAIL table is set to 5. How can I use the tableupdate() function.
>
>Please teach how to use it.
>
>Best Regards
>Dennis


Dennis,
When you're satisfied with data and should be saved call :
tableupdate(2,.t.,"tablename")

This is a quick start and work in many cases.
Of course parameters might change depending on your case. Look at its help for parameter definitions. It returns a logical meaning if update was succesfull or not. You should check why it failed (ie: it might fail for someone else edited in between - curval() and oldval() do not match).
Help about buffering detailly explain and sample it. Also check wizard buttons save/edit code (wizstyle.vcx - txtbtns).
A save routine (a quite rough skeleton) :
begin transaction
if lEverythingIsOK
  if tableupdate(....)
     ....
     end transaction
  else
     ...
  endif
else
  rollback
endif
Also there is tablerevert().
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
Répondre
Fil
Voir

Click here to load this message in the networking platform