MySQL 5.0 in VB6 using ODBC 3.51

[kurokotoque]

---

mangutana lang unta ko ngano kon MS ACCESS ang gamiton sa sql query kay ok dayon kon sa mysql dili:

MS ACCESS query
rs.Open "select * FROM REPORTS WHERE (((REPORTS.DATE)>=#" & Text1 & "# And (REPORTS.DATE)<=#" & Text2 & "#));", con, adOpenDynamic, adLockOptimistic

ODBC query
rs.Open "select * FROM REPORTS WHERE (((REPORTS.DATE)>=" & Text1 & " And (REPORTS.DATE)<=" & Text2 & "));", con, adOpenDynamic, adLockOptimistic

bali ang nahitabo kon sa access ok ra kon naay ## syntax inig initiate sa date value...pero sa odbc mag-error siya...pero kon tangtangon lang ang ## ok ra pero ang naka-apan kay dugay kaayo makabasa...akong duda kay ang database was originally done in MS ACCESS dayon ako lang gi-convert sa MYSQL using BULLZIP software,ang mga date nga values kay nadungagan man.. 2006-04-30 00:00:00..mao cgurong dugay makabasa....

unsa kahay laing pama-agi aron pagsulbad mga bossing?

[cold_fusion]

Dates in MySQL should not be enclosed with ##. So the 2nd statement is correct.

Having a long delay of the results may not be caused by this statement change but maybe due to lack of index on the "reports.date" field.