I have added the records from six files into one receiving file now named
recd.db; with each addition I changed the name of the receiving file to reflect
the additional records. Now, I get "Invalid File Name" error when I try to
run a Changeto query on the recd.db file.

I tried renaming the recd.db file, but the query will still not work. I exported
the receiving file as a .csv file and imported it as a .db file with a different
name, but the query will still not work.

Any suggestions on how to correct this error or work around it would be appreciated.

I would suggest posting the code associated with the query (or is this a
standalone query?; if so, paste the contents of the .qbe file). Without it
we probably aren't doing much better than shots in the dark.


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

This is a File\Query in Pdox9, with only "changeto c" data entered into one
field box of the query design. I can't post the contents of the .qbe file
because when I try to save the query, I get an "Incorrect File Name" error
message, even when I give the query a different name from the table.


"Tony McGuire" <png.paradoxcommunity@com> wrote:

Try

changeto x

Do you still get the error?

How about

stString="c"

and in the query

changeto ~stString

Oh, interactive.

how about

changeto "c" (literally, using the quotes)

Lastly, is there a subdirectory by the same name as the query/file?

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

I tried each of your suggestions, without any success. There is not a subdirectory
with the same file/query name.

I created a new directory, copied the recd.db plus one of the original files
whose records were added to recd.db and whose file was not renamed to the
new directory; then, in Pdox9, changed directory to the new directory; when
I tried to do a query on either file in the new directory I got the "Invalid
File Name" error.

I did some unrelated queries in unrelated directories and they all worked
ok.

I also restarted my pc, but that didn't help.

I think that I somehow corrupted something in the file or directory format
of each .db file in the original directory. All of those files were copied
from other directories, so I am going to start again & be very careful when
adding each file's records into the new recd.db.

Thanks for trying to help me.


"Tony McGuire" <png.paradoxcommunity@com> wrote:

How are you adding records from one table to another?

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

Don

Can you open the queries in design mode from Paradox?

You can, in Windows Explorer, open the QBE file with Notepad, copy the
contents and paste it into a message to show what's in the QBE file.


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

remove spamfilter (reversed) to reply

He gets that error when he tries to save the query, so doesn't have a .qbe
to open and paste here.


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

When you say, "From 6 files",
do you mean Text files from another program,
and that you import them into paradox ?

When you say,
"into one receiving file"
do you mean you put all information into one pdox *table* ?

So, you have a pdox table,
and you can view the table,
and page up / page down through the table from beginning to end ?
How many records ?

When you say
"run a changeto query"
are you saying you are building a new query from scratch ?
or are you running an existing query ?

Can you create new query on any pdox table
and check all fields and save that query ?

Can you then create a new query on this particular recd.db table
and check all fields and save that query ?

In your opinion, are you getting invalid filename error when you
try to RUN the query, or when you try to SAVE the query.

Sorry to answer your questions with questions.
It is probably something very simple.

Cheers
Robert Wiltshire

Then it's probably a too long path to private directory

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

"Tony McGuire" <png.paradoxcommunity@com> skrev i meddelandet
news:460a6954$1 (AT) pnews (DOT) thedbcommunity.com...