Ok. I'm at a loss. I've got a simple script that is going to track information about users (IP, domain, etc) as they come to my site. I've created a free-standing table and set up the master indexes the way I want - nothing special, no data-rule enforcements and such.
At the very top of the script: I have the following code:
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:
"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."