How you modify SQL Lite tables which have many records?

2010-10-28 Thread Ruslan Zasukhin
Hi Guys, One developer, which try now implement some GUI around SQL Lite have touch me with wonder that SQL Lite do not have any way to modify schema of database. At this URL http://www.sqlite.org/omitted.html You can read that Only the RENAME TABLE and ADD COLUMN variants

Re: How you modify SQL Lite tables which have many records?

2010-10-28 Thread Bob Sneidar
, but it's not strictly necessary to remove it. Also, the order the columns are in is irrelevant. Mind you I am not defending or supporting sqLite as a good engine for large databases. I'm just saying, given the name sqLITE, you can't hope for full SQL compliance. Bob On Oct 28, 2010, at 9:11 AM

Re: How you modify SQL Lite tables which have many records?

2010-10-28 Thread Bob Sneidar
begin to crop up and security can break down. There are however, so far as I have been able to tell, no record limits for sqLite. Bob On Oct 28, 2010, at 9:11 AM, Ruslan Zasukhin wrote: Hi Guys, One developer, which try now implement some GUI around SQL Lite have touch me with wonder

Re: How you modify SQL Lite tables which have many records?

2010-10-28 Thread Bob Sneidar
Oh yeah and this tidbit of info is useful: After ADD COLUMN has been run on a database, that database will not be readable by SQLite version 3.1.3 and earlier. Bob On Oct 28, 2010, at 9:11 AM, Ruslan Zasukhin wrote: Hi Guys, One developer, which try now implement some GUI around SQL Lite

Re: How you modify SQL Lite tables which have many records?

2010-10-28 Thread Ruslan Zasukhin
Foreign Key constraint to table. Mind you I am not defending or supporting sqLite as a good engine for large databases. I'm just saying, given the name sqLITE, you can't hope for full SQL compliance. :-) Well, I know of course that SqlLite should not be used on db/tables over few thousands

Re: How you modify SQL Lite tables which have many records?

2010-10-28 Thread Ruslan Zasukhin
... And it was for years for many dbs. E.g. I remember that 4D was not able also remove column from Table. I remember that old good dbVista (network model) also was not able modify links Once dbVista expert user have to see Valentina db with its API -way (i.e. NON-SQL) and said: wow! Valentina

Re: Rev SQL question

2010-09-03 Thread Andrew Kluthe
All the apps that I currently write or maintain are frontends for databases. SQLYoga from Trevor DeVore (creator of the DataGrid control) has been extermely invaluable to saving me time and thought when handling mySQL. It also supports SQLLite and I think SQL Server. It comes with a trial

Re: Rev SQL question

2010-09-03 Thread Andre Garzia
Me too! SQL Yoga rocks! Also if you're doing web with RevServer, then RevIgniter active record implementation is the best thing ever. Everytime I throw something like: rigDbWhere email, myEmail put rigDbGet(members) into tRecord put rigDbRow(1) into tContactA I almost cry tears of joy. I

Rev SQL question

2010-09-02 Thread Mike Arnold
I am finally back at Rev again, with a small project up front and eventually a much bigger project (I hope). It seems each time I start with a rev project I find a new area to explore and get stopped cold ... its such a nice platform, just have to get back in the swing again. This time I've

Re: Rev SQL question

2010-09-02 Thread Monte Goulding
revExecuteSQL dbID,SELECT Name FROM myTable INTO ARRAY :1,eventList Hi Mike You can't do it that way. The array syntax for revExecuteSQL is for SQL statements like INSERT where :1 is replaced by the value if eventList[1]. I have a blog post that includes some simple generic db functions

Re: Rev SQL question

2010-09-02 Thread Mike Arnold
Monte, Perfect! Worked like a charm. thank you, Mike. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Remote SQL databases

2010-05-25 Thread Bob Sneidar
, both databases are on the same machine and can be accessed using the same username/password. Hope this helps. Bob Date: Sun, 23 May 2010 18:19:24 -0300, From: Andre Garzia an...@andregarzia.com Subject: Re: Remote SQL databases I did it on my 6k thousand table database... It works

