Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Robert Jan de Nie

133 Replies

Newest first

Oldest first

HJ van DalfsenSidekick

Arjan SollieThinkwise blogger

Atomic Transaction checkbox set default to trueCompleted

I agree that less is usually more and a validation will suffice. But people do need to be aware of just implementing everything as an atomic transaction if the application/logic has not been set up this way, or if transaction handling was built in manually before.

1 year ago

Arjan SollieThinkwise blogger

Atomic Transaction checkbox set default to trueCompleted

This should be a project(version) setting in my opinion. For existing projects, defaulting to true could have serious impact, while on new projects you'd want this behaviour by default.

1 year ago

René WSuperhero

Override delete and copy with a custom taskMerged

Really, REALLY like your idea. I'd like to propose one change. Have the form be just the form. So when adding or editing, the input parameters can just be the form fields. This way you maximize flexibility and have a consistent interface to boot.

3 years ago

Moller TomaCaptain

An editable GUI that modifies the settings of the SF and IAMOpen

Yes please. I think I have wanted this since version G6 (way back when).

1 month ago

René WSuperhero

Select all with CTRL + A in web guiCompleted

Also, put in CTRL-C / X / V edit: It is not available in the context menu. This is the other way around…

4 years ago

Jop ter HorstVanguard

Validation on RDBMS reserved keywordsCompleted

Should be pretty easy to resolve: Here is Microsofts list: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15

4 years ago

Erwin EkkelModerator

if exists Alter procedure on functionality executeCompleted

Yes, create or replace / create or alter is the way to go!

1 year ago

Roland van AggeleApprentice

Show failed task call in debug windowCompleted

Yes please!

3 years ago

eurbanVanguard

asked in Questions & Conversations

Sql SEQUENCE

Yes, dynamic model is a way to go, I use that as well at the moment. But I still think it should be a default feature everybody can use rather than having to do something (semi-) complex using dynamic model. If you agree, please upvote my idea as posted by @Mark Jongeling

4 years ago

MichaelSidekick

Display Combo/Radio elements as stars in form (and maybe list)Open

I like the idea, but can we make it a bit more flexible? Maybe be able to select your own ‘star’ picture?

2 years ago

Harm HorstmanSuperhero

Disable detail tabs when master record does not existCompleted

Good idea, but i'd like to have both options, maybe defined by a checkbox or something. Because hiding all details could break screens, if you have the detail, for example to the right of the grid, rather than in a separate tab.

4 years ago

Arjan SollieThinkwise blogger

Maintain project version destinationCompleted

