Xailer & OZ Software

Dear Collegues,
When I try to ad a record in a MySQL table I all the time get this error :
TMYSQLRECORDS:QUERYCURRENT(251)
Error MySQL/-1 You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''
at line 1: TMYSQLRECORDS:QUERYCURRENT
Arguments: ( [ 1] = Type: C Val: SELECT * FROM org WHERE )
Does anybody know why this happens ? It looks like after WHERE there is some
text missing.
Thanx !

Lars,
> When I try to ad a record in a MySQL table I all the time get this error :
>
> TMYSQLRECORDS:QUERYCURRENT(251)
> Error MySQL/-1 You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '' at line 1: TMYSQLRECORDS:QUERYCURRENT
> Arguments: ( [ 1] = Type: C Val: SELECT * FROM org WHERE )
>
> Does anybody know why this happens ? It looks like after WHERE there is
> some text missing.
Perhaps you are using a fieldname which is a reserved word in MySQL. Please,
show your table description.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info