double quote in autosearch

rbuser

Hi,

When creating a new autosearch criteria, I get " (double quotes) around my
text value rather than ' (single quote).

The DatabaseType = dtMSSQLServer.

Can anyone point me in the right direction?
Thanks

digitalmetaphors

Are you running RB 6.03? I run it here on SQL Server 2000 and it places
single quotes my string search expression. Change your library path to
RBuilder\Source and place a breakpoint in TdaSQL.ResolveCriteria on the
lines inside of the nested FormatValue routine, to see what the quotes it
creates:

if (FSQLType = sqBDELocal) then
Result := '"' + Result + '"'
else
Result := '''' + Result + '''';


Cheers,

Jim Bennett
Digital Metaphors