[dba-SQLServer]SQL Server strangeness

John W. Colby jcolby at colbyconsulting.com
Tue Nov 18 22:52:24 CST 2003


Awhile back I moved my client billing to SQL Server, just a simple upload of
the mdb data, and then relinked to the ODBC.  Nothing fancy.

It all just worked.

Now (since recovering EVERYTHING due to a hard disk crash), the LIKE keyword
is causing failures in the odbc call.  I use things like "LIKE
forms!someform!somecontrol" etc.  Now this fails (silently), just no data
returned.  Replace the LIKE with IN() and it works again.

The TRULY strange part is that I use a LIKE ccfrmWhich() EVERYWHERE in order
to only display active records in my forms.  That fails in a combo, but
succeeds in the form that hosts that combo.

I do so love Access / SQL Server.



John W. Colby
www.ColbyConsulting.com




More information about the dba-SQLServer mailing list