Search options (Page 4 of 34)

Hi Roberto,

Let's simplify the script a little.
Something like this

I will repeat to you once again that checking in DELPHI and other languages that cannot operate with very large numbers (in our case up to 31 digits) does not require converting the entire number and is performed on a string of characters.

Your code in DELPHI will not work.
How to do this in DELPHI is described in the article at the link I gave you above. In addition, this non-working code also contains a calculation error.

Why do you need to convert all the characters into numbers and what type of IBAN verification do you want to do?

Hi  Jean, Frank.

Jean,
Sorry, I just got this mixed up.
I have corrected the text below.

We used Image in this project.
As for DBImage, the main obstacle was its functionality, which is different from other components.
For example, correct interception of image loading for recording in the database, similar to Edit and Memo.
Essentially, the DBImage component is an enhanced Image. Therefore, we used Image and attached some functions to it in the script.
If you need a Save button to save a picture from a storage location to another location you need, adding it is no problem.
In any case, there is room for creativity in a test project. Add Tree Search, ComboBox for Styles. Apply the color as Derek suggested.
A picture for a musician. It is possible to download and view multiple images for an album (requires database modification).
I think that at this stage it is necessary to divide this topic into two so as not to disturb Frank with other conversations. If you have any new questions or help, please create a new topic.
If any difficulties arise, I will try to help.

Frank,
You can find a description of the base structure for the tree and an example at this link. http://myvisualdatabase.com/help_en/pro … ings1.html
As far as I understand you, you want to make some kind of analogue of Persona.
You don't have enough database knowledge yet.
You have taken on a rather large project.
Start small. Don't try to do everything at once.
Let what you drew remain. Start first with the main tree in your project. Get the output to work.
Then Enable One Edit field. Let's say Name (its output in Edit , its editing and saving to the database).
At this stage, through trial and error, you will begin to understand how the components interact with each other.
The next step is to connect the ComboBox. Etc..
And of course read the forum, books, websites. Use examples of solutions from forum members.
Persona uses XML in its work. It stores reference books, saved characters, and projects in this format.
As you gradually expand your program, you will add data from XML to SQLite tables. Now your database is all in one pile.

Version of the program with image support.
Something like this.

Hello Jean

For images you need to use a different path.

I'll try to make an example

Hi,

You can try it like this.

Thanks to Derek for starting this.

Sorry Roberto)

that's exactly what I meant). "Lost"

One more thing. Table "bar_data".
This table is used once to form a chart and is erased to form a new chart.
At the same time, the size of the database is constantly increasing.
Pay attention to this feature of SQLITE as a temporary table.

    SQLExecute('DROP TABLE IF EXISTS bar_data_temp');
    SQLExecute('CREATE TEMP TABLE bar_data_temp (eixo_x TEXT, eixo_y REAL)');
    SQLExecute('INSERT INTO bar_data_temp (eixo_x, eixo_y) ...  '+

Technically, SQLite stores temporary tables in a separate temp database.
It keeps that database in a separate file on disk, visible only to the current database connection.
The temporary database is deleted automatically as soon as the connection is closed.

Such a table does not need to be registered in MVD.
I offer it just for information. Perhaps it will be useful in future projects, and perhaps in this one too.

MySQL 8.0 supports a new authentication based on improved, stronger SHA256-based password methods.

Unfortunately, MVD does not support new authentication, and FreeDB does not support legacy authentication.

Hi Roberto

procedure Form1_OnKeyDown (Sender: TObject; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
  if (Ctrl) and (key=107) then showmessage('You press "+"');   // PLUS on NumPad
  if (Ctrl) and (key=109) then showmessage('You press "-"');   // MINUS on NumPad
end;