Re: Remote SQL databases

2010-05-25 Thread Mark Wieder
database. That can't be done with an SQL statement because the SQL command is performed by the database itself. So if you send a SQL command to the MySQL database it's getting executed by the MySQL engine, not by rev. The MySQL engine has no knowledge of any other databases, and so it would fail. I think

Re: Remote SQL databases

2010-05-25 Thread Bob Sneidar
Which is why if I pull this off, there are people who may be interested in it. Bob On May 25, 2010, at 10:19 AM, Mark Wieder wrote: I think the only way around this is to issue two SQL commands, one to MySQL, one to SQLite, then take the recordsets and mangle them yourself, pretending

Re: Remote SQL databases

2010-05-25 Thread Trevor DeVore
On May 21, 2010, at 6:31 PM, Bob Sneidar wrote: I'm wondering if the Relational aspect of Trevor's sqlYoga would be able to do this, but again, I think I have to be working with two tables in the same database for that to work. Trevor? That is correct. SQL Yoga will only work

Re: Remote SQL databases

2010-05-24 Thread Bob Sneidar
Gotcha. Teaches me to take my web guy's word for it. :-) Bob On May 21, 2010, at 5:04 PM, Mark Stuart wrote: Hi Bob, on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote: So now I have to think about using joins. Just preface the table name that's in the other database with the

Re: Remote SQL databases

2010-05-24 Thread Bob Sneidar
Hi Mark and all interested parties. Perhaps I failed to mention that the two databases do not know about each other. The SQL server doing the join has no access to the file based SQLite database it is doing a join against. I am pretty sure this is impossible to do like this. It's okay though

Re: Remote SQL databases

2010-05-24 Thread Bob Cole
databases are on the same machine and can be accessed using the same username/password. Hope this helps. Bob Date: Sun, 23 May 2010 18:19:24 -0300, From: Andre Garzia an...@andregarzia.com Subject: Re: Remote SQL databases I did it on my 6k thousand table database... It works fine for us. I have

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-23 Thread Kay C Lan
On Sat, May 22, 2010 at 11:17 PM, Lynn Fredricks lfredri...@proactive-intl.com wrote: Valentina on On-Rev is still a topic on the table. The reality is that a malicious curveball launched from a location in California is causing a momentary distraction to all parties. Thanks Lynn for your

Re: Remote SQL databases

2010-05-23 Thread Bob Sneidar
Oh hello! You are saying you CAN do a join on a table that is not in the same database? Bob Sneidar IT Manager Calvary Chapel CM Sent from iPhone On May 22, 2010, at 18:35, Mark Wieder mwie...@ahsoftware.net wrote: Mark- Friday, May 21, 2010, 5:04:57 PM, you wrote: SELECT

Re: Remote SQL databases

2010-05-23 Thread Mark Wieder
Bob- Sunday, May 23, 2010, 12:04:03 PM, you wrote: Oh hello! You are saying you CAN do a join on a table that is not in the same database? Well, I haven't tried it, bu Mark S. implied that it was possible with two different aliases... -- -Mark Wieder mwie...@ahsoftware.net

Re: Remote SQL databases

