I have made a copy of a directory on the server containing about 45.000 files, most in jpg format, some different and I want to run a script to loop over all these and just record the filename for once - I will go from there.
For some reason, the code I have doesn't work - it looped over all the files, I could watch it in the progress_window - but I see only BLANKs in a listbox.
The code is like this
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
// Zunächst laden wir eine kleine Dummy-Tabelle Dateinamen: FIRST 1 LOAD ' ' asDateiname_alt RESIDENT Fin_Bew ; DIRECTORY 'C:\Users\friedrich.hofmann\Documents\QS_IdentBilder\Sicherungskopien_20160126\'; FOREACHFileinFileList('*') Concatenate (Dateinamen) FIRST 1 LOAD '$(file)' asDateiname_altAutoGenerate 1; NEXTFile STORE Dateinamen INTO 'C:\Users\friedrich.hofmann\Documents\QS_IdentBilder\Metadaten\Gesamtliste\Alle_alle.qvd';
So I loaded a small dummy_file to concatenate to in each iteration of the loop - so I have one record too much, I can get rid of that lateron - and then I start the loop and for every file I encounter, I just want to load the file_name_and_path.
Can anyone help me find out why this isn't working?
I decided to start that whole task over because after I have worked on it on and off with long intervals inbetween, I don't remember exactly what I did. Now I hope that I'll have no more problems with the command-line stuff skipping files - I guess that was the LOWER() I had built into the LOAD before, or maybe I need a SLEEP statement in the loop.
