can't open fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JPGREENASSOC (jpgreenassoc_at_aol.com)
Date: 02/21/04 

Date: 21 Feb 2004 17:04:38 GMT

Hi,

I'm wondering if someone can help me with a problem I'm having. I'm not a
programmer, but I wrote a program in Foxpro 8.0. This programs uses a few
tables. The problem I'm having is that I have one main table, I call it "&mid."
The name of this table changes everyday, I need to create and save a new table
everyday for my program to work right. What I do is use today's date and a
number and store that in, 'mid.' When I want to read or write to that table I
reference it by using "&mid.," example. "SELECT Time FROM &mid." I have no
problem reading and writing to '&mid,' but if I open one of the other tables
and read and write to them, then try to read and write to, '&mid' again, I get
an error saying Variable rank (this is the name of the field) not found. What I
do is a take some information from my other tables, do some work on the data
and try to put the new data in a field called,'rank', in table, '&mid.' I use
the replace command (tried using insert command but that didn't work), "
replace rank with XYZ(an element in a array)." I tried using, "Replace
&mid.rank with xyz" but I get an error message, "Command contains unrecognized
phrase/ keyword." I tried using the use command, 'Use &mid' but I get back an
error saying, "file is use." I also tried, "Use &mid in 0 (tried all the way up
to 10)," same error message. I tried using the open command, "Open database
&mid in 0" (Also tried all the way up to 10 and tried use, Open &mid in 0), I
get, "Command contains unrecognized phrase/keyword." I tried using, "Select
&mid in 0" and again get "Command contains unrecognized phrase/keyword."

If I don't open the other tables and just assign a value to, 'XYZ,' and use,
"replace rank with XYZ," I have no error messages and it puts it right in rank.

Any helpful ideas?

Relevant Pages

  • Help with DELETE Statement
    ... When I run the below DELETE statement I receive the error message "Command ... contains unrecognized phrase/keyword." ... formatting this incorrectly? ...
    (microsoft.public.fox.helpwanted)
  • Re: Display Problems
    ... If it shows up in the GUI, it is there, and must be present ... Or issue the command; ... > and got the error message file or folder not found. ... in the midst of the frustration, by all means, vent away. ...
    (alt.os.linux.suse)
  • Re: Display Problems
    ... If it shows up in the GUI, it is there, and must be present ... > get the error message that you, in fact, did get. ... > Or issue the command; ... > in the midst of the frustration, by all means, vent away. ...
    (alt.os.linux.suse)
  • RE: Run a Stored Procedure from Excel
    ... get a single line multiple command working from ... I changed all the Charto Charand found that I got an error message ... Dim cnnDW As ADODB.Connection ... Dim rsDW As ADODB.Recordset ...
    (microsoft.public.excel.programming)
  • Re: A form that could no longer be opened for modification
    ... You CANNOT get that error message from the USE command. ... file corruption should be the reason. ... I can of course get from backup and lost some works, ...
    (microsoft.public.fox.vfp.forms)