---- Original Message -----
From: "Warren van der Merwe" <[EMAIL PROTECTED]>
Subject: MSACCESS v.s. MYSQL
> 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
My experience has been that you are much better off by executing your SQL
statements, rather than using the Update and AddNew methods, which it looks
like you might be using.
Your statements should look something like:
strSQL = "SELECT * FROM tblFoo"
objConn.Execute(strSQL)
where objConn is your connection object and strSQL is a string with your SQL
statement. It may take just a little bit longer, but it will cause you the
least problems in the long run.
> Also, has anyone moved from Access to MYSQL on a live application, what
kind
> of things did you encounter when doing this migration?
When working with MySQL and ADO, not all of the methods and properties are
supported, which may be a problem depending on the complexity of your
application. For example, RecordCount is a property is not supported and
some of the cursor methods like MoveLast and MoveFirst are also not
supported. Needless to say, it will take a lot of thorough testing, and
perhaps some re-coding to move your application to MySQL, but it will
definitely be worth it!
Good Luck,
Dennis
**********************************************'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
---------------------------------------------------------------------
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
