Axisbase1 Tasks/Release notes

Programming tasks report for release 20110103

Implemented in ListViewPanel only

The "random number is not random enough" error occurs when many connections are started at the same time, indicating possibly that the time-based random number seed is only accurate to the second or is producing the same random number for some other reason.

Found that each connection thread creates its own random number generator, so 2 generators could possibly have the same time-based seed. Changed to use one static random generator.

Switch to label printer results tab when there are parameters; cancel parameters window; get null reference exception.

The server generates error message "File was not closed properly after the last session" when the server has an automatic MS update and reboot. This was working; something apparently stopped it from working.

done, tested on dev machine only; need to install on axisbase.com and wait for a reboot
In Dec 2010, this was reverted when pluto.axisbase.com migrated to new server. Retested reboot on 20110103 final release; OK.

test by faking the pad file

Is fixed by .NET 4 upgrade; no action taken

imports string lengths ok, but blobs come through as 0..0

all assemblies, add [assembly: AllowPartiallyTrustedCallers]

done for all server assemblies, not for UI
However, this doesn't solve the problem of partially trusted web apps, because remoting requires full trust.

on loss of communication to the server, the client aborts inelegantly

may have introduced new bug: lost session key (no such session key, server may have been restarted) This seems to happen more often now.

some help buttons dont find the correct page in the help system

Changed about 10 search terms to match the page titles.

upgraded to Visual Studio 2010 and .NET 4.0 - Extended profile (not client)
upgraded to DevEx 9.3.7
Note bug 197 was to upgrade to v9.1

error: "serialized to wrong type" (see in FLY db, main window)
Occured only after upgrade to .NET 4

Found that .NET 4 doesn't deserialize NameValueCollection objects properly, so Hyperlink,Args is the problem on deserialization.
(in cells.cs). However, a workaround for the issue of not being able to open some objects is to open and resave the object in the current (2009) version of axisase, then they will open in the new version. No programming change made.

Programming tasks report for release 20091023

Lists currently open to a fixed window size. The width should be set to accommodate the data width.

Currently OK requires Alt-O or mouse action in parameter entry. Make this quicker

Backup process may corrupt database if it is processing writes during the backup.

changed ServedPondCollection and BackgroundWorker

Corruption could occur when long strings cause heap expansion during the save process.

AxFishFile.SaveFish calls LoadFish, then hashToRecord (which may alter the blocks), then SaveFish(which expects LoadFish to have saved its position); corrected by not sharing the read data window with any write operation

BlockFile was checking block1 instead of 0 for moving

Very long strings, over 20k in length, take a very long time to display in lists

Limited display to 750 chars with ... following the truncated text. Editing shows the whole string, which for some reason does not have speed problems.

Implemented a Zoom edit feature.

Memory mapped files have memory constraints that are unpredictable, for example at about 800MB on a 32-bit Windows machine. Therefore they should be turned off until a more reliable solution is found.

Inconsistently, the server will take a long time to stop (for example on system shutdown) and the logs indicate that the databases were not shut down properly. First noticed during this update (released versions do not appear to have the problem.)

make pleasestop member volatile

Programming tasks report for release 20090808

when Windows does an automatic restart after installing updates, Axisbase log files say "the database was not closed properly", meaning that Windows crashed the axisbase server instead of stopping it nicely.

Upgraded to 9.1.4
Changes to retest:
/Allrecordsform - maxrows entry and all other spinedits
/commadelimcombobox - used where? text align, mouse hot track
/textcellpainter & datacellpainters alighment
/datecellpainter - removed test for bad date

/ViewStyle deleted in combine popup, hyperlinkpopup, pondform/navbar. messageform, reporteditform, aggregatepopup, labelprinteditform, combinepopup

new errors introduced:
/numeric entry has decimal/comma for integers
/commadelimpainter, remove close box from dropdown because it cancels
messageboxes have white background in XP w/o theme (probably ok)

in Vista, security prohibits start/stop server

in XP, use the old way; "runas" doesn't work
currently works on vista and on some XP, not others. Sydney thinks it is vista.

