I'm creating a cursoradapter class using Native data to
get ready for a move to SQL Server. I'v created a function
to return a data set that accepts the alias I want to use
and the SQL command to pull the data:
FUNCTION GetHistoryData(sAlias, sSqlCmd)
SELECT 0
USE History
oAdapter = CREATEOBJECT("CursorAdapter")
WITH oAdapter
.Alias = sAlias
.DataSourceType = "Native"
.DataSource = ""
.SelectCmd = sSqlCmd
.KeyFieldList = "Id"
.Tables = "History"
.UpdatableFieldList = "Id, DoneDate"
.UpdateNameList = "DoneDate History.DoneDate"
ENDWITH
USE IN History
RETURN
The question is this; Unless I pass other parameters, how can I set
other options, such as UpdatableFieldList or KeyFieldList, each time I call
this? It seems that this code locks me into a set number of fields, and is
not very flexable.
Anyone?
Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people