RE: mysql to valentina using libdatabase
Selon Robert Mann <[EMAIL PROTECTED]>: > I was following the getting started I see the changes now, am I correct that > to use liDatabase you input this through the message box? > > Robert Mann > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Trevor > DeVore > Sent: Friday, December 29, 2006 11:02 AM > To: How to use Revolution > Subject: Re: mysql to valentina using libdatabase > > > On Dec 28, 2006, at 6:52 PM, Robert Mann wrote: > > > trying to convert a mysql database to a valentina database > > searching the > > list I ran across libDatabase and looks like it will do the > > conversion, I am > > just having a hard time figuring out how to use it tried to go > > through the > > getting started, to run this do you put the following in the > > message box? > > > > put "mysql" into tDbA["Type"] > > put "localhost" into tDbA["Host"] > > put "recipes" into tDbA["Name"] > > put "root" into tDbA["Username"] > > put "" into tDbA["Password"] > > > > libDatabase_RegisterDatabase "myrecipesdb", tDbA > > > > libDatabase_Connect "myrecipesdb" > > > > libDatabase_GetDBConnectionID("myrecipesdb") > > Robert, > > It looks like you are using the version 1 syntax. You should > download version 2 of libDatabase if you are just getting started > with it. > > Then syntax in 2.0 would be: > > libdb_registerDatabase "myrecipesdb", tDbA > libdb_connect "myrecipesdb" > put libdb_getConnectionID("myrecipesdb") into theConnectionID > > -- > Trevor DeVore > Blue Mango Learning Systems - www.bluemangolearning.com > [EMAIL PROTECTED] > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > cessez de remplir ma boite d'inutilite merci ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
Selon Robert Mann <[EMAIL PROTECTED]>: > ok so what is the best way to use libDatabase? > > Robert Mann > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Stephen > Barncard > Sent: Friday, December 29, 2006 11:59 AM > To: How to use Revolution > Subject: RE: mysql to valentina using libdatabase > > > you might be able to do this db stuff from the message box, but I'd > recommend against it. You need multiple script lines to do this and > using ";" between statements gets pretty unclear fast. > > just create a handler in your stack script and call it from the msg box. > You'll have the advantage of indenting and colorization of the > script, better error reporting, and of course debugging. > > also don't forget to define your globals, especially of the array > you're creating for opening.. > > sqb > > > >I was following the getting started I see the changes now, am I correct > that > >to use liDatabase you input this through the message box? > > > >Robert Mann > > > > > > > -- > stephen barncard > s a n f r a n c i s c o > - - - - - - - - - - - - > > > > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
Selon Ruslan Zasukhin <[EMAIL PROTECTED]>: > On 06/29/12 9:16 PM, "Robert Mann" <[EMAIL PROTECTED]> wrote: > > > I have been in contact with Ruslan he has been very helpful and there seems > > to be a bug in valentina studio so it won't do the conversion, > > By ODBC way. Yes, Jochen is back and should check this soon. > > -- > Best regards, > > Ruslan Zasukhin > VP Engineering and New Technology > Paradigma Software, Inc > > Valentina - Joining Worlds of Information > http://www.paradigmasoft.com > > [I feel the need: the need for speed] > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Jan 2, 2007, at 3:45 PM, Robert Mann wrote: I tried both of these and I get "application error handler running low on memory, script aborted" put libdb_getSQLDump ("RecipesDB","empty" ,"empty" , "true","true","empty", "mysqldump.sql") into mysqldump get libdb_getSQLDump ("RecipesDB","empty" ,"empty" , "true","true","empty" "mysqldump.sql") Hmmm, sounds like an infinite loop. Can you email me a sql dump of your db privately (created using mysql client or some other tool)? -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
I tried both of these and I get "application error handler running low on memory, script aborted" put libdb_getSQLDump ("RecipesDB","empty" ,"empty" , "true","true","empty", "mysqldump.sql") into mysqldump get libdb_getSQLDump ("RecipesDB","empty" ,"empty" , "true","true","empty" "mysqldump.sql") Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor DeVore Sent: Tuesday, January 02, 2007 11:16 AM To: How to use Revolution Subject: Re: mysql to valentina using libdatabase On Jan 1, 2007, at 7:14 PM, Robert Mann wrote: > I thought it would be just passing the info to the libdb_getSQLDump > function > as in the libdb_registerDatabase libdb_registerDatabase is a command, libdb_getSQLDump is a function. You always have to store the return value of a function somewhere, > I also thought that if you put a value in the last parameter > mysqldump.sql > it would write it to a file That is correct. libdb_getSQLDump will store the contents to a file but you still need to call the function correctly. Try changing your syntax and see if it works. -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Jan 1, 2007, at 7:14 PM, Robert Mann wrote: I thought it would be just passing the info to the libdb_getSQLDump function as in the libdb_registerDatabase libdb_registerDatabase is a command, libdb_getSQLDump is a function. You always have to store the return value of a function somewhere, I also thought that if you put a value in the last parameter mysqldump.sql it would write it to a file That is correct. libdb_getSQLDump will store the contents to a file but you still need to call the function correctly. Try changing your syntax and see if it works. -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
I thought it would be just passing the info to the libdb_getSQLDump function as in the libdb_registerDatabase I also thought that if you put a value in the last parameter mysqldump.sql it would write it to a file ON DoMysqlDump put "empty" into theInfoA["pTables"] put "empty" into theInfoA["pDrop"] put "true" into theInfoA["pCreate"] put "true" into theInfoA["pInsert"] put "empty" into theInfoA["pVersion"] put "mysqldump.sql" into theInfoA["pOutFile"] libdb_getSQLDump "SuspensionDB",theInfoA END DoMysqlDump Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Monday, January 01, 2007 9:26 PM To: How to use Revolution Subject: Re: mysql to valentina using libdatabase On Jan 1, 2007, at 6:15 PM, Robert Mann wrote: > ON DoMysqlDump > libdb_getSQLDump ("SuspensionDB","empty" ,"empty" , "true", > "true","empty" , "mysqldump.sql")//tried this with and without the > () no > difference still get error > > END DoMysqlDump libdb_getSQLDump is a function but you are using it like a command. You have to put the value somewhere: put libdb_getSQLDump(...) into myVariable OR get libdb_getSQLDump(...) // puts value into the "it" variable -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Jan 1, 2007, at 6:15 PM, Robert Mann wrote: ON DoMysqlDump libdb_getSQLDump ("SuspensionDB","empty" ,"empty" , "true", "true","empty" , "mysqldump.sql")//tried this with and without the () no difference still get error END DoMysqlDump libdb_getSQLDump is a function but you are using it like a command. You have to put the value somewhere: put libdb_getSQLDump(...) into myVariable OR get libdb_getSQLDump(...) // puts value into the "it" variable -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
The registerDatabaseA seems to be working/connecting but when I run the DoMysqlDump I get an error can't find handler, I even tried to add this to the recipes card and get the same error, I could not get the valentina to connect so I thought that I would create a SQLdump and try Valentina Studio to import ON preOpenStack start using stack "lib.bmm.Database" start using stack "lib.bmm.DatabaseObjects" pass preOpenStack END preOpenStack ON RegisterDatabaseA put "mysql" into theConnectInfoA["Type"] put "localhost" into theConnectInfoA["Host"] put "name" into theConnectInfoA["Name"] put "username" into theConnectInfoA["Username"] put "password" into theConnectInfoA["Password"] libdb_registerDatabase "SuspensionDB", theConnectInfoA_# Associates connection settings with "RecipesDB" key. put libdb_getConnectionID (SuspensionDB) into fld "fieldmysqlid" // checking to make sure connected to database END RegisterDatabaseA ON DoMysqlDump libdb_getSQLDump ("SuspensionDB","empty" ,"empty" , "true", "true","empty" , "mysqldump.sql")//tried this with and without the () no difference still get error END DoMysqlDump Thanks Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On 12/30/06, Stephen Barncard <[EMAIL PROTECTED]> wrote: you might be able to do this db stuff from the message box, but I'd recommend against it. You need multiple script lines to do this and using ";" between statements gets pretty unclear fast. Off Topic for the current discussion. The message box can be run in two modes, single line and multi-line. If using ";" to turn multiple lines into a single line becomes unclear, try the multi-line mode - excellent for testing script snippets:-) Closer to On Topic. Robert, I've been following, on and off due festive season commitments, your posts here and on the valentina list, and I just wanted to say that I appreciate the work your putting in. As soon as the festive mayhem is over and I have a little spare time again I have some mysql to valentina conversions I'd like to do. Your posts have hilighted a few mistakes I'm sure I'd make, and Ruslan's replies have, as usual, been enlightening - man the guy was even posting on Christmas Day! Does he ever rest? So, thanks:-) ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Dec 29, 2006, at 2:29 PM, Bill wrote: Trevor Do you have a mailing list to notify people of the cool stuff you do like new versions of libDatabase? If so I'd like to be on that list. I don't have any such list for my personal stuff as I'm not nearly that organized :-) I usually post to this list when I update any of the stuff on my site. For Galaxy, Jerry and I post messages to the BaseCamp support site we maintain for Galaxy. -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
Trevor Do you have a mailing list to notify people of the cool stuff you do like new versions of libDatabase? If so I'd like to be on that list. Bill On 12/29/06 3:30 PM, "Trevor DeVore" <[EMAIL PROTECTED]> wrote: > On Dec 29, 2006, at 11:12 AM, Robert Mann wrote: > >> Trevor, >> thanks >> ok I see the libdb_export in the stack script >> >> now I am lost >> >> how do I go about running it or any of the handlers? > > libDatabase is a library script so it needs to be in the message > path. If you aren't familiar with library stacks yet then I would > recommend looking at "start using" in the documentation and taking a > look at the "Message Hierarchy" conference session at support.runrev.com/scriptingconferences/>. > > Once libDatabase is in the message path you can call any of the > handlers from any stack or from the message box. The Getting Started > with libDatabase PDF document included in the download has some > examples of how to call libdb_export on page 8. > > Let me know if that helps. ||| )_) )_) )_) )___))___))___)\ )))_)\\ _|||\\\__ ---\ /- http://www.bluewatermaritime.com ^ ^ ^^^^^ ^^^ 24 hour cell: (787) 378-6190 fax: (787) 809-8426 Blue Water Maritime P.O. Box 2087 Rio Grande, PR 00745 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Dec 29, 2006, at 11:12 AM, Robert Mann wrote: Trevor, thanks ok I see the libdb_export in the stack script now I am lost how do I go about running it or any of the handlers? libDatabase is a library script so it needs to be in the message path. If you aren't familiar with library stacks yet then I would recommend looking at "start using" in the documentation and taking a look at the "Message Hierarchy" conference session at support.runrev.com/scriptingconferences/>. Once libDatabase is in the message path you can call any of the handlers from any stack or from the message box. The Getting Started with libDatabase PDF document included in the download has some examples of how to call libdb_export on page 8. Let me know if that helps. -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On 06/29/12 9:16 PM, "Robert Mann" <[EMAIL PROTECTED]> wrote: > I have been in contact with Ruslan he has been very helpful and there seems > to be a bug in valentina studio so it won't do the conversion, By ODBC way. Yes, Jochen is back and should check this soon. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On 06/29/12 8:39 PM, "Stephen Barncard" <[EMAIL PROTECTED]> wrote: Hi Stephan, > as far as I can tell (having never tried Valentina, but briefly > examining parts of Trevor's library) is that > > 1. Valentina uses standard SQL code, but adds many supersets commands > of its own on top of the standard SQL dialect. Ruslan Zasukhin, the > man who WROTE THE Valentina CODE, is on this list. I'm sure he can > give you better advice about 'conversion' . Valentina offer as as SQL way, so API way, so RevDB way on choice of developer. > 2. Trevor's library will handle connection and some conversion. > Trevor's description would imply to me that it should just work. > Trevor will have to describe what exactly happens internally...I just > know that his lib made using sql in rev very easy. > > I still haven't used Valentina. I think I was eligible for a version > during the last Revcon, but I could never find anyone that could > point me to the right place to get it...Lynn? Ruslan? Revcon vistors did get Valentina Office Server license, right? What exactly is not clear to you? Where download Valentina archive? Else? -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
I have been in contact with Ruslan he has been very helpful and there seems to be a bug in valentina studio so it won't do the conversion, Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Barncard Sent: Friday, December 29, 2006 1:39 PM To: How to use Revolution Subject: RE: mysql to valentina using libdatabase ok as far as I can tell (having never tried Valentina, but briefly examining parts of Trevor's library) is that 1. Valentina uses standard SQL code, but adds many supersets commands of its own on top of the standard SQL dialect. Ruslan Zasukhin, the man who WROTE THE Valentina CODE, is on this list. I'm sure he can give you better advice about 'conversion' . 2. Trevor's library will handle connection and some conversion. Trevor's description would imply to me that it should just work. Trevor will have to describe what exactly happens internally...I just know that his lib made using sql in rev very easy. I still haven't used Valentina. I think I was eligible for a version during the last Revcon, but I could never find anyone that could point me to the right place to get it...Lynn? Ruslan? >Thanks for the great explanation, >I already have mysql running locally(using xampp) for a rev application that >I have built and that works great I am now exploring valentina(for the fact >that I can deploy and not have the expense mysql) so I need to convert the >mysql database to valentina so was trying to get libDatabase working to help >me do the conversion. I tried to use valentina studio but have had problems >getting it to do the conversion. > >So more specifically how are people using libDatabase to do a conversion of >a mysql database to valentina? > >Thanks >Robert Mann > -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
Trevor, thanks ok I see the libdb_export in the stack script now I am lost how do I go about running it or any of the handlers? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Friday, December 29, 2006 1:38 PM To: How to use Revolution Subject: Re: mysql to valentina using libdatabase On Dec 29, 2006, at 10:06 AM, Robert Mann wrote: > So more specifically how are people using libDatabase to do a > conversion of > a mysql database to valentina? Robert, I've just uploaded a newer version of libDatabase to my site. This version has been tested with Valentina 2 more than the version you downloaded. I've also included libDatabaseObjects, an example stack and additional documentation. I haven't had time to proof the text and do some other sanity checks on the examples but I'm not sure when I will so I am just putting it up there. http://bluemangolearning.com/developer/revolution/ libDatabase contains a handler that attempts to convert from one database to another. I've used it in my projects to convert from MySQL (which we use in-house) to Valentina 1.x databases for deployment to customers. I haven't tried it with Valentina 2 though. Check out the PDF documents included in the download for more info. If nothing else, you can look at the libDatabase code for ideas on how to do the conversion. -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
ok as far as I can tell (having never tried Valentina, but briefly examining parts of Trevor's library) is that 1. Valentina uses standard SQL code, but adds many supersets commands of its own on top of the standard SQL dialect. Ruslan Zasukhin, the man who WROTE THE Valentina CODE, is on this list. I'm sure he can give you better advice about 'conversion' . 2. Trevor's library will handle connection and some conversion. Trevor's description would imply to me that it should just work. Trevor will have to describe what exactly happens internally...I just know that his lib made using sql in rev very easy. I still haven't used Valentina. I think I was eligible for a version during the last Revcon, but I could never find anyone that could point me to the right place to get it...Lynn? Ruslan? Thanks for the great explanation, I already have mysql running locally(using xampp) for a rev application that I have built and that works great I am now exploring valentina(for the fact that I can deploy and not have the expense mysql) so I need to convert the mysql database to valentina so was trying to get libDatabase working to help me do the conversion. I tried to use valentina studio but have had problems getting it to do the conversion. So more specifically how are people using libDatabase to do a conversion of a mysql database to valentina? Thanks Robert Mann -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Dec 29, 2006, at 10:06 AM, Robert Mann wrote: So more specifically how are people using libDatabase to do a conversion of a mysql database to valentina? Robert, I've just uploaded a newer version of libDatabase to my site. This version has been tested with Valentina 2 more than the version you downloaded. I've also included libDatabaseObjects, an example stack and additional documentation. I haven't had time to proof the text and do some other sanity checks on the examples but I'm not sure when I will so I am just putting it up there. http://bluemangolearning.com/developer/revolution/ libDatabase contains a handler that attempts to convert from one database to another. I've used it in my projects to convert from MySQL (which we use in-house) to Valentina 1.x databases for deployment to customers. I haven't tried it with Valentina 2 though. Check out the PDF documents included in the download for more info. If nothing else, you can look at the libDatabase code for ideas on how to do the conversion. -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
Thanks for the great explanation, I already have mysql running locally(using xampp) for a rev application that I have built and that works great I am now exploring valentina(for the fact that I can deploy and not have the expense mysql) so I need to convert the mysql database to valentina so was trying to get libDatabase working to help me do the conversion. I tried to use valentina studio but have had problems getting it to do the conversion. So more specifically how are people using libDatabase to do a conversion of a mysql database to valentina? Thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Barncard Sent: Friday, December 29, 2006 12:30 PM To: How to use Revolution Subject: RE: mysql to valentina using libdatabase >ok so what is the best way to use libDatabase? > >Robert Mann > install a database or use one provided by your ISP. The ISP method could be used if you've never installed a db. Dreamhost is one such provider. Or go to MYSQL.org and download a version of mysql to install locally on your machine or on another machine on your network. Versions of mysql can be downloaded free, however professional deployment and use must be licensed $$. if you've done this, then get a SQL client like Navicat (paid) or CocoaMySQL(free, mac only) to create populate and talk to your database. This will make it easier to then script your sql commands and test results. It also helps to see what's happening when your scripts don't work. Get the example database and scripts from Trevor's site. import the simple data to the database, then explore. Eventually you can replace all the functionality in those clients with your own code. For instance, you could make a simple stack with two fields, one with your SQL statement, and one to show the results. Sarah at Trozware has a couple of stacks that have worked well for me for getting started. Her stacks use the built in rev database hooks, but do not use Trevor's libraries. MySQLtests.rev This stack provides a GUI for testing connections to MySQL databases. It does basic queries as well as editing of tables and records. Not intended for long term use, but I found it helpful when starting to learn about MySQL. MySQL.rev This stack is a simple client for communicating with MySQL servers either on your own computer or remotely. It accepts any MySQL command and displays the results in a simple text-based table form. It is supposed to be similar to the client available when using OS X's Terminal, but does not require that the client & server be installed on your computer. http://www.troz.net/Rev/tutorials.php sqb -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
ok so what is the best way to use libDatabase? Robert Mann install a database or use one provided by your ISP. The ISP method could be used if you've never installed a db. Dreamhost is one such provider. Or go to MYSQL.org and download a version of mysql to install locally on your machine or on another machine on your network. Versions of mysql can be downloaded free, however professional deployment and use must be licensed $$. if you've done this, then get a SQL client like Navicat (paid) or CocoaMySQL(free, mac only) to create populate and talk to your database. This will make it easier to then script your sql commands and test results. It also helps to see what's happening when your scripts don't work. Get the example database and scripts from Trevor's site. import the simple data to the database, then explore. Eventually you can replace all the functionality in those clients with your own code. For instance, you could make a simple stack with two fields, one with your SQL statement, and one to show the results. Sarah at Trozware has a couple of stacks that have worked well for me for getting started. Her stacks use the built in rev database hooks, but do not use Trevor's libraries. MySQLtests.rev This stack provides a GUI for testing connections to MySQL databases. It does basic queries as well as editing of tables and records. Not intended for long term use, but I found it helpful when starting to learn about MySQL. MySQL.rev This stack is a simple client for communicating with MySQL servers either on your own computer or remotely. It accepts any MySQL command and displays the results in a simple text-based table form. It is supposed to be similar to the client available when using OS X's Terminal, but does not require that the client & server be installed on your computer. http://www.troz.net/Rev/tutorials.php sqb -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
ok so what is the best way to use libDatabase? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Barncard Sent: Friday, December 29, 2006 11:59 AM To: How to use Revolution Subject: RE: mysql to valentina using libdatabase you might be able to do this db stuff from the message box, but I'd recommend against it. You need multiple script lines to do this and using ";" between statements gets pretty unclear fast. just create a handler in your stack script and call it from the msg box. You'll have the advantage of indenting and colorization of the script, better error reporting, and of course debugging. also don't forget to define your globals, especially of the array you're creating for opening.. sqb >I was following the getting started I see the changes now, am I correct that >to use liDatabase you input this through the message box? > >Robert Mann -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
Not sure but I just am not able to work at least I don't think it is working, this maybe simply my lack of some of rev's tools i.e. message box, I know the database is in mysql "recipies" and the host is localhost would someone be gracious enough to point me in the right direction to get this working, I tried the below from Trevor I do not get any errors but now how do I know that it connected? thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Friday, December 29, 2006 11:02 AM To: How to use Revolution Subject: Re: mysql to valentina using libdatabase On Dec 28, 2006, at 6:52 PM, Robert Mann wrote: > trying to convert a mysql database to a valentina database > searching the > list I ran across libDatabase and looks like it will do the > conversion, I am > just having a hard time figuring out how to use it tried to go > through the > getting started, to run this do you put the following in the > message box? > > put "mysql" into tDbA["Type"] > put "localhost" into tDbA["Host"] > put "recipes" into tDbA["Name"] > put "root" into tDbA["Username"] > put "" into tDbA["Password"] > > libDatabase_RegisterDatabase "myrecipesdb", tDbA > > libDatabase_Connect "myrecipesdb" > > libDatabase_GetDBConnectionID("myrecipesdb") Robert, It looks like you are using the version 1 syntax. You should download version 2 of libDatabase if you are just getting started with it. Then syntax in 2.0 would be: libdb_registerDatabase "myrecipesdb", tDbA libdb_connect "myrecipesdb" put libdb_getConnectionID("myrecipesdb") into theConnectionID -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
you might be able to do this db stuff from the message box, but I'd recommend against it. You need multiple script lines to do this and using ";" between statements gets pretty unclear fast. just create a handler in your stack script and call it from the msg box. You'll have the advantage of indenting and colorization of the script, better error reporting, and of course debugging. also don't forget to define your globals, especially of the array you're creating for opening.. sqb I was following the getting started I see the changes now, am I correct that to use liDatabase you input this through the message box? Robert Mann -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
I was following the getting started I see the changes now, am I correct that to use liDatabase you input this through the message box? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Friday, December 29, 2006 11:02 AM To: How to use Revolution Subject: Re: mysql to valentina using libdatabase On Dec 28, 2006, at 6:52 PM, Robert Mann wrote: > trying to convert a mysql database to a valentina database > searching the > list I ran across libDatabase and looks like it will do the > conversion, I am > just having a hard time figuring out how to use it tried to go > through the > getting started, to run this do you put the following in the > message box? > > put "mysql" into tDbA["Type"] > put "localhost" into tDbA["Host"] > put "recipes" into tDbA["Name"] > put "root" into tDbA["Username"] > put "" into tDbA["Password"] > > libDatabase_RegisterDatabase "myrecipesdb", tDbA > > libDatabase_Connect "myrecipesdb" > > libDatabase_GetDBConnectionID("myrecipesdb") Robert, It looks like you are using the version 1 syntax. You should download version 2 of libDatabase if you are just getting started with it. Then syntax in 2.0 would be: libdb_registerDatabase "myrecipesdb", tDbA libdb_connect "myrecipesdb" put libdb_getConnectionID("myrecipesdb") into theConnectionID -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On Dec 28, 2006, at 6:52 PM, Robert Mann wrote: trying to convert a mysql database to a valentina database searching the list I ran across libDatabase and looks like it will do the conversion, I am just having a hard time figuring out how to use it tried to go through the getting started, to run this do you put the following in the message box? put "mysql" into tDbA["Type"] put "localhost" into tDbA["Host"] put "recipes" into tDbA["Name"] put "root" into tDbA["Username"] put "" into tDbA["Password"] libDatabase_RegisterDatabase "myrecipesdb", tDbA libDatabase_Connect "myrecipesdb" libDatabase_GetDBConnectionID("myrecipesdb") Robert, It looks like you are using the version 1 syntax. You should download version 2 of libDatabase if you are just getting started with it. Then syntax in 2.0 would be: libdb_registerDatabase "myrecipesdb", tDbA libdb_connect "myrecipesdb" put libdb_getConnectionID("myrecipesdb") into theConnectionID -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql to valentina using libdatabase
I only need to get my current mysql database converted to valentina so I can continue to test if all goes well I will then change over to valentina, but it would be nice to learn how to do this just in case I need to do this in the future Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ruslan Zasukhin Sent: Friday, December 29, 2006 2:57 AM To: use-revolution Subject: Re: mysql to valentina using libdatabase On 06/29/12 4:52 AM, "Robert Mann" <[EMAIL PROTECTED]> wrote: > trying to convert a mysql database to a valentina database searching the > list I ran across libDatabase and looks like it will do the conversion, I am > just having a hard time figuring out how to use it tried to go through the > getting started, to run this do you put the following in the message box? > > put "mysql" into tDbA["Type"] > put "localhost" into tDbA["Host"] > put "recipes" into tDbA["Name"] > put "root" into tDbA["Username"] > put "" into tDbA["Password"] > > libDatabase_RegisterDatabase "myrecipesdb", tDbA > > libDatabase_Connect "myrecipesdb" > > libDatabase_GetDBConnectionID("myrecipesdb") Robert, I did forget to ask: you need convert only one existed database, or you need that your application is able do this at any time with any mySQL db ? -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: mysql to valentina using libdatabase
On 06/29/12 4:52 AM, "Robert Mann" <[EMAIL PROTECTED]> wrote: > trying to convert a mysql database to a valentina database searching the > list I ran across libDatabase and looks like it will do the conversion, I am > just having a hard time figuring out how to use it tried to go through the > getting started, to run this do you put the following in the message box? > > put "mysql" into tDbA["Type"] > put "localhost" into tDbA["Host"] > put "recipes" into tDbA["Name"] > put "root" into tDbA["Username"] > put "" into tDbA["Password"] > > libDatabase_RegisterDatabase "myrecipesdb", tDbA > > libDatabase_Connect "myrecipesdb" > > libDatabase_GetDBConnectionID("myrecipesdb") Robert, I did forget to ask: you need convert only one existed database, or you need that your application is able do this at any time with any mySQL db ? -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution