realbasic-nug
[Top] [All Lists]

Re: Execute MySql query from file or from a edit field

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Execute MySql query from file or from a edit field
From: Lars Heidieker <lars at merlin dot de>
Date: Fri, 1 Jul 2005 00:17:17 +0200
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <BAY102-F28C3B70E85C85BF641FFED7E30 at phx dot gbl>
probably a typo
db.sqlexecute = EditField1.text // THIS WON'T. I tried to load several SQL files, generated via PhpMyAdminshould read db.sqlexecute(EditField1.text) // THIS WON'T. I tried to load several SQL files, generated via PhpMyAdmin

Greetings,
Lars

On Jun 30, 2005, at 10:03 PM, the wiper wrote:

If you're using MySQL 4.1 or higher, make sure the password is created with the OLD_PASSWORDS functions, or start your server with the --old-passwords command.


Sorry, i have explained my problem in a bad way. MySql server seems well configured and if i try to connect via RB it works. For example

Private sub TestConnection
dim db as new mysqldatabase

// Configuration lines such db.port=3306, db.username = "test" ...

if db.connect = true then
db.sqlexecute (" insert into test (test_1,test2) values ("a","b) // THIS WORK, via phpMyAdmin i see these values
db.commit
end if

if db.connect = true then
db.sqlexecute = EditField1.text // THIS WON'T. I tried to load several SQL files, generated via PhpMyAdmin
msgbox (db.errormessage) // returns nothing :-(
end if
End sub

Thank you again.


_______________________________________________
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>


_______________________________________________
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>

<Prev in Thread] Current Thread [Next in Thread>