Search options (Page 26 of 34)

Is that the answer Prahousefamily?

@DriveSoft

If I remember well, there was some files which could be removed before distribution like the .vdb file and one of the script file, I do not remember which one is used by the compiled application.

Preview pictures are unavailable.

The welcome message is a bit too much for me
When searching for a country, there are too many results in my opinion.

I still like the standalone version but there is place for improvement in the graphical user interface for final user

I could manage to do it using an example from another user who sent a project (License) using this feature, thanks to him.

just declaring the proper variable, assigning a sql query to this variable and then using caption did the trick:

procedure Form1_OnShow (Sender: string; Action: string);

begin 
var
q: string;

// Manage Parameters
q := SQLExecute('SELECT Quarantine FROM Parameters WHERE id=1');
Form1.Quarantine.Text:= q;
end;

To update the value, an update query on a button is sufficient

// Save parameters
 procedure Form1_save_quarant_OnClick (Sender: string; var Cancel: boolean);
begin
   SQLExecute ('REPLACE into Parameters (id,quarantine) VALUES (1, '+ Form1.Quarantine.sqlValue+')');

end;

Since Myvisualdatabase requires an id column for each table, the way I proceed for bulk import is as follow:

1 - I prepare all tables in myvisualdatabase, save the project and close it.
2 - I open the SQLite.db with SQLite studio
3 - I create a copy of the table I want to import data into without the id column
4 - I import data into this copy using csv file
5 - I run a query to insert the data into target table like this :

INSERT INTO target_table_name [(column1, column2, ... columnN)] 
   SELECT *
   FROM temporary_table_name
   [WHERE condition];

6 - I delete the temporary table

In the FAQ, you could find a script to import data into your project using a scripted button http://myvisualdatabase.com/forum/viewtopic.php?id=1448. The csv must be well prepared though, the column order must match the table, no header and separator is semi-colon ";"

And how to manage ShowMessage border icons like the example below where I want to remove the close icon?

procedure MenuClick6 (Sender: string);
begin
     ShowMessage('Version 1.0.0 Date 2015/07/08');

end;

Kind of,

when using this example, I have the ports listed but it does not filter the results in the grid for searching. I already sent you my project some days ago

Never mind, I closed the project and reopened it and now the feature is working again...

When doing the calculation by hand, it is not equal...

2*5/(1+sqrt(5)) = 10/(1+2,24) = 10/3,24 = 3,09

5/((1+sqrt(5)/2)) = 5/(1+2,24/2) = 5/2,12 = 2,36

It is a matter of parenthesis

5/((1+sqrt(5))/2) = 5/(3,24/2) = 5/1,62 = 3,09

Results are rounded.

To me, it looks like a tree view