SQL Northwind employees DB Notes field is a nText16 field. USet he followingto display them in a magic cell. Bote that dbMemoField is for backwwards comp. only and allows only 1 memofield. Use the template approach if memo fields > 1.
Dim T As New tornado.z
T.dbQP = "U=1|S=1|dt=SQL|Q=employees|gdf=0,1,2,3,Notes|ni=b 5|mf=f=Notes|mts=-1"
T.dbDSN = "i22;northwind;sa;sa" 'ServerName; DBName; UID; Password
T.dbMagicCell = "fi=Notes| Mac=<b>#Notes#</b>"
T.ASPdbNET()
Frank
