Will anyone ever get tired of tracking down the proper form the date portion of an SQL string should take. Well I've got one now that is part of the Insert and don't have a whole lot to go on. The File that is being written to is called xxxx.dbf. It will open in VisualFoxPro but I was told it was an Xbase file. So where to start. VFP6 documentation shows {yyyy-mm-dd}. Java Xbase BDE SDK {d 'yyyy-mm-dd'}....etc, etc.
Where to turn? Could probably narrow it down to under a million combinations. If I went with a gut feeling on which drivers to use. LOL. So just a general plea to all who have executed a string on a VB connection object to a mysterious .dbf file that needs some dates.
This .dbf file is going to be read by a black box proprietory reader and app support on that end has been limited. The guy gave me a screen shot of it in VFP in browse mode. <sarcastic>Thanks buddy.</sarcastic>
So chime in with any and all directions. Can't hurt.
