Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the best place to save record data in a grid
Message
De
30/04/2001 12:34:11
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00501593
Message ID:
00501606
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
>>>Hi everybody,
>>>
>>>I have a form with a Record-Buffering table and a grid. I want to save data from one field for each current record. As I understand, it could be a form (or grid) property, say, cOldData. The question is: what's the best method for saving this olddata? The form has a navigation bar, which allows to move from record to record + user can navigate through grid itself.
>>>
>>>Thanks in advance.
>>
>>Update trigger ?
>>Cetin
>
>I don't understand your suggestion :( Besides, the table is not necessaryly the part of database, it could be a free table. For each current record I want to save an OldData. Could it be a method in the form? From where should it be called? It might be against n-tier design, but here we have just single tier application...

Free table :) OK.
If mdown()
  lnBottom		= .top+.headerheight+.relativerow * .rowheight
  lnTop			= lnBottom - this.rowheight
  lnMouseRowPos	= mrow(wontop(),3)
  lnMouseColPos	= mcol(wontop(),3)
  llChangingRow	= !(between(lnMouseRowPos,lnTop, lnBottom) ;
    and between(lnMouseColPos,.left,.left+.width))
Else
  llChangingRow	= inlist(lastkey(),24,5,18,3,145,148)
Endif

If llChangingRow
  If getfldstate('myField',this.Recordsource)%2=0
    Wait window ;
      'OLDVAL:'+nvl(oldval('myField',this.Recordsource),'')+chr(13)+;
      'NEWVAL:'+nvl(eval(this.Recordsource+'.myField'),'')
  Endif
Endif
Navigator buttons have something like Beforemove I think.
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