StrComp: does not compare strings properly

G

Gus Miller

I have created a SQL Library table that allows users to
store their queries in a table; database is being updated
constantly therefore users where loosing their queries.

Before archiving their queries I perform a StrComp in
order to determine whether the SQL Statement has changed
but it does not work. I have tried the different methods
allowed by the function but all of them return that SQL
has changed, but it hasn't.

I suspect that it could be the length, or perhaps the
Linefeed or return characters.

Ideas anyone?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top