No problems I know of.

I don't think a batch file can do that. I could be wrong, but del doesn't seem to have a property that will read file date, just name and...

I'm afraid I can't take this any further without test data that returns something for the original query.

Can you post some sample lines of the input data, and the desired end result of what is supposed to go into the database? If so, I can almost...

brewmanz (6/20/2008)

---

GSquared (6/20/2008)

---

The whole point of "Any" is that it...

I may be missing something here, but why use a While loop for this kind of thing? Do a set-based merge of all the update data, then upsert it...

As already mentioned by others, the second "correct" answer (#3) is definitely incorrect. The author didn't test it.

The whole point of "Any" is that it compares a...

I haven't tried this, but can you set up a linked server to VFP?

You can't completely eliminate transactions (so far as I know). Exporting to a file and bulk importing would result in very minimal loggings (under most settings). Like, it...

That's similar to what I read, but I don't remember the exact thing. Didn't consider it important enough to bookmark it. Was part of some longer rant about...

maynor_ramirez (6/20/2008)

---

I guess I cannot leave the date blank if I do want to test on it.

With the Or I have to pick a date for any datetime column, but...

You might be better off having VFP connect to SQL, rather than the other way around. I'm pretty sure it can do that.

That's what...

You might find that you're better off exporting to a file from the DB2 database and then bulk importing (minimal logging).

SSIS can do that for you pretty easily.