Page 1 of 1
Function YEAR
Posted: Mon 05 Nov 2007 19:08
by dooh
Hi,
I have the lastest verstion of corelab (3.5) and this query dont work:
SELECT YEAR(mydate) as y
FROM entries
MyDate is a datetime field.
Note: DAY, MONTH functions works.
Posted: Tue 06 Nov 2007 13:41
by Alexey
I've tried the following query with MySQLDirect .NET 3.55
and it does work.
Please make sure you are using the latest version of MySQLDirect .NET.
Posted: Tue 06 Nov 2007 21:09
by dooh
Alexy,
Is this the lastest version:
CoreLab.MySql, Version=3.55.25.0?
I am trying make a TableAdapter with and MySQL DataSet Wizard
The exact error is:
Error Source: CoreLab.MySql
Error Message: FUNCTION myDB.YEAR does not exist
Posted: Wed 07 Nov 2007 09:55
by Alexey
Yes, the latest version is 3.55.25.
The error is MySQL server's error. Try to execute your SQL query in any other client.
Posted: Wed 07 Nov 2007 19:39
by dooh
I use Navicat the execute this query without any error:
select year(current_date)
return:
2007
Posted: Thu 08 Nov 2007 09:00
by Alexey
Try to execute
Make sure that connection string is the same for both MyDirect .NET and Navicat.
If the problem persists, please specify your hardware platform, operating system, version of MySQL server and send your test project to the address provided in the Readme.html file.
Posted: Thu 08 Nov 2007 21:33
by dooh
I Had
Visual Studio 2005
local: MySQL Server 5.0.26-community-nt
production: 5.0.27-community-nt
I am developing an Web Application
Why all these requisites?
Posted: Fri 09 Nov 2007 08:10
by Alexey
Please specify your hardware platform, operating system, and send me your project.
I'll need all this to reproduce the problem.
Posted: Sat 10 Nov 2007 12:56
by dooh
I found the problem.
The QueryDesigner of a Table Adapter, doest work with some functions of MySQLDirect
The subquery also does not work.