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