BlogSphere - Feature Request: limit the number of displays of dbcolumn blocks
Please add the function to limit the number of displays of dbcolumn blocks to evade 64k error of @dbcolumn.
1.The DBLook_Num field that sets Number of lines to the BLOCKDEFDB form is added.
2.'"~" @Text(DBLook_Num)' is added to the sixth row of the BLOCKS_LEFT view :
BlockPosition "~" BlockType "~" BlockTitle "~" BlockHTML "~" DBLook_Cache "~" DBLook_Server "~" DBLook_Database "~" DBLook_View "~" @Text(DBLook_Column) "~" DBLook_Key "~" @Text(DBLook_Num)
3. Change @Formula of "dbcolumn" on computed field building the left blocks of the D6.SideBlocks subform.
@LowerCase(type) = "dbcolumn";
@Do(x1 := @DbColumn("Notes" : @Word(LeftBlockInfo[x]; "~"; 5); @Word(LeftBlockInfo[x]; "~"; 6):@Word(LeftBlockInfo[x]; "~"; 7);@Word(LeftBlockInfo[x]; "~"; 8);@TextToNumber(@Word(LeftBlockInfo[x]; "~"; 9)));
x2 := @TextToNumber(@Word(LeftBlockInfo[x]; "~"; 11));
x3 := @Subset(x1;@If(x2=0;20;x2));
@If(x3 = "";"Lookup Failed";x3)
);
4.The same logic as computed field building the right blocks of the D6.SideBlocks subform and the BLOCKS_RIGHT view is built in.
Taken Actions by OwnersDocuments