Database Query Builder

2008-08-05 Thread Kurt Kaufman
"...To start, I'll read the manual, do the tutorials, etc. before I ask additional questions." My printed user manual arrived, and the information I needed is right there at sections 8.5.1 and 8.5.2. I don't know how I missed the first sentence at 8.5.1! Maybe there's something special abou

Database Query Builder

2008-08-01 Thread Kurt Kaufman
Thanks, Jan. I'm looking into the possibility of redesigning an accounts-receivable program that currently is written entirely in Revolution. I have it designed to allow a limited form of multi-user access, but it's cumbersome, and a switch to a SQL database would leverage that arrangemen

Re: Database Query Builder

2008-08-01 Thread Jan Schenkel
--- Kurt Kaufman <[EMAIL PROTECTED]> wrote: > Is the Database Query Builder designed to be used > only within the IDE, > or can its functionality be exported into a > standalone application (as > a sort of "core" for a stack --> standalone)? > Sorry if th

Database Query Builder

2008-07-31 Thread Kurt Kaufman
Is the Database Query Builder designed to be used only within the IDE, or can its functionality be exported into a standalone application (as a sort of "core" for a stack --> standalone)? Sorry if this is a FAQ; I haven't fully explored this area of Revol

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-24 Thread Jerry Daniels
it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-24 Thread Jerry Daniels
wl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting the defaultFolder. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this ur

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
Sarah Ignore that question please. I looked it up. Bill On Sat, Mar 22, 2008 at 6:31 PM, william humphrey <[EMAIL PROTECTED]> wrote: > Can you tell me why specialFolderPath("Documents") has "Documents" in > there? Is it a way to set that type of folder path as opposed to one that is > an applica

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
Can you tell me why specialFolderPath("Documents") has "Documents" in there? Is it a way to set that type of folder path as opposed to one that is an application for RunRev to use instead of a Document? ___ use-revolution mailing list use-revolution@lists

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
Thanks for the explanation. So GLX2 changed my default folder without notifying me. That's interesting. When it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the databas

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread Sarah Reichelt
On Sun, Mar 23, 2008 at 1:26 AM, william humphrey <[EMAIL PROTECTED]> wrote: > I just changed the subject > I just updated to GLX 2.1b40 and it did something (automatically) that I > realize now is very cool but which caused me some consternation. It made a > GLX2 Work Spaces folder in the "My

GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
uff will tell me a better way to say put "/Users/administrator/Documents/My\ Revolution\ Studio/Plugins/GLX2\ Work\ Spaces/shipping.sqlite" into tDBA["FilePath"] for the SQLite stuff I'm doing without using RunRev's built in Database Query Builder. Ideally there would just be

Problem building stand alone database application using database query builder

2007-09-28 Thread Sadhunathan Nadesan
Greetings, Wondering if anyone can shed some light on this problem? Context In the past building database apps I have coded everything, meaning, scripted the database connection, the queries to add, modify, delete, search, etc. They work. Problem This time I'm trying to build a simple app

Re: How to fill out Database Query Builder fields

2006-12-08 Thread Bill
Start with reading the PDF. On 12/8/06 5:10 PM, "Reinhold Venzl-Schubert" <[EMAIL PROTECTED]> wrote: > Hi Bill, > > thank you for your consolation. I switched off Revolution for 3 days > and than I swore never to use any QueryBuilder in my life. > > Ok, I will use Trevors library, but how I ha

Re: How to fill out Database Query Builder fields

2006-12-08 Thread Reinhold Venzl-Schubert
Hi Bill, thank you for your consolation. I switched off Revolution for 3 days and than I swore never to use any QueryBuilder in my life. Ok, I will use Trevors library, but how I have to put it? I found of a Change Log.txt, a folder docs with the files "bmm-cod.css", "Getting

Database Query builder

2006-12-08 Thread baleareninsel
orrect and works fine But, and that´s the question: How to open a new (existing) Card to show the datas behind the customernumber I think I can´t mix SQL with "RunRev" variables otherwise I would say in the Database query builder: SELECT * from Customers where customernumber = Cstm_nr T

Re: How to fill out Database Query Builder fields

2006-12-04 Thread Bill
Reinhold Don't give up. I use SQLite3 and it worked great with RunRev and the ALTSQL plug in. Now I upgraded to 2.7.4 and after moving my datafile (has to be in the same folder as RunRev main file) and putting the altsqlite plugins where they go it works fine But, I can't help you with the q

Re: How to fill out Database Query Builder fields

2006-12-04 Thread chris bohnert
Reinhold, Between 2.7.1 and 2.7.2 Runrev changed the configuration for revdb. As far as I know altSqlite and QueryBuilder have always worked when configured as necessary. Support for altSqlite, altBrowser and altFont have officially become part of Runrev as of Dec. 1st. They can be reached at

Re: How to fill out Database Query Builder fields

2006-12-04 Thread Reinhold Venzl-Schubert
Reinhold, You should replace the line in your "Database Drivers.txt" file altSQlite3,dbsqlite3.bundle with sqlite3,dbsqlite3.bundle This combined witht he previous parameters and your test stack works fine on my machine running Rev 2.7.2 on 10.4.9 -- cb Hi Chris, I found 5 files "Datab

Re: How to fill out Database Query Builder fields

2006-12-03 Thread chris bohnert
Reinhold, You should replace the line in your "Database Drivers.txt" file altSQlite3,dbsqlite3.bundle with sqlite3,dbsqlite3.bundle This combined witht he previous parameters and your test stack works fine on my machine running Rev 2.7.2 on 10.4.9 -- cb On 12/3/06, Reinhold Venzl-Schubert <

Re: How to fill out Database Query Builder fields

2006-12-03 Thread Reinhold Venzl-Schubert
Hi Sarah, "altSQLite3" is the select of the QueryBuilder and The name "sqlite3" is necessary to connect to the Database. It is the script used in the SQlite3 Demo of Altuit. Reinhold This script connects my stack to my database: put revdb_connect("sqlite3","TestDB.db","[EMAIL PROTECTED]

Re: How to fill out Database Query Builder fields

2006-12-03 Thread Reinhold Venzl-Schubert
he UB version. Does everything work correctly if you script the database commands with revdb? -- cb On 12/2/06, Reinhold Venzl-Schubert <[EMAIL PROTECTED]> wrote: Hi! I need some help in filling out the Database Query Builder correctly. This script connects my stack to my dat

Re: How to fill out Database Query Builder fields

2006-12-02 Thread chris bohnert
nning querybuilder on the UB version. Does everything work correctly if you script the database commands with revdb? -- cb On 12/2/06, Reinhold Venzl-Schubert <[EMAIL PROTECTED]> wrote: Hi! I need some help in filling out the Database Query Builder correctly. This script connects my

Re: How to fill out Database Query Builder fields

2006-12-02 Thread Sarah Reichelt
This script connects my stack to my database: put revdb_connect("sqlite3","TestDB.db","[EMAIL PROTECTED] online.de","...xyz...") into tConID Therefore I filled out in that way: Name: Fragen Type: altSQLite3 Host: /Users/rvs/Documents/5-Fächer-Lernprogramm/5FLK-

How to fill out Database Query Builder fields

2006-12-02 Thread Reinhold Venzl-Schubert
Hi! I need some help in filling out the Database Query Builder correctly. This script connects my stack to my database: put revdb_connect("sqlite3","TestDB.db","[EMAIL PROTECTED] online.de","...xyz...") into tConID Therefore I filled out i

Re: AltSQLite and Database Query Builder

2006-06-06 Thread Bill
On 6/6/06 12:08 PM, "Michael Mandaville" <[EMAIL PROTECTED]> wrote: > I am currently using altSQLite3 and trying to see if I can use the Database > Query Builder to hook it into. I have a few questions. > > > 1. Once the database has been created, is it best

AltSQLite and Database Query Builder

2006-06-06 Thread Michael Mandaville
I am currently using altSQLite3 and trying to see if I can use the Database Query Builder to hook it into. I have a few questions. 1. Once the database has been created, is it best placed in the same folder as the Applications Mainstack? Or in the folder with the Revolution Application? 2

How to fill in the Database Query Builder?

2006-06-03 Thread Reinhold Venzl-Schubert
Hi! My trial to build a Database Query to an altSQLite-Database fails, but Revolution stores it somewhere. Because when I save my stack and open it again, I got the same error message and the Database Query Builder shows me the failed Query. Therefore I looked for the place where

How to fill in the Database Query Builder?

2006-06-02 Thread Reinhold Venzl-Schubert
Hi! I just go my first steps in using database with Revolution. I bought a license von SQLite from Altuit and created my first database "AppReg3.db" Then I created a stack and want to build a database query with the Database Query Builder. I studied the User Guide and the ap

Re: Database Query Builder

2005-08-27 Thread Bill
That's a good question. It would be nice if the query builder didn't crash when you search for a record that isn't there. But in order to search for a record with the query builder you have to use "revsetSQLofQuery" and I believe that isn't a supported command (maybe because it isn't finished) but

Re: Database Query Builder

2005-08-27 Thread Trevor DeVore
On Aug 27, 2005, at 5:03 PM, Scott Kane wrote: Hi Bill, Thanks for the info. Has this issue with Query Builder that you mention been raised as a bug with Rev? I'm going to take a look at "libDatabase" - but will it work with altSQL - because I'm adament to use that library, it's so nicely don

RE: Database Query Builder

2005-08-27 Thread Scott Kane
Hi Bill, Thanks for the info. Has this issue with Query Builder that you mention been raised as a bug with Rev? I'm going to take a look at "libDatabase" - but will it work with altSQL - because I'm adament to use that library, it's so nicely done. Scott __

Re: Database Query Builder

2005-08-27 Thread Bill
I use the database query builder a lot but have been gradually shifting over to "libDatabase is a database abstraction library" by Trevor DeVore which is much better than the database query builder for everything except easily building a card that goes through each record of a database

Database Query Builder

2005-08-27 Thread Scott Kane
Hi folks, I'm using altSQLLite for the database. One thing I can't seem to get right is the path to the table (it's in the same path as the executable). The Database Query Builder only takes a fixed path for the location of the database. i.e. "C:\MyFolder\MyApp\mytable.db

Re: Database Query Builder -- errors

2005-06-13 Thread Jan Schenkel
blename1.shipID and another one as > tablename2.shipID even though SQL > is happy with this the database query builder update > feature will choke. > [Sorry for the late reply, jsut cleaning the backlog] You're touching on one of the main drawbacks of SQL databases: their relation

Re: Database Query Builder -- errors and aliases

2005-06-06 Thread Bill Humphrey
s use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. You could probably get around this by doing: S

Re: Database Query Builder -- errors

2005-06-06 Thread Bill Humphrey
e else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the databas

Re: Database Query Builder -- errors

2005-06-06 Thread Trevor DeVore
tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. You could probably get around this by doing: SELECT tablename1.shipID AS ShipID1, tablename2.shipID AS ShipID2... -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED

Database Query Builder -- errors

2005-06-06 Thread Bill Humphrey
the database query builder update feature will choke. And if you use SQLite which won't allow you to alter tables then you will be in trouble. Also when you have many joins in your query use the index for the fields you are most likely to want to change (this error is not as perf

Re: Database Query Builder 2

2005-05-21 Thread HyperChris
Thank you Jan. I will do that with BZ. I know how to do the sql connect using the functions but I think the DBQ could be such a boon for new users that I really want to see it work. As we say in my country "YOU are the man!" Jan writes: > Hi Chris, > > This problem would happen on MacOS, of cou

Re: Database Query Builder 2

2005-05-21 Thread Jan Schenkel
--- [EMAIL PROTECTED] wrote: > [snip] > > So now I can make changes but I still have one major > hickup. If I click a > button that is linked to the database such as a Next > button set to 'Move to Next > Record' then the field doesn't appear to ever get > the close message needed to > trigger

Database Query Builder 2

2005-05-20 Thread HyperChris
Jan was kind enough to point me to the check box 'Cache record set' as a means of getting the DQB to upload changes made to a field when the 'Update Field after editing' option is checked in the Database section of the inspector. I had thought Cache'ing the record set meant it would NOT be rech

Re: DataBase Query Builder

2005-05-15 Thread Jan Schenkel
get around this? Thank you. > One of the problems is that when a script updates the data in the back-end database, the corresponding data in the revdb cursor is not updated. You can work around this by ticking the 'Cache record set' checkbox in the database query builder. However, it

Re: DataBase Query Builder

2005-05-13 Thread Bill
I have a little button that says "refresh" which I have to push. I never did automate it because it takes so long. On 5/12/05 11:10 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > It doesn't look like an auto Refresh of the query was ever incorporated > into the DB Query Builder. Changes to

DataBase Query Builder

2005-05-12 Thread hyperchris
It doesn't look like an auto Refresh of the query was ever incorporated into the DB Query Builder. Changes to a field, which do update the database, are not visible when you come back to that record. Is there a simple way to get around this? Thank you. ___

RE: Database Query Builder, commit changes

2005-05-02 Thread Jan Schenkel
--- michael parent <[EMAIL PROTECTED]> wrote: > Hello Jan, I did not check 'cache record set" as I > will be opening many > different Db files. When I do a change and either > click refresh query > from Query Builder or through a Button set to the > auto refresh action > from Query Builder the orig

RE: Database Query Builder, commit changes

2005-05-02 Thread michael parent
arent Read Naturally 1-800-788-4085 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Schenkel Sent: Monday, May 02, 2005 1:45 PM To: How to use Revolution Subject: Re: Database Query Builder, commit changes --- Michael Parent <[EMAIL PROTECTED]> wro

Re: Database Query Builder, commit changes

2005-05-02 Thread Jan Schenkel
--- Michael Parent <[EMAIL PROTECTED]> wrote: > Hello, all I need to make some simple changes to a > Valentina DB, the > Query builder is a great tool and I have everything > set to open the > tables and edit the fields. The problem comes when I > am saving the > changes back. If I use the auto edi

Database Query Builder, commit changes

2005-05-02 Thread Michael Parent
Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the change

RE: MySQL Database Query Builder Question

2005-04-28 Thread Stephen Barncard
Dreamhost. <$10/month for all goodies. Great dedicated deals too. I host 15 sites there. Even the 'shared' hosting rocks... Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick ___ use-revolution mai

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
Hi Martin, I just had a look at the feature matrix provided by your hosting company and an upgrade may in fact be required, depending on the hosting package you have now Bummer. :( -Doc- On 4/28/05, Martin McCarrick <[EMAIL PROTECTED]> wrote: > Hi Docmann > > It seems that I cant even use p

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
nerve's have been taken to the > > limit with >> call centre's. I would love to speak to an English > > speaking person who I can >> understand & who isn't simply > > referencing a FAQ (that I've already > > studied) >

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
5 10:49 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hello Xavier, Actually there is a link directly from the main phpMyAdmin page where you can check and or change the status (assuming you have the right access privilages). I know that on our LAN

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
have been taken to the limit > > with > > >> call centre's. I would love to speak to an English speaking person who I > > can > > >> understand & who isn't simply referencing a FAQ (that I've already > > studied) > > >> to provide ans

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
p; who isn't simply referencing a FAQ (that I've already > studied) > >> to provide answers. > >> > >> I think id like to simply change ISP (out the frying pan!) > >> > >> Thanks for your help > >> > >> Martin

Re: MySQL Database Query Builder Question

2005-04-28 Thread xbury . cs
t;> >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> [EMAIL PROTECTED] >> Sent: 28 April 2005 09:18 >> To: How to use Revolution >> Subject: RE: MySQL Database Query Builder Question >> >&

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
imply change ISP (out the frying pan!) > > Thanks for your help > > Martin > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 28 April 2005 09:18 > To: How to use Revolution > Subject: R

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very effi

RE: MySQL Database Query Builder Question

2005-04-28 Thread xbury . cs
ED] >[mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt >Sent: 28 April 2005 05:00 >To: How to use Revolution >Subject: Re: MySQL Database Query Builder Question > >Hi Martin, > >> I'm trying to connect to my database which is hosted by >> oneandone.co.uk

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
Re: MySQL Database Query Builder Question Hi Martin, > I'm trying to connect to my database which is hosted by > oneandone.co.uk. I'm using the database query builder in RR. > > I set the name (Contact), > host (db141.oneandone.co.uk) - this is the actual server name Data

Re: MySQL Database Query Builder Question

2005-04-28 Thread xbury . cs
Note that some ISPs block this capability... Mine does... cheers Xavier On 28.04.2005 06:00:02 use-revolution-bounces wrote: >Hi Martin, > >> I'm trying to connect to my database which is hosted by >> oneandone.co.uk. I'm >> using the database query builder in

Re: MySQL Database Query Builder Question

2005-04-27 Thread Sarah Reichelt
Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () Whe

MySQL Database Query Builder Question

2005-04-26 Thread Martin
Hi, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I tr

BUG: Database Query Builder Feature Missing on 2.2.1...

2004-07-21 Thread Andre Garzia
Hi Folks, If you look into the documentation on Databases on the rev docs under "About connecting to and using SQL Databases" you'll see an article about Database Query Builder, under the topic "Displaying automatic query data" you'll that there's a specific p

Re: Database query builder not really a bug just not finished

2004-07-21 Thread Andre Garzia
card. It worked fine, but now with the "show all" missing, I think I'll have to code it by hand (and not by mouse as I wanted). cheers andre On Jul 21, 2004, at 3:42 PM, Bill wrote: On 7/21/04 1:38 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: is anyone

Database query builder not really a bug just not finished

2004-07-21 Thread Bill
On 7/21/04 1:38 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > is anyone here using Database Query Builder on Rev 2.2.1? I am using it > and using it to display the contents of a query in a nice listbox > field. The query should return 3 rows (it does that on php

Database Query Builder bug - only returning one row, and not updating...

2004-07-21 Thread Andre Garzia
Hi Folks, is anyone here using Database Query Builder on Rev 2.2.1? I am using it and using it to display the contents of a query in a nice listbox field. The query should return 3 rows (it does that on phpMyAdmin, the same query). It returns only one row on rev. Also I am making use of the

Re: HELP!!! (was Re: is Database Query Builder bugged for Rev 2.2.x?)

2004-07-14 Thread Jan Schenkel
--- Andre Garzia <[EMAIL PROTECTED]> wrote: > > Hi Folks, > > I think my Stack is damaged, I managed to use the > Query Builder with a > new stack, but with this stack it does not work > up... even on Rev 2.1. > > I think Revolution exploded when I was working with > this stack sometime > ago

HELP!!! (was Re: is Database Query Builder bugged for Rev 2.2.x?)

2004-07-12 Thread Andre Garzia
a old project of mine for I decided to take it to the summit. I was going to update the Queries I made with Database Query Builder so that they reflect my new MySQL home, but guess what? Pressing the "+" button of the Query Builder does nothing at all... I quited revolution, launche

is Database Query Builder bugged for Rev 2.2.x?

2004-07-12 Thread Andre Garzia
Hi Folks, I just opened a old project of mine for I decided to take it to the summit. I was going to update the Queries I made with Database Query Builder so that they reflect my new MySQL home, but guess what? Pressing the "+" button of the Query Builder does nothing at all...

Re: How to change Database Query Builder connection info at runtime?

2004-04-03 Thread Andre Garzia
Hi Andre, As I remembered looking into this before for someone, I dug up the relevant posts from the mailing list archive : Hope this helpe

Re: How to change Database Query Builder connection info at runtime?

2004-04-03 Thread Jan Schenkel
--- Andre Garzia <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I'll be deploying a simple DB app for an enterprize > here at Brazil but > they do not know where their mySQL server will be > running, is there a > way that I can change Database Query Builder > conn

How to change Database Query Builder connection info at runtime?

2004-04-03 Thread Andre Garzia
Hi Folks, I'll be deploying a simple DB app for an enterprize here at Brazil but they do not know where their mySQL server will be running, is there a way that I can change Database Query Builder connection info at runtime? this way I could just pop a dialog asking for the info at startu

Re: Two Questions on Database Query Builder

2004-01-12 Thread Andre Garzia
On Jan 12, 2004, at 8:40 AM, Jan Schenkel wrote: Have you tried ? *grin* Just tried it here, and it seems to work just fine, allowing you to fetch fields from both tables when you link fields to the query. Cheers, and thanks in advance. Andre Alves Garzia à 2003 à BRAZIL http://www.soapdog.org

Re: Two Questions on Database Query Builder

2004-01-12 Thread Jan Schenkel
-revolution/2003-December/026932.html> <http://lists.runrev.com/pipermail/use-revolution/2003-December/026982.html> > And what about SQL joins, if I try to > use something like > "SELECT * FROM names, projects WHERE > projects.manager = names.id" will > it work in t

Two Questions on Database Query Builder

2004-01-11 Thread Andre Garzia
Hi Folks, Is there a way to change connections parameters (server, user, pass) at run time? And what about SQL joins, if I try to use something like "SELECT * FROM names, projects WHERE projects.manager = names.id" will it work in the Database Query Builder, like being able to s

Is there a func for changing Database Query Builder connection parameters at runtime?

2004-01-10 Thread Andre Garzia
Hi revFolks, I am making an app (Called DataJunior, nice app, http://www.soapdog.org/blog for info) which uses a mix of DB handlers and Database Query Builder stuff... This application is a mix of substacks, each substack is like an self-contained application dealing with a very specific

Re: Database Query Builder

2003-12-08 Thread [EMAIL PROTECTED]
Tnx Jan, This works! > From: Jan Schenkel <[EMAIL PROTECTED]> > Reply-To: How to use Revolution <[EMAIL PROTECTED]> > Date: Sat, 6 Dec 2003 03:13:33 -0800 (PST) > To: How to use Revolution <[EMAIL PROTECTED]> > Subject: Re: Database Query Builder > > --

Don't everyone loves undocumented features (was Re: Database Query Builder)

2003-12-06 Thread Andre Garzia
Jan, this tips are forming what I call the "The Black Voodoo Book of Revolution Internal tricks & other time sparing code", you and the other revGurus out there got your own mailbox folder here where I store every bit of undocumented code that I see (I might need it later). We should put them

Re: Database Query Builder

2003-12-06 Thread Jan Schenkel
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Jan, > > It's not working, I don't think I understand how to > use this... :( > When I setup a databse-connection and use > put revQueryLongName(cREVDatabaseQuery["dbhost"]) > into msg > I don't get anything... > > What am I doing wrong? > >

Re: Database Query Builder

2003-12-06 Thread [EMAIL PROTECTED]
TECTED]> > Reply-To: How to use Revolution <[EMAIL PROTECTED]> > Date: Fri, 5 Dec 2003 07:03:52 -0800 (PST) > To: How to use Revolution <[EMAIL PROTECTED]> > Subject: Re: Database Query Builder > > --- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >&

Re: Database Query Builder

2003-12-05 Thread [EMAIL PROTECTED]
Hahaha, Thanks for the warning Jan, will give it a try! Ton > From: Jan Schenkel <[EMAIL PROTECTED]> > Reply-To: How to use Revolution <[EMAIL PROTECTED]> > Date: Fri, 5 Dec 2003 07:03:52 -0800 (PST) > To: How to use Revolution <[EMAIL PROTECTED]> > Su

Re: Database Query Builder

2003-12-05 Thread Jan Schenkel
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Question... > > When using the Database Query Builder, you have to > enter the address of the > database. But is there a way to create a > preference-file which is loaded > during startup, because I¹m cr

Database Query Builder

2003-12-05 Thread [EMAIL PROTECTED]
Question... When using the Database Query Builder, you have to enter the address of the database. But is there a way to create a preference-file which is loaded during startup, because I¹m creating a mySQL-front-end which uses different databases (development db on server 1 and live db on server

Re: Database Query Builder: workaround please

2003-11-14 Thread David Wilkinson
On Thursday 13 November 2003 3:47 pm, you wrote: > On the Database Query Builder, Record Set Tab, SQL query field: > > 1) enter some syntactically bad SQL > 2) click the refresh query button (or close the Database Query > Builder window) > 3) now Rev gets stuck in an endless l

Re: Database Query Builder: workaround please

2003-11-13 Thread Alex Rice
iteration produces the error message. FWIW, deleting the query seems to fix the problem here. David, I think you are talking about something else. What I am seeing is a bug. A GUI bug, and doesn't have anything to do with the query loop going for 3 iterations. On the Database Query Builder, Recor

Re: Database Query Builder: workaround please

2003-11-12 Thread Pierre Sahores
Le mer 12/11/2003 Ã 06:35, Alex Rice a Ãcrit : The same difficulties under Linux and Jaguar there... > On Nov 11, 2003, at 10:19 PM, Alex Rice wrote: > > > I can't believe I'm the only one being hassled by this bug, so is > > there a workaround I am missing? > > And I mean other than *not usin

Re: Database Query Builder: workaround please

2003-11-11 Thread Alex Rice
On Nov 11, 2003, at 10:19 PM, Alex Rice wrote: I can't believe I'm the only one being hassled by this bug, so is there a workaround I am missing? And I mean other than *not using the query builder at all*. It is appealing to use the GUI to maintain connections and recordsets, and doing scriptin

Database Query Builder: workaround please

2003-11-11 Thread Alex Rice
I can't believe I'm the only one being hassled by this bug, so is there a workaround I am missing? In the Database Query Builder, Record Set tab, if you enter some bad SQL into the field labeled "SQL Query:", a popup error message says "An error resulted for the SQ

Re: About mixing Database Query Builder with normal database library calls.

2003-09-02 Thread Jan Schenkel
atabase I > am using Database Query Builder, filling fields with > the data and some > buttons to navigate. But I cannot use Query Builder > to insert a Record > can I? How can I identify what is the current record > (so that i can > disable the "previous" and &quo

Re: using database query builder

2003-06-14 Thread Jan Schenkel
--- rand valentine <[EMAIL PROTECTED]> wrote: > I have several questions about working with Rev > and databases (I'm using > Valentina xcmd for now on a mac running os 10.2.6). > > 1. When I open my main working stack, I have a > Database Query Builder >

Re: Database Query Builder?

2003-06-13 Thread Jan Schenkel
--- Marvin Wurth <[EMAIL PROTECTED]> wrote: > I am building a standalone Revolution frontend > application for a MySQL > database. I would like to use the Database Query > Builder to build the > queries and connect the various fields. I have a > good handle on how to

Database Query Builder?

2003-06-13 Thread Marvin Wurth
I am building a standalone Revolution frontend application for a MySQL database. I would like to use the Database Query Builder to build the queries and connect the various fields. I have a good handle on how to use the Database Query Builder and to set everything up. The problem is how do I

using database query builder

2003-06-12 Thread rand valentine
I have several questions about working with Rev and databases (I'm using Valentina xcmd for now on a mac running os 10.2.6). 1. When I open my main working stack, I have a Database Query Builder (hereafter DBQB) connection that connects to a Valentina database that presently has two t