Search options (Page 5 of 6)

thank you so much for your help
can I use the CopyTo command for images as well?
I don't want the pictures to be saved in the database but my version does not have LinkFile for the images.

Hi
I used this script but it does not work for me. I guess it's because I use version 1.45 which does not have copyTo command.
is there any other script to make a backup using version 1.45?
thanks

yes I have a very specific reason to do it
the reason is my version of this program is 1.45 and it does not have link file or copy to
now that you know my reason, could you please help me get rid of this error
thanks

Hi mathmathou
thank you for your help

I have 2 questions in mind?
1) if I make a separate table for the images, will the speed of the database go up or it doesn't matter if the images are stored in the original table or in a separate table only with images?

2) you said (Unless you manually, and by script, attach a second database to your project, everything goes into the sqlite.db file)
how can I use a script to store the images in another file or database? the version I use is 1.45 and it doesn't have linkfile.
is there any script regarding storing images in another file because in my project there are approximately 1000 pictures and the size of the sqlite.db is about 1.5 Gigabyte therefor every time I want to check a record I have to wait a lot.
thank you

thank you
I have tried this code but only the window is shown in full screen
what i need to do is that all of the items in the form1 are shown in full screen
your code does the same as when I check the sizeable checkbox in the properties section of the form1

are there any other scripts?
thanks

thank you so much
I have corrected your query myself. it works fine

SELECT
employees.lastname,
employees.firstname,
employees.id

FROM

employees

WHERE

(CASE WHEN {chbYes} = 1 THEN employees.yes = 1 ELSE 1=0 END) OR
(CASE WHEN {chbNo} = 1 THEN employees.no = 1 ELSE 1=0 END) OR
(CASE WHEN {chbAlmost} = 1 THEN employees.almost = 1 ELSE 1=0 END) OR
(CASE WHEN {chbMaybe} = 1 THEN employees.maybe = 1 ELSE 1=0 END)

Thanks for your reply
In the version i use which is 1.45 combobox does not have multiselect value.
Could you please tell how can I use SQL query for search?
Thank you so much

Hi tcoton

I have checked my project but button "New Record" name is button2 and button "save" name is button1
the script says that only button 1 should show the message but both of the buttons show the message.

I have attached a simple version of the project which is somehow like my project. can you correct it?

thanks

Hi
your script works fine and thanks for your reply

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
    if Form1.Edit1.Text = '' then
    begin
        Cancel := True;
        ShowMessage('Fill in the Blanks.');
    end;
end;

but in my project apart form the save button, there is also a button defined as "New Record"
whenever I push the save button, the message ('Fill in the Blanks.') is shown and that's OK
But when I press the "New Record" button, this message is also shown. What should I do to get rid of seeing this message when I press the "New Record" button
thanks