|
-
Apr 3rd, 2002, 09:46 PM
#20
Thread Starter
PowerPoster
At a quick glance i note:
On the delete statement:
1) sql = "DELETE FileInfo.[Comments] FROM FileInfo WHERE FileInfo.[FileName] = '" & selectedFile & "'"
2) Else just do this rst.fields("Comments") = ""
On the Update statement:
1) sql = "UPDATE FileInfo SET Comments = " & "rst.Fields("Comments").AppendChunk strdata " & "WHERE FileInfo.FileName =" & selectedFile
Just those "" could help!
Good luck!
b
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|