Public dbConnection as object, accessRights as string\r
Public LastErrorMsg as String\r
Public defaultDB as String = "Northwind"\r
-Public const dbDialect = "TSQL" ' What kind of database are we connecting to?\r
+Public const dbDialect = "Access" ' What kind of database are we connecting to?\r
\r
\r
Public Function OpenDB()\r
<Rico:LiveGridEdit runat='server' id='ex8' TableName='orders' DefaultSort='OrderID' FilterLocation='-1'>\r
<Rico:CalendarControl runat='server' id='Cal' icon='rico-icon rico-calarrow' />\r
<Rico:TreeControl runat='server' id='CustomerTree' icon='rico-icon rico-dotbutton' source='CustTree.aspx' />\r
- <Rico:Panel runat='server' heading='Basic Info' />\r
+ <Rico:ColumnGroup runat='server' heading='Basic Info' />\r
<Rico:Column runat='server' heading='Order#' width='60' ColName='OrderID' EntryType='B' ColData='<auto>' ConfirmDeleteColumn='true' />\r
<Rico:Column runat='server' heading='Customer' width='160' ColName='CustomerID' EntryType='CL' InsertOnly='true' SelectCtl='CustomerTree' SelectSql="select CustomerID,CompanyName from customers order by CompanyName" filterUI='t' />\r
<Rico:Column runat='server' heading='Sales Person' width='140' ColName='EmployeeID' EntryType='SL' filterUI='m' id='EmployeeID' />\r
<Rico:Column runat='server' heading='Required Date' width='100' ColName='RequiredDate' EntryType='D' ColData='Today' SelectCtl='Cal' />\r
<Rico:Column runat='server' heading='Net Sale' width='80' format='DOLLAR' Formula='select sum(UnitPrice*Quantity*(1.0-Discount)) from order_details d where d.OrderID=t.OrderID' />\r
\r
- <Rico:Panel runat='server' heading='Ship To' />\r
+ <Rico:ColumnGroup runat='server' heading='Ship To' />\r
<Rico:Column runat='server' heading='Name' width='150' ColName='ShipName' EntryType='B' />\r
<Rico:Column runat='server' heading='Address' width='150' ColName='ShipAddress' EntryType='B' />\r
<Rico:Column runat='server' heading='City' width='120' ColName='ShipCity' EntryType='B' filterUI='m' />\r