MagicCell - Logical Masking

1997 Dakota - $19,690.00 The new-for-1997 Dodge Dakota adopts the look of the full-size Dodge Ram, an appearance heavily influenced by big rigs. (Big-rig styling has propelled the Ram ...
	1998 Ram 1500 - $21,455.00Of all the success stories Chrysler has experienced in recent years, one of the biggest has been the introduction of the Ram pickup for 1994. While the ...
1997 Ram 2500 - $23,785.00 While the previous Dodge pickup could barely attain one-tenth the sales volume of its rivals, the 1994 introduction of the big rig-influenced Dodge Ram was an ...
	1997 Ram 3500 - $25,120.00When the hot-selling Dodge Ram pickup was introduced in 1994, its big-rig inspired styling set it apart from other full-size pickups. You could say the Ram ...
1997 F-250 - $24,865.00 Even though Ford's F-Series pickup trucks have been America's best-selling new motor vehicles for the last 14 years, the introduction of the restyled '97 F-150 ...

[221 - 225 : 225]

Magic - Logical Masking

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim ZigZag As New Tornado.Z()
  With ZigZag
    .dbQP="U=1| S=moto| D=CAR2000.mdb|M=ty=Grid!header=false| mts=160| Th=Title=MagicCell - Logical Masking"
    .dbSQL = "SELECT Car,Price,Yr,Picture,Comment,'dummy' as Photo,'dummy' as Notes FROM CarSpecs"
    .dbGridHideFlds = "Car, Price, Yr, picture, Comment"

'... This is the ZigZag Workhorse
    Dim mc as string = "(;,[]#|~/+{})Fi=Photo| Macro=(#aspdbindex#|NVL||align=right|"
    mc &= "<A HREF='/tornado/db/images-car/#Picture#'><IMG WIDTH=150 BORDER=0 VSPACE=0 HSPACE=0 "
    mc &= "SRC='/tornado/db/images-car/#Picture#' ALT='Click here to see a larger photo'></A>~"
    mc &= "#aspdbindex#|EVL|||<center><b>#Yr# #car# - #price:c#</b> </center>#Comment#), Fi=Notes| "
    mc &= "Macro=(#aspdbindex#|EVL|||<A HREF='/tornado/db/images-car/#Picture#'>"
    mc &= "<IMG WIDTH=150 BORDER=0 VSPACE=0 HSPACE=0 SRC='/tornado/db/images-car/#Picture#' "
    mc &= "ALT='Click here to see a larger photo'></A>~#aspdbindex#|NVL|||<center><b>#Yr# #car# - "
    mc &= "#price:c#</b></center>#Comment#)"
    .dbGridMagicCell = mc
    .ASPdbNET()
  End With
End Sub
</script>

This illustration is for showcase purpose only -

Another form of masking is logical masking where logical conditions are tested to determine the field's display mask. The illustration of displaying the fields in a zigzag manner is an actual application of a user. This is the most difficult example we have ever come across in our 'example chest' and if you catch the syntax of this one, you have mastered MagicCell!

Essentially the challenge is to display the fields in two columns with column 1 displaying several fields including a Memo Field with text round off at length of 160. Round off means break the memo in the space and not in the middle of a word. The Image name field is displayed in the second column but itself linking to the original image. The twists is to toggle the display in alternate rows. Logical Mask is primary design for displaying data according to 29 pre-programmed logical conditions including text, numeric, logical, regular expression etc.... This enables you to present, hide or mask your data under different conditions.