Hi there
I have an application that is currently running on MSACCESS, using ADO and
Visual Basic 6.0
I am looking at alternate databases and have been testing with MYSQL for
some days now. I have noticed a couple distinct differences in some of the
SQL statements, but have managed to come around these. I do seem to be
having one problem, and that is when I am trying to write a blank value to a
column. The column is set to "Null allowed=YES", but when I try and write
rs.addr3=variable & "" it says "Multipe steps generate errors" which when
using access, mean't I never had the '& ""' at the end. By the way, variable
in this particular case equals nothing
Also, has anyone moved from Access to MYSQL on a live application, what kind
of things did you encounter when doing this migration?
Thanks
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