help icon needs to be anchored to the bottom of the Add/Remove properties form

fails with error message; can't reuse disposed window

Master/detail lits report save errors after saving changes. All changes are successfully saved, but it shows an error screen that lists no errors. Then, the total number of detail records + 1 are shown in the Changes menu header. 
For example, after editing one master record that has 2 details (but not editing the details), it will save it, then show "3 Changes". See FOX database, data entry form.

Now, only changing dataset when the value is different.

due to latest tools update, date time editors can only edit the date portion

When the hyperlink is invalid

Programming tasks report for release 20090518

when sending emails on a table with deleted rows, get error "deleted row information cannot be accessed"

after the mail server reports an error, on the "resume sending" box, you can't skip the one that is causing the error

no action; fixed by other code

If a parameter screen asks for a record of the type being shown in the form, the user enters a parameter, then deletes the record, then returns to the parameter form, it has a null reference error.

Some clients experience dynamically reassigned IP addresses, or broadband routers. Permit disabling the security feature that ensures the IP address has not changed.

If local file, show file name. If remote, show host name.

To reduce delays from network latency, implement new server method to accept chunks of records to update as a batch. Test for the methods existence for backward compatibility.

test against old server for fallback - times (before/after)
delete 20 saleitems (3s/ 0.5s)
delete 100 saleitems (7.5s / 0.5s)
import 100 saleitems (43s / 3s)
update 61 products (61s / 1s)
insert 25 services in list (14s / 1s)

If a filter is active and records are deleted which then cause no more records to exist in the category, the filter list should be updated. Also selecting the filter item causes the wrong set of records to be displayed.

reverted to prior behavior so the filter list does not change on data edits

Beeps in vista only; should not beep

in all listviews: filter, properties window, types tab
added EnableVisualStyles to Main
Should test every form

Add app.manifest file

Currently writes axisbase1.ini, axisbase1Email.ini, and notice to the intall directory

changed notice file extention to "axis1notice"
test emailing saves configuration

If a nut reference is shown with "Open" and "Unlink" links (for example a list referencing a data subset) and the referened nut has been deleted, pressing Open will cause an unhandled exception

Programming tasks report for release 20080303

On converting a record type (with data) from a date column to a string columns, error "Attempt to store string larger than allocated size"

string gets the internal format; It is now truncated to fit in the string length

When a type conversion failure happens (see bug 164), the temporary type is not deleted, so that no more type changes can occur.

On attempt to import a bad image file format: bitmap constructor argument not valid
in imageeditor eload_linkclicked

in RTF mailmerge, may include too many $endloop$ constructs in a loop while it looks for a closing bracket.
This can be gotten around by putting them on different lines.

Some improvement was made, but full RTF parsing was not implemented.

images are not shown because TextReportBuilder.rowColumnText is not being called

fixed and posted forms dll to ianford.com on 08`1`5

in flight log database,  a report containing a list using a summary fishnet causes "internal JITYER3"

The original error only appears when the list is nested rather than referenced. (fixed)
A null reference in ListController.measureGroup is thrown in other cases. (make separate task if recurs)
In other cases, "a dependent table of a non-persistent table failed to load the non-persistent table". (make separate task if recurs)

On a text import, when a bad value is found, should show the specific bad value and undo the inserted rows

add a find/replace feature to the massage column menu; with formula option

On re-enter params on a report, it asks for the params twice, then fails on re-displaying data

The screen can't repaint while the data controllers are being rebuilt, so the workaround is to always rebuild as if the form was just created, and then close the form if canceled.

Max Content Width bar doesn't react to the Landscape setting

when prompts is unchecked when adding cells to a list, the prompts are added anyway

fishnet sort order does not permit "desc" clause

Undo selected rows - only undoes one row

Programming tasks report for release 20071011

On pressing Test, the "Running external code" dialog comes up, and the mouse is frozen.

In lists PageDown allows it to go a full screen past the end of the list

If you create a data outsource and don't specify a table name on the File tab, no table name is saved.

If a connection from a pool is broken (such as bad session key, in the case of a db server restart), then it fails to recover from this.

If a nested list has a maximum lines setting, it should ignore that setting when printing; instead it restricts 
the list size with no indication that there is more hidden data.

If a user has multiple roles, it is stored in a comma-delimited format, but that format is incorrectly parsed by the client, preventing editing from occuring when the user actually has the rights to edit.

A tab constant in AxUtil was mistyped as '='

In lists, if there are pending changes, and you press Enter Parameters, the changes are discarded without warning.

fixed in list and data subset forms

The old level was set to 75%, changed to 100%

'table cannot be null when autocreating list' - it's retaining an old cached dataset after the source is changed

When you change the password, it should save the password so that the next time the database connection is opened, the new password is defaulted.

Test both change on login and change from menu item.

Programming tasks report for release 20070518 BETA

labelprinter and reports don't print at all since 20070416, because of the use of textrenderer instead of Graphics methods.
Also, zooming in report preview is nonfunctional

Now, the Graphics methods are used for print and the TextRenderer is used for screen

in Label Printer, if the current table name doesnt exist in the current data source, and you choose Insert>Data and Prompts, then the exception "Table does not exist" is uncaught

On clicking on an invalid hyperlnk, SlateViewForm.openHyperlink does not catch the exception

add feature

copy done; paste will probably wait til Axisbase2

don't load from heap when saving, if the heap item is not changing in the save

AxFishFile.hashToRecord rewritten to handle all cases; updateIndexes rewritten to inspect both object[] records and hashtable records.
AxPond.SaveFish(dataset) changed to prevent sending non-changed fields in changed rows to SaveFish(hashtable)

unchecked checkboxes should show up as a box, not blank.

Changed to show as a line, and the check mark shows as a check mark instad of X. But for printing, it still shows X and blank.

Currently it paints the row when the cell editing is finished, and again when it is entered in a new cell, so there is a flicker.

It should load all rows in the given keyset, not just 500

currently you can't select a bulk operation as the target of a hyperlink

during integrity check> heap check, the exception "negative handle encountered" is uncaught; this can occur after the heap check says it is complete

added try/catch and allowed the zero handle to be cleared

Programming tasks report for release 20070416 BETA

on insert into nested list, nested list gets very tall with a lot of blank space (at least if there is a nested scrollbar) and the edit control appears outside the nested list area, perhaps calculated from the outer list bounds

changes in ListController only

in large files, AxPortableBlockFile constructor runs out of memory. AxLocalFile.SaveCopyAs appears to retain a lock on a partially allocated file. Backups are requested on every cycle and fail every time, thus a lot of garbage files are written.
The server does not report backup errors.
NOTE: APPLE is not being backed up currently

added some try/finally blocks to ensure errored file is closed and doesn't consume memory indefinitely.
Found that used count corruption causes save to fail. -> Allowed silent fixing
Found that lazy write thread could interrupt a backup and the consequences were not analyzed. -> Added lock(copy) on SaveCopyAs
Added error reporting from PondForm.
The server should be reporting backup errors.
Added logic to allow server to proceed to another file even if a backup failed, and only try to back up once per day. It now writes to backup_error.txt
Fixed a threading issue in AxBlockFile.

othertd should be marked nonserializable

Say "You only need the server installed if you are using this machine as a server for other machines" or something to that effect.

double columns cannot be summed in the UI in an summary step; the choices don't appear on the list

After loading a list, the first mouse click on anything (including the close box) sometimes fails. May be related to the progress form.

changed which Windows messages were being ingored in the messagefilter

Due to a recent change, the text measurement is not always right. Some text is cut off - it should wrap to 2 lines but the list only shows one line (this may be fixed but not copied to stage)

Changed to use TextRenderer throughout instead of Graphics.DrawString

If you choose from nest/link popup to select an existing data source, and that datasource has more than one table, the Choose Table dialog attempts to show, but it fails and puts the application windows in the background.

should be able to choose reference columns in summary popup

When installer is "run from current location" or from a network share, it crashes. It should detect the problem and explain to run it locally.

Changed to allow paritally trusted callers, then added code to assert full trust and check if they could be granted. 

if there were no trx since the last backup, don't create a backup

installed on pluto 4`14; has the side effect of making a backup after the first transaction of the day
Changed behavior to write backup time and cull old files, even if a new backup is not created.

Programming tasks report for release 20070209 BETA

in bugs database, installer, client

the backups were unopenable; fixed and installed. This task is just a reminder to test this again after several more automatic backups have been made

in FLY database, its too many keystrokes to select the text and then paste new text

1. currently if one message fails, it just stops; it needs to allow skipping or canceling
2. the from/smtp entries should be saved even if it fails
3. error reporting should be more informative; there may be an inner exception

it overwrote on pluto when installing 20070110

the logic was reversed: the backup configuration was being preserved while the main one was being overwritten

add new type of massage accessible from grid context menu:
set column value for all rows - can set to expression or value

experiment with (1) prohibiting the tab key from reverting to view mode; (2) allowing the insert key to work while in edit mode

date format has no effect; in LineOutsourceLoader, it calls AxUtil.Convert, but it should have a special case for dates

there is an inconsistency

on calling savefish twice, it appears to not update the hashtable with the correct ^ver the first time, so the second call fails.

changed return syntax of SaveFish, so that it writes the new version to the hashtable, instead of returning it as a separate out argument.
However, the remoting syntax still has to have the out argument.
Specifically test with ATRA site.

if you enter a bad date and tab (and dont look) it can change it to 1/1/0001. This is error prone; it should give a message.

if the dropdown list is open, then the Enter key should simply select the item, not open the search window.

if the length is over an estimated amount for the maxlines of the cell, it may be able to shortcut the layout

done; vast speed improvement - at least 100x

on dropdown, no change, closeup: shows the same text for all entries

got around bug in DevEx - CheckItems collection contained many copies of the same item.
Also added spaces after commas.

particularly \r\n

done for \r, \n, \t only

ATRA site appears to be copying all records from db server to web server, before filtering

If a fast filter uses a calculated column, the calculated col and filter were being done locally. This was changed so that calculated columns are always done on the server.
Also, aggregates that dont retain details are now done on the server.

complex expression fails: #datetimefield < date() (tries to convert to int64)
also test date()+30 and similar expressions

singlesourcetransform should call AxUtil.Convert to change type. Test by creating a datetime column and setting to a date value.

Check all calls to Expr constructor. Untrapped exception when called from AxTableStep.ReferencesParameter, from ResolverPanel.Init, from FishnetForm.eTabs_SelectedIndexChanged

single line strings, such as in FLY, are measured as one line even if they should wrap

problem with manual deployment; no action taken

If the data source has no parameters but does have optional filters, the list window should show the Enter Parameters link, and the resolver form should show

done in data subset window and DataManager (affects list window)
Testing: causes resolver form to show twice sometimes.
Rewrote some logic in ResolverForm, OptionalFilterList, FishnetForm, DataManager

saving with a name may allow you to use a name that is already in use

if a data subset is based on a data outsource, it will not update the max rows entry

currently you can work in other windows while the progress form is running; this could lead to problems. Could make it a dialog box and run all durational code in worker threads.

progressform rewritten.
DataManager.GetData had to be rewritten so that resolver form was never shown when progressform is active.
All other instances of ShowProgress checked to make sure dialogs are not shown while the progressform is active.

simple aggregation (count all records) without saving detail yields SingleSourceTransform called with bad step type (possibly only with server)

This appears to work when the server is updated; as of 2`1 the pluto server is old and gives this message. No action taken.

join with 'eliminate' checkbox is too slow or hung  (test on apple data/57000 rows)
join with eliminate not checked is slow and processor intensive

Profiling reveals that we should do a binary search on the allowed values in rowPassesFilter; the code was designed for small value sets.

PROFILING RESULTS:
AxHeap.getNewHandle is calling ReadInt64 about 6000 times per call
FlushViewOfFile is being called too many times, some from flush>writeBlockTable, and a total of 5 times per imported record (counter, create, 2 blobs, re-save)

