26

(2 replies, posted in General)

Sparrow, thank you.

27

(2 replies, posted in General)

Hello everybody! I have no experience or any knowledge of MySql, but I thought about exploring this feature in MVD, since MySQL, according to what I read, is an established multi-user database due to its performance, security, stability, etc. I also think about the future if I have to create an application that must be accessed by several users simultaneously.

I was able to download and run xampp-portable-win32-1.8.3-5-VC11.7z. Connection to Apache and MySQL have been established. I created a name for the database, username and password. I opened an existing MVD application (Sqlite) and pressed the "Webgrid" button. I entered the localhost, database, username and password. I selected the fields from some tables for the "Webgrid", but I can't go to the end of the window - my maximum resolution is 1920x1080 and MVD 5.6. Therefore, I am not able to complete this operation, but I have several questions:


- what is the purpose of "Webgrid"?
- will the data be automatically migrated at some point in the process?
- will existing forms work with MysQL?


I appreciate any information.


-

pavlenko.vladimir.v wrote:
jrga wrote:

Hi Pavlenko, thanks for getting back to us!

 
RichEdit is now working. Thank you, sparrow !
Теперь RichEdit работает.  Спасибо, sparrow !
   
скачать тут  https://fileworld.pavlenkovv.ru/BookLib … y.v5.2.zip

Hello Pavlenko! I tested the new version of BookLib and all the modifications are working! I haven't yet translated words in the language folder. Congratulations and thank you.

pavlenko.vladimir.v wrote:
jrga wrote:

Suggestions:
1 - exchange the TXT control of special brands for RTF, with the user being able to maximize this form or not. RTF, in addition to the various formatting resources, has a native search engine;
2 - if possible, save special marks using MVD's SAVE, which allows you to include quotation marks in the inserted text. The INSERT and UPDATE commands generate an error when there are words in quotation marks in the text that will be saved;
3 - change the Sumatra configuration to save the last reading position, which you already explained how to do in the forum.

