Latest post of the previous page:
1.1.22 (and FAR.NET 3.3.22)http://code.google.com/p/farnet/
DATABASE AND PANEL TOOLS
Panel-Data-.ps1 (and underlying class DataPanel):
- Removed switch -BuildCommands. DataPanel will try to build commands itself
only when you delete, insert or update records. It is simple and effective.
- Added parameter -Title (~ IPanelPlugin.Info.Title) - panel title.
- If parameter -Connection is not defined then variable $DB is assumed. Thus,
parameter -Connection is optional now, and all the parameters were reordered to
make simple commands even simpler. For example with a new alias pd ~ Panel-Data-
you can open a data panel like this (but run Initialize-Test-.ps1 at first, i.e.
open your global connection $DB):
>: pd "select * from testnotes where note like '%<%>%'"
and in the result panel you still can delete, insert and update data really in
the database (!) - it is useful, but take care, these data are 'connected', not
just 'copied'.
- New property TablePanel.FarDescription (~ parameter -FarDescription of
Panel-Data-). Use it instead of IncludeColumns and ExcludeColumns when you want
the only column in Description. It is highly recommended if you expect thousands
of result records. Format-Table which is called when you use IncludeColumns and
ExcludeColumns can take ages.
- Added static property DataTable.MaxFormattedRows = 500 (you can set your value
in your profile) - for 'unknown' tables. See code comments in DataPanel.cs.
- Added property DataTable.Connection (get). Why? It can be passed in lookup
panels so that they can reuse already opened connection (just in case if it is
not in a global variable; a global variable is an easy solution, indeed, say,
for demos and simple tasks, but it is not good if you are about to use several
connections in the same session at the same time).
- Start sort mode of DataPanel is set to Unsorted to preserve the order produced
by SELECT with its powerfull ORDER BY capabilities.
- <ShiftEsc> closes the current panel together with all its parents (as before,
<Esc> closes the current panel and opens its parent if any).
MISC
- Fixed screen garbage on PowerShellFar output when panels are hidden and status
line is visible.
- Fixed an error on opening a Power panel from disk menu when PluginPreloadable
is false and this is the first action in a session.