Silly question, where is the "Calculated Field" ?
many thanks
My Visual Database → Posts by DriveSoft
Silly question, where is the "Calculated Field" ?
many thanks
tcoton
Planned, but now in the priority is Web grid.
Посмотрите пожалуйста данный видео урок
https://www.youtube.com/watch?v=-kKAgCgyRtY
Hello Dmitry
Happy New Year for 2016 !
A suggestion for fa friendly aspect to MVD. :
Would it be possible to add a new button in the toolbar MVD ?
A button which could hide/display the Object Inspector panel to have better visibility on the Script Editor.
Hello.
Unfortunately no.
And now I can't bring it back to its normal state despite the two arrows (it had to leave my screen !!!!).
So I thought this little trick.Thanks if you can do it (YES YOU CAN as says the other B. O).
JB
Thanks, I will fix it in the next release.
You use DBImage with property Type=LinkFile?
If yes, please check it out:
http://myvisualdatabase.com/forum/viewtopic.php?id=1427
Please paste your script here.
Hello,
Try to use TOTAL instead SUM
(select TOTAL(inwards.inqty)
from inwards
where medicine.id = inwards.id_medicine)
-
(select TOTAL(out.outqty)
from out
where medicine.id = out.id_medicine)
The sum() and total() aggregate functions return sum of all non-NULL values in the group. If there are no non-NULL input rows then sum() returns NULL but total() returns 0.0. NULL is not normally a helpful result for the sum of no rows but the SQL standard requires it and most other SQL database engines implement sum() that way so SQLite does it in the same way in order to be compatible. The non-standard total() function is provided as a convenient way to work around this design problem in the SQL language.
Hello,
Do you want make export of data from SQLite database to MySQL database?
nikolai_nn
Пожалуйста опишите, что именно вы хотите сделать с помощью скрипта.
You can create unique index using free tool SQLite Studio (http://sqlitestudio.pl/)
Open database file (sqlite.db) using SQLite Studio
Please look the screenshot for details.
You can call method DoOnChange for parent combobox to update child combobox and use event OnAfterClick for button with action "New Record"
procedure Form1_ButtonNewRecord_OnAfterClick (Sender: string);
var
iID: integer;
begin
iID := Form1.CB2.dbItemID; // to save selected id
Form1.CB1.DoOnChange;
Form1.CB2.dbItemID := iID; // to restore selected item
end;
No need My Visual Database for the end user.
Final application a exe file ready to work on any Windows OS.
nikolai_nn
Здравейте.
1.
Form1.ComboBox1.dbDeleteRecord (-1);
можете поместить данную строчку кода в событии OnShow главной формы.
2. Вы можете сделать форму с изменяемым размером.
Установите свойство формы Sizeable = True
также каждый компонент имеет свойство Anchors, которое позволяет задать поведение компонента при изменении размеров формы, например чтобы он изменялся в размерах вместе с формой (Anchors = Left, Top, Right, Bottom)
либо чтобы компонент всегда был в правом нижнем углу (Anchors = Right, Bottom) и т.д.
Unfortunately I can't test your project without remote connection to you database.
You use MySQL server, so I don't have access to your database for testing.
Try to connect to database from My Visual Database, thus your database structure will be automatically analyzed and you will get error message if your database structure is broken.
Form1.CheckBox1.State := cbGrayed;
Example:
if (main.bxest1.value >= 0) and (main.bxest1.value <= 3) then main.bxest1.Color := clWhite;
if (main.bxest1.value >= 4) and (main.bxest1.value <= 6) then main.bxest1.Color := clYellow;
if (main.bxest1.value > 6) then main.bxest1.Color := clRed;
Hello Dmitry
To permanently resolve the problem of language, which seems to be a strong demand from users, is it possible to envisage arranging the menus in different languages in the form of an XML file, TXT or INI ?
Thanks
JB
It's planned, but now there is other priority (web access for DB)
Так я добавил туда еще одну вкладку и сделал ее скрытой. Теперь все работает. Смысл в том, что когда в Pagecontrol одна страница с индексом 0 TableGrid пропадает на ней, не отображается. В версии 2.2. было все в норме.
Исправил ошибку.
Как выяснилось свойством Visible следует управлять с помощью скрипта из за специфики свойства данного компонента (TabSheet), поэтому пришлось убрать его из инспектора объектов.
Скачайте пожалуйста снова последнюю версию
http://myvisualdatabase.com/thank_you_f … ading.html
Спасибо за найденную ошибку.
Two more questions:
1. Do I have to buy the Fast Report designer separately?
2. How can I start this thing to directly edit an existing report? Didn´t find an installation of Fast Reports and there is no editor for the fr3 file found by the system.
1. No, if you disable access to report designer for end user from menu (restrictions by license of FastReport)
http://myvisualdatabase.com/forum/viewtopic.php?id=1440
2. Run your project, then follow menu: Options > Report designer
then you can open exists .fr3 file (File > Open)
Thanks a lot.
Any docs about the functions (reference) and the scripting ?
Script is pascal language, so you can use any book about Pascal (Delphi) language.
Here you can find list functions and classes
MB
Currently there is no roadmap yet.
You can use multiuser:
- for SQLite using shared folder in the LAN
- using MySQL (original multi-user database)
Here you can find example, how to create users via script:
http://myvisualdatabase.com/forum/viewtopic.php?id=1422
Video lessons:
http://myvisualdatabase.com/video_lessons.html
Documentation:
http://myvisualdatabase.com/help_en/
отправил, pha1984@yandex.com
Проверил на версиях 2.1, 2.2, 2.3
разницы не заметил, на всех версиях диалог появляется на доли секунды.
Unfortunately I did not use FileMaker and can't tell you what the differences between FileMaker and MVD )
Hello,
Almost all dialogs or messages you can replace using script.
What kind of dialogs and messages you talk?
My Visual Database → Posts by DriveSoft
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi