Re: Getting Started with a Database

2006-02-17 Thread Kay C Lan
Thanks Trevor for the insight. ___ 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: Getting Started with a Database

2006-02-16 Thread David Burgun
Hi, Thank you all so much! WIth this information (and all the other posts) I am just bound to get something working for Monday! On 15 Feb 2006, at 19:19, Trevor DeVore wrote: On Feb 15, 2006, at 7:58 AM, David Burgun wrote: Ok, that's great, but I don't have any database to import, I want

Re: Getting Started with a Database

2006-02-16 Thread David Burgun
Again - FANTASTIC Thank you all so much! It took a while to figure out all the different components but with the help of the posts here, I managed to do it! I just created my Database using CocoaSQL and am about to start accessing it with RunRev in a test stack. Once I have

Re: Getting Started with a Database

2006-02-16 Thread Trevor DeVore
On Feb 16, 2006, at 4:53 AM, David Burgun wrote: put SELECT * FROM myobjects WHERE Name LIKE '% tSearchString %' into tSQL David, One addition to the above code. You will want to escape the search string in case someone enters a character like '. So change it to: put

Re: Getting Started with a Database

2006-02-16 Thread Kay C Lan
On 2/16/06, Trevor DeVore [EMAIL PROTECTED] wrote: I recommend against using Valentina with revDB I take this to mean that you recommend using Valentina direct calls. Is this just because of speed issues, or are there bugs, gotchas or other complexities involved with using Rev calls to

Re: 2.7 BUG: Getting Started with a Database

2006-02-15 Thread David Burgun
Hi, Thanks for this. One other thing that doesn't work correctly is when you press one of the buttons to call up RunRev's documentation. If you do this it fails with an error. Just heads-up. All the Best Dave On 14 Feb 2006, at 22:12, Chipp Walters wrote: Hi David and Scott,

Re: Getting Started with a Database

2006-02-15 Thread David Burgun
Hi Trevor, Thanks for taking the time out to reply. A couple of things to address here. Creating the database The recipes.rev file assumes that you have already created the recipes table in your MySQL database. That is what the recipes.sql file is for. I did a search on google on the

Re: Getting Started with a Database

2006-02-15 Thread Mark Wieder
David- Wednesday, February 15, 2006, 7:58:01 AM, you wrote: All my Stack needs to do is: 1. Create the Database. I have a list of image files in a folder, the name field is the name of the file, the Type and Size fields are determined by looking up the name in a text file and the path

Re: Getting Started with a Database

2006-02-15 Thread Trevor DeVore
On Feb 15, 2006, at 7:58 AM, David Burgun wrote: Ok, that's great, but I don't have any database to import, I want to create a new one from scratch. Is there anyway to do this using libDatabase (with either Version 2 or 1) ? libDatabase has the functions necessary to execute the SQL

Re: Getting Started with a Database

2006-02-15 Thread Charles Hartman
I just tried downloading CocoaMySQL from curiosity. When I selected one of my databases and selected a table, it froze my PowerBook absolutely solid -- after half a minute, the beachball wouldn't even spin! Is there some more modern ( 2003) version I didn't find? Charles On Feb 15, 2006,

Re: Getting Started with a Database

2006-02-15 Thread Stephen Barncard
as I mentioned earlier in the week, the project is open source and this is the latest (1/24/) version. http://www.theonline.org/cocoamysql/ I just tried downloading CocoaMySQL from curiosity. When I selected one of my databases and selected a table, it froze my PowerBook absolutely solid --

Re: Getting Started with a Database

2006-02-15 Thread Charles Hartman
On Feb 15, 2006, at 12:13 PM, Mark Wieder wrote: Is this really a massive learning curve? I have until Monday to get Yes, probably. Find yourself a good SQL tutorial online. It's not that hard to get the basics. I found this series of tutorial pages a decent start:

Re: Getting Started with a Database

2006-02-15 Thread Charles Hartman
Thanks, that's nice new, two years newer than the one I found before. BUT it still freezes my PB totally so only a very hard reboot will bring it back. Am I weird? Some intereaction . . . Charles On Feb 15, 2006, at 5:42 PM, Stephen Barncard wrote: as I mentioned earlier in the week, the

Re: 2.7 BUG: Getting Started with a Database

2006-02-15 Thread Chipp Walters
Turns out, it's not a bug! Mark W helped me out today and it turns out it's not too difficult to setup 2.7 to automatically install database drivers. We'll be ammending our altSQLite auto-install stacks soon to help out, but in the meantime: For Windows users: You need to install the DLL

Re: Getting Started with a Database

2006-02-15 Thread Ken Ray
On 2/15/06 7:36 PM, Charles Hartman [EMAIL PROTECTED] wrote: Thanks, that's nice new, two years newer than the one I found before. BUT it still freezes my PB totally so only a very hard reboot will bring it back. Am I weird? Some intereaction . . . Why don't you try YourSQL instead - I use

Re: Getting Started with a Database

2006-02-15 Thread Pierre Sahores
In about MySQL management tools, both Navicat MySQL (commercial) and YourSQL (freeware) are giving me what i expect from them without any issues. It's always a good idea to use them in ssh tunnelling / localhost port forwarding mode when you need to access a remote mySQL server aka : 1.-

Re: Getting Started with a Database

2006-02-14 Thread Ruslan Zasukhin
On 2/14/06 5:44 AM, Lynn Fredricks [EMAIL PROTECTED] wrote: Hi Kay, Hi Lynn, PS Ruslan I noted your earlier post and as I stated in my last after a little more trouble shooting I may need to post my problem. I am registered with the Valentina list and I must ask do you ever sleep? Your

