Re: Data changes but reverts.


trw7at@xxxxxxxxxxxxxxxxxx (Tim Witort) wrote in
news:Xns967C746ECBFB0timwitortwrotethis@xxxxxxxxxxxxxxx:

> A couple of items that come to mind are:
>
> 1) Are any/all of the affected tables buffered? If so, you need to
> issue a TABLEUPDATE() in there to commit the changes.
>
> 2) Wizard-built stuff is notoriously problematic. I would never
> trust my data to a wizard-built form. It may or may not be
> involved in your problem... but you've been warned.
>
> 3) What is the primary and foreign key in your relationship
> between the symbols and securities tables? If it's the
> "symbol" field, you've got a table design problem. The
> primary and foreign key fields should not be "meaningful"
> data and should not be changed. You're asking for trouble
> if this is the case.
>
> 4) When you say you've "tried automatic RI", that implies that
> you created a cascading update rule. Again, this indicates
> that you are changing the value of a primary key and want
> the RI code to change this in the child table. This is bad
> mojo.
>
> -- TRW


Hi and thanks for your help!

In response to your points...

1. Yes, they are buffered. I did a TABLEUPDATE() and it's now working!
Thanks!

2. I had seen some mention of this before, but I needed the navbar
(buttonbar) and didn't want to have to do it all myself.

3. The symbol field is the primary key in the Symbols table and it is
the field I need to change. I guess I could create a new, non-user-
visible field (maybe an autoinc field) as a proxy for the symbol field;
but it seem redundant.

4. I revisited the RI stuff and it's now working nicely.

There are several new features in VFP9 (I'm used to VFP6 and earlier) so
the learning curve is a bit steep. But I'm getting there ;>)

Thanks again,

Frank
.