Search options (Page 2 of 25)

blackpearl8534,
The reason you are only getting one row is because you are using variables. Variables only hold one instance of information. With each iteration of your while loop you are overriding the previous iteration of variables. So after you finish the while loop you load the report variables with essentially the last iteration of the recordset variables. That's why your report only shows the last record of the table.

Pragma is a sqlite function that can be used to retrieve various technical info about the database. Below is a link for more information about its specific uses.

[https://sqlite.org/pragma.html]

The SqlQuery using the pragma function retrieves all the columns of a table and puts them in a dataset called ColResults. Then using the while statement I go through each row of the dataset which in this case are the columns in the specified table. I check for the col name of Field2. If it finds the column name Field2 it sets the boolean field FieldExists to TRUE otherwise it remains FALSE and can be added to the table in the ALTER statement. Hope this helps.

Quite honestly I never understood it either.  According to a post by Dimitry it is used in an internal algorithm in the program but it has no affect on the speed.  I never check this check box and my apps work just fine. I have plenty of lookup tables without it checked.

It works the same. What version of MVD are you using? You need to be on version 6 for standard access control. Also, make sure the tables "_Role" and "_User" are defined in your MySql database.

I am not familiar enough with using non-MVD databases within MVD, but here is an option you can try. Select the records you want from your sql server and load them into a temporary sqlite or mysql database and then do your report out of there. Then delete the data from the temp database.

For MySql use the DateDiff function.

DateDiff(enddate,startdate)

senseyesenseye1983,
If I understand correctly see attached.

I totally agree with CDB. It seems you are making this more difficult than it really should be. See attached. You can accomplish what you want with very little script. And the only reason for the script is because of the awkward setup of the forms. I did make an assumption and that is there will only be one record in this table. If there is going to be more than one record then your forms will need to change to accommodate such.

If you are the one who is managing the photos, you can simply use Windows Copy and Paste to backup your photo folder. But if you want to do it within MVD, you can use the DirectoryCopy function to do the same. See attached example project. In this example the backup folder is inside the application folder. I do not recommend this. Your backup folder should be in another location, preferably on another media.

nitin.ingale08,
I don't want to take your money. I am not that greedy especially to fellow MVDer's. If you attach your project or database or at least the database structure with some sample data, I or somebody else on the forum can take a look and maybe provide a solution. It really depends on the complexity of the project and time commitments.

First, your project is not really a working application and even after my changes it still is not. No insert feature except upon opening the app and not sure why the two save buttons. One of them does not really do anything.

Second, the DbImage component buttons are not trappable. At least I am not aware of anything to intercept the events on the open button. Therefore, as a possible solution to your needs, I hid the component buttons and created my own OPEN button (visible when you mouseover the image component). The check for the size of the file occurs when selecting an image in the dialog. If the file size is within your size range then it will display otherwise it will present an error message and not display. The BUTTONSAVE button is the real save button to save the record.

I changed your DbImage component from StoreFile to LinkFile. I highly recommend storing images outside your database. It can dramatically slow your app especially if you have a lot of records holding images.

Hope this helps.

Try this: (Not tested for syntax)

procedure OnTimer;
var sMessage,sId: string;
begin
     sId := SQLExecute('SELECT id FROM reminder WHERE strftime(''%d.%m.%Y %H:%M'', datetime) <= strftime(''%d.%m.%Y %H:%M'', ''now'',''localtime'') ');
    If sId <> '' then
      Begin
         sMessage := SQLExecute('SELECT message FROM reminder WHERE id = ' +sId);
         if SendMail('smtp.mail.xxxx.your-server.de', 'notification@qualitymanagementsystems.eu', 'xxxxxxxx', 465, 
           'notification@qualitymanagementsystems.eu', 'wayne.hollowayr@gmail.com' , 'Subject', 'Message') then
            SqlExecute('Delete From reminder where id = '+ sId);  // Here is your delete record statement
      End;

      // I commented the following. Not legitimate.
          //Begin
         // Form1.Button3.click;
         // end;
end;