[Obonye]

Reason of using timer, I’m using the timer in the loading overlay timer in a long process like sending many customer statements as email attachment.

[Obonye]

I have created 2 instance variables for the timer and the smtp worker and assigned the superclass for each object. I have created the method $complete in the remote form. How will each of the object call it’s $complete method which performs different function?

[Obonye]

Thank you for the extra push in this. The drawback with setting up the unique column in the database is that it would mean the duplicate is returned 1 by 1. If there are many duplicates and/or missing values, (especially import of many records), the user will solve one duplicate then clicks save button hoping the duplicate is gone, then another check error is returned for the next duplicate. Some will find this an unfriendly user experience.

[Obonye]

Hi Andreas,

Thanks for the quick response. ‘City’ can be duplicate therefore shouldn’t be checked. There are unique fields/columns that a user will want not to duplicate like national ID, bank account, email address, mobile number, social security number ETC. Before he/she clicks save button, an alert is returned showing duplicate or missing values. This minimizes data entry errors that updates untidy/unnormalized data.

Martin.

[Obonye]

Hi Andreas,

I can’t seem to find the preformatted tag in the method editor. Using $OS 10.22. Where is it located? Could you confirm if a $sendallref command accepts multiple conditions for the $filter and would it also apply in the $filter command? Would make it simpler to just share the complete line for the $sendall to minimize the back and forth. Kindly.

Martin.

[Obonye]

What I’m trying to do is find duplicate entries in iDataList with multiple columns say, lEmployeeNum,lEmployeeFullName,lEmailAddress. If any of the values in the any of the columns is duplicated or missing, then alert the user.

[Obonye]

Hi Andreas,

I prefer a one-liner to an IF statement. I had this $sendallref function

Do <b style=”background-color: var(–bb-content-background-color); font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”>pDataList.$sendall($ref.$selected.$assign(kTrue),$ref.[<b style=”background-color: var(–bb-content-background-color); font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”>pColName]=<b style=”background-color: var(–bb-content-background-color); font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”>pDataList.[$ref.$line+1].[<b style=”background-color: var(–bb-content-background-color); font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”>pColName]&$ref.[<b style=”background-color: var(–bb-content-background-color); font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”>pColName]<>”)

in an object class but I’m not sure how it would work in a table class instance. I’d appreciate a one-liner with the $filter.

Martin.

[Obonye]

Hi Andrea’s,

Passing the first column selects the duplicates okay. Passing the next column seems to fail. Do I need to return the duplicate list for each column passed?

Martin.

[Obonye]

AHA! Great insight right there. Does this mean I could replace the iDataListObjRef.$duplicate with the table class when manipulating iDataList in the UI? This could be a huge redesign of my code paradigm.

[Obonye]

Hi Andreas,

You said I create a method in the superclass table. Does this mean entries in iDataList are already saved in the database before $dowork command, as to check for duplicates? The reason I have the subform is to display a datagrid for duplicate/missing entries. A iDuplicateList can display more than one issue with the iDataList.

Martin.

[Obonye]

After implementing the quotes, now I get a javascript error message as shown below:

Calculate lCalcSeparators as $root.$prefs.$separators()

Calculate lSeparators as mid(lCalcSeparators,3,1) ## function parameter separator

Calculate lParam as con(kSq,’jsMyRemoteForm’,kSq)

Do $cinst.$clientcommand(“subformdialogshow”,row(‘jsDialogSelectFieldSearchResult’,lParam,stgettext(‘search_result’),$cwind.$width*0.7,$cwind.$height*0.7))

• This reply was modified 8 months, 1 week ago by  Obonye Mato.

subformdialogshow-param-error.png 9 KB Image File - Click to view

Options

• Copy Download Link

[Obonye]

Hi Andreas,

Sure. It helps.

Just curious to know what is the advantage of calling the container methods from the subform over passing a parameter from the main form on to the subform? And/or vice versa.

Regards,

Martin.

[Obonye]

Thank you @ for the explanation. You taught me this client-side method call in one of classes. Q: Why is it that I cannot run methods in an object reference on the client? The SMTP worker send sample library has an object and I wish to run the methods on the client to use together with the jsProgress sample library. Is this a way around this? – Martin.

[Obonye]

Also, what do the methods $updateProgressBar and $updateProgressBar_return in jsProgressDialog do? I do notice that the suffix “return”. I have no idea why you name them that way and running on the client.

[Obonye]

Hi, Uwe. How is the progress bar object able to show the progress without the property $events set to evCarryOn ? Martin.