26 Reply by Wood

(187 replies, posted in General)

Hello,

Some ideas as improvements for the script editor:
a) Search text
b) Replace text
c) F1 on commands to open suitable help for the command
    e.g. take a look to scite editor from Autoit3 https://www.autoitscript.com/site/autoit-script-editor/
d) a marker to see whether script is saved or not (like in every editor or word, excel etc.)

Kind Regards
Wood


01.12.2019 - Meanwhile I found this:
Control + f = search text
Control + h = replace text

Things like F1 for contextsensitive help,  Autocomplete and Intellisense I'm still missing.
This would be a very great enhancement for the editor and very helpful.

Go to forum: General

27 Reply by Wood

(3 replies, posted in Talks about all)

Topic order vs. Forum order

Go to forum: Talks about all

28 Reply by Wood

(3 replies, posted in Talks about all)

Hi,

There a many examples. Strictly speaking its in every topic.

A newer one:
http://myvisualdatabase.com/forum/viewtopic.php?id=4757
It starts 2018-12-04 and you have to goto page 2 and jump down to entry from 2019-11-20 to see the newest info.

An older one and especially clear:
http://myvisualdatabase.com/forum/viewtopic.php?id=150
It starts with first entry on 2014-04-27 and you have to goto page 7 and jump down to entry from 2019-11-01 to see the newest info.

...and so on.

Regards
Wood

Go to forum: Talks about all

29 Reply by Wood

(6 replies, posted in General)

Hi Derek,

Thank you so far! Your answer inspired me to test another thing.
This is what I found: I can print without error when I remove the 5 INTEGER fields and then include them again!
With that the 5 fields are placed at the end of the sql statement. In this constellation there is no chance for MVD to produce the error, because no TEXT fields are following then.
Now I'm still more convinced that there is a bug in generating the correct sql statement when INTEGER fields are included and TEXT fields are following when search fields are in use.

In my case, you are right, I dont need the search fields (it took a while until I realized what you meant).
But for other users, using the search fields, the error exists.

Thank you for your quick help!

Kind Regards
Wood

Go to forum: General

30 Reply by Wood

(6 replies, posted in General)

I hope this time the file is attached :-)

Go to forum: General

31 Reply by Wood

(6 replies, posted in General)

No problem, see attached ZIP file.

But the statement is not written by me, it is generated by MVD if you press the print button.
Double click the record of "Tom Garden" and press print button (named "Drucken") and you will see.
If you remove the value of the field RAM then you can print without problems!

Kind Regards
Wood

Go to forum: General

32 Topic by Wood

(6 replies, posted in General)

Hi,

I've made a very simple database (just for learning MVD) where most fields are TEXT. Just 5 fields are INTEGER.
For printing I've started to make a report. All works fine as long as I dont fill in values into the INTEGER fields.
If I try to print then I get a strange error message which seems not to be related to any values in the form.
But if I look at the select statement then it gets clear.
As soon as there is any value in one of the INTEGER fields, then all following compare values of the TEXT fields have no quotation marks any more. And with that the select will fail of course.

Can you check this please?

Kind Regards
Wood

Go to forum: General

33 Topic by Wood

(3 replies, posted in Talks about all)

I have a question regarding the forum itself.
If you open a forum like e.g. "General" then you will always see all new topics on top of the list.
Also if you search a keyword all results will be displayed in discending date order.
That's pretty good, because you can find new things always rather quick.

But if you open a topic with many entries then they are in ascending date order.
This means that you always have to scroll to the end of the page or first of all even have to jump to last page and then scroll there to the end to see what's new in there in this topic.

Maybe there is a (hidden) setting in the personal profile to do that per user, but I did not find something like that there at the moment.
My question is: would you be willing to change this order?
Of course I would also accept a "no", because you are the owner and we have to take it as it is.
But I could imagine that many other users would also appreciate a different order of entries in topics.
In addition, it would then be consistent throughout the forum: new entries are always on top, old always below.

What Do you think about it? What do others think about it?

Regards,
Wood

Go to forum: Talks about all

34 Topic by Wood

(1 replies, posted in General)

How about including the Report Designer within MVD?

I suggest somthing like the Tab "Database Tables" but with "Reports" where you can add new and edit existing reports.
Every report could be simply displayed by an icon and its name.

With that you could design reports without always having to run the project (and make Report Designer visible there, if it's hidden for some reasons).

Kind Regards
Ewald

PS: I also postet it as a reply to "what to implement first" by accident, sorry!

Go to forum: General

35 Topic by Wood

(1 replies, posted in General)

Hi,

Another suggestion is, that items that are placed in a form, can also be moved using the cursor keys and then the grid should be ignored. When moving with the mouse, a grid is always used and that is often not precise enough.
E.g.:
cursor key = move item 1 pixel
shift cursor key = move item 5 pixels

Kind Regards
Ewald

Go to forum: General

36 Topic by Wood

(1 replies, posted in General)

Hi,

I want to suggest, that the block "Additional" in the database filed dialog should be open by default.
You always have to click on it just to see only 2 more fields. Alternatively you could also show these 2 fields without placing them in a separate panel. These are unnessecary mouse clicks that every developer has to do on every new field over and over again.

Kind Regards
Ewald

Go to forum: General

37 Topic by Wood

(1 replies, posted in General)

I just want to suggest an improvement.

At the moment there are different forums like "General", "Script", "SQL-Queries" and so on.
If you want to know something about a version, you allways have to search in the forums (e.g. when was a specific feature added or when did a specific version come out?).

Could you establish a new separate forum like "Version"?
Within this forum you could bring together all version numbers, informations about the versions like new functions added, fixes etc. and at last possibly also downloads of all versions (including older versions).

This would help to increase clarity a lot.

Kind Regards
Ewald

Go to forum: General

38 Topic by Wood

(1 replies, posted in General)

Hi,

I'm new to MVD and I wonder, if it is generally possible to show the values of a record outside of a grid, e.g. in a subform or in separat textboxes etc.

If you navigate up or down to another record in the grid, the values in the separat textboxes or fields should be updated with the values of the grid.

See example in the Picture.

Is this possible?

Kind Regards
Wood

Go to forum: General