VB6 and IInformix : Problem execution of query HELP ME, HELP ME
I develop an application under Visual BASIC with a data base INFORMIX. I
use a requete with traditional clause BETWEEN on fields of the Date type.
Apparamment, my ODBC (Informix 3.34 32 BIT) does not understand BETWEEN
whereas. My query goes very well on INFORMIX SQL. On the other hand, under
I use a requete where I récupere two dates seized by the user:
sSqlWhere = sSqlWhere & "AND tete_lanc.date_l >= #" & msk_DateDeb_Comm.Text
& "# AND tete_lanc.date_l <= #" & msk_DateFin_Comm.Text & "# "
This requete (with the seized dates in this manner) walk very well on the
level of the manager of data of VB
The problem is that I am made throw VB (on the level of the code) with the
execution of the code below:
rsRecordset.Open sSql, cnBase
rsRecordset : is an ADODB.Recordset
sSql is a STRING
cnBase est de type ADODB.Connection : my string connexion
My requete walk very well without the seized dates
The problem is as soon as I execute this requete under VB, I have the message
according to ' ERROR APPLICATION VB6 '
Thank you in advance for your assistance
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL