What I want to do with my DBC-housed tables is enter the following in the field validation rule of most fields of my tables (in the table Properties thru the DBC designer):

     FieldVal(ThisColumn)

And then have my generic FieldVal function take some action based on the column parameter that is passed to it. That way I can have a single location for field-level code and it will work whether I am using the data from a desktop app or a faceless COM app, since it happens at the DBC level.

But my problem is that there doesn't seem to be a DBC-level command/function in the language to say what column/field VFP is currently looking at. I can know where the record/row pointer is with recno() but I don't know where the "column pointer" is.

I would hate to have to enter individual field-level handlers for each field (my database has 30 tables each with 10+ columns) when I could have a central one.

I know VFP knows something it's not telling, since I can open up a BROWSE window, hilight a field, go to the command prompt, monkey around, click back to the BROWSE and I am in field cell where I left off 3 minutes ago.


I hope that makes more sense, I have been staring at this so long I am confusing myself. :)