Re: Database: INSERTS, speed and primary keys

2010-09-27 Thread Monte Goulding
Hi David However if I uses a surrogate primary key (ie the usual auto-incremented numeric id field), for each updated record I need to check first whether it is already in the database before adding it - this is a lot of overhead in terms of finding the ids based on other fields. I haven't

Re: Database: INSERTS, speed and primary keys

2010-09-27 Thread David Bovill
HI Monte - hows down-under :) On 27 September 2010 11:31, Monte Goulding mo...@sweattechnologies.comwrote: I haven't yet used SQLYoga but I'm sure Trevor has this all worked out. SQLite will handle the auto increment of integer primary keys when you INSERT without an ID field and then you

Re: Database: INSERTS, speed and primary keys

2010-09-27 Thread Monte Goulding
HI Monte - hows down-under :) Getting better all the time ;-) Only by making the primary key = name,type,location,hnum instead of id woudl you get a fast normalisation of the data inserted. You can create an secondary key for those fields and still use your primary key auto-increment field

Re: Database: INSERTS, speed and primary keys

2010-09-27 Thread David Bovill
OK - not getting very far with that - Google is not my friend :) Can you give me an idea of what the CREATE statement would look like? CREATE TABLE 'handler' ( 'name' VARCHAR(255) NOT NULL, 'type' VARCHAR(255) NOT NULL, 'location' VARCHAR(255) NOT NULL, 'handler_num' INTEGER

Re: Database: INSERTS, speed and primary keys

2010-09-27 Thread Monte Goulding
Try: -- - -- Table `handler` -- - CREATE TABLE IF NOT EXISTS `handler` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `type` VARCHAR(255) NOT NULL , `location`

Re: Database: INSERTS, speed and primary keys

2010-09-27 Thread David Bovill
Thanks for that Monte, On 27 September 2010 13:44, Monte Goulding mo...@sweattechnologies.comwrote: UNIQUE INDEX `mykey` (`name`, `type`, `location`, `handler_num`) ); Or you can use a separate Create Unique Index statement. OK - will have to read up more on Indexes - I thought they were

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 to

Re: Database access in revlet?

2010-01-08 Thread Devin Asay
Well, as often happens, the act of posting about my problem triggered an idea of something I had forgotten to check. It turns out that I forgot I was doing some fancy shell calls to make sure the database port was open before trying to connect to the db. Works just fine as a standalone,

Re: Database access in revlet?

2010-01-08 Thread Devin Asay
One more report: I couldn't get the revlet to work with the shell call, even when I manually selected Shell calls under the Security settings in the standalone builder. In fact, when the revlet launches and asks for the needed permissions, Shell calls is not one of them. Process permission

Re: Database access in revlet?

2010-01-08 Thread Alejandro Tejada
Hi Devin, After you finish this project, Could you post a tutorial or lesson to show how to receive and send data to a database using a revlet? Thanks in advance! Alejandro Devin Asay wrote: One more report: I couldn't get the revlet to work with the shell call, even when I manually

Re: Database connection fails with MS SQL 2008

2009-08-27 Thread mfstuart
Ahhh, found the problem. When defining the ODBC connection, you must check the Change the default database to: box when selecting the database. then select the database. Unchecked, it will return an error. Mark Stuart mfstuart wrote: Hi all, Anyone know if RunRev 3.5 can successfully

Re: Database Basics

2008-12-07 Thread Joe Lewis Wilkins
Hi Tom, I did something with a bird stack about 20 years ago; but, since I wanted to have a picture of each one, I used a separate card for each bird. Only B/W with HC, however. That made sorting and arranging and doing all sorts of things real easy - even for HC; but I don't remember

Re: Database Basics

2008-12-07 Thread Mark Schonewille
Hi Tom, I made a very simple database example, which you can find in RevOnline, username Mark. It keeps all data in properties. I have also a much more complex version, which has no problems searching for a string in several tens of thousands of records, but I must admit that it takes

Re: Database Basics

2008-12-07 Thread Chipp Walters
Hi Tom, Here's my 2 cents on the subject. I'd stick with the one card per record which Joe suggested. But, during runtime, I'd keep the stack with the cards invisible, and pull information into your 'application' stack. The idea being the business logic in the application code in a standalone

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 this is a FAQ; I haven't fully explored this area