RichEdit does not work with styles, there is an error.
If you create the ability to remember a page, then Sumatra creates a lot of unnecessary information, which leads to too much data.
Unfortunately, not all dreams come true (.

Fixed a bug with double quotes
Added the ability to expand the special recording window to full screen
Fixed language file errors
Eliminated TableGrid artifacts that occur when changing the window size.
 
   
RichEdit не работает со стилями, имеется ошибка.
Если создать возможность запоминать страницу, то Sumatra создает много лишней информации, что приводит к слишком большому объему данных.
К сожалению не все жилания сбываются (.
 
Исправил ошибку с двойными ковычками
Добавил возможность развернуть окно специальной записи на весь экран
Исправил ошибки языкового файла
Устранил артефакты TableGrid возникающие при изминении размера окна.
   
скачать тут  https://fileworld.pavlenkovv.ru/BookLib … y.v5.2.zip

Hi Pavlenko, thanks for getting back to us!

I tested an MVD application with Enigma and it worked perfectly! The script.dcu file has become invisible! Attached is the Enigma screen with the file structure I used.

Thank you all for the clarifications! I am sorry for my ignorance! As an EXE file is created, I thought the MVD application depended only on script.dcu to run and that PAS was only used in creation / editing.

k245 wrote:
jrga wrote:

If you can't answer, that's okay: how did you incorporate SCRIPT.DCU into the executable?

Let me make a guess: the system needs either script.dcu (compiled script.pas) or script.pas. Script.pas is available in this project.

I think I expressed myself badly and the translator does not help sometimes. I asked about script.dcu because, according to what I saw in the forum, it is not an inviolable file. Thus, if the script.pas is erased when the application is delivered to the end user, hide the script.dcu or incorporate it to the executable is the dream of every developer, I think .... in any case, I said I would understand If the answer to my question was confidential.

PS: Booklib comes with the executable and does not have script.dcu, only script.pas.

Suggestions:
1 - exchange the TXT control of special brands for RTF, with the user being able to maximize this form or not. RTF, in addition to the various formatting resources, has a native search engine;
2 - if possible, save special marks using MVD's SAVE, which allows you to include quotation marks in the inserted text. The INSERT and UPDATE commands generate an error when there are words in quotation marks in the text that will be saved;
3 - change the Sumatra configuration to save the last reading position, which you already explained how to do in the forum.


If you can't answer, that's okay: how did you incorporate SCRIPT.DCU into the executable?

I have been using BookLib since the previous version as my default reader. Congratulations on the project.

Oi Pavlenko, congratulations on the new version, but what is appearing to me (attached floor) is different... File sqlite3.dll is not in the zip.

35

(6 replies, posted in General)

sparrow wrote:

By default, RichEdit loads text as RTF.
If RichEdit does not find RTF markup, then the text is displayed on one line.

Look at this solution. Allows you to read and load TXT or RTF text into RichEdit.
Parses the text header and downloads as Text or TextRTF.


Hi Sparrow, it worked perfectly. Thank you very much!

36

(6 replies, posted in General)

Hi Sparrow, I will explain my problem better: I want to have the same text as the cooking recipe in two fields. A simple text field and a field that will be edited with RTF control. This way I can do research on the ingredients of a recipe in simple text fields. Derek helped me develop this idea. The Formatted Fields with RTF do not allow research with "Select ... Where". For this, in addition to the recipe field, I created the field r_e_c_e_i_t_a_rtf. Then I transferred the entire content from the first to the second field through SQLSTUDIO. But when I edit the field r_e_c_e_i_t_a_rtf, the text is all disorganized, according to the photo I sent for this topic. Since there are 4,000 records, making any adjustment manually is unfeasible. Sorry for the long text.

37

(6 replies, posted in General)

tcoton wrote:

There is a RTF memo component, the one with a little red A.

I didn't understand! I have MVD 5.6

38

(6 replies, posted in General)

I have a table with 4 thousand records filled with culinary recipes, which are in a memo field. I copied the memo field to another field, for editing with RTF control, but the text was left without a line break. I would like to maintain the same paragraph structure in the RTF as the text field. Can anyone help?

Backup tool on the link, which I use on some projects. Very good! Allows you to include encrypted password with AES256.

PS.: Sparrow, I will still give feedback on the dynamic query.


https://2xdsoft.de.tl/AutoZipper.htm

This batch file can be executed by AutoZipper, after finishing the copy, which will add date and time to the name of the zip file.

echo off
for /f "delims=" %%a in ('wmic OS Get localdatetime  ^| find "."') do set dt=%%a
set YYYY=%dt:~0,4%
set MM=%dt:~4,2%
set DD=%dt:~6,2%
set HH=%dt:~8,2%
set Min=%dt:~10,2%
set Sec=%dt:~12,2%

set stamp=%YYYY%%MM%%DD%_%HH%%Min%%Sec%

move "G:\Meu Drive\Projetos Visual Kit 5\projeto_atual\Projeto_Atual_VK5.zip" "G:\Meu Drive\Projetos Visual Kit 5\projeto_atual\Projeto_Atual_vk5_%stamp%.zip"

40

(17 replies, posted in General)

Hi Pardal, you sophisticated the project! Congratulations. However, as you said: "- Bugs fixed, new ones added". I found the new ones! I don't have that much knowledge, but I will study the new code snippets that were inserted.

41

(17 replies, posted in General)

sparrow wrote:
I tried to use the "SQLQuery" function, to avoid the standard MVD error message, in case of 
an error when manually constructing the SQL statement, but I couldn't...

what do you want to see on the screen when an error is intercepted, instead of the standard one?


Hi Pardal, thanks for asking.

The message that I think should be displayed, when an error is made in the SQL statement, contained in "SQL commands", would be "The SQL statement cannot be executed due to an error in syntax, operator or names related to the table be consulted." Or something equivalent. In addition to indicating the need to review and correct the problem, the message can be translated into the user's language. This subject is new to me and, unless there is any misunderstanding, it is just an idea.

42

(17 replies, posted in General)

jrga wrote:
sparrow wrote:

Added:
- Working with IS NULL , IS NOT NULL in the filter
- Function to detach a database to connect to a new one
- When using a filter, the generated request is displayed in MEMO for the opportunity to supplement the request
- The clear button clears the filter and returns the default query
- Fixed some bugs


Sparrow, congratulations and thank you for the improvements you have implemented! I will include the formatting below for the "Field Total" field and am making changes so that the "Field Filter" and "Field Total" comboboxes are changed when the SQL statement displays results other than the default in the tablegrid, by user intervention - e.g. :

"SELECT ID_FORNECEDORES, SUM(SAIDA) AS SAIDA FROM DB2.LANCAMENTO GROUP BY ID_FORNECEDORES".

After that, I upload the new version. I tried to use the "SQLQuery" function, to avoid the standard MVD error message, in case of an error when manually constructing the SQL statement, but I couldn't...

  frm_runsql.TableGrid1.Columns[num_col_total].Footer.Caption :=
  FormatFloat( '###,###,##0.00', frm_runsql.TableGrid1.Columns[num_col_total].Footer.FormulaValue);

Finished!
* includes formatting in the total field "Field Total";
* Combobox "Field Filter" will continue to have the original field structure of the selected table;
* Combobox "Field Total" will only contain the fields of the SQL statement, contained in "SQL commands"

This way, the "Field Total" field can be used without errors in queries - examples below - for the same table:
- select * from table
- select id_product, value_test from table
- select id_product, sum(value_test) as total from table group by id_products

43

(17 replies, posted in General)

sparrow wrote:

Added:
- Working with IS NULL , IS NOT NULL in the filter
- Function to detach a database to connect to a new one
- When using a filter, the generated request is displayed in MEMO for the opportunity to supplement the request
- The clear button clears the filter and returns the default query
- Fixed some bugs


Sparrow, congratulations and thank you for the improvements you have implemented! I will include the formatting below for the "Field Total" field and am making changes so that the "Field Filter" and "Field Total" comboboxes are changed when the SQL statement displays results other than the default in the tablegrid, by user intervention - e.g. :

"SELECT ID_FORNECEDORES, SUM(SAIDA) AS SAIDA FROM DB2.LANCAMENTO GROUP BY ID_FORNECEDORES".

After that, I upload the new version. I tried to use the "SQLQuery" function, to avoid the standard MVD error message, in case of an error when manually constructing the SQL statement, but I couldn't...

  frm_runsql.TableGrid1.Columns[num_col_total].Footer.Caption :=
  FormatFloat( '###,###,##0.00', frm_runsql.TableGrid1.Columns[num_col_total].Footer.FormulaValue);

44

(17 replies, posted in General)

jrga wrote:

I don't know if "dynamic query" is the best name for this project. I like programming, but my background is different. I created it to be integrated into my applications, which can be activated with Ctrl-9. The goal is to have a feature in the application itself to eventually resolve end-user issues by checking tables, executing custom SQL statements in real time, etc. If anyone wants to improve it, please share the improvements. It was made with MVD 5.6

I included a combobox for the user to select the field that should be totaled in the tablegrid footer and converted the HelpSqlite.exe file to HelpSqlite.chm.

45

(17 replies, posted in General)

k245 wrote:
pavlenko.vladimir.v wrote:
jrga wrote:

I don't know if "dynamic query" is the best name for this project. I like programming, but my background is different. I created it to be integrated into my applications, which can be activated with Ctrl-9. The goal is to have a feature in the application itself to eventually resolve end-user issues by checking tables, executing custom SQL statements in real time, etc. If anyone wants to improve it, please share the improvements. It was made with MVD 5.6

обнаружен вирус
virus detected

Та же фигня - защитник винды не даёт скачать....


I will attach it again without the HelpSqlite.exe file.

46

(1 replies, posted in General)

sdpc62 wrote:

I saw that in an application a Table had the boxes grayed out, how is this done?


I have MVD 5.6 but I saw that in version 6.5 (latest) there are standard tables: _role, _user etc that allow the user to natively create a login and password system. I believe that, because they are system tables, this grayed-out condition is specific to these tables and prevents changes to them.

47

(17 replies, posted in General)

derek wrote:

Hi Roberto, Hi Vladimir,
It's a neat application - kudos to you Roberto.
For information, Bit Defender and Total AV didn't find any problems with the download.
Regards,
Derek.

Thanks  Derek

48

(17 replies, posted in General)

pavlenko.vladimir.v wrote:
jrga wrote:

I don't know if "dynamic query" is the best name for this project. I like programming, but my background is different. I created it to be integrated into my applications, which can be activated with Ctrl-9. The goal is to have a feature in the application itself to eventually resolve end-user issues by checking tables, executing custom SQL statements in real time, etc. If anyone wants to improve it, please share the improvements. It was made with MVD 5.6

обнаружен вирус
virus detected


Isn't it a false positive? I have Avast Antivirus which did not identify viruses!

49

(17 replies, posted in General)

I don't know if "dynamic query" is the best name for this project. I like programming, but my background is different. I created it to be integrated into my applications, which can be activated with Ctrl-9. The goal is to have a feature in the application itself to eventually resolve end-user issues by checking tables, executing custom SQL statements in real time, etc. If anyone wants to improve it, please share the improvements. It was made with MVD 5.6

50

(5 replies, posted in General)

other..

var
   mydebug: boolean = true; // false disable all breakpoints

procedure m(lbl:string;txt: variant);
//*** Proc 851 - minha solução para depurar...
begin
   if mydebug then
       showmessage(lbl + vartostr(txt));
end;

examples:

m('Edit1: ',frmLogin.Memo_tp2.text);
m('sKey: ',sKey);