Search the web
Sign In
New User? Sign Up
fnxbasic
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
New user questions   Message List  
Reply | Forward Message #15 of 43 |
RE: [fnxbasic] Re: New user questions

> 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




Mon Dec 1, 2008 7:29 pm

johnspikowski
Offline Offline
Send Email Send Email

Forward
Message #15 of 43 |
Expand Messages Author Sort by Date

List, I started working with FnxBasic the other day and find it refreshing and well thought out. This is a big change from working with HotBasic. Q. I get a...
John Spikowski
johnspikowski
Offline Send Email
Nov 30, 2008
9:08 pm

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...
byteshaper
Offline Send Email
Dec 1, 2008
5:17 pm

... 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...
John Spikowski
johnspikowski
Offline Send Email
Dec 1, 2008
7:25 pm

I think the problem is in mysql.lib, just open it (notepad) and replace the 'open' command with 'mysql.open' there is a conflict with the basic function open. ...
byteshaper
Offline Send Email
Dec 2, 2008
4:46 pm

... I made the change as your recomended but I now getting a GPF with the generated program. John...
John Spikowski
johnspikowski
Offline Send Email
Dec 2, 2008
9:09 pm

... I didn't notice the error message box before sending my last e-mail. John "Runtime error at 0049FBAE"...
John Spikowski
johnspikowski
Offline Send Email
Dec 2, 2008
9:13 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help