Build Common Tables into Session using user list or SQL list. This function is intended for web page building.

Version: All

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string ASPdbInitCommonTables()
Visual Basic (Declaration)
Public Function ASPdbInitCommonTables As String

Remarks

Remember that default session varibale name for the commontables is ASPDB_name where name is the index name 'catlist' in the above example.

Examples

CopyVB.NET
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
x.dbQP = "U=1| Dt=Access| D=CA"
x.dbCommonTables = "ind=catlist|SQL=Select CatName from cat"
x.ASPdbInitCommonTables()
Response.Write(Session("ASPDB_catlist")(0).ToString())  '... check the first item
End Sub
</script>

See Also