Re: Quickly View Contents Of An Array
Well if you know SQL syntax like the back of your hand and dream about insert statements, then you could get by without it I suppose. But if you are not that keen on SQL then I highly recommend it, because it offers a way to do quite complex database operations without knowing ANYTHING about SQL. Trevor's support has been excellent for me (God knows I have needed it). Another thing I find useful, is that it stores information about your database like schemas and such, and also it reconnects it if detects that the connection is dropped. This works great for network local connections, but have found that when a remote mySQL like on-rev server has dropped the connection and Revolution tries to reconnect, there is a HUGE lag of many minutes before the command fails. This is not a problem with sqlYoga, but I think has something to do with how the remote SQL server handles attempts to connect that are not valid. The solution is to close you connections when finished, which is good programming practice anyway. Bob On Feb 9, 2010, at 4:48 PM, Andrew Kluthe wrote: And is SQL Yoga worth it? My boss told me I can get whatever plugins I need to improve my productivity. I looked into it a bit but it seems to be what I have my DB handlers written for. What is the benefit of SQL Yoga vs Custom handlers? ___ 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
Re: Quickly View Contents Of An Array
On Feb 9, 2010, at 7:48 PM, Andrew Kluthe wrote: And is SQL Yoga worth it? My boss told me I can get whatever plugins I need to improve my productivity. I looked into it a bit but it seems to be what I have my DB handlers written for. What is the benefit of SQL Yoga vs Custom handlers? Sorry, I missed this question the first time around until I saw Bob's response. Here are just some of the benefits I get with SQL Yoga. As background I've been working with SQL Databases for over 12 years so I'm not relying on SQL Yoga to write SQL that I don't already know. Basics * SQL Yoga allows you to think of your Database, tables and records as objects. * SQL Yoga manages the connection ids and cursor ids for you behind the scenes. * SQL Yoga plays the role of a database interface library that you would write by hand in a Revolution project. It knows all about your schema so there is no shim layer to write or update. Just use the SQL Yoga commands for creating, updating, deleting or querying records. * SQL Yoga allows you to interact with data in the database using arrays. This speeds up development time considerably. * Since you are creating objects and setting properties as opposed to wrapping hand-written SQL strings in functions you can experiment and iterate more quickly. * SQL Yoga allows english strings in search conditions (begins with, ends with, etc.). Table Objects - SQL Yoga can treat your tables as objects. * Define specific search conditions using scopes. Multiple scopes can be added to a query based on UI input and a WHERE clause is automatically generated for you based on all scope conditions. * Add properties to your tables. For example, a property that returns a date column in the database as a nicely formatted string or a property that returns a full name based on the values of the FirstName and LastName columns in a record. * Add data validation routines that get called when creating or updating data in a table. * Add callbacks that get called when creating, updating or deleting data. Table Relationships - You can tell SQL Yoga about table relationships and then leverage those relationships in your code. * SQL Yoga automatically generates joins for you and can convert query results into a hierarchal nested array. * Given a record from a table SQL Yoga can fetch all related records in a related table. * SQL Yoga has commands for automatically linking/unlinking records in related tables. -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com ___ 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
Re: Quickly View Contents Of An Array
hmm an impressive list of features. I will have to look into it more. It seems half or more of my programming work is writing handlers and functions for database queries. -- View this message in context: http://n4.nabble.com/Quickly-View-Contents-Of-An-Array-tp1474936p1476224.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Quickly View Contents Of An Array
I made my presentation to my supervisor and got the go ahead to purchase revEnterprise, SQL Yoga, tRev, and a printed manual dictionary. I'm starting to get my feet wet with all of this and don't want to have to re-write a very large app to work with SQL Yoga after spending so much time on DB handlers. This is why I wanted to move up my presentation and get the OK to purchase it. :) im excited. Thank you for all of your help and suggestions. -- View this message in context: http://n4.nabble.com/Quickly-View-Contents-Of-An-Array-tp1474936p1476342.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Quickly View Contents Of An Array
On Feb 10, 2010, at 2:33 PM, Andrew Kluthe wrote: I made my presentation to my supervisor and got the go ahead to purchase revEnterprise, SQL Yoga, tRev, and a printed manual dictionary. I'm starting to get my feet wet with all of this and don't want to have to re-write a very large app to work with SQL Yoga after spending so much time on DB handlers. This is why I wanted to move up my presentation and get the OK to purchase it. :) im excited. Great. The SQL Yoga page is located here: http://www.bluemangolearning.com/revolution/software/libraries/sql-yoga/ It links to all of the documentation and tutorials and has the latest download. You can run SQL Yoga in demo mode if you don't have a license key yet. -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com ___ 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
Quickly View Contents Of An Array
I've spent a half an hour searching for something I used from the messagebox the other day. Someone I found something along these lines that was used to quickly view the contents of an array. answer PrintKeys blahh blahh blahh theDataA I can't find it anywhere, and don't remember what resource I found it on. Any help? -- View this message in context: http://n4.nabble.com/Quickly-View-Contents-Of-An-Array-tp1474936p1474936.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Quickly View Contents Of An Array
Nvm, Found it. For Search References: send PrintKeys to control controlName -- View this message in context: http://n4.nabble.com/Quickly-View-Contents-Of-An-Array-tp1474936p1474960.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Quickly View Contents Of An Array
Printkeys() is a basic function for displaying the contents of an array. It does not to my knowledge handle nested arrays, and I believe it was written by Trevor DeVore as a utility to his sqlYoga utility, but I may be mistaken on that. Bob On Feb 9, 2010, at 12:03 PM, Andrew Kluthe wrote: I've spent a half an hour searching for something I used from the messagebox the other day. Someone I found something along these lines that was used to quickly view the contents of an array. answer PrintKeys blahh blahh blahh theDataA I can't find it anywhere, and don't remember what resource I found it on. Any help? -- View this message in context: http://n4.nabble.com/Quickly-View-Contents-Of-An-Array-tp1474936p1474936.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ 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
Re: Quickly View Contents Of An Array
On Feb 9, 2010, at 4:04 PM, Bob Sneidar wrote: Printkeys() is a basic function for displaying the contents of an array. It does not to my knowledge handle nested arrays, and I believe it was written by Trevor DeVore as a utility to his sqlYoga utility, but I may be mistaken on that. The Data Grid behavior has a PrintKeys command that will print out the dgData array. It supports nested arrays. SQL Yoga has a printKeys() function defined that will print out nested arrays as well. Since the engine provides no way of printing out arrays I added the above for troubleshooting purposes. I've filed an enhancement request for a function akin to print_r in PHP: http://quality.runrev.com/qacenter/show_bug.cgi?id=8425 -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com ___ 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
Re: Quickly View Contents Of An Array
I figured out later that it was a command for the DataGrid. I wish there was a print_r lol. Guess I'll have to write a little one :P. Thanks And is SQL Yoga worth it? My boss told me I can get whatever plugins I need to improve my productivity. I looked into it a bit but it seems to be what I have my DB handlers written for. What is the benefit of SQL Yoga vs Custom handlers? -- View this message in context: http://n4.nabble.com/Quickly-View-Contents-Of-An-Array-tp1474936p1475276.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
