Query "changeto" doesn't work in Paradox 8

#1

Hello,

for example, I want to change the values from a table, namely that ones in
the field "Pos", by adding 7.

My query looks similiar this ("aendernzu" = "changeto"):

Quote:

Nr | Pos |
092 | >=98, _p, aendernzu _p+7 |

If I hit F8 to run the query, the values inside the table will not be
changed at all! But I remember, that the same query ran in the past very
well. I tried with different tables and different "changeto"-queries, but it
seems, that it doesn't work at all; no values will be changed.

What do I do wrong? Thank you in advance for your help!

Frank

--

Quote:

Frank Boelsen * Kampweg 6 * D-26725 Emden
boelsen (AT) online (DOT) de

#2

Frank,
1) Do you use a german BDE? and which version is your BDE?
Do a test by removing aendernzu in changeto

Quote:

Nr | Pos |
092 | >=98, _p, changeto _p+7 |
2) Verify you don't have a field checked

3) It appears to me you get too much commas in Pos field

HtH
Régis

"Frank Boelsen" <frankboelsen (AT) onlinehome (DOT) de> a écrit dans le message de
news: f91soj$t09$1 (AT) online (DOT) de...

Quote:

Hello,

for example, I want to change the values from a table, namely that ones in
the field "Pos", by adding 7.

My query looks similiar this ("aendernzu" = "changeto"):

| Nr | Pos |
| 092 | >=98, _p, aendernzu _p+7 |

If I hit F8 to run the query, the values inside the table will not be
changed at all! But I remember, that the same query ran in the past very
well. I tried with different tables and different "changeto"-queries, but
it
seems, that it doesn't work at all; no values will be changed.

What do I do wrong? Thank you in advance for your help!

Frank

--
Frank Boelsen * Kampweg 6 * D-26725 Emden
boelsen (AT) online (DOT) de

#3

Quote:

Frank,
1) Do you use a german BDE? and which version is your BDE?
Do a test by removing aendernzu in changeto
| Nr | Pos |
| 092 | >=98, _p, changeto _p+7 |
2) Verify you don't have a field checked
3) It appears to me you get too much commas in Pos field

Hello Régis,

yes, I am using German version of Paradox 8, but I don't know about version
of BDE. Where can I check it?

I tried already replacing "aendernzu" by "changeto", but it has no affect.
Also if I remove some commas, it will not work.

Regards

Frank

#4

Frank.. your commas are fine..

start from the beginning.. have you confirmed, with a regular CHECK query,
that you have values that meet the rules?

[NR]="098" and [Pos] >=98

do you get an error message? an empty Changed table?

--
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 Boelsen" <frankboelsen (AT) onlinehome (DOT) de> wrote

Quote:

Hello,

for example, I want to change the values from a table, namely that ones in
the field "Pos", by adding 7.

My query looks similiar this ("aendernzu" = "changeto"):

| Nr | Pos |
| 092 | >=98, _p, aendernzu _p+7 |

If I hit F8 to run the query, the values inside the table will not be
changed at all! But I remember, that the same query ran in the past very
well. I tried with different tables and different "changeto"-queries, but
it
seems, that it doesn't work at all; no values will be changed.

What do I do wrong? Thank you in advance for your help!

Frank

--
Frank Boelsen * Kampweg 6 * D-26725 Emden
boelsen (AT) online (DOT) de

#5

Frank,
try to do 2 queries
1)

Quote:

Nr | Pos |
check 092 | check >=98 |

Do you get records in the answer table?

2) query the answer table

Quote:

Nr | Pos |
| _p, changeto _p+7 |

About Paradox and the BDE languages, only the BDE language is important in a
query:
Have a look at http://www.ars-florida.com/PDOXboard/ there is a little
script than help you to know which language your BDE accept

Régis

"Frank Boelsen" <frankboelsen (AT) onlinehome (DOT) de> a écrit dans le message de
news: f91umg$va7$1 (AT) online (DOT) de...

Quote:

Frank,
1) Do you use a german BDE? and which version is your BDE?
Do a test by removing aendernzu in changeto
| Nr | Pos |
| 092 | >=98, _p, changeto _p+7 |
2) Verify you don't have a field checked
3) It appears to me you get too much commas in Pos field

Hello Régis,

