if(num(`cod_bloq`) <> 8, 'Vigente','Castigada') as Vigente_Castigo,
#deudat as Deuda_Total,# estado as Estado, MonthName(Date(`td_corte2`,'MMM-YY')) as Periodo,
SQL SELECT * FROM `btcc11_40` Where estado =1 And deudat <> 0;
And So on.... Every time when a dbf fall into the folder Im connecting to the new file and I create a new "Site". But I need left this automate. So I have this:
Sub Busqueda (Root) For Each Ext In 'dbf' // Búsqueda para el actula directorio For Each File In FileList (Root & '\*.' & Ext) Files: Load '$(File)' as Name, FileTime('$(File)') as FileTime, RangeSum(Peek('FileCount'), 1) as FileCount Autogenerate 1; Next File Next Ext
For Each Dir In DirList (Root & '\*.dbf') // Búsqueda en SubDirectorios Call Busqueda (Dir) Next Dir
End Sub
Call Busqueda ('E:\Datos externos\2012\'); // Starting point
MostRecentFileName: //FIRST 10 Load Name AS MostRecentFileName Resident Files Order by FileTime Desc;
Let vFileToLoad = FieldValueCount('MostRecentFileName');
For each file in FieldValueList('MostRecentFileName')
I`ve eliminated 02_Febrero From in the string of connection (e:\datos externos\2012\02_Febrero) so I have this now e:\datos externos\2012\ But doesn't work.
I cannot help with OLEDB as I don't have the drivers installed, but I have connected to VFP files previously using ODBC drivers using a System DSN which was pretty easy. Just point the driver to one of the files in the directory and you can select any other file in that folder as though it was a database table.
If I recall I had to have both the DBF and CDX files (and for some tables the FPT file).
Could be worth trying ODBC to see if it's an OLEDB issue.
How do you do for take all dbf files? (I can not take all dbf files with just one selection) When I try to take all files QlikView shows me the complete directory but when I put Select Qlikview just let me choose just one base for each connection. Could you please advice me about this type of connections?
