Paradox for DOS 4.0...

How can I refer to the contents of another field in a Query by Example?
I want to update the one field with the contents of another field using
the CHANGETO command, but I can't get it to accept anything logical. I
don't find the answer in the F1 help, or in my one Paradox book, "Using
Paradox 4" (Que). Seems like it should be basic operation, so it should
be easy.

Nil wrote:
If you're building a query manually, then:
- put the cursor in the "source" field
- hit F5, and type a simple name for that field, just a few letters
or digits, say we call the field "x".
- move the cursor to the "destination" field
- type the following:
changeto x
- BUT, just before typing the "x", hit F5.

In the "changeto", you can build fairly complex formulae, if needed...

If you're building a query in PAL, you can save the above query (using
QuerySave) and use it "as is", or you can build the equivalent commands.
In the latter case, where the "x" appears, just precede them with an
underscore.

- Mike

On 04 Jun 2007, Michael Kennedy <Info (AT) KennedySoftware (DOT) ie> wrote in
comp.databases.paradox:

Thank you very much. Now that I know what to look for, I find the
answer in the book, buried in the section about multi-table queries.
Obviously not where I would have expected to find it!

I think it's a little odd to have to use these arbitrary tokens to
refer to fields rather than the field names themselves. Maybe it will
make more sense after I use the method for a while.

Anyway, I knew it had to be simple, as it's a basic function that any
DBMS would have. Thanks for pointing me in the right direction.

1. You can use very short IDs on the fields, say, 1, 2, 3, 4, 5

2. Your query might involve 10 tables, and many of the tables might
have a field called "Code", and they might refer to very different
"codes"...

3. etc...

Mike