Version History - PocketSqlMan

Version Alpha 1.6

• New features:
  • Alter a table through a new GUI. A new screen helps you alter a table without writing SQL statements.
  • Edit a record visually, PocketSqlMan can now help you edit a record from the records list.
  • Delete a record when you realise its no longer needed. Bring the context menu up on the records screen and choose "delete".
  • Ability to insert a record into a table without the need to writing the insert statement manually.
  • On the query screen, now you can select the database on which you would like to execute a query on.
• Feel free to get in touch for any feature request or bug report at: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it or just click on "Contact Us". We @Loginworks, would like to know what you think about our product.

Version Alpha 1.5a

• Bug fix: While manually entering the sql query, the characters were appearing twice.

Version Alpha 1.5

• Major Update: Code base moved to CF.Net 2.0.
• Major Update: Gracefully handles landscape and portrait screen modes.
• Major Update: List of objects inside tables (Columns, Triggers and Indexes) are populated when the user wants to see them (Handled on multiple treads for very fast response).
• Major Update: Gracefully handles data editing, i.e. data returned using any SQL command.
• Major Update: A fresh GUI started to take shape.
• Bug Fix: Select query raised an error if there was no primary key in the query.
• Bug Fix: Cancel button on login form was not functioning.
• Bug Fix: The application can now be installed on a storage card as well.

 Version Alpha 1.41

• Data is editable through the select query only if the dataset returned contains a primary key.
• No need to see list of all permitted databases, you can now mention the database at the time of logging in and just restrict to that database (very useful, for slow GPRS connections)

Version Alpha 1.4

• PocketSQLManager is now capable of handling Views and Stored procedures as well.
• Edit Views
• Edit Procedures

Version Alpha 1.3

• Fix: Better grid sizing when multiple result sets are to be displayed.
• Full screen grid when only one dataset has to be displayed.
• The resulting grids are now sort able (by clicking on the column header).
• The result set is also editable (if the result returned by the query contains the primary key columns).
• User can now select a portion of the query when he presses the "Execute Query" button, in which case, only that selected text will be executed.

Version Alpha 1.2

• FIX: the server list management was not very smooth, while creating a new server entry it was messing up with the last entry in the list. That’s fixed now.
• Added the clipboard support for Query panel, wherein you can now save a query to text file, do normal cut/copy/paste operation and get a query from text file. All this happens from a new menu that gets activated when the query window receives focus.

Version Alpha 1.1

• Earlier to add another server to the list, we needed to edit the .xml file manually, now this can be handled by the application itself i.e. there is a "New ..." button which will create a blank entry in the Servers.xml file (and will be saved if the login to that server gets successful). There is also a delete button now, in case you want to delete a server entry.
• Application now supports running multiple t-SQL statements at one go (separated by ;).
• Bug Fix: If the SELECT keyword was not typed in uppercase, it won't recognize the command. Well now it will.

Version Alpha 1.0

• Get a list of databases your login is permitted for and their corresponding tables.
• Also available is Tap and hold menu attached to table names which let you do some basic tasks like:
  "View structure"
  "View top 5 records"
  "View all records"
  "Select Query"
• Run any T-SQL Statement on the selected database. (Only single SQL is supported at one time).