Kim,
Awesome. Thanks alot. In the mean time, I read further to finally realize
that REALSQLDatabase is a subclass of database.
Also, that databaseFile returns a folderitem.
Thanks for the help.
On 10/1/05, Kim Kohen <kim at webguide dot com dot au> wrote:
>
> On 01/10/2005, at 9:25 AM, Kirt Cathey wrote:
>
> > How to create a REAL SQL Database? Is this a BUG? Is ANYBODY using
> > REAL SQL
> > Database successfully?
> > dim db as REALSQLDatabase
> > db=WorkPapersDB //The compiler stops here with the type mismatch
> > error.
> ••••
> I'll preface this by saying I've never used a Real DB - only Postgres
> or MySQL. I did a quick test by copying the example from the language
> reference and this seemed to work.
>
> Dim dbFile as FolderItem
> Dim db as REALSQLdatabase
> db= New REALSQLdatabase
> dbFile = GetFolderItem("WorkPapersDB.rsd")
> db.DatabaseFile=dbFile
> If db.Connect() then
> MsgBox "Connected"
> // do stuff here - inserts, selects etc
> else
> Beep
> MsgBox "The database couldn't be opened."
> end if
>
> cheers
>
> kim
>
> _______________________________________________
> 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>
>
--
Kirt Cathey
WorkPapers Development
_______________________________________________
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>
|