> hi,
> I think you use the basic command open that expects a string
> for a document.
> You must declare the dll calls you want to use first ie :
> declare aliasname as SetFocus of dllname
> var as integer
> var2 as string*25
> end declare
>
> then set the vars
> aliasname.var=9786786789
> aliasname.var2="kjghkjjhkjhjk"
> aliasname''the actual call
Thanks for your response but I'm talking about the MySQL demo that comes
with the FnxBasic.
As soon as I try to run it using the login info for my MySQL server, a red
line at the top of the page says:
"error:45 line:14 openopen is not a valid operator"
''example of the use of mysql
''instal mysql anonymious, without a password and user.
''for encription is needed more than this example.
''mysql is an freeware database server
uses mysql
object myform as form
object grid as stringgrid
align=alClient
separator=chr$(8)
end object
end object
dim db as mysql
db.separator=grid.separator
db.address="127.0.0.1" <<--- ERROR POINTS HERE !!! (also tried localhost)
db.port=3306
db.user="root"
db.password="xxxxxxx"
showmessage db.query("connect")
db.query("create database if not exists mydbase")
db.query("use mydbase")
db.query("create table if not exists mytable(name CHAR(10),zipcode
char(10),address char(20))")
db.query("INSERT INTO mytable (name,zipcode,address)
VALUES('john','1234','bublestreet')")
db.query("INSERT INTO mytable (name,zipcode,address)
VALUES('mike','5678','teststreet')")
grid.Text=db.query("Select * from mydbase.mytable")''*=everything
myform.showmodal