Search options (Page 1 of 4)

Ok i managed to amke this work.

I have a table grid that displays info for parts in my wharehouse.
When a user clicks on a row on the grid pictures of the part are downloaded from my web site and they are displayed in 4 image components on a form.

This is the code I used:  (sorry some parts are in greek)

procedure Form1_TableGrid1_OnCellClick (Sender: TObject; ACol, ARow: Integer);
var
url,image_name :string  ;   // για την αποθηκευση των url της τοποθεσιας εως 4 φωτογραφιών ανα προιόν (αν υπάρχουν τόσες)
mikosPinakaUrls :integer;          // αποθηκεύει την θέση που βρίσκεται το διαχωριστικό (;) στο path των φωτογραφιών
urls: array of string;
localImageFileName : array of string;
metritisFor:integer;
ThePicture: TComponent;
begin

gridRowSelected:=form1.TableGrid1.SelectedRow;

url:=form1.TableGrid1.Cells[40,gridRowSelected];           //παιρνω το αρχικο path των φωτογραφιών με όλες τις φωτογαρφίες
urls:=SplitString(url,';');                                //σπαω και αποθηκευω το αρχικο path στα επιμέρους path των γωτογραφιών και τα αποθηκεύω σε πίνακα
mikosPinakaUrls:=length(urls);                             //βρίκσω το μήκος του πίνακα
setlength(localImageFileName,mikosPinakaUrls);

for metritisFor:=0 to  mikosPinakaUrls - 1  do             //τρεχω λουπ τόσες φορές όσο και το μήκος του πίνακα για να φορτώσω τις φωτό
begin

    if metritisFor < 4 then                                     //για να φορτώσω μόνο 4 φωτο. αν υπάρχουν παραπάνω τις αγνοώ.
        begin
        urls[metritisFor]:=ReplaceStr(urls[metritisFor],'https','http');
        HTTPGetFile(urls[metritisFor], ExtractFilePath(Application.ExeName) + 'image'+ inttostr(metritisFor) +'.jpg', True);
        localImageFileName[metritisFor]:=ExtractFilePath(Application.ExeName) + 'image'+ inttostr(metritisFor) +'.jpg';
        ThePicture := form1.FindComponent('Image'+IntToStr(metritisFor+1));
        Timage(ThePicture).Picture.LoadFromFile(localImageFileName[metritisFor]);

        end;

end;

end;

I tried your solution but I do not get any results.

The data in the sqlite database have been imported from a csv file.
Maybe I have to convert them to the format you mentioned above.

I am using sqlite.

In the above example the string variable dateSearchString contains a value like this: 21/11/2014 6:09:41 μμ

How can I use the date() function in the sql satetement mentioned in the first post. Can you write an example?

The date values in the sqlite database table have the same format like this 21/11/2014 6:09:41 μμ

Thank you

As can be seen I get a result when I use the '=' operator.
The results are displayed in the last word page.
If I change the operator to '<' it does not work correctly.

Thank you again.

Thank you so much for your help. I will try it out.

Thank you,

That is the way I implemeted it also. I was just wondering if it could be done in another way.

Regards
George

Unfortunately I did not manage to make it work.

It should be simple but I am not a professional programmer.

I looked at your code and searched online also but I could not make it work.

The question is simple. I have a table with 4 fields. One of them is for storing an image in BLOB format.

I have all the nessacery data to insert a new table entry but I do not know how to formulate the sql command.

In the attached image you can see the 4 fields.

id                             >>> id of record
Picture                     >>> this is where the BLOB picture must be stored
Picture_filename     >>> the path of the stored picture
id_Vehicles              >>> the id of a connected record in another table

Can anyone help me?

Thank you
George