AltSQLite and Database Query Builder
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. In Database Query Builder, I have the following questions: A)Host: In the tutorial, the writer puts in "RunRev". Does this mean that the Host is the Revolution Studio Application? But should I put in "localhost"? Or name it anything that I want? Or Use the Filepath to the Database file? (not the Application) B) Database Is this only the name of the Database? e.g.. "TestDatabase" OR should it include the entire FilePath "A:\\HardDriveName\Applications\Revolution Studio\Work\TestDatabase" Or should it ALWAYS have the extension? e.g. "TestDatabase.sqlite" Should the extension be ".sqlite" OR "dbsqlite" OR "altsqlite3" C)User If it is on my local machine, then do I have to put in a User Name? Or is there a default if I am NOT on an external server? Or can I leave it blank to connect? D) Password: If it is on my local machine, then do I have to put in a Passwoord? Or is there a default if I am NOT on an external server? Or can I leave it blank to connect? I also learned from Chris at altuit that in the Altuit tutorial's CONNECTION BUTTON SCRIPT, the revdb_connect command...requires the commas. E.g. "AppReg.db", According to Chris, "You need the commas. They are extra parameters that revdb uses when connecting to other database(Mysql,Postgres, Oracle and the like)..In altSqlite we don't need them, but they still need to be passed to the function call as empty." A lot of people might already know that but not a Newbie like myself. Thanks, Revolutionary Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
AltSQLite to Mobile Content
Andre, That's terrific. Do you have any guidelines or samples on this? Or any direction that you can point me in? I'd really appreciate it. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
AltSQLite to Mobile Content
Has anybody been checking into how to take altSQLite data from an application and port it over to PDS/Phones, etc., through a Mobile Content conduit/program/app/service, etc., ?? Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Adding List Items to Popup/Option Menus, etc.,
I am trying to take a items from a list to automatically populate PopUpMenus and Option Menus when the List is updated. The List uses a Priority Group - tPrimary. An Option Menu - tSecondary. A field - tTask. It puts these items into a field "List" Here's the code for the button which puts these items into the field "List" ON mouseUp put the hilitedButtonName of group "CheckBoxGroup" into tPrimary put the selectedText of button "Secondary" into tSecondary put field "Task" into tTask put tPrimary & tab & tSecondary & tab & tTask & cr after field "List" END mouseUp The above works fine. Now I want to take the above items and put them into a PopUpMenu (assuming that the same code also works for other menus, e.g., OptionMenu, etc., ) NOTES: The PopMenu would be on the same card as the list so I believe that this is a local variable. Other PopMenus will be within the stack or on substacks so I believe that this would require a global variable. It sounds like it's better to use globalvariables in the solution to have the info accessible from other stacks and cards. I would like to have the option of sorting the populated PopUpMenu by the tPrimary variable. All items set to "A" would be shown. Thanks for all your help. I've cut and pasted a half-dozen scripts and tried my usual gum and bailing wire syntax. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
A Triangle Box Field like Entourage
Does anybody have a sample of the Triangle system used in fields in Entourage? Where one clicks the triangle to reveal either folders in the left hand box. Or email in the center column? Or is there a better, alternate way to do this in Rev? Thanks, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
A Stripped Down Manual Reordering of Lines for a Field
I have been studying Jan Schenkel's excellent stack on Manual Reordering. I'm taking it apart to learn. Also another stack called "Get in Line". But I wanted to know if there's a stripped down version of Manual Reordering for a field. The user would select certain controls, buttons, A category and input text into a field. Then this A [tab] Category [tab] User Input would go into a field. I'm trying to find some simple code for Manual Reordering by the User. Thanks for your help. I'll keep studying the other material, but just need a jumpstart. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
A Constellation Problem - of my own making
Tim, As far as I can tell, you described the problem quite accurately. The Constellation top is tucked under the Revolution/Mac OSX menubar at the top so I can't drag it anywhere. I'm on a 14" Mac Powerbook too And when I restart it goes right under the menu bar as well. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
A Constellation problem-of my own making?
Revolutionaries, I installed version 2.7 along with Constellation. However, when I use Constellation, the interface sticks to the top of the screen, covered up by the Revolution Toolbar Text and Toolbar Icons pallettes. I might have inadvertently hit a button on Constellation that locks it into place? The only way I can see the Constellation tabs is to turn off the Revolution text and icon pallettes? Yoda? Thanks, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Addition-Elementary Style
I just want thank everybody for their kind and considerate help. Don't worry. I'm not going to ask about Long Division. Whew! Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Addition-Elementary Style
Revolution brothers and sisters, On the basis that the most stupid question is the one left unasked, I throw myself on the pyre with this question: I have eight multiple text fields. Numbers will go into these fields. I want all the numbers to add up and go into the Ninth field. Add field1+field2+field3 [etc.,} and put into field Total Add field Timeneed + Effort + People [etc.,] and put into field Total I have searched the documentation and tried a dozen syntaxes but can't seem to get something as fundamental to work. Thank you. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
A Custom Property Sets 'Database"
Rather than dive into mySQL or altSQLite, (I am a Newbie), I was directed to look at Custom Property Sets in order to use the 'internal databse' of Revolution to store information. 1. Would I use a Table Field as the object to store at least 500 records? 2. What is the language in the Custom Property tab that I should use to 'create this internal database' structure. 3. Would I use a Table Field like a spreadsheet, creating a Table like in a traditional DB? Any direction or even an example, would be much appreciated. Thank you, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Asking about Rev and the Web-PHP?
Can Rev work with PhP programming to serve up web pages? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Rev Internal Data Structures
Everyone, thanks for the help. If I used Fields (or tables in fields) in a data stack that is hidden, what is the limit to the number of entries from the user? If I can figure out where to put all the data that I know will be generated, I can make good progress toward the app. Does anybody have a miniexample that they can share that shows User Entry Fields going to such a TABLE or FIELD WITH GRIDS&TABS. I assume that the TABLE or FIELD WITH GRID&TABS would operate like a traditional DB table. Or bad assumption, too much early eggnog? Thanks, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Rev Internal Data Structures
I received an email from Sarah a while back that Revolution was perfectly capable of handling data through its own internal database structures (rather than have a newbie like myself work in mySQL).I am primarily manipulating extensive tables of data, not unlike a huge spreadsheet with input from the user. Is this done by putting data in an invisible substack hundreds of fields, each containing a chain of data? I have gone through the Help section of Revolution but am not sure where to begin to familiarize myself with the internal data structure for naming conventions, etc., Thanks, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Application on Task -Dan Shafer Book
I sent the stack to the email address that was in your response. Hopefully you got it. Thank you, Michael -- Forwarded Message From: Michael Mandaville <[EMAIL PROTECTED]> Date: Tue, 26 Jul 2005 11:41:33 -0700 To: Subject: Application on Task -Dan Shafer Book I'm a Newbie, working through the Tutorials and Dan Shafer's book. So far, I've built the application up to page 266 in the book "Revolution" However, while I've gone over the scripts more than a few times, I don't believe that I have any errors and that they're in the right places, i.e., object, stack, etc., I still cannot populate the list or txt file with a task. If anybody is familiar with the Dan Shafter app, I would appreciate some guidance to get me past this roadblock. Happy to share the final app - with my hopefully correct comments - with anybody who wants it. I can email the stack at will. Thank you, Michael Mandaville -- End of Forwarded Message ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Application on Task -Dan Shafer Book
I'm a Newbie, working through the Tutorials and Dan Shafer's book. So far, I've built the application up to page 266 in the book "Revolution" However, while I've gone over the scripts more than a few times, I don't believe that I have any errors and that they're in the right places, i.e., object, stack, etc., I still cannot populate the list or txt file with a task. If anybody is familiar with the Dan Shafter app, I would appreciate some guidance to get me past this roadblock. Happy to share the final app - with my hopefully correct comments - with anybody who wants it. I can email the stack at will. Thank you, Michael Mandaville ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Asking for Shao Sean's Calendar Object
I am working through the Dan Shafer book and couldn't find the Shao Sean's Calendar Object A previous Runrev submission said that it was at... http://www.shaosean.tk/ But it is NOT posted. Does anybody have this stack for me to download. Or could you email it to me? Thank you very much, Michael Mandaville [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
("sqlite", filepath...)
How can I program a new database, made with altSQLite, to put the database in the same folder i.e., the filepath, where the user created a new stack from the application? Is there a certain piece of code which picks up the name of their file (chosen by the user) and then automatically put into the 'filepath' ? Thank you ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Creating & Using Tabs tutorial
Judy, Where is your tabs tutorial? I tried searching online for "RevOnline" but didn't find anything that pertained to your work. Can you post a URL for it so that I can see your labor of love? I appreciate your newbie approach. I'm right there with you and trying to decipher optimized code doesn't stoke my enthusiasm or build the mental library. Thank you, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Combo-box/popup menu in a list field?
Paul, Are you trying to get this from Jan Schenkel? I may have something similar. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Columns and Internal Option Menus
1. COLUMNS: I have three elements - Primary, Secondary and Task. I already got it to sort on the Primary. I can then set up a button for the Secondary aswell. How do I send them items to a nice even scrolling field of three columns? In that way, I suppose, I can sort on each column or set up a sort order. 2. INTERNAL BUTTON: Once a person makes a choice in the Primary field (which is to establish Priorities using "A","B" and "C") and it is sent to a list, I've seen where these Lists have the choice listed, but also access to an option Menu within the List.So that if a priority changes, they can go into this List, hilite the Primary choice and change the ABC to whatever they want. In effect, it's an Option Menu within the List. Thanks for everything. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Buttons, Fields & Columns
Sarah, This was extremely helpful. I followed your instructions and it worked just great. BTW, you were the one who was so kind to give me your opinion on Revolution which convinced me to move forward!I had to figure out that you used Radio Buttons and then put them into a group, but then got it to work. I also tried it with CheckBoxes and got that to work. I was also able to figure it out with OptionBoxes and Pulldown Menus. I'm saving the stacks as I work on them for my examples. I'm trying to go through all the controls as I do this. 1. COLUMNS: I have three elements - Primary, Secondary and Task. I already got it to sort on the Primary. I can then set up a button for the Secondary aswell. How do I send them items to a nice even scrolling field of three columns? In that way, I suppose, I can sort on each column or set up a sort order. 2. INTERNAL BUTTON: Once a person makes a choice in the Primary field (which is to establish Priorities using "A","B" and "C") and it is sent to a list, I've seen where these Lists have the choice listed, but also access to an option Menu within the List.So that if a priority changes, they can go into this List, hilite the Primary choice and change the ABC to whatever they want. In effect, it's an Option Menu within the List. Thanks for everything, Sarah, Michael ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Buttons,Fields & Columns
I am a new Revolutionary - a whole two weeks - but very excited. I am trying to primarily work with text and data. If anybody knows of any useful examples (like Jan Schenkel's stack) for -drag and drop -text manipulation from field to field. I would appreciate it. I am currently trying to: 1. Use PrimaryOptionButton with the lettters, A,B,C, 2. A SecondaryOptionButton -set multiple choice categories. 3. A TaskField for entering a task or action. 3. Combine the PrimaryOptionButton and the SecondaryOptionButton and the TaskField into a Multicolumn field which can be sort by A,B,C, Multiple Choice Task/Action I appreciate your guidance. I am going through the tutorials and reading Dan Shafer's book. Though it's slow going, I've made great discoveries so far and am very encouraged. Michael Mandaville ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Question for the Mailing List
Here is my question for the Revolution User List TOPIC: Buttons,Fields & Columns I am a new Revolutionary - a whole two weeks - but very excited. I am trying to primarily work with text and data. If anybody knows of any useful examples (like Jan Schenkel's stack) for -drag and drop -text manipulation from field to field. I would appreciate it. I am currently trying to: 1. Use PrimaryOptionButton with the lettters, A,B,C, 2. A SecondaryOptionButton multiple choice categories. 3. A TaskField for entering a task or action. 3. Combine the PrimaryOptionButton and the SecondaryOptionButton and the TaskField into a Multicolumn field which can be sort by A,B,C, Multiple Choice Task/Action I appreciate your guidance. I am going through the tutorials and reading Dan Shafer's book. Though it's slow going, I've made great discoveries so far and am very encouraged. Michael Mandaville ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
basic database primer V1
Bob, What is the url for you primer at revonline? I'm new at this. I'd appreciate your help. Michael ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
