I'm using Visual Basic with DAO 3.6 and I try to execute this query
dim rsPersonen as dao.recordset
Set rsPersonen = db.OpenRecordset( _
"SELECT Mitglieder.* FROM Mitglieder " + _
"WHERE Mitglieder.geb='1978-08-26'")
Here I get an Error-Message:
"Runtime-Error 3464, ..."
If I use any other SQL-Query-Tool (e.g. "MySQLFront") this query works and returns (as
estimated) 1 Record.
Any other query which is not using any date works, e.g.:
dim rsPersonen as dao.recordset
Set rsPersonen = db.OpenRecordset( _
"SELECT Mitglieder.* FROM Mitglieder " + _
"WHERE Mitglieder.VName='Florian'")
I hope you could help me solving this problem. By the way: Sorry for my bad english!
Thanks
Florian Lagg ([EMAIL PROTECTED])
______________________________________________________________________________
Ferienklick.de - Jede Menge Urlaub auf einen Blick!
Hier geht's zu Ihrem Traumstrand: http://ferienklick.de/?PP=2-0-100-105-1
---------------------------------------------------------------------
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
