Well I have a configuration tool designed for generating data for our
sales screen. I was told that our DBA will not allow a single table for
lookups. Instead I now need 5 tables to hold identical data.
Key, Description, status, ChangeDate, LastUser
All I did was add another column for generalized key.
Key, GKey, Description, status, ChangeDate, LastUser
Unfortunately I need to change all my syntax to adapt to the frigin table
and column names.
I got the configuration form done in 3 days with lots of side requests. I
guess that I can redo it in about the same time. :)
so code like this :
Public Shared Function ShowNode(ByVal gkey As Integer, ByVal dt As
DataTable) As DataTable
Dim ds As DataSet = New DataSet
Dim sql As String = "Select * from itapps.bizLists where bl_gkey =
" & gkey & " and bl_status = 0 order by 3 "
ds = DataPortal.FillDataSet(sql, ds, "MasterList", "LOL")
dt = ds.Tables(0)
ShowNode = dt
ds.Dispose()
dt.Dispose()
End Function
It will probably have to get refactored to :
Public Shared Function ShowNode( ByVal dt As DataTable, byVal tbl as
string, byVal colPre as string, byVal TName as string ) As DataTable
Dim ds As DataSet = New DataSet
Dim sql As String = "Select * from itapps." & tbl& " where "
&ColPre & "_status = 0 order by 2 "
ds = DataPortal.FillDataSet(sql, ds, "MasterList", "LOL")
dt = ds.Tables(0)
ShowNode = dt
ds.Dispose()
dt.Dispose()
End Function
I have update, insert, and removal code that all needs to get this
stupidity because the term NORMALIZED is a farce here.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