CHANGES
AxHeap.Pack stops packing if there is no room to fit 100-byte or smaller blobs
getNewHandle now remembers if the handle table is nearly full and stops searching if it is; this should cut down on the calls to ReadInt64
AxBlockFile.findBlock now stores up to 4 recently accessed blocks for superfast finding by number
AxVectorFile.findVector now does the same thing as AxBlockFile.findBlock
AxBlockFile.flush rewritten to use a separate thread

PROFILING RESULTS
FindFirst is calling LoadSingleField about 500,000 times per call when called from DeleteBlob, because the big empty space in the vector is expensive to scan through

added code to detect long sequences of empty records, but that could not be fit in elegantly with the existing packing code (the existing code works on one block while the discovery of empty space works on a vector level).
Therefore added code to rewrite block on every 100 deletes.

summary w/o group column with retain details checked causes a hang

It doesn't actually hang, but it takes a long time for many DataRows to be updated to store the relation values; no action taken.

when called from loadLastStep

problem also exists in singlesourceTransform, and performAggregate
Was not noticed before because outsourced data is not filtered during load, so it has deleted rows in it prior to other transforms.
In loadLastStep and singleSourceTransform, added check for RowState.
In performAggregate, called AcceptChanges before processing.

on eOtherTable.TextChanged>getUsableColumnNamesOther; when joining tables from 2 different databases and the other one doesn't exist

if you enter spaces in the summary popup (create one row for each..), it fails

Dynamic compilation fails because the assemblies are not in the same path as AppDomain.BaseDirectory when the dlls are deployed in the web.
It is requiring axisbase1.exe, which it may not actually need.

when splitting comma delim lists, make sure to trim each piece

added method to centralize this

on smtp server error, when continuing, need to re-create the connection. Also try sending only one email per connection.

if parameter values are passed into a list from a hyperlink, it still asks for the values (defaulting to the correct one), because of a recent change. It should only do this if there are optional filters.

The outer list's add/edit/delete checkboxes are controlling nested lists' abilities; each list should be separately controlled

in join after a summary (see APPLE), only the first row of the joined table is populated when 2 or more rows are the same value

because they both have the same table name

works now, if you retain details; a more general approach is needed for axisbase2

in larger files - APPLE, JOE
various types, have not narrowed down cause 
lazy writes theory: no happened on server with version prior to lazy writes
server theory: no because it also happened on client direct open file

fixed closing logic; was sometimes not finishing lazy write; this may not be the whole problem

Loader line 1731 bug created by task 109; attempt to modify collection within enumeration

Programming tasks report for release 20070110 BETA

