What wrong here? I'm getting "Invalid object name 'authors'
PUBLIC oCursorAdapter AS CursorAdapter
oCursorAdapter = CREATEOBJECT("CursorAdapter")
cConnStr = "Driver=SQL Server;Server=MCMPC149;Databaser=Pubs"
WITH oCursorAdapter
.Alias = "MyAuthors"
.DataSourceType = "ODBC"
.DataSource = SQLSTRINGCONNECT(cConnStr)
.SelectCmd = "select * from authors"
.KeyFieldList = "Au_Id"
.Tables = "authors"
.UpdatableFieldList = "Au_Id, Au_LName, Au_FName"
.UpdateNameList = "Au_Id Authors.Au_Id Au_LName Authors.Au_LName, Au_FName Authors.Au_FName"
IF .CursorFill()
SELECT CustCursor
ELSE
AERROR(aerrorinfo)
WAIT WINDOW aerrorinfo[2]
ENDIF
ENDWITH
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
