open new form in a separate application

[MadsCastle7]

I am using your FormView example to view a dictionary that i've created in a separate application.

Do you have a method to open a from for a particular row in edit mode, or open a new form dynamically from a separate application?

[MadsCastle7]

I have worked out how to open a new blank form in a separate application. Do you have a method of returning the id of the row that has been inserted upon save?

[LucioPelinson]

Hello, @MadsCastle7
Where and how do u like to return the generated Id?
Would you have an example of what you are trying to do?

[MadsCastle7]

I would like the Id to be generated after an InsertAsync. By way of example, I may wish to complete a form about the details of a hospital bed. Once i have completed those details, I then need the returned Id in order that i can link the hospital bed to a patient. The patient information may have been taken from somewhere like an API and would not be anythnig to do with Dynamic Forms.

See attached

[MadsCastle7]

i note that EntityProviderBase.cs goes someway to achieving this, but the Id is not returned.

[MadsCastle7]

Hi Lucio, i've just noted that the Dictionary item is passed by reference and therefore we can access the new identity seed that has been added from there. I suppose it wouls be nice if the method returned the id though

[LucioPelinson]

@MadsCastle7, you can get the Id by reference.
After the insert command the id will be in the values hash.

Ex.:

// after insert command
var myId = values["id"];

If you are using procedures, check if after the insert command at procedure it's returning the id variable.

Example:

...
IF @TYPEACTION = 'I' 
	BEGIN 
		INSERT INTO [TB_TEST] (
			[name],
			[age])
		VALUES (
			@name,
			@age)
		SET @RET = 0; 
                 OUTPUT Inserted.id --THIS LINE IS IMPORTANT
	END 
...

[LucioPelinson]

Hi Lucio, i've just noted that the Dictionary item is passed by reference and therefore we can access the new identity seed that has been added from there. I suppose it wouls be nice if the method returned the id though

Yes, we have been thinking about this for a long time, but this will generate a big breaking change.

[MadsCastle7]

thanks for the replies, in addition can you please tell me if its possible to create additional custom field component, for example, i notice there is no Check Box List Component

[MadsCastle7]

The logging code uses inline SQL, are there any plans for this to be replaced with Stored Procedures?

[LucioPelinson]

The logging code uses inline SQL, are there any plans for this to be replaced with Stored Procedures?

Yes, it is in development at 4.3 version

[LucioPelinson]

thanks for the replies, in addition can you please tell me if its possible to create additional custom field component, for example, i notice there is no Check Box List Component

No yet... any interfaces is missing

But you can use a ComboBox Component and enable mult select option

or

Use a Relation
https://md.jjconsulting.tech/articles/tutorials/relationship.html

[MadsCastle7]

The logging code uses inline SQL, are there any plans for this to be replaced with Stored Procedures?

Yes, it is in development at 4.3 version

Morning Lucio, do you have timescales for version 4.3?

[LucioPelinson]

The logging code uses inline SQL, are there any plans for this to be replaced with Stored Procedures?

Yes, it is in development at 4.3 version

Morning Lucio, do you have timescales for version 4.3?

The release of version 4.3 will be on 2024-08-28.