Search options (Page 1 of 5)

Another option, for a trial App and/or protecting your deployed application.

Engima Virtual Box is a free option that you can use to package all files into one application, if you include the sqlite.db into the package all changes will be reverted upon exiting.

http://enigmaprotector.com/en/aboutvb.html

If you want to protect your files but want to retain data changes, you would create a package including all files but the sqlite.db and put that in the same folder as the packaged files.  (see image) 

For the most security, you will want to ensure your db only contains user data and not any system required information.

One of two ways,
1) the date of the key has to be encoded into the string and the number of days support
2) the calculated expiration date of support needs to be encoded into the string

Then that is compared to the current date.

Robb

I would implement a license key system to validate the user and their computer.

Upon the user registering you would ask the user to provide the hard drive serial based on the method shown above.

You would enter this, plus their name and email address as components of the license key (plus anything else  you want to include in the license generation). 
The resulting code, would be given to the user and they would enter the license key which would validate that the computer matches the serial and you would display their name and email in the about screen. 

If you wanted to support multiple computers, you would just add these multiple serials codes into the key generator.  (See image)

Robb

Check out the MVD Copier to copy forms from one project to another.

http://myvisualdatabase.com/forum/searc … 1054709239

Sample.zip

The project generates three files:
sample_export.csv which comes from my main table
headerrow.csv which comes from the header row
fOutfile.csv which is my combined file - which does not transform nicely.

My procedure ConcatenateFiles does the final output.

Thanks for your assistance.

I am using the following commands

FrmExport.TableGrid1.SaveToTextFile(SaveDialog.Filename);

and

Frmexport.Memo1.Lines.savetofile(ExtractFileDir(SaveDialog.Filename)+'\'+'headerrow.csv');

I am then trying to concatenate the two files.  The headerrow file is showing as strange characters when concatenated with the textfile.

Are these two commands writing to the same character set?  Each file visually looks ok, but when I combine then using TFileStream the header file is not readable. See attachement https://www.dropbox.com/s/k2kzovxz1cnz6 … 6.pdf?dl=0

Thank you,
  Robb

Perfect. Thank you.

The sparrow checkbox has the allowGrayed option as True compared to the other checkboxes.

RK

I found a third party tool which will open the encrypted db file.

SQLite2009 Pro
http://sqlite2009pro.azurewebsites.net/

When you select the db, it will show a dialog, File is encrypted or is not a database! click OK

The Enter DB Password screen will come up.

Enter the Encryption Key - same as the PRAGMA key.
Then select the RSA (Compatible with ADO.NET Provider) radio button and then select OK

You should have successfully attached the db.
Enjoy!