Re: Data changes but reverts.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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
.

Relevant Pages

  • Re: FAQ? factors influencing choice of data type for primary key
    ... >>example, an Autonumber as a primary key, are there ... >>it is a foreign key? ... >don't need to bring the lookup table or any indexes into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: OT: SQL & Dave
    ... A&E broadcast ... My initial thought was to have the "show number" be the primary key, ... so that it'll be the foreign key in other tables (guests, staff, ... could I set up those other tables (guest, ...
    (alt.fan.letterman)
  • RE: Creating an DB for an Office Rota/Skills
    ... Also how do i set up a foreign key? ... primary key because atm i have to type them in eg. 1.2.3.4.5 for each persons ... "Duane Hookom" wrote: ... fields for skills and/or days then you are on your own. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Data Normalization
    ... CustomerID foreign key. ... of the database whether an SSN would be a good candidate for a primary key. ... applicable that relates that given record to it's parent. ... Create the relationship between the child table and my new parent ...
    (microsoft.public.access.queries)
  • Re: Database Design Question
    ... > Using foreign keys to form a composite primary key of a child ... > LanguageId int identitynot null, ... If the foreign key does not lead the Primary Key, ...
    (microsoft.public.sqlserver.server)