Questions & Conversations

I'm having difficulties unit testing certain concepts like a context. Let's say I'm having the following use case; The purchase_order (PO) contains purchase_order_line's (POL). When the PO has the status ‘done’, the user or api cannot insert or update PO lines for that PO. I've disabled this using a trigger, i.e. if exists ( select 1 from inserted i -- purchase_order_line join purchase_order po on po.purchase_order_id = i.purchase_order_id where po.status = 'done') begin -- abort etc, cancel insert/update for purchase_order_line.end I have attached a layout and a context concepts for both the PO and POL's. I want to unit test the behaviour for in example the context or layout of a purchase_order_line, that certain tasks / buttons are disabled. This can be done via unit test or via process test

Windows Defender doesn’t see Thinkwise Software B.V. (TSF_dotNET.exe) as a trusted app. I don’t know which conditions you need to comply but it would be great if this application is recognized as trusted and the message doesn’t have to shown. It can be confusing for the users.  Windows Defender Smartscreen message Click on the link “More information” to get the following two buttons Choosing “Do not execute” the following error appears  Once accepted by choosing “Execute” the message will not com

I'm trying to use the Indicium OData API via a .NET Core 3.0 console application. I receive an exception on inserting records, while the record is inserted in the database. I have no clue why. I'm not sure if this is an issue in the Indicium OData API or the .NET nuget package. For example I want to add a ‘server’ to the IAM database. By using a generated piece of code (see https://docs.microsoft.com/nl-nl/odata/client/basic-crud-operations) this is quite easy to set up; Add the indicium OData API via “Unchase OData Connected Service”

Can the email notification messages send by the Community Portal be made more focused to the topic? This to make them more valuable to read. The same picture with a man watching his tablet PC, doesn't make sense and is just pollution of my inbox. The title of the topic should be part of the email subject, something like: 'New Idea: Apex Refactor and Software Factory' or 'New comment on topic: Home button in Mobile GUI' The description, part of the description or comment in the body, would be great.

/-This is more of a SQL question-/For the project I work on I'm in charge of realizing functionality to import large amounts of Product data (ASCII format / .txt file data). The database I work with is placed in a environment where multiple companies work on the same database. In the application, they only see their own data. For example, if 30 companies use the database and all have a pool of 1 million Products, then the 'Product’ table will have 30 million records in total but will only see their own 1 million products.The data that I will import consists possibly over a million records and will be inserted into the single ‘Product’ table. What I'm worried about is that inserting 1 million products in one go will take a very long time, so I want to look at possible ways to accelerate this process and making sure that importing big files does not take hours.I have read about removing indexes, parallel processes and such to speed up the

We are trying to design a new screen for data input with a grid similar to a spreadsheet. Let me try to picture our situation. Our products are garments in all kinds of sizes which could be XXS to XXL, 44 to 64, etc. Several size systems are at play here and every kind of garment has its own system as well as size range. Our design team needs an easy input screen with spreadsheet like layout. Per type of garment and per size there are several measurements to be made. Think of something like this for trousers: 44 46 48 50 52 54 56 58 60 62 64Waist . . . . . . . . . . .Inseam . . . . . . . . . . .Length . . . . . . . . . . .Pocket . . . . . . . . . . .The left column contains the measurement types. The top row contains the sizes. Every dot is a measurement that needs to be

I'm trying to deploy an application to Azure using App Services and a Azure SQL database. We want users to log in with their e-mail address, such as user@company.com and john@doe.com both on the same application / database. The user id in IAM is an e-mail address and the users in the SQL database are also. Only when trying to log in, the login with the e-mail address user@company.com fails: Cannot open server “company.com” requested by the login. The login failed. When I add the database server address to the e-mail address (user@company.com@my-database.database.windows.net), then the login succeeds. How can I fix this t

We created a report in which we want to retrieve some images we uploaded in the application. The images are saved in the application folder where the service account has full rights. We can approach the image in the windows and web GUI by pressing the download button. However, when we create the report the previewer in the Web-GUI seems not to retrieve the image properly. Does the dev-express reporting previewer expect access in a different way in the web-gui? I expect this to be the same for web and windows.  webwindows 

 where can i change the field width from the filter

I created a column in a table with the xml data type. However during execution of the source code of the update trigger of that table, I get the following error caused by this field.Therefore I would like to exclude this field from the update trigger, but I cannot find a way to do this. I already set the “Trigger for update” attribute of the column to false in the subject, but that doesn’t do the trick.The following highlighted code fragment in the update trigger is the problem I guess.Is there a way to exclude this field from the automatically gener

We want to use the API alias but when we fill the alias (field API alias) however the name does not change in the OData layer (Indicium)

Is this correct behavior by the (latest) GUI? It seems to me this is not the way it should work. A password shouldn't be revealed like this.Visible password values 

For certain contexts where we show a difference between values it makes sense to display positive numbers with a plus sign. For example a difference of 5 displayed as “+5” in a list or a cube. I looked for a domain control to see if the gui offers such an option but I couldn’t find it. Is there a straightforward method or do I have to convert numbers to varchar to accomplish this?

We have a request from Customer Aartsen if we can provide (besides custom background and logo) opportunity to have custom colored (Aartsen red) progress bar on Windows GUI splash screen starting the application.  

When I was studying the present situation in our system, I came across attached database design. I would never have designed it this way myself, but since I'm relatively new to database design and eager to learn, I wonder what the advantages and disadvantages are of laying out the references and private keys in this way.A 'calculatie' consists of one of more 'calculatie_onderdeel' which consists of one or more 'calculatie_onderdeel_blok' which consists of one or more 'calculatie_onderdeel_blok_vak'.When I would have been the one to design this, I would have used one private key per table. E.g. calculatie_id for the first, calculatie_onderdeel_id for the second and so on. Then I would have created PK / FK references on these id fields.Please see attached picture of the design I'm referring to. Any thoughts on th

As a follow up on this topic, I'm trying to replace the application icon in the web gui. According to the documentation, the value for ApplicationLoginLogo must be an absolute (UNC) path. But when you're hosting on Azure, or an IIS without network access, you cannot specify a absolute path. In the settings.ini file i've tried to use .\MyLogo.png, MyLogo.png, .\App_LocalResources\MyLogo.png, App_LocalResources\MyLogo.png (placed MyLogo.png both in the root and App_LocalResources for all cases, just to be sure). But none of those work. According to the documentation, a full path is required, but isn't there a way to fix this usi

I would like to be able to assign a task to a taskbar like we assign details to a detailgroup. I want to be able to show other tasks in the taskbar above the grid than the tasks on the form.  In case we use 2 taskbars in the same screentype you get all the tasks in both bars (see Any ideas/tricks to running tasks from different parts of the same screen?) .It would be easier to assign the tasks to the ‘taskgroup’ of the taskbar. Maybe It could also be used to omit tasks in the taskbar (see Configure task, report and prefilter bars). The same could apply for reports.

I have a Long list of test question evaluations.  Because rther e is no indication of the Learning Pan or Course, onbly the Question is repeated, it is very hard to look up a specific evaluation.

The notifications of evaluated questions would greatly benefit from adding the Learning plan and Course the evaluation is for.  Currently only the question is displayed.  If you want to retake the test, searching for this by opening all the courses is way too much effort.

Currently is a question is ndoes not receive full marks no reason is given.  Since the student already proved incapable of providing the correct answer, this leaves the student in a non-learning position. Clarification: I do not suggest you should proviode the answer.  I do request to provide the reason of the rejection of the anser, a bit more descriptive as ‘incorrect’.

I have done heaps of tests in the Learn platform.  The evaluations sometimes do not award the full points.  how do i get more information about the result?Now I cannot continue since I do not know what I should answer to get full points.

I have created a table where there are different types of stands and they have different color code. I have a cloumn where you create a stand type and specify the color to that stand. I do know how to use conditional formating but conditional formating is for static data and only developer can assign the color. I want the end user to enter the stand type and the color code which will be assigned to the stands in master tab and detailed tabs or views where ever the stands will be displayed.

We run into problems with our rapport_queue. Problem is that we have more than 1 process adding rows into the table. Sometimes there is a conflict. We think a unique id could help, so a key with seed. Is that possible, why is that not done?

I think it would be really nice if a learner viewing the notification or an evaluated question would have some way  like a button to contact the evaluator about the result.  

I think it would be really nice if a learner viewing the notification or an evaluated question would have some way  like a button to contact the evaluator about the result.