Re: REALbasic and MySQL-database

[Paul Harvey <realbasic at hiddenfield dot com>]

On Monday, July 29, 2002, at 10:50 , Luc Bressinck wrote:

Hello,

I have the plugin MySQL Plugin version 1.0.3.
I want to connect to an mysql-database (in OS X, I have Mysql installed) but
there is no OPEN function for mysql (there is one e.g. For OpenBase:
OpenOpenBaseDatabase).
How do I open the database?

Luc Bressinck

You could try starting with something like this:

// connect to MySql database
dim db as mySQLDatabase
dim dbCursor as DatabaseCursor
dim sqlstring as string

db=new mySQLDatabase
db.Host="address of database server" // localhost for own computer
db.DatabaseName="database name"
db.UserName="user name"
db.Password="password"

if db.Connect then
sqlstring="select * from myTable"
dbCursor=db.SQLSelect(sqlstring)
dbCursor.MoveFirst
while not dbCursor.EOF
msgBox dbCursor.Field("fieldname").stringValue
dbCursor.MoveNext
wend
end