Re: database scripts location

2008-06-26 Thread Mark Wieder
Mikey- Other than the rev query builder, where else are the database scripts (e.g. revdb_columnnames) located again? I'm a bit confused, too. Are you looking to hack the library routines or just wondering about the handlers? revdb_columnnames() is an alias for revDatabaseColumnNames(), if

Re: database scripts location

2008-06-19 Thread william humphrey
I'm interested in your question because I'm not sure I understand it. What database scripts? Do you mean the various rev_database functions that are listed when you are in the help menu and enter database as the search term? ___ use-revolution mailing

Re: Database Encryption

2008-03-11 Thread Trevor DeVore
On Feb 5, 2008, at 1:54 PM, Ross Giddings wrote: A simple way to prevent unauthorized access to a database is to encrypt the relevant part of the file header so that it's not recognized as a db outside your programme. Decrypt the header programmatically inside your app and encrypt it on

Re: Database vs Array

2008-02-04 Thread viktoras didziulis
3. Can it be protected? Ye, but it is not a free feature. Check this: http://www.hwaci.com/sw/sqlite/prosupport.html#crypto http://sqlitee.homepc.it/ http://www.sqlite-crypt.com/ On the other hand you can use revolution to encode/decode data before it gets into the database and when

Re: Database vs Array (was: Filtering array vs plain list)

2008-02-04 Thread Shari
Thanks to all who answered my questions about arrays vs databases. I reached a juncture where I had to make a decision about how to format this particular set of data before I could continue coding. I made a few adjustments and I think the end result will be easy to access and speedy.

Re: Database vs Array (was: Filtering array vs plain list)

2008-02-03 Thread Thierry
Hi Shari , Truthfully I've not considered databases. I've never worked with one. So I have NO concept of how you'd use one, install one, make it work for lots of folks with lots of computers, etc. May be it's interesting to read this tutorial on SQL:

Re: Database vs Array (was: Filtering array vs plain list)

2008-02-03 Thread Sarah Reichelt
1. Would the user need to install something extra to use it? If so, would it be a separate program from my app that I would have to deal with tech support if the user upgrades his system? Thousands of people download my apps from around the world, so added tech support is a big bad.

Re: Database - quickest way to do this?

2007-06-10 Thread Ruslan Zasukhin
On 10/6/07 4:13 PM, David Bovill [EMAIL PROTECTED] wrote: Hi David, NB - Ruslan what do you use to monitor emails - have you got a Valentina database searching for key words - or do you just use GMail :) I use MS Entourage for MAC, and have setup for each list a rule, So if letter contains

Re: Database - quickest way to do this?

2007-06-10 Thread Ruslan Zasukhin
On 10/6/07 4:13 PM, David Bovill [EMAIL PROTECTED] wrote: Hi David, That should get Ruslan to reply :) Keywords are in a simple database link table and i want to do a search for handlers based on 10 or so keywords selected by the user or automatically selected by the software. Now i want

Re: Database - quickest way to do this?

2007-06-10 Thread David Bovill
Valentina Valentina Valentina Valentina Valentina On 10/06/07, Ruslan Zasukhin [EMAIL PROTECTED] wrote: I use MS Entourage for MAC, and have setup for each list a rule, So if letter contains e.g. word Valentina it play sounds Ah - so what sounds do you hear - maybe it would sound nicer if

Re: Database - quickest way to do this?

2007-06-10 Thread David Bovill
On 10/06/07, Ruslan Zasukhin [EMAIL PROTECTED] wrote: So I guess I do an or SQL search for all these keywords, and then loop through them checking hits. Or do I do AND searches, and iterate replacing the AND with OR to widen the search? 1) Actually it is not clear: your result should

Re: Database - quickest way to do this?

2007-06-10 Thread william humphrey
I used to use entourage on mac too for all my emails but I have had to send a lot of it to gmail now because entourage begins to bog down to nearly terminal slowness when it has a lot of email archived in various folders. On 6/10/07, David Bovill [EMAIL PROTECTED] wrote: Valentina Valentina

Re: Database - quickest way to do this?

2007-06-10 Thread Ruslan Zasukhin
On 10/6/07 4:57 PM, David Bovill [EMAIL PROTECTED] wrote: So I guess I do an or SQL search for all these keywords, and then loop through them checking hits. Or do I do AND searches, and iterate replacing the AND with OR to widen the search? 1) Actually it is not clear: your result

Re: Database - quickest way to do this?

2007-06-10 Thread Jeanne A. E. DeVoto
At 4:26 PM +0300 6/10/2007, Ruslan Zasukhin wrote: On 10/6/07 4:13 PM, David Bovill [EMAIL PROTECTED] wrote: NB - Ruslan what do you use to monitor emails - have you got a Valentina database searching for key words - or do you just use GMail :) I use MS Entourage for MAC, and have setup for

Re: Database - quickest way to do this?

2007-06-10 Thread Andre Garzia
or some mispelled valentine's day spam during the next week.. :D On 6/10/07, Jeanne A. E. DeVoto [EMAIL PROTECTED] wrote: At 4:26 PM +0300 6/10/2007, Ruslan Zasukhin wrote: On 10/6/07 4:13 PM, David Bovill [EMAIL PROTECTED] wrote: NB - Ruslan what do you use to monitor emails - have you got a

Re: Database query fields

2007-03-06 Thread Bill
Still trying to figure out how to set the properties of fields with a for each script. I just found out that Galaxy has a property editor which I've never tried because my version of Galaxy is Lite. I emailed them about an upgrade as maybe their property editor will solve my problem. I found in

Re: Database query fields

