Will anyone ever get tired of tracking down the proper form the date portion of an SQL string should take.
(Presently, I am. And not thinking very clear Lee.)😱
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 (Qbase??) 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.
(Presently, I am. And not thinking very clear Lee.)😱
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 (Qbase??) 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.
