Vantage 8.00.809c on SQL 2000 - table index problem?

We have seen that problem also, solved it by using a SQL update
query to copy the values in the column named PROGRESS_RECID_IDENT_
to the other PROGRESS_RECID column. I would make sure everything is
well backed up before trying that, but it should fix it.

Dave Thomas



--- In vantage@yahoogroups.com, "Gary Franks" <garyfr2003@...> wrote:
>
> David....Do you have FULL TEXT SEARCH CATALOGS setup in your
> installation? If not, I'm pretty sure you will need them. If so,
you
> might look to see if they've been updated recently.
>
> Just a thought......Gary
>
>
> --- In vantage@yahoogroups.com, "david2murphy" <djmurphy@> wrote:
> >
> > After having an 'expert' looking at my part table in SQL server
I
> > suddenly could no longer add Parts to the database through Part
> > Maintenance. Any entry attempt is reported as a duplicate part
number.
> > Leads me to think the Progress index column numbering in SQL
Table is
> > not in synch with the number Openedge is trying to create.
Anyone ever
> > had this misfortune? Does anyone know of a tool that brings
Openedge
> > and SQL table ID's back into synch. Any thoughts at all will be
> > appreciated.
> >
> > David Murphy
> > Information Systems Manager
> > A&A Machine & Fafrication, LLC
> >
>
After having an 'expert' looking at my part table in SQL server I
suddenly could no longer add Parts to the database through Part
Maintenance. Any entry attempt is reported as a duplicate part number.
Leads me to think the Progress index column numbering in SQL Table is
not in synch with the number Openedge is trying to create. Anyone ever
had this misfortune? Does anyone know of a tool that brings Openedge
and SQL table ID's back into synch. Any thoughts at all will be
appreciated.

David Murphy
Information Systems Manager
A&A Machine & Fafrication, LLC
David....Do you have FULL TEXT SEARCH CATALOGS setup in your
installation? If not, I'm pretty sure you will need them. If so, you
might look to see if they've been updated recently.

Just a thought......Gary


--- In vantage@yahoogroups.com, "david2murphy" <djmurphy@...> wrote:
>
> After having an 'expert' looking at my part table in SQL server I
> suddenly could no longer add Parts to the database through Part
> Maintenance. Any entry attempt is reported as a duplicate part number.
> Leads me to think the Progress index column numbering in SQL Table is
> not in synch with the number Openedge is trying to create. Anyone ever
> had this misfortune? Does anyone know of a tool that brings Openedge
> and SQL table ID's back into synch. Any thoughts at all will be
> appreciated.
>
> David Murphy
> Information Systems Manager
> A&A Machine & Fafrication, LLC
>