Preventing InLine Query allowing New Records

[customaware]

I have a situation where I want to show a range of records in an Query that has Inline Editing enabled.
I want the user to be able to inline edit those records but I do not want to allow a new record to be created as they tab right at the end of the last record.

Any suggestions please?

[customaware]

I guess a Rule on the BO will work....

MyBO IS NEW AND MyBO.date IS UNDEFINED

REPORT ERROR 'Whoops! You Cannot Add a Record Here."

Dynamic.

[customaware]

Hmmmm.... That doesn't work. :-/

[customaware]

Retract that...

It sort of works.

Allows the user to traverse the new row and in fact does not pop up an error until the user tries to create a second row (but different error... Not the REPORT ERROR error)

BUT.... the records are not saved.

Would be nice to be able to disable the creation of a new row completely

[Jaymer]

Ctrl-c then tab to the option “allow create” and set to No
Voila! It’s magic

[bondicoffee]

Ctrl-c then tab to the option “allow create” and set to No
Voila! It’s magic

Could you please brief little bit, I am unable to find option "Allow Create"

[customaware]

Hi BondiCoffee (you must live in Sydney, yes?)

Jaymer's comment was a personal joke that he know I would get. It is not related to Aware.

[johntalbott]

Try this in the query init script ...

Code: Select all

config.edit = function(e){

     if(e.model.isNew()) {
          var grid = e.sender
          grid.cancelChanges()
     } 		
}

[Jaymer]

From Support:

In render script of a query:
parser.m_doNotAddNewOnTab = true;

added in bld 2464
https://www.awareim.com/forum/viewtopic.php?f=1&t=10421

keyword: create allow prevent disable

--> JaymerTip