U++ forum: Welcome to the forum

Use ctrls in another tab as detail problem [message #38593]

Wed, 26 December 2012 16:40

lectus
Messages: 329
Registered: September 2006
Location: Brazil

Senior Member

Is it possible to perform a JOIN with SqlArray on a SqlArray that's located in another tab?

I'm put a master SqlArray in one tab.

I'm trying to use 2 docedits to edit the data in the detail table.

But the docedits appear grayed.

Any ideas?

tab1.arrmaster.SetTable(MASTER);
tab1.arrmaster.AddKey(ID);
tab1.arrmaster.AddColumn(NAME, "Name").Edit(name);
tab1.arrmaster.AddColumn(BIRTHDAY, "Birthday").Edit(birth);
tab1.arrmaster.SetOrderBy(NAME);

tab2.arrdetail.SetTable(DETAIL);
tab2.arrdetail.AddKey(ID);
tab2.arrdetail.Join(MASTER_ID, tab1.arrmaster);
tab2.arrdetail.AddCtrl(DATA1, tab2.data1);
tab2.arrdetail.AddCtrl(DATA2, tab2.data2);

[Updated on: Wed, 26 December 2012 17:05]

Report message to a moderator