Re: Getting Started with a Database

2006-02-14 Thread David Burgun
Hi Trevor, Thanks for taking the time to reply on this. On 13 Feb 2006, at 18:41, Trevor DeVore wrote: On Feb 13, 2006, at 5:52 AM, David Burgun wrote: Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called

Re: Getting Started with a Database

2006-02-14 Thread David Burgun
Hi, I downloaded and installed this and running the test stack: go URL http://www.gadgetplugins.com/altsqlite/SQLite3Demo.rev; seems to work ok, this (although there are problems running under RunRev 2.7, so I am using 2.6.1). I can't seem to find out what the restrictions are on the Demo

Re: Getting Started with a Database

2006-02-14 Thread Trevor DeVore
Hi David, It looks like you haven't created the recipes database in MySQL. Did you import the recipes.sql file into your MySQL database? I am really not sure what I have to do. I downloaded libDatabase_2.zip. This expanded into a folder called libDatabase 2.0 which contains the

RE: Getting Started with a Database

2006-02-14 Thread Scott Kane
Message- From: David Burgun [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 February 2006 3:48 AM To: [EMAIL PROTECTED]; How to use Revolution Subject: Re: Getting Started with a Database Hi, I downloaded and installed this and running the test stack: go URL http://www.gadgetplugins.com

2.7 BUG: Getting Started with a Database

2006-02-14 Thread Chipp Walters
Hi David and Scott, altSQLite3 does work fine with 2.7. Just tested it, but you have to know where to install the DLL/bundle to. Find the folder where Rev in installed, then be sure and copy the bundle/DLL to the folder below. /Externals/Database Drivers Next, update your database

Re: Getting Started with a Database

2006-02-14 Thread Kay C Lan
On 2/15/06, David Burgun [EMAIL PROTECTED] wrote: I have now looked that three database solutions and none of them seem to work and there seems to be very little getting-started information supplied with them. Just confirm that you have a copy of the MySQL reference manual. I can't remember

Re: Getting Started with a Database

2006-02-13 Thread David Burgun
Hi, Yes, I am running on Mac for the moment, the app will eventually be deployed on Mac and Windows. Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the recipes.rev stack,

Re: Getting Started with a Database

2006-02-13 Thread David Burgun
Hi, Yes, I am running on Mac for the moment, the app will eventually be deployed on Mac and Windows. Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the recipes.rev stack,

Re: Getting Started with a Database

2006-02-13 Thread Kay C Lan
On 2/12/06, David Burgun [EMAIL PROTECTED] wrote: Hi, What is the issue number? I looked at issue 166 (http:// www.macformat.co.uk/) but couldn't see anything about Valentina and I can't seem to find details on the February issue. Yes, you want issue 165, the Feb issue.

Re: Getting Started with a Database

2006-02-13 Thread Trevor DeVore
On Feb 13, 2006, at 5:52 AM, David Burgun wrote: Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the recipes.rev stack, I get an error: libdberr: unable to connect to

RE: Getting Started with a Database

2006-02-13 Thread Scott Kane
Hi David, Not sure if it has been mentioned or not to you, but I heartly recommend altSQLite. It's zero configuration (database can be in the same folder as your binary). it's pretty lean and is fast enough for the number of records you are looking at. Check it out at: http://www.altuit.com

Re: Getting Started with a Database

2006-02-13 Thread Kay C Lan
May I also suggest you get a copy of the donationware CocoaMySQL: http://cocoamysql.sourceforge.net/ It makes it extremely easy to determine if your MySQL is set up correctly - although if it isn't you still have to nut out what the problem is. Best of all it makes it very easy to create/modify

Re: Getting Started with a Database

2006-02-13 Thread Stephen Barncard
I agree, a working SQL client is essential to get past the 'chicken and egg' of develop an app without data. I loved and used CocoaMySQL for years, but the version at the sourceforge link will break with 10.3.4 and above and most certainly Tiger. Just stops functioning. use this link

Re: Getting Started with a Database

2006-02-13 Thread Kay C Lan
On 2/14/06, Stephen Barncard [EMAIL PROTECTED] wrote: I agree, a working SQL client is essential to get past the 'chicken and egg' of develop an app without data. I loved and used CocoaMySQL for years, but the version at the sourceforge link will break with 10.3.4 and above and most

RE: Getting Started with a Database

2006-02-13 Thread Lynn Fredricks
PS Ruslan I noted your earlier post and as I stated in my last after a little more trouble shooting I may need to post my problem. I am registered with the Valentina list and I must ask do you ever sleep? Your support is phenomenal - some of the Rev officials could take a lesson of making

Getting Started with a Database

2006-02-11 Thread David Burgun
Hi All, I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database

RE: Getting Started with a Database

2006-02-11 Thread Lynn Fredricks
I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database

Re: Getting Started with a Database

2006-02-11 Thread Ruslan Zasukhin
On 2/11/06 5:43 PM, Lynn Fredricks [EMAIL PROTECTED] wrote: Hi Dave, I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to

Re: Getting Started with a Database

2006-02-11 Thread Charles Hartman
What platform? On OSX I was in a similar position recently, and I settled for MySQL (downloadable) with Blue Mango's (Trevor DeVore's) libDatabase 2.0 (ditto). This way's free. The libDatabase isn't strictly necessary (it's a wrapper around revdb functions), but it makes things a *lot*