|
close tables all use "c:\program files\foxweb\programs\sessions.db" shared alias sess_table response.write("Record Count: ") response.write(reccount()) response.write("<br>") response.flush() |
Now, the table "sessions.db" is EMPTY. I know this because I just created the table moments ago -- and as I chased the issue down, I wrote a FoxPro program to blow away the table contents. When the above code executes the first time, the reccount is 1(!!). If I refresh the page, the reccount increases 1 for every time I hit the Refresh button. Keep in mind, that there isn't a single 'append' command in the entire script. In fact, as I tested the script, I deleted everything else below it!
In FoxPro, the reccount is 0 and stays that way. Why is FoxPro automatically appending a record to this table when it is opened?
12/19/2004 - Update:
Apparently, this odd behavior is due to the fact that the table name is "sessions" (regardless of the extention). I changed the name to something else, and the record-adding behavior ceased. 'Fixed' but still a mystery.
-Jim
"The true measure of a career is to be able to be content, even proud that you succeeded through your own endeavors without leaving a trail of casualties in your wake."