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

Jaymer wrote
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 ...

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
Build 2464 is out...with improvements!>

keyword: create allow prevent disable

--> JaymerTip