First Loop - bugger, not working....

[4xjbh]

I am attempting to add members to a group contact list, selected from a list, (check box is a calc "is selected")

I cannot get it to work. How do I get the contact_id of the current index? (???) How do I get this to only add the the contact ID for the checked record rather than all of the records in the foundset.

Code: Select all

for ( var i = 1 ; i <= forms.contact_dlg_lst.controller.getMaxRecordIndex() ; i++ )
{
   if (forms.contact_dlg_lst.isSelected = 1)
   {
      forms.group_layout_main.contact_group_to_contact_group_member.newRecord( )
      
      forms.group_layout_main.contact_group_to_contact_group_member.contact_id = ???   
   }

Thanks in advance.

[ROCLASI]

Hi James,
You can fetch a record object from the foundset using foundset.getRecord(index).
Also I would use the getFoundSetCount() function to get the real amount of found records because the controller might nog have loaded all the records (does this in batches of 200 records).
So your code would look like this:

Code: Select all

var rc; // record object
var fsCount = databaseManager.getFoundSetCount(forms.contact_dlg_lst.foundset); // will get the count of all found records, not just the loaded ones.
for ( var i = 1 ; i <= fsCount ; i++ ) {
    rc = forms.contact_dlg_lst.foundset.getRecord(i);
    if (rc.isSelected = 1) {
        forms.group_layout_main.contact_group_to_contact_group_member.newRecord( )   
        forms.group_layout_main.contact_group_to_contact_group_member.contact_id = rc.theIdColumn;
    }
}

Hope this helps.

[4xjbh]

This is adding all of the contacts in the foundset rather than the the selected ones.

I have confirmed "isSelected" is listed in the contact_dlg_lst dataproviders.

Code: Select all

   var rc; // record object
   var fsCount = databaseManager.getFoundSetCount(forms.contact_dlg_lst.foundset); // will get the count of all found records, not just the loaded ones.
   
   for ( var i = 1 ; i <= fsCount ; i++ ) {
    rc = forms.contact_dlg_lst.foundset.getRecord(i);
    if (rc.isSelected = 1) {
        forms.group_layout_main.contact_group_to_contact_group_member.newRecord( )   
        forms.group_layout_main.contact_group_to_contact_group_member.contact_id = rc.contact_id;
    }
}

[ptalbot]

Try

Code: Select all

if (rc.isSelected == 1) {

Otherwise you set the isSelected flag to 1.

[ROCLASI]

Heh, seems I've missed that.

[ptalbot]

Heh, seems I've missed that.

We all do, from time to time!
I think that Servoy in strict mode now checks for that and emit a warning.

[ROCLASI]

Heh, seems I've missed that.

We all do, from time to time!
I think that Servoy in strict mode now checks for that and emit a warning.

Yeah I have strict mode enabled and I like it.

[ptalbot]

Heh, seems I've missed that.

We all do, from time to time!
I think that Servoy in strict mode now checks for that and emit a warning.

Yeah I have strict mode enabled and I like it.

They should also activate it on the forum, it would save us some embarassment sometimes...

[4xjbh]

Thanks for the help