2010-05-23 Thread Andre Garzia
I did it on my 6k thousand table database... It works fine for us. I have something like select Database1.* from DatabaseName1.Table1 as Database1, DatabaseName2.Table2 ... On Sun, May 23, 2010 at 4:34 PM, Mark Wieder mwie...@ahsoftware.net wrote: Bob- Sunday, May 23, 2010, 12:04:03 PM,

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Kay C Lan
? Because if it is a text file, then you can upload the text file to your on-rev account and then use a SQL command such as COPY to parse and load the file. You don't need a option in phpPgAdmin to do it, you can just write the SQL command there. Check out http://www.postgresql.org/docs/8.1/static

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Kay C Lan
On Sat, May 22, 2010 at 12:54 AM, Bob Sneidar b...@twft.com wrote: I wouldn't look at it that way. You can get an all day ticket at Disneyland. You can ride all the rides, or just some of them, or none at all. You can't get a cheaper ticket if you promise not to ride some of the rides. It's

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Ruslan Zasukhin
On 22/5/10 1:25 PM, Kay C Lan lan.kc.macm...@gmail.com wrote: [THE ABOVE IS HYPOTHETICAL, DISNEY DO NOT DO THIS] mySQL offers it's db free for non-profit. If I were a non-profit I would assume that it would cost me less to use mySQL than for a commercial outfit. I appreciate that for LAN

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Kay C Lan
On Sat, May 22, 2010 at 6:39 PM, Ruslan Zasukhin ruslan_zasuk...@valentina-db.com wrote: * mySQL server is free for ISP itself. but if ISP now give access to his clients, clients should pay commercial license. That seems sensible to me. I was just replying to comments made by Bob and

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Ruslan Zasukhin
On 22/5/10 2:15 PM, Kay C Lan lan.kc.macm...@gmail.com wrote: On Sat, May 22, 2010 at 6:39 PM, Ruslan Zasukhin ruslan_zasuk...@valentina-db.com wrote: * mySQL server is free for ISP itself. but if ISP now give access to his clients, clients should pay commercial license. That

RE: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Lynn Fredricks
://www.paradigmasoft.com Valentina SQL Server: The Ultra-fast, Royalty Free Database Server ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Richard Gaskin
Kay C Lan wrote: mySQL offers it's db free for non-profit. Kinda sorta. MySQL is released under the GPL, so you can grab the source for free, compile it yourself, and sell it for $1000 if you like. But there's one catch: anything you make with it must also have its source available, and

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-22 Thread Bob Sneidar
Sure but read my recent posts on the limitations of a remote SQL server. Not a speed demon by any means. On-rev SQL is really primarily intended as a backend database for you web based apps. The way I am going at it has shown me that with certain applications I face serious limitations

Re: Remote SQL databases

2010-05-22 Thread Mark Wieder
Mark- Friday, May 21, 2010, 5:04:57 PM, you wrote: SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name FROM database1.customers AS cus LEFT OUTER JOIN database2.customer_types as ctyp ON cus.Customer_Type = ctyp.Customer_Type_ID Nice one - someone actually found a use for

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-21 Thread Kay C Lan
Folks, I apologise, I post then depart for a couple of days and am unable to reply. I don't mean to be rude. Andre, Yes it's a plain tab delimited text file so I'll follow your link and give it a go. Thanks. On Thu, May 20, 2010 at 2:12 AM, Bob Sneidar b...@twft.com wrote: On-Rev is paying

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-21 Thread Bob Sneidar
I wouldn't look at it that way. You can get an all day ticket at Disneyland. You can ride all the rides, or just some of them, or none at all. You can't get a cheaper ticket if you promise not to ride some of the rides. It's kind of like that. I saw a great video of an English man trying to

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-21 Thread Richmond Mathewson
On 21/05/2010 19:54, Bob Sneidar wrote: I wouldn't look at it that way. You can get an all day ticket at Disneyland. You can ride all the rides, or just some of them, or none at all. You can't get a cheaper ticket if you promise not to ride some of the rides. It's kind of like that. I saw a

Remote SQL databases

2010-05-21 Thread Bob Sneidar
Hi all. Anyone have any idea how fast the queries to the On-Rev SQL databases are on average? I was using a method where I was looking up a key from one query of 100 records at a time and querying a mySql database at my On-Rev site ONE RECORD AT A TIME! I discovered that the queries were

Remote SQL databases

2010-05-21 Thread Mark Stuart
Hi Bob, on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote: So now I have to think about using joins. Just preface the table name that's in the other database with the database_alias_name.table_name: SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name FROM

[SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-19 Thread Kay C Lan
I'm guessing Andre is the guru to answer this one. How does one populate a postgreSQL db on On-Rev in bulk? MySQL's phpMyAdmin gives you both an Import option and the ability to enter raw SQL commands, ie LOAD DATA LOCAL INFILE, but the postgreSQL's phpPgAdmin has neither option. I'm not going

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 11:01 AM, Kay C Lan lan.kc.macm...@gmail.com wrote: Hi Kay, About postgre -- may be you can prepare db on local computer then upload to server? And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, I'd be trying to figure out how to do this with Valentina rather

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-19 Thread Kay C Lan
On Wed, May 19, 2010 at 5:06 PM, Ruslan Zasukhin ruslan_zasuk...@valentina-db.com wrote: About postgre -- may be you can prepare db on local computer then upload to server? I'm new to On-Rev and I couldn't see where the db files were stored. I'm hoping Andre or someone else can lead me in

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-19 Thread Andre Garzia
Hi There Kay, What is the format of the data? Is it a csv file or something? Because if it is a text file, then you can upload the text file to your on-rev account and then use a SQL command such as COPY to parse and load the file. You don't need a option in phpPgAdmin to do it, you can just

Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

2010-05-19 Thread Bob Sneidar
On-Rev is paying the fees to mySQL as a commercial venture, so the licensing restrictions have been satisfied. You ARE paying for mySQL use because you pay for On-Rev. Bob On May 19, 2010, at 4:07 AM, Kay C Lan wrote: To me, On-Rev is NOT a commercial DB Server, they are just a Server, if

Re: [Database] Retrieving sql statement result

2010-04-29 Thread Bob Sneidar
Hi Marcello. It's my understanding that only SQL statements that return a value of some kind will return the data you expect. To do what you are trying to do, you would need a persistent connection, and then a way to monitor that connection for any data coming back over the socket. I suppose

Re: [Database] Retrieving sql statement result

2010-04-28 Thread Sarah Reichelt
On Tue, Apr 27, 2010 at 6:36 PM, Marcello Bertoli mbert...@libero.it wrote: Hi all, I have a question about runrev database commands. Is there a way to get the result of a sql statement that doesn't retrieve data (is not a select)? For example: In a postgresql scenario I need to execute

Re: [Database] Retrieving sql statement result

2010-04-28 Thread Marcello Bertoli
On 28/apr/2010, at 11.12, Sarah Reichelt wrote: If you check the result after your revExecuteSQL statement, it should contain the data you need. Hi Sarah, thank you for your answer. the result of revExecuteSql doesn't seem to contains the information the sql engine answers and I need

[Database] Retrieving sql statement result

2010-04-27 Thread Marcello Bertoli
Hi all, I have a question about runrev database commands. Is there a way to get the result of a sql statement that doesn't retrieve data (is not a select)? For example: In a postgresql scenario I need to execute the statement: listen foo and I need to retrieve the result. It seems

Re: [SQL Yoga] Trying to get started.

2010-02-17 Thread Trevor DeVore
On Feb 16, 2010, at 3:58 PM, Andrew Kluthe wrote: Anything without a t is a view. This is a mySQL db. This is definately not all of my tables. no tables past tinventory get loaded. Confirmed with a test SQLite database. Report file: http://quality.runrev.com/qacenter/show_bug.cgi?id=8620

Re: [SQL Yoga] Trying to get started.

2010-02-17 Thread Trevor DeVore
On Feb 16, 2010, at 4:06 PM, Andrew Kluthe wrote: I cut all of the views out of my DB and got tlease to show up. Now I'm getting this error. line: 1438 of libSQLYoga Application error: 66,677,9 66,677,9 83,677,9 83,677,9,Handler: running low on memory, script aborted. 465,677,1 Is this

[SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
tlease at all in it. Is there a table limit to SQL Yoga? -- View this message in context: http://n4.nabble.com/SQL-Yoga-Trying-to-get-started-tp1557873p1557873.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Trevor DeVore
On Feb 16, 2010, at 3:10 PM, Andrew Kluthe wrote: Ok, I made an Database object, I made a connection object. Do I have to dbobject_reloadSchema before I can do this? The very first time SQL Yoga connects to your db it will import the schema. You only need to call dbobject_reloadSchema

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
this message in context: http://n4.nabble.com/SQL-Yoga-Trying-to-get-started-tp1557873p1557911.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Trevor DeVore
On Feb 16, 2010, at 3:41 PM, Andrew Kluthe wrote: I get that the schema only needs loaded once. The tlease is just a table (designated by the t in front of it). It just seems like only a small part of the schema is getting loaded into the object. I am going to try thinning the database out

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
Can't find handler? Message execution error: Error description: Handler: can't find handler -- View this message in context: http://n4.nabble.com/SQL-Yoga-Trying-to-get-started-tp1557873p1557923.html Sent from the Revolution - User mailing list archive at Nabble.com

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Trevor DeVore
On Feb 16, 2010, at 3:51 PM, Andrew Kluthe wrote: Can't find handler? Take the space out between Names and the (: put revDatabaseTableNames(dbconn_get(connection id)) -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Releasable Revolution Resources for

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
tgrnloandetailsqty tgrntickets thrcontactus thremploymentapp ticketnumberfix tinventory Anything without a t is a view. This is a mySQL db. This is definately not all of my tables. no tables past tinventory get loaded. -- View this message in context: http://n4.nabble.com/SQL-Yoga-Trying-to-get-started

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
this message in context: http://n4.nabble.com/SQL-Yoga-Trying-to-get-started-tp1557873p1557942.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url

SQL/MySQL Database Question

2010-01-21 Thread Warren Kuhl
I am trying to get the number of records that exist in 1 tables that do not exist in another table. Looking online, I saw an example of a SELECTWHERE NOT EXISTS. I have a two questions: 1) Does RR handle the scenario below? For some reason I am getting a error around the not exists (select

Re: SQL/MySQL Database Question

2010-01-21 Thread william humphrey
Did you try running your query in a SQL utility first? On Thu, Jan 21, 2010 at 3:02 PM, Warren Kuhl warrenk...@gmail.com wrote: I am trying to get the number of records that exist in 1 tables that do not exist in another table. Looking online, I saw an example of a SELECTWHERE NOT EXISTS

Re: SQL/MySQL Database Question

2010-01-21 Thread Warren Kuhl
William, Thanks for the suggestion! It was an error in my SQL which I fixed. Warren On Thu, Jan 21, 2010 at 1:35 PM, william humphrey b...@bluewatermaritime.com wrote: Did you try running your query in a SQL utility first? On Thu, Jan 21, 2010 at 3:02 PM, Warren Kuhl warrenk...@gmail.com

Re: SQL Yoga 1.0.1 Update and New Plugin

2010-01-13 Thread Trevor DeVore
On Jan 12, 2010, at 4:23 PM, Sivakatirswami wrote: Thanks! the upgrade to Hinduism Today Digital Edition, newly named Hinduism Today Navigator, owes a lot to you work (via Andre whose doing this for us) I appreciate the kind of strong support you give to everything you do. You're

Re: SQL Yoga 1.0.1 Update and New Plugin

2010-01-13 Thread Bob Sneidar
Seriously Trevor, sqlYoga is in my opinion exactly in the spirit of what Revolution SHOULD have provided end users with concerning database access. Anyone ever involved with the differing flavors of SQL and the subtleties of syntax, or who have ever tried to write SQL for complex joins knows

SQL Yoga 1.0.1 Update and New Plugin

2010-01-12 Thread Trevor DeVore
Version 1.0.1 of the SQL Yoga library is now available for download from our site. This version includes a few new features, some bug fixes and a new plugin. You can learn more at the following url: http://bit.ly/6bXMiJ -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http

Re: SQL Yoga 1.0.1 Update and New Plugin

2010-01-12 Thread Sivakatirswami
Trevor DeVore wrote: Version 1.0.1 of the SQL Yoga library is now available for download from our site. This version includes a few new features, some bug fixes and a new plugin. You can learn more at the following url: http://bit.ly/6bXMiJ Aloha, Trevor: Thanks! the upgrade to Hinduism

Re: SQL Yoga 1.0.1 Update and New Plugin

2010-01-12 Thread william humphrey
Thanks for this new plug in. I love the improvement in the IDE! ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Can a SQL data base update app when there is a change?

2009-12-13 Thread Josh Mellicker
I think the best method is to have a datetimestamp column in the remote database, which you then have locally when you do a query. Then, periodically, your app does the same query, but ONY finds records that have a datetimestamp later than the last time you updated (very fast, since the record

Can a SQL data base update app when there is a change?

2009-12-10 Thread Bill Vlahos
I have an app that talks to a MySQL data base. This is fine for posting queries and updating records. Is there a mechanism that tells my application when someone else updates the data base? When that happens I want to update the display in my app with the changes. I can do this with periodic

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread Pierre Sahores
Hi Bob, For security reasons, the on-rev servers are set to accept localhost MySQL connexions only. To let your stack bind the MySQL server, she need to tell to an irev script what to query/request from the db. Works like a charm in this way. Best Regards, Le 22 nov. 09 à 19:12, Bob

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread stephen barncard
Not true. Security issues aside, one can use % as the ip address to accept any address for a MySQL client connection. See Remote Database Access Hosts in the Cpanel. 2009/11/22 Pierre Sahores psaho...@free.fr Hi Bob, For security reasons, the on-rev servers are set to accept localhost MySQL

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread George C Brackett
And I can verify from experience that this approach works just fine. George On Nov 23, 2009, at 11:35 AM, stephen barncard wrote: Not true. Security issues aside, one can use % as the ip address to accept any address for a MySQL client connection. See Remote Database Access Hosts in the Cpanel.

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread stephen barncard
and I should add that if one has to only have to deal with a single or series (comma delimited) of remote IP, use that for much better security. - Stephen Barncard San Francisco http://houseofcubes.com/disco.irev 2009/11/23 George C Brackett gbrack...@luceatlux.com And

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread Pierre Sahores
Why not but the irev or php or... ways lets us a safer solution ;-) Le 23 nov. 09 à 17:35, stephen barncard a écrit : Not true. Security issues aside, one can use % as the ip address to accept any address for a MySQL client connection. See Remote Database Access Hosts in the Cpanel.

Connecting directly to On-Rev SQL

2009-11-22 Thread Bob Sneidar
Hi all. I have browsed through the Use Rev posts but can't seem to find any info on this. I'd like to connect directly to the On-Rev MySQL from my Rev stacks. What is the URL or address to do that? Bob___ use-revolution mailing list

Re: Connecting directly to On-Rev SQL

2009-11-22 Thread stephen barncard
One can create any number of MySQL databases in the ON-REV control panel. This arrangement is typical of ISP hosted MySQL servers: One has to set up each new database through the control panel, One cannot create new databases from within a MySQL instance here. One can create as many tables as

Does SQL Yoga works with Linux?

2009-10-13 Thread Andre Garzia
Hello Folks, Can anyone tell me if SQL Yoga will work with Rev Enterprise 3.5.0 on Linux? Cheers andre -- http://www.andregarzia.com All We Do Is Code. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe

Re: Does SQL Yoga works with Linux?

2009-10-13 Thread Trevor DeVore
On Oct 13, 2009, at 3:46 PM, Andre Garzia wrote: Hello Folks, Can anyone tell me if SQL Yoga will work with Rev Enterprise 3.5.0 on Linux? I haven't tested it myself yet but I don't know why it wouldn't. Nothing platform specific is going on in the code. As long as RevDB works SQL Yoga

Re: Does SQL Yoga works with Linux?

2009-10-13 Thread Andre Garzia
andre On Tue, Oct 13, 2009 at 4:48 PM, Trevor DeVore li...@mangomultimedia.comwrote: On Oct 13, 2009, at 3:46 PM, Andre Garzia wrote: Hello Folks, Can anyone tell me if SQL Yoga will work with Rev Enterprise 3.5.0 on Linux? I haven't tested it myself yet but I don't know why it wouldn't

Re: Does SQL Yoga works with Linux?

2009-10-13 Thread Trevor DeVore
On Oct 13, 2009, at 3:58 PM, Andre Garzia wrote: I just tried opening one of my apps in the Linux 3.5.0 and it broke, but I guess it was GLX APP Framework the problem, I think it has some platform specific code in it right? It failed because it could not create some root folder thingy,

Re: Does SQL Yoga works with Linux?

2009-10-13 Thread Peter Alcibiades
I have a copy, but health difficulties have prevented me from doing anything much besides firing it up (in Debian Squeeze). Which seemed superficially fine. Maybe will get further in the next few weeks. Peter Andre Garzia-3 wrote: Hello Folks, Can anyone tell me if SQL Yoga will work

[ANN] SQL Yoga Now Supports More Databases, Additional Documentation

2009-10-09 Thread Trevor DeVore
Last night a new version of SQL Yoga was uploaded with support for Valentina client and server connections. With the addition of Valentina the list of supported databases is now: * MySQL * PostGreSQL * SQL Server (ODBC) * SQLite * Valentina local and client I recommend using the latest beta

RE: [ANN] SQL Yoga Now Supports More Databases, Additional Documentation

2009-10-09 Thread Lynn Fredricks
Last night a new version of SQL Yoga was uploaded with support for Valentina client and server connections. With the addition of Valentina the list of supported databases is now: * MySQL * PostGreSQL * SQL Server (ODBC) * SQLite * Valentina local and client I recommend using

Re: [ANN] SQL Yoga Now Supports More Databases, Additional Documentation

2009-10-09 Thread Neal Campbell
...@dxbase.fogbugz.com Abroham Neal forums: http:/www.abrohamnealsoftware.com/community/ DX Cluster: dxc.k3nc.com port 23 On Fri, Oct 9, 2009 at 1:36 PM, Lynn Fredricks lfredri...@proactive-intl.com wrote: Last night a new version of SQL Yoga was uploaded with support for Valentina client and server

Re: Support for SQL Server in SQL Yoga

2009-09-19 Thread Len Morgan
Thanks for this Trevor!!! I'll give it a workout and report back! len morgan Trevor DeVore wrote: Just a note for those who have been asking about SQL Server support in SQL Yoga. I just uploaded 1.0.0 build 5 BETA. With this version SQL Server accessed through RevDB using ODBC is passing

Re: Support for SQL Server in SQL Yoga

2009-09-19 Thread George C Brackett
asking about SQL Server support in SQL Yoga. I just uploaded 1.0.0 build 5 BETA. With this version SQL Server accessed through RevDB using ODBC is passing unit tests. You can find links to downloads and the docs (works in progress, finished before release) here: http

Re: Support for SQL Server in SQL Yoga

2009-09-19 Thread Trevor DeVore
On Sep 19, 2009, at 8:56 AM, George C Brackett wrote: The 'download demo' is listed on the page as 1.0.0 build 3 -- is that just a typo? Is this the page purchasers should look at to find out about new versions? I'm eager to keep up to date... I forgot to update the main SQL Yoga page

Support for SQL Server in SQL Yoga

2009-09-18 Thread Trevor DeVore
Just a note for those who have been asking about SQL Server support in SQL Yoga. I just uploaded 1.0.0 build 5 BETA. With this version SQL Server accessed through RevDB using ODBC is passing unit tests. You can find links to downloads and the docs (works in progress, finished before

Database connection fails with MS SQL 2008

2009-08-27 Thread mfstuart
Hi all, Anyone know if RunRev 3.5 can successfully connect to MS SQL 2008? So far I haven't been able to. Platform: WINXP Regards, Mark Stuart -- View this message in context: http://www.nabble.com/Database-connection-fails-with-MS-SQL-2008-tp25179419p25179419.html Sent from the Revolution

Re: Database connection fails with MS SQL 2008

2009-08-27 Thread mfstuart
connect to MS SQL 2008? So far I haven't been able to. Platform: WINXP Regards, Mark Stuart -- View this message in context: http://www.nabble.com/Database-connection-fails-with-MS-SQL-2008-tp25179419p25180968.html Sent from the Revolution - User mailing list archive at Nabble.com

SQL Yoga Query

2009-08-24 Thread Josep
in context: http://www.nabble.com/SQL-Yoga-Query-tp25116856p25116856.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe

Re: SQL Yoga Query

2009-08-24 Thread Trevor DeVore
On Aug 24, 2009, at 10:17 AM, Josep wrote: I'm try to retrieve all the records from a table named products Hi Josep, Going forward you may want to post SQL yoga related questions in the forums I've set up for it: http://www.bluemangolearning.com/forums/viewforum.php?id=15 And from

Re: SQL Yoga Query

2009-08-24 Thread Josep
Hi Trevor, I reply you in the other forum. Salut, Josep -- View this message in context: http://www.nabble.com/SQL-Yoga-Query-tp25116856p25123674.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing

PostgreSQL support in SQL Yoga

2009-08-21 Thread Trevor DeVore
A number of people have asked about PostgreSQL support in SQL Yoga. A PostgreSQL database now passes all of the unit tests and I've updated the SQL Yoga download. Latest download, link to the new forum, link to webinar recording, sample application and docs are all available at: http

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-20 Thread Trevor DeVore
On Aug 17, 2009, at 11:15 AM, Trevor DeVore wrote: In September Blue Mango Learning Systems will be releasing a database library that will change how you work with databases in Revolution. Join us Wednesday for a webinar where we will introduce SQL Yoga and announce the public beta leading

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-18 Thread David Beck
that will change how you work with databases in Revolution. Join us Wednesday for a webinar where we will introduce SQL Yoga and announce the public beta leading up to release. ___ use-revolution mailing list use-revolution@lists.runrev.com Please

[ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread Trevor DeVore
In September Blue Mango Learning Systems will be releasing a database library that will change how you work with databases in Revolution. Join us Wednesday for a webinar where we will introduce SQL Yoga and announce the public beta leading up to release. Find out more on our Releasable

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread Peter Alcibiades
Trevor, what are the system requirements? Peter Trevor DeVore wrote: In September Blue Mango Learning Systems will be releasing a database library that will change how you work with databases in Revolution. Join us Wednesday for a webinar where we will introduce SQL Yoga

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread Trevor DeVore
On Aug 17, 2009, at 1:44 PM, Peter Alcibiades wrote: Trevor, what are the system requirements? SQL Yoga sits on top of RevDB. It will require at least version 3.5 of Revolution. -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Developer Resources: http

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread viktoras d.
sorry for impatience, is it anything like visual query builder tool? :-) All the best! Viktoras Trevor DeVore wrote: On Aug 17, 2009, at 1:44 PM, Peter Alcibiades wrote: Trevor, what are the system requirements? SQL Yoga sits on top of RevDB. It will require at least version 3.5

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread Trevor DeVore
On Aug 17, 2009, at 2:20 PM, viktoras d. wrote: sorry for impatience, is it anything like visual query builder tool? :-) I'm not familiar with visual query builder but there are features the will build queries for you. There are no visual components to SQL Yoga though, it is a library

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread william humphrey
but there are features the will build queries for you. There are no visual components to SQL Yoga though, it is a library. -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Developer Resources: http://revolution.bluemangolearning.com

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread Trevor DeVore
On Aug 17, 2009, at 3:17 PM, william humphrey wrote: Will it also work with Valentina? Before release, yes. I have all of the Valentina code for connections, etc. included but I have yet to add Valentina to the Unit Testing stack. -- Trevor DeVore Blue Mango Learning Systems

Re: [ANN] SQL Yoga: A Flexible Database Library for Revolution

2009-08-17 Thread william humphrey
Great. I want to test Valentina on a stack I used your old database library for with SQLite and which needs to be converted to Valentina. Sounds like fun! On Mon, Aug 17, 2009 at 3:24 PM, Trevor DeVore li...@mangomultimedia.comwrote: On Aug 17, 2009, at 3:17 PM, william humphrey wrote: Will

  1   2   3   4   5   >