Search options (Page 2 of 15)

Thinking about how to make the connection secure, by which I take you mean the connection string is obfuscated in some way, I came up with the following idea. Not tested, so have no idea if it would work, and is probably more complicated than needs be!

1. Create a SQLite database that has just one table and for security about 5 fields.
..... Field 1 contains an encrypted form of the connection path details.
..... Field 2 ........   contains the encryption key spread across one or more fields, the other fields  contain dummy information and or the password
.

2. Before opening the SQL Server connection as demonstrated above, read in the SQLite database contents and perform the deincryption.

3. Parse the results into the actual  db_settings:='Provider=SQLOLEDB;Server=localhost;database=DatabaseName;UID=UserName;PWD=password';
 
To make it more secure, a function could be written that actually changes the encryption key (some sort of randomise function) each time the program is run, This could be placed on the MainForms OnClose event where the new encrypted path and key can be written back to the database. I assume the SQL Server DB would be disconnected at this point as well.

I've probably over thought this far more than is necessary, but if it worked, this idea could also be used for other settings in the ini file such as column widths in tablegrids etc.

The other option would be to have the encryption or password key in plain sight, but looking like an encrypted  string.

Мне интересно, почему в вашем коде для создания динамической формы (или других объектов) вы не «освобождаете» экземпляры при закрытии формы.

Я заметил, что MVD не делает этого с собственным созданием форм, они просто складываются, когда не используются, как скрытые.

Процедура есть как часть TObjectClass(). FreeAndNil, кажется, тоже работает, по крайней мере, компилируется.

I'm wondering why in your code for creating a dynamic form (or other objects) you don't "free" the instances when the form is closed.

I've noticed that MVD doesn't do this with native form creation, they just fold up when not in use and become hidden.

The procedure is there as part of TObjectClass(). FreeAndNil seems to work also, at least it compiles.

Use the upper or lower case function Uppercase() or LowerCase(), either when you first enter the hash number into your database or run the sHash variable through it  .

sHash := UpperCase(sHash)

You could also run the edit1.text through the function instead.

begin
   form1.color:= clGray;  //whatever default colour you want the form to be
   
   if form1.CheckBox1.Checked := True then
   begin
       form1.CheckBox2.Checked := False;  //make sure you don't have both boxes checked
      form1.color := clBlue;
   end
   else if
   begin
     form1.CheckboxBox2.Checked := True then
     form1.CheckBox1.Checked := False;
     form1.color := clred;
   end;
    

The above allows the form to keep it's default colour if no checkbox is ticked.

If you wished, in the form OnClose event, you could untick both checkboxes as above so that if the form is called again, everything is in it's default state.

I think all you need is the opposite function to the one you used to encode the database.

It would only work for your database though .

I've never been able to get the MVD DecryptRC5 to work for me though, it always crashes the program.

Generally speaking, you could export the current database in CSV format and then import into the new database. If the new fields are to the right of the old fields (so to speak), you should be able to just import the records so long as the old field names have not been changed.

The Export and Import function provided in MVD under options should do the trick.

Is Tax rate actually being filled? Try changing  Tax from a double to (temporarily) Int or Var putting in a

TaxRate := sqlexecute('select TaxRate from TaxRates where id = '+frmRevenue.cbTaxRate.sqlvalue);
showmessage((InttoStr(taxrate));

or "varToStr

If TaxRate is not getting data assigned your next line will fail as you would be dividing zero by 100 (0/100) which will cause an error.  The declaration of Tax as a double might also be causing a problem in MVD

I think you need to have a look at K245 posts in the Russian section, his latest 'tutorial' address that kind of thing using MVD.

Do you need to store the calculations in the database or just view them?

If just viewing you will need to write a 'calculated field' entry. This means everytime you view the record the time will be calculated on the spot as you look at the record.

To do this on the database setup page find the table that has the start and finish times and make a new calculated field:

Field Name:   timings

strftime(%s, TABLE_NAME.your_field_finishtime) - strftime(TABLE_NAME.your_field_starttime)

Go to the Russian part of this forum and look for K245 he has just written up on how to turn an image of some kind in to operating like a button.

https://createmyvisualdatabaseapp.blogs … /ui-1.html

The website is in Russian. You will need to either have Google page Translate installed in your browser or cut and paste into Google Translate.

If your modem uses the AT command set, I would think it possible.

There is a large project on here somewhere that sends SMS, I think was called iAPPt

Ах я понимаю спасибо