Re: REALSQLDatabase name?

[briman31]

Eric,
if you are creating the DB via code there is no reason to drag it into the 
IDE

 // Create Database Object
mydb = New REALSQLDatabase

 // Set Database File
 mydb.DatabaseFile = GetFolderItem("mydb.rbd")

 // Database File Does Not Exist, So Create the Database
 if GetFolderItem("mydb.rbd").Exists = false then

   // Create the Database
   if mydb.CreateDatabaseFile = false then

     // Error While Creating the Database
     MsgBox "Database Error" + EndOfLine + EndOfLine + "There was an error 
when creating the database."
     Quit
   end if

   // Add Tables to the Database
   ect ect
 // Connect To Database
 if mydb.Connect = false then
   MsgBox "Database Error" + EndOfLine + EndOfLine + "There was an error 
when creating the database."
   Quit
 end if


-Briman


How do you name a REALSQLDatabase via code such that the name will
"stick"?

I've tried this:

  db.DatabaseName = "SomeDatabase"
 db.DatabaseFile = GetFolderItem("SomeDataFile")
    If Not db.CreateDatabaseFile then
      //handle error
    end if

And this:

   db.DatabaseFile = GetFolderItem("SomeDataFile")
    If Not db.CreateDatabaseFile then
      //handle error
  else
     db.DatabaseName = "SomeDatabase"
  end if

Neither one seems to work. When I drag the newly created database
into the IDE, it has the name of "Untitled". Am I missing something
obvious?

Thanks
Erick
Mac OS X 10.4 PPC and RB2k7
. 

Comodo AntiVirus http://www.comodo.com : Outbound message clean.
Scan Date: Fri, 19 Jan 2007 7:13:19 PM
Virus Definition Update: Fri, 19 Jan 2007
Copyright © 2006 COMODO ®. All rights reserved.
_______________________________________________
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>