I have just found an annoying little bug.

 

If you enter a user id that contains a " ' " char the Auth object with generate an error.

 

It tries to build a string select statement:

"SELECT password AS password FROM 'data\Users.dbf' WHERE UPPER(userid) LIKE 'CM1-102'' INTO CURSOR _Authentic"

 

Is there a way we can check the user id before you get it.

(I could put a java function in the Auth.fwx)

 

or will you be correcting this bug.

 

james