[quote=Erwin Ekkel]I created a similar wish for this. Jasper commented that the files will be stored in the application in future versions. Making this wish redundant in the near future. [url=https://community.thinkwisesoftware.com/ideas-18/otap-for-file-locations-472]https://community.thinkwisesoftware.com/ideas-18/otap-for-file-locations-472[/url][/quote] This depends if it is a requirement, to store all files in the database, or an option.

4 years ago

Jeroen van den BeltAdministrator

Or prefiltersCompleted

I think AND/OR concepts are hard enough for a user, so I'd suggest have them 'fixed' in a predetermined group. Could we combine this with a 'mandatory' property for a prefilter-group? Always have at least one prefilter from within a group active?

9 months ago

RemcoModerator

Disable add/edit/delete buttons when type is viewCompleted

I'm convinced :)

2 years ago

Jeroen van den BeltAdministrator

Or prefiltersCompleted

I think making such a thing safe is not something that can be enforced trough the Software Factory. You could require locked prefilters to be always true and then, on top of that, have one or multiple 'or-prefilters'. It would generate a query like this: [code]select some_values from some_table t1 where locked_prefilter = 'true' and ( first_or_prefilter = 'true' or second_or_prefilter = 'true' ); [/code] But it is the responsibility of the developer to make sure that the 'or-prefilters' will not result in situations that show too much data.

9 months ago

Mark van BenthemSidekick

Have a lookup for display and a lookup for input.Closed

Mark, When creating the situation that Jasper explained, make sure to test the queries (view combined with prefilter) for performance. You'd might even want to add an extra index for this situation. If you do, performance (based on 'pushing the predicate') shouldn't really be a problem.

4 years ago

FreddyThinkwise Local Partner Brasil

Question to sql generation?On the backlog

[quote=Vincent Doppenberg]Leveraging application models and corresponding translation sets in order to process questions and commands in natural language is something we have already looked into over the last two or three years. This concept was actually the basis for an experiment we did with a user interface that used text and voice commands to perform actions (i.e. generate requests to Indicium). I expect that we will invest more research into this in the future.[/quote] What did come out of the experiment, was it successful, and to what degree? Would be really cool to see/know more about this.

4 years ago

RemcoModerator

Disable add/edit/delete buttons when type is viewCompleted

[quote=Vincent Doppenberg]Views that do not have multiple base tables do not require instead of triggers for inserts, updates and deletes. Because of this, the presence of instead of triggers cannot be used as a surefire way to determine if the view should be mutable.[/quote] Why would you have a view with one base table? That's a table variant, in my opinion. Furthermore, you could easily find out if the view has got multiple base tables, either by looking at the definition in the model (automatic views) or looking into the template that holds the select statement for the view. [quote]Disabling inserts when an instead of insert trigger is removed is simply wrong.[/quote] Why? No means of actually inserting means by default, you should not be able to.

2 years ago

FreddyThinkwise Local Partner Brasil

Question to sql generation?On the backlog

Not only for the in-GUI SQL editor. With this question to SQL generation, you could, like Freddy mentions, let the user ask the application questions, in natural language, and the AI would turn that into a query and retreive an answer. I think for ad-hoc questions from users, this would be an amazing tool! Especially combined with the structured way applications are set up using the Software Factory, you could use the SF as a meta-database, so a user does not have to be aware of the names of tables or fields. The AI knows the translations as well and can use those. A question like 'How many projects have we running for the customers in Belgium?' should be an easy question to answer. The possibility for end users, is in my opinion endless and very powerful. I'd strongly encourage that we look into this. [user=144]Marcel Zuur[/user], do you have any ideas about this?

4 years ago

RemcoModerator

Disable add/edit/delete buttons when type is viewCompleted

I think it could derive meaning (on SQL Server) on the fact that there is an instead of (insert/update/delete) trigger in place. No instead of update trigger -> no edit button. When an instead of trigger gets configured for the view, the apropriate button should become available.

2 years ago

Erwin EkkelModerator

After merge to trunk set previous project to the previous version of the trunkCompleted

[quote=Erwin Ekkel]This won't always be correct, but it will be sometimes correct whereas the snapshot seems to be always incorrect.[/quote] Sometimes correct, this seems dangerous as well. Why not ask the user for input?: 'What is the new previous project-version?' and have the default answer be the previous version of the trunk.

2 years ago

Page 3 / 6

Badges

Dave Bieleveld Starcodehas earned the badge Critical Thinker
Theo Neeskenshas earned the badge Critical Thinker
Niels Koophas earned the badge Geek
Alban_Thas earned the badge Deployer
ssitalhas earned the badge Preparator

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login to the Thinkwise Software Community

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

Replies posted by Robert Jan de Nie

INSERT CODE HEREDeclined

The effect of granting rights to an objects on its childsOn the backlog

Reuse icon from database

refresh screen after completing task

Atomic Transaction checkbox set default to trueCompleted

Atomic Transaction checkbox set default to trueCompleted

Override delete and copy with a custom taskMerged

An editable GUI that modifies the settings of the SF and IAMOpen

Select all with CTRL + A in web guiCompleted

Validation on RDBMS reserved keywordsCompleted

if exists Alter procedure on functionality executeCompleted

Show failed task call in debug windowCompleted

Sql SEQUENCE

Display Combo/Radio elements as stars in form (and maybe list)Open

Disable detail tabs when master record does not existCompleted

Maintain project version destinationCompleted

Or prefiltersCompleted

Disable add/edit/delete buttons when type is viewCompleted

Or prefiltersCompleted

Have a lookup for display and a lookup for input.Closed

Question to sql generation?On the backlog

Disable add/edit/delete buttons when type is viewCompleted

Question to sql generation?On the backlog

Disable add/edit/delete buttons when type is viewCompleted

After merge to trunk set previous project to the previous version of the trunkCompleted

Badges

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded