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

2010-10-28 Thread Ruslan Zasukhin
ema is pain ... 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

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

2010-10-28 Thread Ruslan Zasukhin
aste space. * but original task was add 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

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 a

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

2010-10-28 Thread Bob Sneidar
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 won

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

2010-10-28 Thread Bob Sneidar
our schema, 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

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 of

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

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 to

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: http://lists.runrev.com/mailman/listinfo/us

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 th

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 de

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

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, p

Re: Remote SQL databases

2010-05-25 Thread Mark Wieder
ase and a SQLite 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

Re: Remote SQL databases

2010-05-25 Thread Bob Sneidar
QLcommand > put revDataFromQuery(tab, return, tConId, tSQLcommand) into tItems > > I did not find it necessary to give the databases alias names. > In my situation, both databases are on the same machine and can be accessed > using the same username/password. > Hope this helps. >

Re: Remote SQL databases

2010-05-24 Thread Bob Cole
ems I did not find it necessary to give the databases alias names. In my situation, 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 Subject: Re: Remote SQL databases I

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 t

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-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 wrote: > Bob- > > Sunday, May 23, 2010, 12:04:03 PM, you wrote: > > > Oh he

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 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 wrote: Mark- Friday, May 21, 2010, 5:04:57 PM, you wrote: SELECT cus.Customer_Number, cus.Customer_Name,

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

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

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: [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 Lynn Fredricks
their own. Best regards, Lynn Fredricks President Paradigma Software http://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 u

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" 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 seem

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

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" 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 use, a non-profit c

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

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

2010-05-22 Thread Kay C Lan
t; 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://

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 database1.custo

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

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

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 ge

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 wrote: > On-Rev is paying the fees to my

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, i

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

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 m

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" 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 than > postgreSQL, es

[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.

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 su

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

Re: [Database] Retrieving sql statement result

2010-04-28 Thread Sarah Reichelt
On Tue, Apr 27, 2010 at 6:36 PM, Marcello Bertoli 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 scen

[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.

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 error

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

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

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 t

Re: [SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
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 to

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 if

[SQL Yoga] Trying to get started.

2010-02-16 Thread Andrew Kluthe
MANY in here because of the different views for reporting). When I copy and paste the schema listed in the plugin it cannot find "tlease" at all in it. Is there a table limit to SQL Yoga? -- View this message in context: http://n4.nabble.com/SQL

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

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

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

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 welcome.

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: http://lists.runrev.com/mailman/list

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

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: 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 s

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 qu

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. 20

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 > And I can verify from exper

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
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 > Hi Bob, > > For security reasons, the on-rev servers are set to accept localhost MySQL > connexion

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 Sne

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 one

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 use-revolution@li

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

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, and

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 wrote: > 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

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

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: [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 Va

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

[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: 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 mai

Re: Support for SQL Server in SQL Yoga

2009-09-19 Thread George C Brackett
e 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 releas

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 pa

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

Re: Database connection fails with MS SQL 2008

2009-08-27 Thread mfstuart
w 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-tp25179419p25180968.html Sent from

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 Revol

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

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/viewforu

SQL Yoga Query

2009-08-24 Thread Josep
ot;dg_test" of me to theRegionDataA else answer "Error populating regions:" && theError end if But nothing happen or the protected stack appear... What I'm doing wrong? Salut, Josep -- View this message in context: http://www.nabble.com/SQL-Yoga-Query-tp2511

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:

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
brary 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 P

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 wrote: > On Aug 17, 2009, at 3:17 PM, william humphrey wrote: > > Will it also work with Valen

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 ScreenSteps

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

2009-08-17 Thread william humphrey
"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. > > -- > Trevor DeVore > Blue Mango Learning Systems > ScreenSteps: http://www.screensteps

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 S

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 vers

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

[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

  1   2   3   4   5   >