Hello Dmitry, Jean,
Just downloaded 1.52 and added the new properties to my script - it works perfectly.
Thanks, as always for your help and quick response.
Derek
2,801 2015-05-30 00:33:03
Re: Hints (3 replies, posted in General)
2,802 2015-05-29 17:53:48
Re: Big project requires some help :) (15 replies, posted in General)
Hi TCoton,
Perhaps you could add a 'USERS' table with 2 fields (UserName, UserGroup).
Then you could restrict access to various sub-sets of tables conditional upon each UserGroup.
For example,
if UserGroup = 'A' then
form1.tablegrid3.visible:= false;
form1.tablegrid7.visible:= false;
If UserGroup = 'B' then
form1.tablegrid2.visible:= false;
and so on
I've tried something a bit similar before - but not as complicated as your project. But the theory is the same.
Good Luck.
Derek.
2,803 2015-05-29 16:55:43
Topic: Hints (3 replies, posted in General)
Hi Dmitry,
I use the 'hint' function quite a lot. But the 'hint' message only stays visible for about 3 seconds. This is often not long enough for a User to read all of the 'hint'.
Is there something i can do in a script to increase the time to display - for example to 5 or 6 seconds.
I'm using MVD 1.51.
Thanks,
2,804 2015-05-28 23:51:42
Re: Can we build a categorized directoryrepository of snippets/scripts? (8 replies, posted in General)
Hi Archer, Hi Everyone,
It's funny how we all store our bits of code in different ways.
I use a very simple project written in MVD - it was my first attempt so i used it as a little training exercise to get more familiar with the software.
If it's of any interest to you, feel free to download it and change it to suit your own specific needs (i've left a bit of data in it to give an idea of how i use it but it's easy to delete if you don't want it).
You can also download the project, including executable from: https://app.box.com/s/k5l1s084wer9645umgrdbim0durnq7km
Finally, apologies for the colour scheme that it uses - my grandson was "helping" me when i was writing it and he chose them!!
Derek.
2,805 2015-05-26 17:19:15
Re: problem with texthint (7 replies, posted in General)
Hi Dmitry, Hi Jean,
As you say, maybe it is because of Windows XP although it surprises me. I hope there are not other areas where some features only work with certain versions of Windows - that has implications for installing projects you have written on different PCs.
I have used ('showhint' and 'hint') before but i think 'texthint' looks better. But it is not a major problem if i can't use 'texthint', it just would have been nice.
By the way, i have always used 'Form1.showhint := true; rather than write it for each Edit field - i suppose it's slightly quicker if you have lots to do.
Actually, i don't know why 'hints' (and 'texthints') can't be one of the properties for Edit fields (and Combobox, Memo and DateTimePicker fields) - it would be much easier, it would encourage people to use the 'hints' features (not many appear to use it) and you could then take it out of the scripts.
I have also just tried 'crhandpoint' and that is a nice touch! I will certainly use that.
Thankyou Both for the quick replies.
Derek.
2,806 2015-05-26 14:38:28
Re: problem with texthint (7 replies, posted in General)
Hi Dmitry,
I still have the problem so i have tried to make a better example for you.
On Form1, i click ADD to open Form2.
When Form2 opens, Edit3 has focus, therefore the texthints for Edit1 and Edit2 should display, if i understand your reply correctly.
But as you can see in the attached screenshot ('dmitry texthint.jpg), no texthints are displayed.
Is there something else that i need to do?
For information, i am running MVD 1.51 on Windows XP SP3.
Thanks,
Derek.
2,807 2015-05-25 22:06:03
Topic: problem with texthint (7 replies, posted in General)
Hi Dmitry,
I am trying to add a script to use the .texthint function as - Form1.Edit1.TextHint := 'Enter First Name';
But no text hint is displayed in form1.edit1.
Any ideas what I am doing wrong?
Example is attached.
I am using 1.51.
Thanks,
Derek.
2,808 2015-05-12 22:12:08
Re: In Place Edit Grid Data (4 replies, posted in General)
In-grid editing would be a major improvement. I think it would take MVD to a whole new level.
Hope it comes soon.
Derek.
2,809 2015-05-11 20:34:47
Re: Table Grid Sorting (4 replies, posted in General)
Hi Dmitry,
Just read through the script and tried it out and it works well. Working with the grid is much more user-friendly now.
Agree with TCOTON - having it as a grid object property would be even better.
Thanks again,
Derek.
2,810 2015-05-08 21:09:11
Topic: Table Grid Sorting (4 replies, posted in General)
Hi Again Dmitry,
I often need to sort a tablegrid in different sort sequences to work on it.
To do this, I click on the column header and the tablegrid is re-sorted as I want it.
But when I have viewed, amended or deleted a specific row and saved the record, the tablegrid does not remember the sort sequence I was working with. So I have to click on the column header again and find the position in the tablegrid where I was working before I can continue (see attachment).
Is this the way it is supposed to work?
Thanks,
Derek.
2,811 2015-05-08 20:33:11
Re: Position of pop-up form (8 replies, posted in General)
Hi Dmitry,
I wasn't sure if it could be done by writing to the registry or perhaps with a .ini - but I would have struggled either way to write it.
I've just tried it and it works exactly how I wanted it to.
Thanks as always for the quick response.
Derek.
2,812 2015-05-08 15:19:25
Topic: Position of pop-up form (8 replies, posted in General)
Hello Dmitry and MVD Team,
I use a pop-up form to display some menu options.
This pop-up form shows in the centre of the screen (see dmitry1.jpg).
I manually re-position this (see dmitry2.jpg).
This is okay until I close the application but when I start the application again, the pop-up form is in the centre again.
Is there a way for MVD to remember the last position of the pop-up form?
My application is attached and I am using Version 1.51.
Thanks,
Derek.
2,813 2015-04-20 12:46:16
Re: Combobox and default index (2 replies, posted in General)
Hi Dmitry,
Working correctly now.
Thanks,
Derek.
2,814 2015-04-20 00:24:49
Topic: Combobox and default index (2 replies, posted in General)
Hello Dmitry,
I am starting a small project to collect names of teachers and what country / region they are based in.
I have a form (form4) with 2 comboboxes, one of which is a parent combobox.
90% of teachers are based in England so I set the default index for combobox1 = 1 ('England') and the User can go directly to combobox2 to select a region. But instead of displaying the regions for England in combobox2, no values are displayed (screenshot 'combobox no values'). So the user has to return to combobox1, reselect 'England' from the combobox1 values and only then are the values for combobox2 displayed (screenshot 'combobox with values').
Is this the correct way to use the default index or am I making an error?
I have attached a copy of the project and I am using Version 1.51.
Thanks,
Derek.
2,815 2015-04-15 21:41:33
Re: What to implement first? (188 replies, posted in General)
Hello Dmitry
I have used MVD for a few weeks now and would like to make the following suggestions for features in a future release.
** SMALL IMPROVEMENTS TO TABLEGRID
1. A currency field shows in a tablegrid column as right-justified automatically. Can the column header.alignment also be right-justified automatically?
2. A currency field's properties can be set in the Object Inspector to display, for example, as £27,500.00 but shows as 27500 in the tablegrid (cell) and as £27500.00 in the tablegrid (footer). Can both tablegrid (cell) and tablegrid (footer) display the field contents exactly as defined in the field's properties so that it is consistent?
3. Could a color picker be added to the tablegrid footer options so that footer summaries can be easily highlighted (ie, 'Formula', 'Text Before', 'Text After' and then 'Color Picker')?
** NEW FIELD PROPERTIES IN THE OBJECT INSPECTOR
4. Add an 'uppercase' property to force upper case to ensure that data is entered consistently.
5. Add a 'hint' property with an edit box so you can write help messages that will appear when hovering over the form / tablegrid / field with the mouse.
6. Add a vertical scroll-bar property for text fields that are displayed as memos.
** NEW BUTTON ACTION
7. Add a new BUTTON action that makes an 'open url' call to a website.
** NEW FIELD TYPE
8. A "LIST" field type (like Google Docs' List of Items where you create a small list of valid entries, separated by commas).
For example, in your MVD Students project, currently you have to:
a) create 5 separate 'dictionary' tables (sex, groupname, specname, status, prohod),
b) create 5 relationships with other tables
c) create 6 forms.
With a "LIST" field type, you would only need 5 "List" fields with list items of (Male,Female), (1st Attempt,2nd Attempt), (01,02), (Doctor,Lawyer) and (Normal,Fired,Graduate) - much more simple.
Perhaps there are programming reasons why you can't have an option like this but it would make creating a project much quicker and easier to set up.
I understand that most of these things can be done by writing scripts (as I have done myself) but for ease of use, speed of development and for those Users who are not comfortable with scripts, perhaps some of these things could be included as part of the basic MVD program in the future.
Thanks for all your help so far.
Derek.
2,816 2015-04-14 21:41:19
Re: SQL Query and Tablegrid (4 replies, posted in SQL queries)
Hello Dmitry,
I've just dowloaded the latest 1.51. Footer settings are working well now with SQL QUERY searches.
Thanks, as always,
Derek.
2,817 2015-04-14 18:29:58
Topic: SQL Query and Tablegrid (4 replies, posted in SQL queries)
Good Evening Dmitry and MVD Team,
If I use footer settings in a tablegrid (for example, 'SUM' with a prefix of '£'), these are displayed correctly.
If I use a SEARCH and specify the tablegrid for the output, the footer settings are still displayed correctly.
But if I write an SQL Query and specify the same tablegrid for the output, the footer settings are not shown.
Is there perhaps something else I need to use?
I know that I can correct this using a script but it is not so quick or so easy.
I am using 1.50 but I also noticed the problem in versions 1.45 and 1.49.
Thanks,
Derek.
2,818 2015-04-10 00:01:38
Re: Search result with first letter in a name? (8 replies, posted in General)
Good Evening Dmitry,
Just downloaded 1.51 and tried the new s% filter and it works very well - much easier and quicker to set up "begins with" searches now.
Thanks as always.
Derek.
2,819 2015-04-08 19:03:10
Re: Search result with first letter in a name? (8 replies, posted in General)
Good Evening Dmitry,
Currently, the filter type %s% finds a character string ANYWHERE within a field. Would it be possible to add a new filter type of s% so that the first (leading) character(s) of a field can be retrieved? I know this can be done by using the SQL Query option but Search with a filter type of s% would be much easier and quicker.
Derek.
2,820 2015-04-08 18:45:05
Re: Search result with first letter in a name? (8 replies, posted in General)
Hi There Supabeast,
I had a similar problem a few weeks ago.
My understanding is that you want to enter the FIRST letter (or the FIRST COUPLE of letters) of a name and then search.
Setting the filter on the combobox to %s% will retrieve rows where the particular letter (or couple of letters) appears ANYWHERE in the name and not just at the start. Unfortunately, setting the filter to s% (rather than %s%) doesn't seem to be an option.
If this is, indeed, the case, the easiest way of achieving what you want is simply to enter the first letter (or first couple of letters) of the name and then manually add %.
If you don't want to have to manually add the %, then i believe you'll need to change the action of the button from 'Search' to 'SQL Query' and in your WHERE clause use where fieldname like '{edit1}%';
You might also want to perform an 'incremental search' so that the names filter as soon as you start typing. Some people like the effect, some don't. If you do, add the button to the 'incremental search' in the properties of the search field.
Hope this helps a bit and good luck.
Derek.
2,821 2015-04-06 12:16:00
Re: Tablegrid, sub-grids and sql search (3 replies, posted in General)
Hello Dmitry.
I didn't realise you could actually reference a tablegrid like that as part of your sql query search.
Thanks.
Derek.
2,822 2015-04-06 00:28:10
Topic: Tablegrid, sub-grids and sql search (3 replies, posted in General)
Hello Dmitry,
In a project i have just started, Form1 has 1 main Tablegrid, 2 sub-Tablegrids and 2 incremental sql-searches.
In the following example, when I start, Form1 looks like this (screenshot1).
I use an incremental sql-search on Tablegrid1 which retrieves 3 rows into Tablegrid3 (screenshot2).
I then use the second incremental sql-search on Tablegrid3 which reduces the rows from 3 rows to 2 rows (screenshot3).
If I want to try a different search on Tablegrid3, I delete my criteria but instead of looking like (screenshot2) which is what I expected, it now looks like (screenshot4), showing ALL rows.
To make it look like (screenshot2) again, I need to go back and re-highlight or re-enter the selection in Tablegrid1.
I think there is something that I've not set up correctly but I cannot find it. Can you help?
I have enclosed a copy of the project and I am using Version 1.50.
Thanks,
Derek.
2,823 2015-04-03 18:11:08
Re: Splashscreen (6 replies, posted in General)
Hello Jean,
Thanks for your suggestion. It doesn't matter to me if it's unorthodox providing it works!!
I was just hoping for a really easy way of having the splash screen wait until the user actually 'started working'.
But it's 99% how i wanted now so it's okay (nothing is ever 100% - ha ha!).
Derek.
2,824 2015-04-03 18:05:11
Re: Splashscreen (6 replies, posted in General)
Hi Dmitry,
Thanks, i've changed it as you advised.
But it still surprises me that it works okay within the MVD environment but not when run as a standalone exe.
Derek.
2,825 2015-04-03 10:55:59
Topic: Splashscreen (6 replies, posted in General)
Good Morning Dmitry, all at MVD,
I have a Welcome / Splashscreen that I show when my project starts.
The splashscreen stays visible until the user either uses the keyboard or moves the mouse at which point the splashscreen disappears.
When I run this WITHIN the MVD environment, it works as intended (see dmitry splashscreen.jpg) in the attached .zip file.
But when I run it as a standalone executable (requisitions.exe), the splashscreen immediately disappears.
Do you know how I can correct this?
Thanks,
Derek.