![\"image\"](\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2008\/12\/image2.png\")
<\/a><\/p>\nThe combo-box of course is there to keep a history of your queries so you don’t have to type them over an over again while experimenting.
\nWith this improvement of the Query window you can experiment and fine tune any query you have and verify its results against a live data source. Once you got it right, you can confidently copy it to your script.<\/p>\n
The database people amongst you now obviously have some questions.<\/p>\n
– How does it know what database to connect to?<\/strong><\/p>\n The database toolbar now has a combo-box which allows you to select the current data source for a query.<\/p>\n This way you can also quickly alternate the data source and verify your query results against multiple connections.<\/p>\n – Where do I define the data sources in this connection combo-box ?<\/strong><\/p>\n Very easy, in the database browser you are familiar with from PrimalScript 2007. Anything you set up there shows up in this combo-box.<\/p>\n – What type of databases can I connect to?<\/strong><\/p>\n Virtually anything ADO can connect to. The functionality and speed may vary with the particular provider. We test with MS Access, SQL Server, MySQL and Oracle.<\/p>\n – Are the query results live?<\/strong><\/p>\n Yes, the returned data is live and you can actually just type in the grid and modify data. The grid is in a virtual mode and fetches only displayed records, so that performance is not impacted by large result sets.<\/p>\n<\/p>\n