How to Set the null default value in a lookup in a String edit control.

(0) Share

Report

Posted on by Ram Kumar

454

Hi,

I want to set the Lookup that should be a null value in default in a Stringedit Control . I need some Assistance for this. Should we set this property by Code or Manually ? .

Thanks in Advance,

Ram.

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

You talk about two different things.

A lookup is a form; it doesn't have any value.

A string edit control does have a value and you surely can set it to an empty string (null isn't a valid string value in X++).

Anyway, I think you should explain what you're trying to achieve from user's point of view; then we'll be able to decide what needs to be done technically.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

HI Ram,

Do you want to make the Lookup String control appear blank?

How do you set up your form? Is the data source set? If so, clear it first. Then override the lookup () of the string control.

As result: (You do not choose, it is blank)

Was this reply helpful? Yes No
Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

No, overriding lookup() won't change the value. This method controls how the lookup form is built, when you try to expand the list of possible values.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report
Hi Martin,

Thanks for your correction.

I agree with what you said, it doesn't change the value.

Is it possible that the data is empty because I cleared the data field of the String control and I override lookup () ,so the value is only displayed in the drop-down list?

-

My code:

public void lookup() { SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(PhoneTable), this); Query query = new Query(); QueryBuildDataSource queryBuildDataSource; ; sysTableLookup.addLookupfield(fieldnum(PhoneTable, NewFieldString2)); queryBuildDataSource = query.addDataSource(tablenum(PhoneTable)); queryBuildDataSource.addSortField(fieldnum(PhoneTable, NewFieldString2)); //queryBuildDataSource.addRange(fieldNum(PhoneTable, NewFieldString2)).value(queryNotValue('')); queryBuildDataSource.orderMode(ordermode::GroupBy); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); super(); }

Was this reply helpful? Yes No
Martin Dráb 237,884 Most Valuable Professional on at

Like (1)

Report

Yes, clearing the value (setting it to an empty string) of the StringEdit controls is what changes the value displayed in the control. Lookup() method doesn't get execute at all unless you tried to expand the list of values, because what the method does it building the lookup form.

You can easily test by adding a breakpoint to lookup() and attaching the debugger. You'll see at which moment the method executes.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Thank you very much .

Was this reply helpful? Yes No