Hi Daniel,
I tried that to no avail (I had actually had the code set initially to
use single quotes thusly:
sqlstr = "INSERT INTO Jobs VALUES("' & _
txtSceneFile & "')"
but it generated the same erroneous string. Using the ascii-code
equivalent (Chr(34) does the same.
It's just so....odd!!
Daniel Clark wrote:
>I think you want chr(39) (single quote).
>
>
>
>
>>Every time I think I've got it, I am reminded that....I don't got it.
>>
>>Hello all, once again! Can anyone tell me why the following takes
>>place? In my VB app I am adding records to the table "Jobs" with this
>>code (trimmed way down - my actual INSERT statement populates about 20
>>fields):
>>
>>sqlstr = "INSERT INTO Jobs VALUES(" & _
>> Chr(34) & txtSceneFile & Chr(34) & ")"
>>
>>adocn.execute sqlstr
>>
>>Now, let's say that my txtSceneFile contains
>>"C:\Data\test\foo\bar.lws". My Jobs table will show the following for
>>the applicable data field: "C: Data". This, my frields, is a new one
>>to me, to be sure! Any ideas?
>>
>>Many thanks,
>> Steve
>>
>>
>>
>>
