1.1.21 (and FAR.NET 3.3.21)
http://code.google.com/p/farnet/
DATABASE TOOLS
- New script Panel-Table-.ps1: show tables and views of an open connection $DB
in a panel. <Enter> opens a selected table by Panel-Data-.ps1: depending on a
table and a connection you can insert, delete and update records; <Esc> returns
you back to the parent panel with tables.
- New script Panel-Database-.ps1 (designed and tested for SQL Server Express):
shows all databases; <CtrlPgDn> opens database properties, <Enter> opens list of
tables in the database (it is done by Panel-Table-.ps1, see above).
- You can now configure your table panels to take some fields values from
another (lookup) table panel. See how it is done in Panel-TestNotes-.ps1: when
you <Enter> Category field then another Panel-TestCategories-.ps1 is called
where you: can <Esc> to exit with no changes, <Enter> to set selected Category
as new value in TestNotes record, or before <Esc> or <Enter> you can work with
lookup table as if it is opened directly, i.e. you can add, remove, edit
records (use <CtrlPgDn> to enter a record because <Enter> is used for lookup).
- Other minor changes in scripts and code mostly related to new tools above.
TEST SCRIPTS
- Test scripts moved to Bench\Test directory and some test rules changed, read
About-Test.txt if you want to run some tests, especially database test panels.
- Functions from Test-DataPanel-.ps1 was transformed into Panel-Table-.ps1 and
advanced test scripts in Test directory; script itself was removed.
MISC
- Demo Profile-.ps1: $ErrorActionPreference = 'Stop' again. 'Inquire' mode is
really good for troubleshooting but it is too annoying for normal work when
errors are not due to bugs in code.