• Anonymous
  • Login
  • Register
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 Owners



Documents
In this field you can enter the actual request.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.
In this field owners can describe what they have done or want to do.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.