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>