2007-03-06 Thread Jerry Daniels
Bill, I'm not sure you need Galaxy to do the scripting you mention. But, could it hurt? I don't think so. repeat for each line thePropDatum in thePropData put item 1 of thePropDatum into theCustomPropName put item 2 of thePropDatum into theCustomPropValue do set the cRevGeneral[

Re: Database query fields

2007-03-06 Thread Jerry Daniels
Correction: do set the cRevGeneral[ quote theCustomPropName quote ] to theCustomPropValue -JD On Mar 6, 2007, at 9:54 AM, Jerry Daniels wrote: Bill, I'm not sure you need Galaxy to do the scripting you mention. But, could it hurt? I don't think so. repeat for each line

Re: Database query fields

2007-03-06 Thread Bill
Thanks Could the set fld property line look more like this? do set the cRevGeneral[ quote theCustomPropName quote to theCustomPropValue] in fld theFieldName On 3/6/07 11:54 AM, Jerry Daniels [EMAIL PROTECTED] wrote: Bill, I'm not sure you need Galaxy to do the scripting you mention.

Re: Database query fields

2007-03-06 Thread Bill
Thanks for the correction. I should check my email more often. Because I am setting the custom property value of many fields would the line be do set the cRevGeneral[ quote theCustomPropName quote ] to theCustomPropValue for fld theFldName On 3/6/07 12:12 PM, Jerry Daniels [EMAIL

Re: Database query fields

2007-03-06 Thread Jerry Daniels
of fld theFldName On Mar 6, 2007, at 10:23 AM, Bill wrote: Thanks Could the set fld property line look more like this? do set the cRevGeneral[ quote theCustomPropName quote to theCustomPropValue] in fld theFieldName On 3/6/07 11:54 AM, Jerry Daniels [EMAIL PROTECTED] wrote: Bill,

Re: Database query fields

2007-03-06 Thread Bill
tried: do set the cRevGeneral[Linkcolumn] of fld theFldName to theFldName Still trying... On 3/6/07 12:28 PM, Jerry Daniels [EMAIL PROTECTED] wrote: of fld theFldName On Mar 6, 2007, at 10:23 AM, Bill wrote: Thanks Could the set fld property line look more like this? do set

Re: Database query fields

2007-03-06 Thread Jerry Daniels
You don't need the do stuff if your property name is a literal. On Mar 6, 2007, at 10:32 AM, Bill wrote: tried: do set the cRevGeneral[Linkcolumn] of fld theFldName to theFldName Still trying... On 3/6/07 12:28 PM, Jerry Daniels [EMAIL PROTECTED] wrote: of fld theFldName On Mar

Re: Database query fields

2007-03-06 Thread Bill
Thanks -- I got it: set the cREVDatabase[Linkcolumn] of fld theFldName to theFldName You know it is fun when this stuff works. On 3/6/07 12:36 PM, Jerry Daniels [EMAIL PROTECTED] wrote: You don't need the do stuff if your property name is a literal. On Mar 6, 2007, at 10:32 AM,

Re: Database query fields

2007-03-06 Thread Bill
I spoke to soon. This does set the correct field property but it seems that in order for the fld to work with the database query it can only be set manually using the GUI. I can see the property set correctly when calling it but the GUI doesn't and it doesn't work with the query manager. I ended

RE: database connect/query id's

2006-06-11 Thread Robert Mann
not able to open it? I am able to open the one above Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of mfstuart Sent: Sunday, June 11, 2006 12:20 AM To: use-revolution@lists.runrev.com Subject: Re: database connect/query

RE: database connect/query id's

2006-06-11 Thread mfstuart
Hi Robert, What version of RunRev Studio do you have? This was saved in version 2.7.2. If you have an earlier version, let me know and I'll save it in the Legacy Revolution Stack format. Also, you'll need to have the MySQL database already created: Database name: States Table name: States

RE: database connect/query id's

2006-06-11 Thread mfstuart
Robert, I forgot to mention: please use the RevOnline to down load the stack again. I changed the revOpenDatabase connection parameters that reflect connecting to a database named: States, and a table named: States. See my other reply with more detail about this. Regards, Mark -- View this

RE: database connect/query id's

2006-06-10 Thread Robert Mann
Thanks I figured there was something out there Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Josh Mellicker Sent: Friday, June 09, 2006 8:30 PM To: How to use Revolution Subject: Re: database connect/query id's I

Re: database connect/query id's

2006-06-10 Thread mfstuart
Hi Robert, I also have been learning RunRev to access SQL databases, and so I've created a sample stack to do just that - it connects to MySQL. To get the sample stack, load RunRev and click on the Rev Online toolbar button, the revOnline Viewer pops up. Select the User Space option, select

Re: database connect/query id's

2006-06-09 Thread Josh Mellicker
I learned these things from Sarah's excellent MySQL stacks on this page: http://www.troz.net/Rev/tutorials.php On Jun 9, 2006, at 5:38 PM, Robert Mann wrote: can some one send me a complete example of how to connect to database then find the database id number to use in the query, then how

Re: database connect/query id's

2006-06-09 Thread Jan Schenkel
--- Robert Mann [EMAIL PROTECTED] wrote: can some one send me a complete example of how to connect to database then find the database id number to use in the query, then how to find the record set id number to use to display the data I think these are the four library items that need to

Re: database query

2006-06-09 Thread Jan Schenkel
--- Robert Mann [EMAIL PROTECTED] wrote: Is there a way to pass a global variable to a mysql query? here is what I would like to do display a query in a list (which I can do this) select from the list (store it in a variable) then pass that selection to a new query any thoughts on how

Re: database access bandwidth: PHP vs. Revolution

2006-05-19 Thread Stephen Barncard
The database features of Rev are very fast. Although I am not totally conversant of all that goes on inside RevDB itself (as I use Trevor's DB abstraction library to make RevDB easier to implement), or what code you saw that looped but I know that using that library I can get back the data as

Re: Database Conversion

2006-03-21 Thread Ruslan Zasukhin
On 3/21/06 7:03 PM, Robert Sneidar [EMAIL PROTECTED] wrote: Hi Robert, Does anyone know of any good dBase/Foxpro table to sql/Valentina conversion utilities? I can write one in Revolution I suppose, but I would have a lot of front end work to do first, and this project is already huge.

Re: Database query for pull down option/menu

2006-02-17 Thread Josh Mellicker
Wow! One I might be able to help on. ___ In Revolution, put this script into your option menu: ON menupick pChoice put pChoice into queryValue put pChoice chosen into field status get libUrlFormData(queryvalue, queryValue)

Re: Database query for pull down option/menu

2006-02-17 Thread Benjamin Bacon
Hey thanks! I will give this a try too. Scott pointed me to a great example he made and it solved the problem! /Benjamin Josh Mellicker wrote: Wow! One I might be able to help on. ___ In Revolution, put this script into your option menu: ON menupick

RE: Database query for pull down option/menu

2006-02-16 Thread Scott Kane
Hi Benjamin, I am trying to create two pull down menu's that are based on MySQL query's. Then based on what the user choses from the pull down menu's they can get a listing of available files based on what is already in the database. Can anyone help me on this one. I greatly appreciate

Re: Database Connectivity Problems

2005-11-17 Thread Frank D. Engel, Jr.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Aha! What do you know, it's a BUG! According to the docs, the use SSL field should be ignored unless connecting to MySQL. I set it to be the hilite of button checkbox name (whatever I called it), which the interface disabled unless using MySQL,

Re: Database Connectivity Problems

2005-11-16 Thread Sarah Reichelt
I'm back... finally! Hi Frank, good to hear from you again. I'm trying to use the database APIs to connect to a PostgreSQL database on the local machine and getting messages like: could not connect to server: Can't assign requested address Is the server running on host localhost

RE: database

2005-10-25 Thread Lynch, Jonathan
Marielle... What is your site for the revdoc wiki again? Does it have the whole revDocs on it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marielle Lange Sent: Monday, October 24, 2005 6:54 PM To: use Revolution How to Subject: RE: database I must

RE: database

2005-10-24 Thread Lynch, Jonathan
Of Rob Cozens Sent: Saturday, October 22, 2005 10:38 AM To: How to use Revolution Subject: Re: database Hi Pascal, my interest now is in databases (I mean relational database without using SQL.) and I'm looking for, and not finding any example of databases build with Revolution. I mean

RE: database

2005-10-24 Thread Lynn Fredricks
What motivates you to create such a beast for free? Surely it took an enormous amount of work for you? How does serendipity compare on speed to database programs written in C++? Jonathan, I don't know how he could seriously answer your question. Valentina 2 is usually several multiples

RE: database

2005-10-24 Thread xavier . bury
Not to say Lynn is wrong but if a database is well organized in terms of functionality, it can beat the pants of a compiled database which woudl suffocate with too much information. Call it the space-folding starship... Before valentina existed, i had to port a database from a PC to Macs for

RE: database

2005-10-24 Thread Lynch, Jonathan
, October 24, 2005 10:26 AM To: 'How to use Revolution' Subject: RE: database What motivates you to create such a beast for free? Surely it took an enormous amount of work for you? How does serendipity compare on speed to database programs written in C++? Jonathan, I don't know how he could

Re: database

2005-10-24 Thread Ruslan Zasukhin
On 10/24/05 5:37 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Not to say Lynn is wrong but if a database is well organized in terms of functionality, it can beat the pants of a compiled database which woudl suffocate with too much information. Call it the space-folding starship...

RE: database

2005-10-24 Thread Lynn Fredricks
Not to say Lynn is wrong but if a database is well organized in terms of functionality, it can beat the pants of a compiled database which woudl suffocate with too much information. Right, but what you are talking about here is a developer skill issue more than anything. Its even easier for

RE: database

2005-10-24 Thread Lynch, Jonathan
To: 'How to use Revolution' Subject: RE: database Not to say Lynn is wrong but if a database is well organized in terms of functionality, it can beat the pants of a compiled database which woudl suffocate with too much information. Right, but what you are talking about here is a developer

RE: database

2005-10-24 Thread Rob Cozens
Hi Joanthan, What motivates you to create such a beast for free? Surely it took an enormous amount of work for you? SDB was originally created in HyperTalk about 15 years ago. I was working with a San Francisco winery supplier and Fresno State College professor of vitaculture on the

RE: database

2005-10-24 Thread Lynn Fredricks
Just curious... How many customers have bought Valentina? How many RunRev users have bought some version of Valentina? We just launched Valentina 2 for Revolution at RevCon, so not huge volumes yet. It replaces Valentina 1.x XCMD. We've had solutions available for Director, C++, REALbasic,

RE: database

2005-10-24 Thread MisterX
for a minimal functionality DB it did work wonders and it hardly used any xternals ;) cheers Xavier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zasukhin Sent: Monday, October 24, 2005 4:59 PM To: use-revolution Subject: Re: database

RE: database

2005-10-24 Thread Lynch, Jonathan
Cozens Sent: Monday, October 24, 2005 11:36 AM To: How to use Revolution Subject: RE: database Hi Joanthan, What motivates you to create such a beast for free? Surely it took an enormous amount of work for you? SDB was originally created in HyperTalk about 15 years ago. I was working with a San

RE: database

2005-10-24 Thread Rob Cozens
Jonathan, If you keep the entire DB in RAM, then do you have to save the entire DB when you do a save, or can you save just one record? The entire db must be saved to disk, which is done automatically whenever the last user logs out. I have contemplated adding a save command to SDB's

RE: database

2005-10-24 Thread Rob Cozens
Hi again Joanthan, What motivates you to create such a beast for free? Second answer...which I just recalled: The HyperTalk version of SDB was single-user. I got around to writing PPC (program-to-program communications) toolbox Xthings; but never could successfully test a client/server

RE: database

2005-10-24 Thread Marielle Lange
I must be the change I want to see in the world. -- Gandhi Funny, this is my favorite quote too. Though the version I know is: Be The Change You Wish To See In The World Though the original version apparently is: You must be the change you wish to see in the world

Re: database

2005-10-24 Thread Bruce Robertson
no offense. no boasting... I did the relational lookup in FMP, and it took minutes! So I opted for a double-linked-list of records (this was a hierarchical database - the relations were previously based on a parent id but searching this was horribly slow... So I made the search

Re: database

2005-10-24 Thread Chipp Walters
Ruslan Zasukhin wrote: BTW, SqlLite do not search all records never. They just search first record which satisfy RANGE search, and stop. When you do NEXT record they do search next one. They can do this only because they have claim: we are single used db. This is why it is not possible right

Re: database

2005-10-23 Thread Rob Cozens
Hi again Pascal, I have scripted a hierarchical, binary-tree database in Transcript which is open-source and royalty-free. Relational indexes are NOT built in, but must be created and maintained individually. SDB could be made relational by: * Adding a list of inverted key field names or

Re: database

2005-10-22 Thread Ruslan Zasukhin
On 10/22/05 12:49 AM, Chipp Walters [EMAIL PROTECTED] wrote: Hey guys. Pascal asks for NON-SQL database. Pascal, I believe that exists only one database for Revolution that fit your needs -- Valentina database. * Valentina support both: SQL and non-SQL ways to work with database. * Valentina

Re: database - valentina

2005-10-22 Thread Bill
I remember when I first looked at Valentina I didn't like it because I was moving from MySQL and was used to the many utilties that are available for working with the database and Valentina didn't seem to have one. I am now using SQLite and the SQLiteManager (and of course the Altuit plug-in).

Re: database

2005-10-22 Thread Rob Cozens
Hi Pascal, my interest now is in databases (I mean relational database without using SQL.) and I'm looking for, and not finding any example of databases build with Revolution. I mean something that looks like a FileMaker or a 4D product. Is ther any example on Revolution web site, or other ?

Re: database - valentina

2005-10-22 Thread Ruslan Zasukhin
On 10/22/05 2:56 PM, Bill [EMAIL PROTECTED] wrote: Hi Bill, I remember when I first looked at Valentina I didn't like it because I was moving from MySQL and was used to the many utilties that are available for working with the database and Valentina didn't seem to have one. I am now using

Re: database

2005-10-21 Thread Chipp Walters
Hi Pascal and welcome to Revolution! A long time ago, one of the developers of Rev was interested in such an animal and thought it could be programmed by combining SQLite with Rev. Unfortunately, the project never got off the ground, but our company does have a very nice SQLite connector

RE: database

2005-10-21 Thread Scott Kane
If you're interested, there's a great (and easy) demo of it at: I second Chipp's recommendation. I'm working with AltSQLite presently (nothing of use yet that I can put up as sample code - maybe soon) and am finding it fits my needs to a tee. Scott

Re: Database or large text file processing??

2005-10-10 Thread Alex Tweedly
Ian Leigh wrote: I wish to retrieve details about a particular file which are held in a text file, fairly large at about 264000 lines. The file contains details about many files but I only need to retrieve one file at a time. I am wondering about the best way to deal with this. The text

Re: Database or large text file processing??

2005-10-10 Thread Stephen Barncard
Hello again! I wish to retrieve details about a particular file which are held in a text file, fairly large at about 264000 lines. The file contains details about many One nice thing about a database, especially a remote one, it that it handles everything you need to do with data - store,

Re: Database or large text file processing?? - dreamhost

2005-10-10 Thread Michael
Hi Stephen: I just discovered Trevor DeVore's excellent libDatabase 2, and have been trying to use it on my dreamhost site with MySQL. However, I am never able to connect directly to MySQL with Rev, only by using the PHPmyAdmin browser interface. Do you know if it is even possible to connect to

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

Re: database : insert/update/delete

2005-08-27 Thread Bill
The database query builder does an excellent (and a little too seamless--no feedback) job of updating (although since the records are catched you have to refresh to see the changes). But I can't help you with delete and insert as you can't do either of those with the database query builder so I

Re: database : insert/update/delete

2005-08-27 Thread Dave Cragg
On 27 Aug 2005, at 14:59, Revolution wrote: Saturday, August 27, 2005 4:57:04 PM (GMT +02:00) Hi, want to add to the database what's in a text field. event from the button mouseup : -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-= put fld MyEdit into

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

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 Buider

2005-06-13 Thread Jan Schenkel
--- Bill Humphrey [EMAIL PROTECTED] wrote: Does anyone know how to get the database query builder to set the cursor to busy when it is working. Simple tasks like refresh or connect always take several seconds and everything just freezes with no indication that anything is happening.

Re: Database Query Builder -- errors

2005-06-13 Thread Jan Schenkel
--- Bill Humphrey [EMAIL PROTECTED] wrote: In case anyone 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

Re: Database saved as custom property

2005-06-06 Thread John Ridge
on 6/6/05 1:11 pm, Signe Marie Sanne wrote : Hello, Since someone a week ago said he had not ventured into custom properties, I have uploaded a very simple stack which shows how you make a small archive stack and save it as a custom property, all with just one card. On RevOnLine you will find it

Re: Database saved as custom property

2005-06-06 Thread Signe Marie Sanne
John Ridge skrev: on 6/6/05 1:11 pm, Signe Marie Sanne wrote : Hello, Since someone a week ago said he had not ventured into custom properties, I have uploaded a very simple stack which shows how you make a small archive stack and save it as a custom property, all with just one card. On

Re: Database saved as custom property

2005-06-06 Thread Klaus Major
Hi John, on 6/6/05 1:11 pm, Signe Marie Sanne wrote : Hello, Since someone a week ago said he had not ventured into custom properties, I have uploaded a very simple stack which shows how you make a small archive stack and save it as a custom property, all with just one card. On

RE: Database saved as custom property

2005-06-06 Thread MisterX
Klaus If it could replace 1000 cards, some containing c. 100k text, it would be FAST... but then setting back the text-styles (set the htmltext of fld x to the xos[thisprop] of me) would penalize the speed in favor of card based databases wouldn't it? Also, tracking what record, updating

Re: Database Query Builder -- errors

2005-06-06 Thread Trevor DeVore
On Jun 6, 2005, at 6:28 AM, Bill Humphrey wrote: In case anyone 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

Re: Database saved as custom property

2005-06-06 Thread Dennis Brown
John, I believe we are still limited to about 2GB of total stack size at present according to recent posts. Dennis On Jun 6, 2005, at 10:56 AM, Klaus Major wrote: Hi John, on 6/6/05 1:11 pm, Signe Marie Sanne wrote : Hello, Since someone a week ago said he had not ventured into

RE: Database saved as custom property

2005-06-06 Thread MisterX
Sent: Monday, June 06, 2005 17:35 To: How to use Revolution Subject: Re: Database saved as custom property John, I believe we are still limited to about 2GB of total stack size at present according to recent posts. Dennis On Jun 6, 2005, at 10:56 AM, Klaus Major wrote: Hi John

Re: Database saved as custom property

2005-06-06 Thread Andre Garzia
: Monday, June 06, 2005 17:35 To: How to use Revolution Subject: Re: Database saved as custom property John, I believe we are still limited to about 2GB of total stack size at present according to recent posts. Dennis On Jun 6, 2005, at 10:56 AM, Klaus Major wrote: Hi John, on 6/6/05 1:11 pm

  1   2   3   4   >