You are not logged in. Please login or register.
My Visual Database → Posts by AD1408
Hi Derek,
Thank you very much for your kind help.....................
Account calc field is fine. Commission is an expense, my bad as it wasn't made clear, but that's OK, I corrected it.
However, journal one should be actual running balance, not just totals. Each line balance would be affecting the next line balance.
Hi All,
I need a help with calculated field formula syntax.
calcField:
Running balance= ((startingBalance)+(AmountWin)+(PositiveSwap))-((NegativeSwap)+(Commission))
Please see the attached sample project file:
Hi Guys,
Thank you very much for all solutions...
Derek, you are right, when I open your sample project file with older (v3.5) MVD formatting works fine.
Hi Derek,
I found the attached one of your sample file that includes formatting calculated fields currency formatting. If I didn't change anything accidentally, TNxNumberColumn formatting for calc fields doesn't seems to be working. Any help please?
Thank you so much EHW.....
Truly appreciated..............
could anybody put the following into MVD script please:
if the task due date + task due time = the current date + current time then
play alert sound file (.mp3 or .wav) specified
I couldn't get the sound alert of the remainders work properly..
I get an error "Cannot determine the device type from the given filename extension"
Could anybody help to resolve the issue please.
Sample project is attached:
Thank you very much Dmitry.............
Truly appreciated................
I have tried to put together a simple reminder app with text pop and sound alerts. Separately they seems to be working but when I want both text and sound alerts on it doesn't work. Text alert message pops up but sound alert only plays after closing text alert popup closed. I was trying to have sound alert playing while text alert popup displayed.
Please see the sample project below:
MVD is a great gift offered to mostly non coders like myself. I love it and I like/wish it to get even better. I like to thank Dmitry for offering as such great development platform and support.
Now, what I'm looking for in respect of improvements. I'll try to keep this thread live, keep nagging with a hope to get Dmitry to implement these features.
1. Treeview
I was waiting for treeview component to be added to MVD. Finally, something is implemented, but it's hard to say that is a proper treeview. I like to see a proper treeview implemented, where we can add custom icons and flags icons for every node, moving, dragging and dropping treeview items, changing font style / color of treeview items.
2. Calendar
Desperately needed better calendar component needed. At the least need a "function that can either change the background color of the selected dates or change the text color of the selected dates". Perhaps even having optional text or sound alarm for selected dates.
3. RTF
This was another component I was waiting for. Thankfully it has been implemented. However, it can be improved further. i.e. dockable toolbars, access to all items to include in toolbars or being able to create new tollbars.
4. Menu designer
This is not that important as we can do it via scrip. It could be great time saver on development.
5. Radio button
I have no idea why one of the basic component (radio button) is not implemented all these time.
Hi Derek,
Thank you very much.....
Is there a way to color in bold dates contain reminders instead of just bold?
Or any other ways to make days with reminders more visible?
Is there a way to highlight / color etc dates that contain records on calendar and display the data in a memo / rtf editor on calendar form rather than pop-up?
Hi Derek,
Thank you very much for your kind help.................
Hi Guys,
I have various resources in various folders in my computer storage devices / hard disks.
When adding a resource I'd like to bookmark the file location and navigate to the location via button with default file browser rather than saving actual resource file within DB file using dbFile component.
I couldn't work it out. Please help.......
Hi Dmitry,
Thank you very much...... it works.
Hi JB,
Thanks a lot but it didn't work at my end.
Could somebody correct the following script please
procedure Form1_OnShow (Sender: string; Action: string);
begin
if Form1.cbMainMethStrategy.dbItemID = '' then
begin
Form1.btnStrategyDetails.Enabled := False;
end else Form1.btnStrategyDetails.Enabled := True;
end;cbMainMethStrategy is a comboBox
Hi Adam,
For me, the easiest way would be to use a calculated field and avoid doing it in the script.
(select round(avg(rating),2) from item where item.id_school = school.id)
See attached.
Derek.
Sample project on the post above.
I realized that, when deleting a school on schools grid, items belonging to school on items grid get deleted too. I have no idea how to do this but I like add some safety to prevent such deletes:
When school grid delete button clicked, check to see if there is any records listed in item grid belonging to the record user trying to delete. If there is then delete canceled with custom message "Cannot delete........ etc"
edit:
-----------------
tried the following but didn't work fully:
procedure Form1_btnSchoolDELETE_OnClick (Sender: string; var Cancel: boolean);
begin
if Form1.tgItem.RowCount > - 1 then
begin
Cancel := true;
MessageBox ('Reord you are trying to delete contains sub records. You must delete sub record/s first.','Error',MB_OK+MB_ICONERROR);
end;
end;couldn't clear cancel:=true so that user can delete main record after clearing sub records.
Hi Derek,
Thank you very much for your kind help..............
Truly appreciated.................
Hi Derek,
Thank you very much for your attention...........
Still couldn't sort out copying footer to another tg column..
Please see attached sample project:
the following didn't work:
procedure Form1_OnShow (Sender: string; Action: string);
begin
Form1.tgSchools.Columns[3].Value := Form1.tgItems.Columns[3].Footer.FormulaValue;
end;How do I clear RichEdit please?
The following didn't work.
procedure Form1_TreeViewPasswMain_OnCellClick (Sender: TObject; ACol, ARow: Integer);
begin
if form1.tgPasswMain.dbItemID = -1 then
begin
form1.RichEdit1.Clear;
end;
end;Hi Dmitry,
Perhaps you are working on it currently but just want to mention.
Adding images on RTF comp increases DB size drastically. I used (c/p from web browser) 12 images and got 47MB db file. Images are not large, even if they are saved as .bmp the biggest one is under 300 kb.
I don't know in which file format images are saved by RTF editor used in MVD. It may be good idea to provide image file format option during image insertion in to rtf editor.
If possible provide option to save images added in RTF editor in an external folder rather than in db file.
Thanks a lot Dmitry......
Looking forward to release of v5.
Please try to include RTF component toolbar customization such as how many toolbar rows, shortcut icons distribution to defined toolbars and perhaps option to replace default toolbar icons with custom ones - all in development phase not end user customization.
Hi JB,
Thank you very much for your reply.
I tried the following but unfortunately I couldn't get it work:
var richText1 : String;
procedure Form1_TableGrid1_OnCellClick (Sender: TObject; ACol, ARow: Integer);
begin
form1.RichEdit1.Text := sqlexecute('select rrrtttfff from employees where id =' + inttostr(form1.TableGrid1.dbitemid));
form1.RichEdit1.Lines.LoadFromFile(richText1);
end;I used Dmitry's treeview sample project which is attached below:
My Visual Database → Posts by AD1408
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi