Mike wrote:

Also note there is a world of free support and articles at the Paradox
Community website and newsgroups. Link in my signature. That includes many
articles on ObjectPAL as well as a series on Local SQL syntax.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

Dennis Santoro wrote:
Thanks for the reminder; had hit the site as a result of my first
series of Google archive searches w/in this NG.

Mike

Larry DiGiovanni wrote:
Thanks again Larry for the reminder; had not looked at SQL on the site
since it hadn't dawned on me that using SQL could be a way to avoid
writing a more detailed level of OPAL script w/ my current situation in
starting the switch-over.

Mike

Again, thanks for the all the helpful suggestions. After several tries
(mostly due to working thru syntax ), got a working model that I can
fine tune.

There was one interesting roadblock, and on the most simple of parts;
that of part one:

Doing a pdox QBE on File1, and then adding the selected records from
Answer File into the empty File3 (same structure). Nothing fancy, yet
when I put this sequence into OPAL commands got a run-time error that
File3 needs to be keyed. Not a problem to have done, but why the
requirement that the destination file be keyed? When doing these steps
interactively File3 was not keyed and the Answer File records were
added into File3.

I bet I'm missing something here ...

Mike

The syntax you were using must have included instruction to update as
well as append - it can't update without a key.

Liz


Mike wrote:

Oh oh ...

I missed the sentence which states, in regards to append and/or update,
when using ADD, "If omitted, both are True."

That does explain it I do believe.

Mike

Liz McGuire wrote: