Code: Select all
RAPPORTO = Trim(Format(GAF_RS(1), "#0000")) & Format(Right(GAF_RS(2), 7), "#00000000")
RAPPORTO = Format(RAPPORTO, "00000000000")
'ACCORDATO_TOT
'UTILIZZATO_TOT
'IMP_RACCOLTA_TOTALE
'CTA_MargineIntermediazioneLordo
'DATA_MART_RS.Find "NDG = " & RAPPORTO
'DATA_MART_RS.Find "NDG = '" & RAPPORTO & "'", , adSearchForward, 1
strSQL = "SELECT * FROM CC_DAILY WHERE RAPPORTO = '" & RAPPORTO & "'"
Set CC_DAILY_RS = GAF_CONN.Execute(strSQL)
Debug.Print strSQL
If Not CC_DAILY_RS.EOF Then
But the code not match value?????
In debug.print windows i have:
SELECT * FROM CC_DAILY WHERE RAPPORTO = '10000000014'
And i think the query search a numeric value not a string?
note:
The var RAPPORTO is dimensioned As String.
Rhe filed RAPPORTO is text format.
I think instead = '10000000014' i need = "10000000014" to match the value in column RAPPORTO, or not?