done, check on pluto server
There may be a locking problem? It didn't create the file when it registered the backup time, on the first try.
Just watch it for a while. - installed version with this on pluto on 12`29
As of 1`3 it was creating backups since 12`29

If a parameter is only referenced inside a c# expression, the reference isn't noticed, so it doesn't ask the user for the parameter value

When you delete a line from the parameters list in hyperlink properties popup, null reference error

might not be working; test with JOE.sale.taxcode

nasty bug - the fast filter comparison for bytes was looking in the first record in the chunk rather than the correct record. All other types were coded correctly.

prior testing resulted in the advice that we can't use DoEvents, so this is not so easy

added argument to allow caller to choose whether to cancel
updated these instances to allow canceling:
LabelPrintEditForm loadpreview, all instances within InitData, SlateView reload edit panel, BulkOpController.GetDataSet & DoOperation, BulkOpForm.loadPreview & Run, FishnetForm.loadPreview, ListForm.crowdResults & loadPreview, EmailForm.Send, FormsUtils.SaveDataSet, AllRecordsForm.hookUpData, ListController.Paint

should test more with server

when using fast filter with type byte, >1, no upper limit, it complains on AxRecList.FindFirst, "object must be type byte"

incrementprimitive was returning (byte)value+1, changed to return (byte)(value+1)

in the regex string, use i=ignore case, m=multiline, s=singleline
example: i.*FOO.*  same as "like FOO" in sql
may either implement as a function regex(col, pattern) or the operator ~

implemented with MATCH() function

add function match(col, searchterms), which returns an integer specifying the rank

implemented with MATCHF() function

AxRankedFilterTableStep - like complex filter but adds a ranking column

canceled; you can get this affect by creating a calculated column using matchf then filtering on that

cache and handle at fishfile level; 
use ^^counter type (string name, int64 value, string expr)
user can seed/reseed monthly
include expressions so that they can be used for strings
AxPond methods - GetCounter(name, bool increment); SaveCounter(old, newvalue) - ensure no process conflicts

This is a breaking change, but the worst it will do is report errors if the server is on the old beta when the feature is invoked.
changed to ^counter, so that the UI could create/delete counters using normal CreateFish, etc

data cell editors are the full width available, while the painted text is the width as defined by the CellBase

add new display type that obtains a value from a counter
add new datacell painter to handle this

* still should test with multiusers

when a list requires multiple FishRefs in order to complete the layout, it should collect them all and hand them to the server in an int array, and receive a string array in return. Currently it makes too many separate server calls.

recoded AxTypeRef.load to use FishnetBuilder
added calls in ReferenceListCellPainter to prefetch AxFishRefs when one is requested that isn't cached

See if it is possible to call CreateFish with a Hashtable, to avoid having to create and then save in two calls.

this has a high risk of breaking code, specificially unique values checks, referential integrity, and changes between remoting clients and servers; therefore it is not being done

added recursive call in getVariables

if '-' is the only char, the popup goes away; probably an int parsing issue

check match between AXIS.file.axisid and the axisid of the served pond once its open; don't allow serving if it was changed.

can trap KeyPress in MemoEdit and change control height, and add scrollbar, BUT don't want to increase height so that it is off the parent control bounds. Also not more than maxlines.

done, but watch this feature - messing with controls while in use can have nonobvious consequences

closing properties window should check if there are unsaved changes in counters

currently you have to restart the server for it to notice the new seed value

when opening a multiselect dropdown box, if the original entry has items in it that aren't in the list, they are erased.
Instead it should temporarily add those items to the list

SaveCopyAs may fail if there are a lot of indexes? test with a larger database

Was omitting empty and unneeded vectors but was failing to remove references to those vectors
done; need to test after installing on pluto

gives untrapped error: single valued parameter expected

1. when choosing 'Count', the term 'rows in group' does not display
2. count - causes null pointer exception 
3. dont include ^ver in col list

if you create a data outsource, dont enter anything, press Test Import, cancel the file dialog, it has a null reference exception

the term "initial filters" suggest it supports more than one, but it appears to only support one

if you create a buk op, dont define a data source, and switch to the data tab, you get an internal error

on start pondform, put in hint that this is beta, please check ianford.com for updates

for exampe, check heap storage -> Close button on working window does nothingm

use the same technique as the help button in axisbase client

should exclude ^ver; currently it fails on duplicate name

to work with string and blob; useful for determining if an image exists

allow: date <--> datetime
all numbers
anything -> string

if a lists data set is invalid and you open a data cell, the exception is not caught

expressions that compare length("...") > 3 fail because 3 is int64 and length returns int32

changed to multiline field

Programming tasks report for release 20061226 BETA

on first edit after reloading, the key is set back to zero; cannot edit again

done

if server is in a different time zone, dates are interepreted incorrectly (not sure how); ignore time zone everywhere

added new tasks to account for this - no action

add connection pool class

on windows Classic theme, no insertion bar is visible in the textboxes
Also the devex controls scroll before you are at the right edge.

serverdb allows lowercase axisids

autocreate user super/super in createsystemstuff

/

catchfish(fishnet), all other params are null
savefish(ds)
axpond.LoadFish(type, fishnet) -> hashtable of first one found or null

test with phonetree

don't bomb on bad row#; 
intent to use like this: 
fishnetbuilder fb = new fishnetbuilder("IRIS.person");
fb.FilterEquals(...)
hashtable x = db.CatchFish(fb.Fishnet).ToHashtable(alertT, 0,0);
x["dob"] = ...
db.savedFish(alertT, x);

/changed to AxDataTable.ToHashtable
test with phonetree

 to take maxvalue rows, all cols, no sort
single col, single row -

test with phonetree

axaggregatetablestep.AddOutput(col, kind, outname)

test with phonetree

staring out, blank slate state should be more instructive - this is when the customer is sizing up the app
1. on showing pond properties, if there are no types, link to planning tab
2. on showing bldg blocks, if there are none, suggest to create some
3. on showing Browse records, if there are no types, say you first need record types

remove user/roles hint - only use hints for actual hints
help links (HL) as follows
HL on each page of pond properties
HL on type level data
HL on integrity check
HL on bldg blocks window
HL on design tab of data subset
HL on data outsource, code, userdef nut
HL on general tab of list, labelprint
HL beneath tabs on window, report
HL on data source tab of bulk op

all help links done; hints are deferred until a specific need is identified

the same fishnet works with LIKE
also test importing temp\cheese to JOE for referenceField import

AxRecList was failing to make the upper limit an indexable string

use UTC time when testing for durations, throughout product

Changed:
/pondform
/progressform
/orderedsubsetpanel
/listfilterbar
/inifile
/axconnection.LastAccessed - UTC
/servedpondcollection - ServedPond.LastBackup
/backgroundworker
/windowsservice

datetime datatype should show local time, allow MS to do its thing with changing the time and timezone on remoting, but it shuld be stored as UTC. Non-nullable. Defaults to current time.

load/save appears ok; Create record seems to fail to make the adjustment, but actually it is a different bug, so this one is closed.

add axdate data type (y/m/d only, no time info), nullable. Update Expr, reclist storage, new painter.

note all the places where you have to change to add a new data type
create new class (AxDate)
AxPrimitive enumeration
AxUtil new methods to read and write to byte[]; PrimitiveByName; PrimitiveToType; TypeToPrimitive; StringToPrimitiveValue; IncrementPrimitive; PrimitiveValueToString, Convert
Expr
ExprCS
AxField/AxFieldFactory
AxRecList
AxFishnet
Loader
DataCellPainter.GetText
DataCellPainter subclass
if affects data outsource: various classes
ParamCellPainter.GetText
ParamCellPainter subclass
VariantEntry

when loading/laying out, show progress bar every 100, not 500

AxPond.save won't delete if there are no non-key columns

this would confuse the server, since it wouldn't change the configuration

/

it is converting to UTC over the wire for all DateTime data; it should be converting only datetime fields, not date fields

redid local/UTC conversion so it affects datetimes only.
wrote AxUtil.FishTimes_LocalToUTC and _UTCToLocal
Called from both sides of SaveFish, LoadFish, CreateFish

pool shouild close all available ponds on thread exit

instead of checking when the main thread exists, a destructor was implemented in AxRemotePond to close the connection on garbage collection
This is not always called, but the server times out connections after 5 minutes so it should not cause a problem in practice.

This makes it too easy to save blank records by mistake. The user should press insert for each new record.

loader error: T9.^^dbprop is based on an invalid type - didn't reproduce locally; possibly I was using the wrong assumed axisID?

no action; if recurs, create new task

if served pond is found to exist, it should keep trying to open/create it on each refresh.
There was some problem with file names not matching up - this fix may solve this.

rewrote parts of ServedPondCollection.Refresh
Still appears to give up, status file says OPEN - ERROR (!?)
Was corrected by another bug fix - Server fails to clear errors

in list window, if a data source was deleted, going to results causes null reference; also pressing Choose Table causes unhandled exception

added tests in NutDataSourcePanel; added tests in ListForm.loadPreview

on new row, the datetime cols default to a value related to when the app started, rather than the current time

added overriding logic in ListController.NewRow

changes user name instead of pw when creating database

when it can open a file after it couldn't, it should clear the error

installed/test on production 

should disable the checkbox; should also ignore the setting

If you click on the bar between menu items, -> null reference error

The text box needs to be tall enough in all themes for the font in use