Thank you for the help. Now on to the next hurdle.
TJH
On Jan 6, 2006, at 6:00 AM, DanteMustDie wrote:
there's a lot of stuff you have to do before inserting a record in a
database
1. create a new instance
2. set the database file
3. create the table you will be using if it doesn't exist
4. then insert the record
moral of the story: read the language reference
On 1/5/06, TJ Hanson <[EMAIL PROTECTED]> wrote:
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>
_______________________________________________
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>
_______________________________________________
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>
