Sorry, I wanted to say: "Pos" is short integer (S), not (I).

Frank

Frank,
I don't know whether this touches your problem, however, I've seen in the
query-fieldorder-clause a tablename with probably the German umlaut for "ü"
is substituted by a "�" depending of the used character-set (OEM or ANSI):

Egbert
--
_______________________________
Babst, Institutionsberatung,
BabstSoft e.K.
Ludwigstr. 86
64546 Mörfelden-Walldorf
Tel: 06105 74974
Handelsregister:
Amtsgericht Darmstadt HRA 53360
www.BabstSoft.com

So you are changing the value of a field in the primary compound key?


--
------------------------------
Tony McGuire

Frank

What is :PRIV:FEHLALTB ? Is that what in English is ERRCHANGED?

Then there is a problem with your changeto query!! The changes are not
allowed. What happens if you change it manually, by editing one row. Is it
allowed ? If not, what message do you get?



--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

that, plus the keyed field, would seem to be the heart of the matter..

good thing they aren't asking us to answer Chinese questions (g)

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Bertil Isberg" <ctech (AT) corel (DOT) ca> wrote

:PRIV:FEHLALTB ist the error table I get after the query (in english the
name maybe :PRIV:ERROROLDB).

Yes, I think also, that the changes are not allowed; but why? If I edit the
records manually, the changes are accepted - no problem.

never, never, never do a changeto or an uncontrolled scan on the key fields
of a table.. what you get will NOT be what you expected, in many cases.. in
this case, you're creating key violations / duplicate records, because the
changes are being made one record at a time..

make a copy of the table, unkey it, make the changes, then rekey and reindex
when you're done..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

Frank

I have a couple of cases with changeto queries in my buglist. Maybe this one
could be your case:

Under certain circumstances, you can’t use a changeto query on a table that
is a referential integrity child. The changes are written to :Priv: ErrChg.
This will happen when you try to change one of the key fields in the child
table and the table has a compound primary key.


--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/