Hi Roy.
>lo = NEWOBJECT("testcursoradapter")
>
>lo.DataSource = "Driver=SQL Server;Server=DEVTEST;DATABASE=TESTDB"
>
>lnConnect = SQLSTRINGCONNECT(lo.DataSource)
>
>lo.SelectCmd = "SELECT nPA_id,tFollowup_Dt FROM PA_TEST"
>
>lo.CursorSchema = "col1 n, col2 D"
>
>lo.CursorFill()
DataSource should be set to an open connection handle *and* DataSourceType should be set to "ODBC". So, change your code to:
lo = NEWOBJECT("testcursoradapter")
lo.DataSourceType = "ODBC"
lo.DataSource = SQLSTRINGCONNECT("Driver=SQL Server;Server=DEVTEST;DATABASE=TESTDB")
lo.SelectCmd = "SELECT nPA_id,tFollowup_Dt FROM PA_TEST"
lo.CursorSchema = "col1 n, col2 D"
lo.CursorFill()
Also, this won't be updatable unless you fill in the KeyFieldList, UpdateNameList, UpdatableFields, and Tables properties.
Doug