yes, I am using German version of Paradox 8, but I don't know about
version
of BDE. Where can I check it?

I tried already replacing "aendernzu" by "changeto", but it has no affect.
Also if I remove some commas, it will not work.

Regards

Frank

#6

Frank, I made a little test , creating a table with a dozen of records with
4 matching your critria, and test your query.
Everything works fine as expected.
In my test Nr and Pos are small integer fields.

The query is correct.
Régis

"Frank Boelsen" <frankboelsen (AT) onlinehome (DOT) de> a écrit dans le message de
news: f91soj$t09$1 (AT) online (DOT) de...

Quote:

Hello,

for example, I want to change the values from a table, namely that ones in
the field "Pos", by adding 7.

My query looks similiar this ("aendernzu" = "changeto"):

| Nr | Pos |
| 092 | >=98, _p, aendernzu _p+7 |

If I hit F8 to run the query, the values inside the table will not be
changed at all! But I remember, that the same query ran in the past very
well. I tried with different tables and different "changeto"-queries, but
it
seems, that it doesn't work at all; no values will be changed.

What do I do wrong? Thank you in advance for your help!

Frank

--
Frank Boelsen * Kampweg 6 * D-26725 Emden
boelsen (AT) online (DOT) de

#7

Quote:

1) Yes, I get records in the answer table. Results:

Nr Pos
092 98
092 99
092 100
092 101
092 102
092 103
092 104

2) Yes, query works!! Results:

Nr Pos
092 105
092 106
092 107
092 108
092 109
092 110
092 111
092 112
092 113
092 114
092 115
092 116
092 117
092 118
092 119
092 120
092 121
092 122
092 123
092 124
092 125
092 126
092 127
092 128
092 129
092 130
092 131
092 132
092 133
092 134
092 135
092 136
092 137
092 138
092 139
092 140
092 141

And now?

Frank

#8

At least 'nr' is a text field.

Good question, but I'm guessing that 'pos' is smallint or longint.
(right justification in displayed values.)

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

#9

Quote:

At least 'nr' is a text field.
Tony, that is correct, I made another test with Nr as an Alphafield and the

query works withour problem.

And when Frank is doing two queries it works too.

And I tested with REMPLACERPAR (changeto in french) and no problems
Régis

#10

Quote:

Frank.. your commas are fine..

start from the beginning.. have you confirmed, with a regular CHECK query,
that you have values that meet the rules?

[NR]="098" and [Pos] >=98

do you get an error message? an empty Changed table?

Hell Steven,

the values meet the rules. "Nr" is a text field (A - 18) and "Pos" small
Integer field (I).

Following table structure:

Nr A 18 *
D A 1 *
S A 1 *
Pos S *
Titel A 65
Interpret A 67
Aufnahme S
Dauer T
Musik_Text A 35
Sprache A 10
Dialekt A 7
Bemerkung A 25
UNr A 4
LfdNr +
Ordner A 17
E S
Typ A 3
Zähl S

If I perform a 'normal' query, everything's fine. For example:

Query
ANSWER: :PRIV:ANTWORT.DB

OPTIONS: NO AUXILIARY TABLES
FIELDORDER: Kuenstler.DB->"KName", Knstler.DB->"Musikrichtung",
Kuenstler.DB->"Musikrichtung_2", Kuenstler.DB->"Musikrichtung_3"

SORT: Kuenstler.DB->"KName", Kuenstler.DB->"Musikrichtung",
Kuenstler.DB->"Musikrichtung_2", Kuenstler.DB->"Musikrichtung_3"

Kuenstler.DB | KName | Musikrichtung | Musikrichtung_2 | Musikrichtung_3 |

Quote:

Check | Check Soul | Check | Check

EndQuery

Result:
----------

KName Musikrichtung Musikrichtung_2
Musikrichtung _3

Aaron Neville & Linda Ronstadt Soul R&B
Alicia Keys Soul
Aretha Franklin Soul Blues
Barry White Soul
Dusty Springfield Soul

(and so on..)

But if I use the "changeto"-options inside the query and let Paradox create
a help-table, I get the answer-table :PRIV:FEHLALT

B with ALL the records!
But in the original table (:WORK:POP.DB) nothing was changed at all!

Any ideas?

Regards

Frank