Dear all,

I have to populate an sql database table with pictures. The table has products with their product_id.
In a folder I have all the pictures in the format product_id.jpg.

I need to compare each row of the table Product_id with the file name’s in the folder and if they are the same update the product row in the table with the image.

I have used MyFolderBrowser in order to select the folder that contains photos.
1)Which is the command in order to read the first file in the folder ???

The files, in the folder, are in the following format = 01-10-MUYE200.jpg
2)How can i read each file name till the DOT and compare it with a specific field in an sql table ????


Thanks in advance,

Best Regards,

RH