sNew is a string variable that may contain a "'" character.
hResult = hConn.Exec("SELECT * FROM gCal WHERE EventText = &1", sNew)
But I always get a result with no records.No doubt I'm missing something obvious but any ideas would be welcome
hResult = hConn.Exec("SELECT * FROM gCal WHERE EventText = &1", sNew)
But I always get a result with no records.
strExt = Quote("*.[jJ][pP][gG]")
strCommand = "cd " & DirView1.Current & " && gimp -i -b '(scale-batch " & strExt & ")' -b '(gimp-quit 0)'"
lblStatus.Text = "Please wait..... " & index & " image files found"
Wait
Shell strCommand Wait
So you may need to build the contents of sNew using Quote(sSomething) for the quoted part. Can we see an example of contents of sNew?John Lancaster's birthday
SELECT * FROM gCal WHERE EventText = '" & Replace(sNew, "'", "''") & "'"
Thanks for the help.