I have created a new REALSQLDatabase, and I am now trying to add the
first record. I keep getting a nilObjectException error. I recreated
the database via Project>Add>Database>New REALSQLDatabase, so the
database is empty, and has only one table, Owner. But the error still
occurs. Here is a cut and paste of some code
DIM Rcd AS DatabaseRecord
Rcd = New DatabaseRecord
Rcd.Column("T1OwnerID") = SaveOwnerID
Rcd.Column("T1Company") = OwnerCompany.Text
Rcd.Column("T1Region") = OwnerRegion.Text
Rcd.Column("T1Address1") = OwnerAddress1.Text
Rcd.Column("T1Address2") = OwnerAddress2.Text
Rcd.Column("T1City") = OwnerCity.Text
Rcd.Column("T1State") = OwnerState.Text
Rcd.Column("T1Postal") = OwnerPostal.Text
Rcd.Column("T1Phone") = OwnerPhone.Text
Rcd.Column("T1Fax") = OwnerFax.Text
Rcd.Column("T1Contact") = OwnerContact.Text
Rcd.Column("T1Title") = OwnerTitle.Text
Rcd.Column("T1Mobile") = OwnerMobile.Text
Rcd.Column("T1Email") = OwnerEmail.Text
//
===================================================================
// Insert record into table "Owner" of the TCIWest database.
//
===================================================================
App.TCIWestDB.InsertRecord "Owner", Rcd //
NilObjectException occurs here
I have checked column names for any misspellings. The fields I am
loading do have data in them. The database is defined as a Property
in App as
TCIWestDB as REALSQLDatabase
Any ideas on why I am getting this error would be greatly appreciated.
Tom
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>