DirectExtraction

ortizmario6025…

Forums

Hello
I'm performing an extraction with an argument, but I can't detect the error.
Here's the extraction.

' Datos: Extracción directa
Function DirectExtractionI
Set db = Client.OpenDatabase("FISA.TCLI_PERSONA.IMD")
Set task = db.Extraction
task.IncludeAllFields
dbName = "Cliente_ingreso.IMD"
task.AddExtraction dbName, "", "CLI_FECHAING_FECHA >= ""& arg1 &"" .AND. CLI_FECHAING_FECHA <= """& arg2 &""""
Set task = Nothing
Set db = Nothing
Client.OpenDatabase (dbName)
End Function

Brian Element Wed, 09/17/2025 - 14:00

Is arg1 numeric or character?  If it is numeric then there should only be one set of double quotes such as:

CLI_FECHAING_FECHA >= " & arg1 & " 

If arg1 is character then it is missing a set of quotes and should look the same as the quotes you have around arg2:

CLI_FECHAING_FECHA >= """ & arg1 & """