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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center