At 02:29 PM 01-12-01 -0600, you wrote:

>I just tried it and it still creates them wrong. Here's a sample of the
>EditSql that it made.

Don,
What is wrong with it?

Helen

>UPDATE EXCLUDEINFO SET
> DAY_ID =:DAY_ID, /*PK*/
> ID =:ID, /*PK*/
> SRVC_TIME =:SRVC_TIME, /*PK*
>WHERE
> DAY_ID = :OLD_DAY_ID AND
> ID = :OLD_ID AND
> SRVC_TIME = :OLD_SRVC_TIME
>
>And here is the InsertSql it created:
>
>INSERT INTO EXCLUDEINFO(
> DAY_ID, /*PK*/
> ID, /*PK*/
> SRVC_TIME, /*PK*)
>VALUES (
> :DAY_ID,
> :ID,
> :SRVC_TIME)
>
>The sql statement that I use is simply:
>
>select *
>from excludeinfo
>
>I know this is easily fixed and probably is from the fact that all fields
>are key fields. But it still created it wrong so that is why I was
>reporting it as a slight bug.
>
>Thanks.
>
>""Don Gollahon"" <dlgllhn@...> wrote in message
>news:9ub050$ug1$1@......
> > I recreated the whole database from scratch. This table had that problem
> > before I changed it, too. The table is part of a scheduler that I've been
> > using. It coordinates data from two other tables, a member table which is
> > the ID field, and an event table which is the Day_id and Srvc_time fields.
> > People are randomly scheduled for several months at a time to cover
>certain
> > events. The ExcludeInfo is a list of events that people cannot cover
> > because they are not available. The scheduler knows which to skip for
>each
> > person by this table. They are all keyed so I can quickly find them.
> > Remember, this was in Paradox before and certain things had to be in order
> > to easily port it to IB. I plan on cleaning up the table structures in a
> > later release.
> >
> > Anyway. I didn't have any keylinks setup for this table. I'll try adding
> > them and see if it creates the updateSql correctly. It seems to work okay
> > without them since I manually adjusted the slight errors the generate
>button
> > created.
> >
> > "Helen Borrie" <helebor@...> wrote in message
> > news:4.2.0.58.20011202002422.02090ae0@......
> > > At 11:44 PM 30-11-01 -0600, Don Gollahon wrote:
> > >
> > > Did you delete and rebuild your persistent field objects after changing
> > the structure of the table? Delphi won't do this for you...
> > >
> > > Also double check that your KeyLinks are correct for the new structure.
> > They should now be
> > > ID
> > > DAY_ID
> > > SRVC_TIME
> > >
> > > (and I'm asking myself why you need all three columns in your primary
> > key...)
> > >
> > > Helen
> > >
> > >
> > > All for Open and Open for All
> > > InterBase Developer Initiative · http://www.interbase2000.org
> > > _______________________________________________________
> > >
> > >
> > >
> >
>___________________________________________________________________________
> > > IB Objects - direct, complete, custom connectivity to Firebird or
> > InterBase
> > > without the need for BDE, ODBC or any other layer.
> > >
> >
>___________________________________________________________________________
> > > http://www.ibobjects.com - your IBO community resource for Tech Info
> > papers,
> > > keyword-searchable FAQ, community code contributions and more !
> > >
> > > Your use of Yahoo! Groups is subject to
>http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> >
> >
> >
> >
> >
>___________________________________________________________________________
> > IB Objects - direct, complete, custom connectivity to Firebird or
>InterBase
> > without the need for BDE, ODBC or any other layer.
> >
>___________________________________________________________________________
> > http://www.ibobjects.com - your IBO community resource for Tech Info
>papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________