Search options (Page 13 of 16)

You can add another registry for checking if the application is purchased then add a condition somewhere in your program. Hope this attachment helps you figure it out.

I think you're missing the point of my database structure. I used a normalized many-to-many approach with it.

If you want to add student attending to a class on a specific date, you have to open(create if doesn't exists) the attendance with that class and date, then add the student there.

I've added a trap in adding an attendance. You don't need to add another record for attendance with the same class and date for it is considered as 1 record only. One record with many students attending to it.

For the relationship. I don't understand what's going on with that error you encountered in creating a relationship. It's working fine in my sample.

Just trigger the click procedure of the buttons.

Maybe something like this.

Here's a sample.

Can you provide sample link to your file to access?

Hope this helps.

If you use Simple Script from InnoScript Studio, it auto-generates AppID, this app ID will be the unique ID of your application so that when you reinstall it or install an updater with the same AppID, It will automatically look for the installation folder of your app and remove/replace/add files depending on your setup script. It also allows windows to know that it is the same application on the existing installed application with it.

You can always install it wherever you want. You only need the settings.ini and sqlite.db (files that are being re-written by MVD) in the userapp folder. But if your application has other file that is being read and write within the application folder/subfolder, then I think installing it on document folder is your option. Other option will be installing it under C:\. But you need to remind your client/s to disable their anti-virus when installing your application. Some antivirus see this as a threat. I used to install my applications in C:\. In that way, they can copy all the files and they can use it like a portable one. 
The option onlyifdoesntexist from the .iss file will solve the database problem. Having that option will make your next installer(updater) to ignore and not replace it(application database). But you need to consider some pointers even you exclude changes within the database in your question, it may happen tho.
- Make sure to properly document changes in your database when you deploy your application for the sake of your next installer(updater).
- You have to include sql queries on your next installer(updater) when:
   a.  you add field/s in table. (calculated fields is an exemption. it is not a field on the database)
   b. delete field/s in a table. You can ignore this if you want. but the deleted fields in your current version of the system will remain in the previously installed application. Sqlite doesnt have alter table drop fields tho. You need to rename current table, create table, insert all records from renamed to new table, then delete renamed table. This is a tedious one so i just ignore it. anyway, it doesn't affect the application.
   c. rename a field/s in the table. well, you can do letter a or b to do this.
- Make sure to have a version control and checker on your application. I do this via having a field on database(settings table) the current version of client's database, then a Constant(current version) in the script of my application.

Note: If you want to hide sql queries, you can encrypt it. then decrypt before you run it in your updater. I suggest you to have another application for encrypting the sql queries if you want this. They only need to have the same encryption Key to work.

I think it cannot be done. CopyFile of the MVD works on the User's computer and not with the server. You need to save file on the database. I hope it will be addressed by Drivesoft. Saving files over network is a different story. I'm no expert with it but I know there's a bunch of things to consider when you want to transfer file/s over network.

Change line 42 on script
from

result_string := result_string + '"'+Excel.ActiveSheet.Cells[rows,columns].Value+'",'

to

result_string := result_string + '"'+VarToStr(Excel.ActiveSheet.Cells[rows,columns].Value)+'",'

Here's one solution.
FirstEmptyItem in Combobox property will disable arrow navigation unless you type at least 1 character.