import table with odbc from IDEA

ortizmario6025…

Forums

I am trying to import a table with today's date, that is, current. but it throws an access denied error on line 8.
example
Sub Main
 Call ODBCImport()
End Sub
 
Function ODBCImport
' para esta tabla rango de fecha para tomar el balance que quedo. 
dbName = "Devengo.IMD"Am I not doing it properly?
Client.ImportODBCFile "" & Chr(34) & "FISA" & Chr(34) & "." & Chr(34) & "TPRE_ACCRUAL" & Chr(34) & "", dbName, FALSE, ";DSN=BLH9I.world;UID=mgortiz;PWD=_IDEA922_012010062027024086039027105003094003018;DBQ=BLH9I.WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;MLD=0;ODA=F;", " where  ACR_FECHA  <=  date()"
Client.OpenDatabase (dbName)
I use now() and it gives me the same thing
Am I not doing it properly?
 

ortizmario6025… Fri, 06/23/2023 - 09:19

Hello,Could you help me with this query, I try to extract a file where the file date will be less than or equal to the current date if it is entered by parameters 
 

Brian Element Mon, 06/26/2023 - 08:21

Hi there,

I put  your code into the IDEAScript editor to have a look at and I noticed  your broke the sql statement into two parts when it should be just one.

I am thinking that this is the problem and that the "where ACR_FECHA <= date()" should be combined with the previous sql statement.