Hi, this is not actually a "real" question given that I was able (due to 
the app's characteristics) to go another way. But the question is still 
bumping inside my head.
This is VFP 6.0, and there is no DBC for this app (though I guess I 
could create it if necessary).
I have :
Flds.dbf :
         Id I
         Name C(40)
         Type C (1)
         Width I
         Decs I

TblFlds.dbf:
         Id    I
         TblFK I
         FldsFK I
         Value C(200)

Tbl.dbf => some table with it's own ID field and some fields

Now the Flds table defines extra, user defined, fields to be added to 
Tbl, the TblFlds has the actual values (converted to string) of those 
fields for every Tbl record.
In my app I "flatten" those extra fields into a cursor (crsrTblFlds) 
that the user may modify at will. And I wanted the user to be able to 
click an "Update" button when he is done with his changes, or a "Revert" 
button if he want's to undo things. I do 
"""CursorSetProp("Buffering",5,"crsrTblFlds")""", now the "Revert" 
button is no problem at all. But the "Update" button is tricky. I had 
thought of using triggers on the cursor and for every 
insert/update/delete performed by """TableUpdate(.T., .F., 
'crsrTblFlds')""" to update the cursor trigger corresponding 
updates/inserts/deletes in both TblFlds and Tbl. This of course won't 
work as crsrTblFlds is a cursor and not included in a DBC (you need a 
DBC to define a trigger).
Any ideas?



_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to