2025-07-13 4.4.9

• Fixed TOOLS-Import CSV so that it trims the text in each field.
• Added Table view context menu "Fix case-sensitive Sire and Dam". This is useful for databases that havebeen converted from PedEx or other sources which are case-insensitive. The way it works is that it willlook at the Sire and Dam fields and if they are not the same case as the Name field, it will change them to match.
• Fixed loading of SQLite table schema where the first field is integer primary key autoincrement.There is a bug in LocalExtendedDatabase.AddRecord() related to adding a record where the first fieldis an integer primary key autoincrement field. The data for that field will be nulland SQLite will allow that to be added rather than coming up with the next integer.Tried adding a "NOT NULL" constraint and that still does not make SQLite create an autoincrement id.At this stage we recommend users to NOT use an explicit INTEGER AUTO_INCREMENT. Instead use the automatic ROWID.

2025-05-31 4.4.8

• Fixed text reports "Sire/Dam Pedigree". They assumed the sire and dam columns index so broke on some schemas.Also sped them up by using PedDataTableBuilder.
• App now remembers which form the user last clicked on for each group: pedigree. general, shows, reports.So when the large group button is clicked, it selects that form.

2025-04-25 4.4.7

• Fixed FILE-Open Connection-MySQL server, dialog Browse button not working.
• Fixed a bug in the Connector where it was not using the correct field name for the primary key.
• Modified doc merge. Added an "expression" tag of the form {e=a unique name;f=comma separated field names}The name of the expression must not be the same as any field used in form tables. The namecan be used wherever a field name is used, e.g. {r;p=otherrec;...}. When it is used, it will take the value for all the fields in its field list and print them separated by spaces.
• Allowed "r" tags to have no name. This is only useful if the tag also includes an "f" parameter thatspecifies a field or expression name in which case a Field tag is created linked to this record.
• Used the above improvements to create a 4G pedigree Word template.

2025-04-12 4.4.2

• Added major feature: TOOLS-Merge Word document with sub menus: "Current selection" and "Marked records".
• Fixed MARKS-Primary AND Secondary, also Primay OR Secondary. Previously it always wiped out the other bits.
• Fixed F8+Shift being clear primary, also fixed F8+Ctrl+Shift clearing secondary.

2025-03-08 4.4.1

• For the "TOOLS-Add PedPoint tables" command, added a MessageBox with description of what thecommand does and an OK or Cancel.Added "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci" to the create table scripts.
• Fixed DiagramDesignForm by adding "Print Setup" menu item. Previously it would not be possibleto change a forms page size and orientation.
• Changed ConnectorTable.SetValue() error message to indicate size of string being entered.
• One user could download and run the installer but got a permission problem on a MOVEin the C:\Program Files (x86)\PedPub4 folder. Suggested they manually delete that folder first.
• In the Connector dialog, removed the Encode option. It is now always on.One user didn't tick it and got 500 HTTP errors whenever she made a change.
• Every FILE-Open Connection method now saves to the Connections and duplicates are checked for.
• ConnectionInfo.Add() modified to detect equality of connections strings.The previous method just compared the strings but the arguments can be in any order so this fails.
• "Open Hosted" used the Connector dialog. This was probably an attempt to allow multiplehosts in different countries. Temporarily changed it back to the Hosted dialog which doesn't allow setting the URL.
• In Relations view, added "Show Generations" button.
• Fixed TOOLS-Import CSV not handling ANSI files.
• Fixed in DataImplement.cs, DataField.TryParse() exception with Convert.ToInt32() for "~Colour" field.Instead used int.TryParse(text, NumberStyles.HexNumber, null, out int m).

2025-01-29 4.4.0

• The form designer toolbar changed to text size has two extra options: 6 and 7.
• Right click menu on Grid view now has space between "Edit text" and "Duplicate...".
• Fixed exception in TOOLS-Export CSV File dialog with mouse over.
• Fixed a bug where the section text in Relations view was not appearing in the first column.
• Someone sent a screenshot of their FILE-Manage Connections dialog and it had a huge number of duplicates.Small change to code so when someone uses FILE-Open Connection it won't add a duplicate.

2024-12-31 4.3.2

• Fixed problem where first time user gets message "A problem occured while attempting to register...There was a problem saving the settings file...".
• Fixed bug in "TOOLS-Add PedPoint Tables" due to having old schemas for account, session and activity.
• Modified "dog.db" and "cat.db" so the account table matches schema for Pedigree Point 7.2.
• Updated User Manual with new FILE-Manage Connections dialog.

2024-12-29 4.3.1

• Fixed bug in FILE-Open Connection-Connector.

2024-12-27 4.3.0

• Big change to settings. They were stored in "PedigreeCloudSettings.xml" as simple key value pairs.They are now stored in "PedigreeCloudSettings2.xml".The reason for the change is to allow connections to be stored in a tree as we personally have too manyconnections to manage. Created FileSettings2 to replace FileSettings.
• Fixed CompileForm handling of LinkType.StartMulti. It incorrectly used the "Name" field as the keywhen it should have just been the primary key.
• Every implementation of IExtendedTable.Fetch() incorrectly used Union() instead of UnionWith()!!No idea what that was affecting but it did include forms that used links like "[0]=[3]".
• Changed CompileForm so it considers links of type [N]=[N] as being IsContinue=true.
• CellReference.IsValid changed to use RecordReference.IsValid.
• RecordReference.Name changed to RecordReference.PrimaryKey.
• Changed TableForm.Table.set so call to OnGridSelectionChanged() has ByUser = true. This could have side effects. It was changed so when a table is first selected the (0, 0) cell becomes the CurrentCell.
• If multiple rows and a single column is selected and the column is of type number, then the sum is displayed in the status bar.
• Increased allowed generation for text pedigree report to 15.

2024-11-21 4.2.34

• Fixed issue with many blank rows being added.

2024-11-06 4.2.32

• Modified Connector so it reverses the SQL string. Users will need to get the latest pp_connector.php and customise it.
• Changed TOOLS-Import Database. If a field is a primary key and string type then the size if limited to 256.This is to avoid a problem found with one database, where the Pedigree.Name field containeda string over 3000 characters. Also the data that is loaded now excludes any record where the primary key string fieldis more then 256 characters and also excludes records of length > 4096 characters.

2024-09-04 4.2.31

• Major refactor of ExpressionLexer to correctly handle field names that start with a digit.
• Improved error message when parsing an Expression by including the line so far.

2024-08-24 4.2.30

• Added version of PedChart with the original straight lines, to all forms and made slight improvements to rendering.
• Fixed tooltip over filterbox.

2024-08-21 4.2.29

• Changed filter appearance so cross is inside the filterbox.
• Fixed bug in Table view filter when field has space or other illegals.
• Changed Table view context menu order.
• Slight change to all database templates. For the Contacts table, added a Country field.
• Changed the TreePedControl so it has the option to draw lines instead of boxes, changed last gento be left aligned, added more lines to the boxes version.

2024-08-11 4.2.28

• Fixed Alter Table and Create Table problem with clicking Primary Key and Autoincrement.

2024-07-23 4.2.26

• Changed filter so it has a cancel symbol next to it. The Delete key is now also handled.

2024-07-14 4.2.25

• Added per column filter to Table view.

2024-07-07 4.2.24

• Added "TOOLS-Add feature-Convert this field to handle large text" command. Only applied to MySQL and converts a varchar field to text.
• In Table view added right click menu command "Edit Text" which brings up a dialog box to allow editing large amounts of text.
• Large changes to TOOLS-Alter Table. Added an extra column "RawType" which thew database type that server type uses, e.g. MySQL has text. Added more types. The user can now specify "text" as the RawType. This is useful for handling very large amounts of text, e.g. a notes field. Setting either Type or RawType will set the other. Setting the "varchar(N)" will set the Character Max.
• In Table view added "TOOLS-Add feature" menu command with sub-menus: "Add ability to set individual row height", "Add lookup table to this field"
• Modified IsFemale() to consider "spayed", "sp" as female; "neutered", "nt" as male.
• Added "Open link" to right click menu in Grid view.

2024-07-07 4.2.21

• Fixed text report "Reverse Sire/Dam Pedigree" being limited to 20.
• Changed create table script for _fields so it includes Height and Section. Section was already in most scripts.
• Changed RelationsForm to add context menu "Select Color".
• Fixed crash exception when double clicking in the first column (Col==-1).

2024-07-07 4.2.18

• Changed Connector code to work with latest pp_connector.php.

2024-07-07 4.2.17

• Changed TextReportContext.CallFunction() so it calls Convert.ToInt32(arguments[1]) for integer arguments so it accepts string or int.
• Changed text report font to "Segoe UI" 9pt.
• A user reported having to constantly re-enter her registration. Changed CheckLicense() so it immediately saves the settings file and if there is an error it reports it.
• In Table form, added option for tiger striping.
• In Diagram form, added "Set Font" button
• Updated DataDoctor self-parenting detection and auto-correction. User compained they can't calculate COIs. Also we urgently need it for Worldpedigrees which has many breeds with selfing.
• Updated all form files so "reverse sire pedigree" etc have consistent generation options.
• Noted that PedigreeModel.BuildPedigreeTable() gets called twice for PedChart and possibly some other IDiagramControl's. First time is if CompileForm() says there is meta data, i.e. COI etc in which case it recalculates the subject but as a record in a PedDataTable with COI calculated and extra fields added and for gens=10 which exceeds the maximum expected in pedigree forms which is 8 ATM. An IDaiagramControl will then call PedigreeModel or ReversePedModel etc but with 0 gens.

2024-07-07 4.2.12

• Fixed TOOLS-Export CSV and Import CSV problem with pipe separator (|). Note Import CSV does NOT correctly handle CRLF within a field!!!
• Changed MySqlRemoteDatabase.RunQuery(sql) to detect MySqlDateTime and convert to DateTime.
• Added "MaxGen" to the GENETICS-Calculate Inbreeding command.
• Fixed up dialog title in HELP-About.

2024-07-07 4.2.11

• Fixed GENETICS-Calculate Inbreeding, Report tab, "Total number of ancestors" and "Total number of possible ancestors" producing negative or very small numbers due to numeric overflow.
• Fixed: IsCaseSensitive() threw a null exception.
• Fixed up language translations.
• Users have reported problems with saving field orders on MySQL. The problem of course is the VIEW-Fix field order problem.

2024-07-07 4.2.9

• Fixed VIEW-Set grid font not being saved and reloaded. Changed the way it interacts with VIEW-Increase character size. If font is set then changing the character size does NOT apply to the grid. Also fixed the diagram "Show List" dialog not using the specified grid font. Grouped the two menu items together.
• Fixed PedChart context menu Edit.
• Fixed exception in Navigator, Relations.
• Fixed two exceptions in DataDoctor BornBeforeParents.
• Added TOOLS-Import GEDCOM file. Assumes data has fields: SURN, SEX, BIRT+DATE, TITL, NICK, FAMC. Only uses the FAMC linkage not the CHIL linkage in the FAM record. The pedigree table must have these fields: Name, Sex, DOB, Sire, Dam, PreTitle, 'Call Name'. Note: the file must be in UTF-8 format. The sample I was sent was in ANSI so had to use Notepad++ to save as UTF-8.
• Fixed text pedigree report following blank names to create a pedigree. This caused problems if there was a record with a blank name and with a sire or dam.

2024-07-07 4.2.2

• Added multi-language support.

2024-07-07 4.1.118

• Expressions can now use Pedigree Point style string formatters. Example: "{v=pretitle;s=title} {v=name} {v=posttitle;s=title}"; The codes are: v=field or variable, a=after, b=before, f=format. Not implemented at this stage is: s=style, e=enclosing style. We might however add: c=color.
• *FEATURE* Connector databases can now access the photos on the web server if the photos folder is set to "*". When the context menu "Insert Photos" is used, Pedigree Cloud get a list of the photos on the server. When a pedigree or other form is displayed the photo is taken directly from the server.
• Fixed "Insert Photo" when there was no folder it asked to create one and when user said no it didn't exit.
• Changed "Import PedPub into MySQL..." to "Import Database...".
• Changed TOOLS-Import Table so it checks if the new name for the table being imported already exists in the current database. If so it offers to delete it first the continue the import. Also it can now also import into MySQL. Also fixed problem where the table being imported had fields with ForeignTable set to itself. This is now changed to the new table name.
• Fixed exception in MySqlDatabaseSchema.ApplyMetaChanges() because a null field in a newly copied table created via TOOLS-Import Table command.

2024-07-07 4.1.117

• Fixed images on forms not being saved. This only occured if the image file path is longer than 32.
• Fixed MySqlRemoteTable.GetEnumerator() when the table has no fields.
• Modified DataDoctor to calculate offspring. Wasn't useful in finding self-parenting so removed it.
• Removed error message in MySqlRemoteTable.SetValues() due to commands in transactions not returning the right number of rows modified.

2024-07-07 4.1.116

• Note Connector doesn't report rows affected not matching because the PHP file pp_connector.php uses mysqli_multi_query() which does not correctly report rows affected.
• Fixed grid updates also failing silently, e.g. if Clear failed there would be no event message.
• Fixed Connector not detecting incorrect key.
• Fixed TOOLS-Calculate Inbreeding for All, silently failing when writing results back to the database. It now reports if there were errors.
• Fixed Events view showing columns in wrong order.
• Fixed problem with TOOLS-Export to Worldpedigrees "The table xxx contains an illegal field type 'double'."
• Fixed problem in Relations view showing colour mark fields.
• Changed IDataTable by adding IProperties Property. Used to get default breed for a table.
• User reported problem they couldn't write Lithuanian characters to MySQL. Found out the issue is you need to add "Charset=utf8;" to the connection string.
• Fixed TOOLS-Export CSV not exporting heading.

2023-03-22 4.1.113

• Fixed problem converting a .BMX file that had a table name with quotes in it.
• Fixed problem converting .MAX files if there are duplicate field names in a table.
• Added support for MySQL composite keys.
• Fixed problem with TOOLS-Export CSV not exporting if the table has a record with a DbNull as the primary key value.

2023-02-12 4.1.111

• In Form view, added "TOOLS-Rename Form..." and "TOOLS-Duplicate Form...".
• Fixed tooltips not working for Owner, Breeder in the Pedigree table and foreign tables generally.
• In "VIEW-Set Tooltips" fixed not deleting expressions and also changed the dialog to not show the Name column as this is not relevant.
• Relations view now has tooltips.
• Fixed up Pedigree Point export for Scandinavian countries. The local culture causes floating point numbers to be printed with commas for the decimal point.

2023-01-24 4.1.108

• When inserting an image it insists the image file is in the same folder or sub-folder of where the form file is located. This restriction is now removed.
• When editing a form, changed the way images are selected so instead of having to click on the boundary the user can click anywhere inside the boundary.
• When adding an image to a form it now pops up the file open dialog first then inserts the image at a fixed location and size and in a selected state.
• Fixed problem with EDIT-Copy in grid not copying when selecting larger row first.
• The "Refresh Form" button in DiagramDesignForm now prompts to save if the form file is modified.

2023-01-01 4.1.107

• Fixed problem using "Connector" where updating of linked fields fails.
• Fixed text report "Offspring" so litters are in date order.
• TOOLS-Export to PedigreePoint now persists the "Database" parameter.
• Added "MARK-Substring dialog...". This pops up a dialog as opposed to the "MARK-Substring" command which runs immediately. The dialog version has options for "Match case" and "Match whole field".

2022-12-28 4.1.105

• Merge Manager menus added SEARCH-Find Next, Find Previous, Find Replace, Find Similar.
• Sped up the scrolling etc.
• Fixed DOB not merging.
• Fixed exception when double clicking datagrid cell in Merge Manager. Fixed random green background when hovering.
• In datagrid, click on top left corner now selects whole grid.
• "Add XXX Sib" buttons in relations view now also copy the "Country of Origin".

2022-10-17 4.1.104

• Fixed Connector error message. pp_connector.php throws an error without the "==" because of the call to the DataConnection ctor in the pp_config.php when the MySQL connection is incorret. This error message is now shown.
• Fixed problem with Connector database, "FILE-Save Copy of Database As".

2022-10-15 4.1.103

• Fixed "FILE-Open Backup File..." so it opens in the Backup folder.
• Added "FILE-Open Backup Folder".
• Fixed exception in DataDoctor Self Parenting check that occurs when a record has a null name.
• Fixed "EDIT-Copy as Image" throwing an unhandled exception if the form is too large. It now shows a dialog box with message "The form is too large to copy. Instead, we suggest using FILE-Save to PDF.".
• Changed the way the drop down list scrolls to the nearest matching record by making it case insensitive.
• Change GENETICS-Calculate Inbreeding so it does the calculation on a background thread, thus allowing a wait cursor to be shown and the grid to be blanked prior to the result being shown.
• Percent of blood calculation is only done when there are less than 10000 ancestors because it uses too much memory.

2022-09-20 4.1.102

• Fixed "Show repeated ancestors as colored" in controls where text is invisible.
• Fixed exception in GENETICS-Calculate Inbreeding dialog grid.
• Fixed problem in Data Doctor, "Remove extra spaces and illegals", where a "non breaking space" was not recognised as a trailing space. Code now recognises all whitespace characters.

2022-09-20 4.1.101

• Added FILE-Open Connection-Connector. Added pp_connector.php to Pedigree Point. It requires that $pedigreeCloudConnectorKey be set to a long random string in pp_config.php. Avoids having to deal with the MySQL Remote Access. It is surprisingly fast and everything works!!
• Changed "HELP-Support-Send ... to support" to it is now a dialog which also asks for the problem description.
• Added to eventlog: product version, registration, current culture.
• Fixed problem with 4.1.100
• the titlebar shows 4.1.10.
• Fixed "HELP-Support-Send ... to support". Problem was it was still using the old http instead of https for www.breedmate.com.
• Fixed up "Show champions in red" and "Show marks as..." in the TreePedControl, CircularPedControl and DescendantsControl.
• When a .BMX file is now opened, if a .DB file with that name already exists it no longer overwrites it.
• Updated cat.db template and catsampledata.db so they have a PostTitle field. Updated cat forms so the "3
• 10G Text Pedigree (Compact)" has ([DOB]) at the end. Also added [PostTitle] after the name in all pedigree forms.

2022-09-20 4.1.100

• Upgraded MySQL Nuget package to fix bug connecting to some MySQL servers.

2022-09-20 4.1.97

• Added "VIEW-Increase character size". It had been removed at some time without the change being documented.
• There is a problem with TOOLS-Export PedPoint. If a field has a single quote in the name then it won't be exported.

2022-09-20 4.1.95

• Fixed MARK-Substring in Color/Colour column.

2022-09-20 4.1.94

• Changed "Add blank record" button in Navigator to "Blank record" and made its action to set the Navigator's editor open a blank record which may or may not exist, but the point is it definitely does not add an actual record. Then when the user enters a non blank name in the originally blank name field it treats this as actually adding a record. If a record with that name exists it simply opens that record in the editor hence it correctly handles duplicates.

2022-04-18 4.1.93

• Fixed MARK-Substring bug if it is the first MARK function called after startup.
• Fixed bug in Relations View where if a one or more sections are folded then marking doesn't work for records after the folds.
• Navigator: added "Add blank record" button.
• Fixed PDF form printing with text printing outside bounds, so word wrapping is now correct.

2022-03-27 4.1.92

• Fixed "Show marks as colored text".
• Fixed Text report compiler so that object methods work, e.g. "A StRiNg".toLower(). Implemented toLower(), toUpper(), like(), pad(), setMark().
• Fixed FunctionAstNode so it can handle a null argument list.
• Changed Breed Planner grid to always show the Name column.
• Text reports now have interpolated strings, e.g. "The name of the breeder is $breeder". If the $ is changed to an @ then the string is escaped, e.g. "select * from pedigree where breeder='@breeder'".
• Text reports now have a query() function which returns a datatable from a database query. This is a much faster way of running reports. The query string can be an interpolated string, e.g. "select * from pedigree where breeder=@breeder" and @breeder means the escaped version of the value of the variable $breeder. This can be used as follows. First here is how you previously listed all champions. <# println 'Test to print name and reg no of all champions' for $p in $Pedigree where $p['PreTitle'].like('CH') println $p['Name'], $p['Reg No.'] end for #> Now this is how you can do it using query(). <# println 'Test to print name and reg no of all champions' for $p in query("select * from pedigree where Pretitle like '%ch%' ") println $p['Name'], $p['Registration'] end for #>
• Text reports now have an expr() function. First argument is a DataRecord, second is an expression string. Sample usage: $expr1 = "[PreTitle] [Name] [PostTitle], [Registration]" println "Pedigree of: ", expr($Subject, $expr1)

2022-03-26 4.1.91

• Fixed Breed Planner so it shows marks.
• Fixed converting BMX file with table that already has a _Marks column.
• Fixed converting BMX not loading meta data like field width, forecolour, backcolour etc.
• Fixed converting BMX not loading field orders.

2022-03-20 4.1.90

• Changed "TOOLS-Backup MySQL Schema and Data to PedPub" to "FILE-Save Copy of Database As...", and "TOOLS-Backup MySQL Schema only to PedPub" to "FILE-Save Copy of Database Schema As..."
• "FILE-Save Copy of Database Schema As..." works for local, hosted and server databases.
• "FILE-Open Hosted File" and "FILE-Open Cloud Connection..." moved as sub-menus to "FILE-Open Connection" and renamed "Hosted..." and "MySQL Server...".
• "FILE-Save Backup" now also works for hosted and server databases.
• "HELP-Support-Send database to support" now also works for hosted and server databases.

2022-03-17 4.1.89

• Added VIEW-Change column order.
• Table view context menu, Set Mark and Clear Mark added.
• Fixed Relations view folding, which was broken in 4.1.87.
• Fixed bug when creating a text report.

2022-03-04 4.1.87

• Table view will now select the record when a name is selected from the taskbar combobox.
• Table view and Relations view, combobox's dropdown list is now at least as wide as the control.
• Relations view will now show relations when a name is selected from the taskbar combobox.
• Navigator relations is now run asynchronously, making the edit part of Navigator a lot more responsive.
• Changed FILE-Merge Database. Instead of a file open dialog it now opens a dialog that allows user to select the file, choose the merging option from: "Combine them, only filling in blanks in current database record", "Don't import records with the same name", "Change the name of the incoming record by adding [other field] to the name". Also user can select "Other field to add to name". So if the "Change the name..." option is chosen and the other field is "Country" then if there is a name collision then the incoming record is renamed by having the value of the "Country" field added to the name in square brackets.

2022-02-28 4.1.86

• Fixed registering Pedigree Cloud.
• Fixed Report-Reverse Pedigree Sire/Dam and updated all those reports in US and non-US cat/dog forms so the expression includes (Sex).

2022-02-23 4.1.85

• Fixed forms not linking records where primary key field name is not "Name". This affected e.g. the Onwer or Breeder's address on a standard pedigree form.

2022-02-20 4.1.84

• Fixed PedPub hosted file access.
• Changed TOOLS-Import CSV so it persists the file path and separator. The dialog was modal, now its not. Also moved some controls around and add an explicit "Preview" button because it wasn't picking up that the text in the file path textbox had changed.
• Fixed problem with saving form files which have forms with illegal XML characters like &. This results in a form file which can't be opened.

2022-02-12 4.1.83

• Added "HELP-Support-Send all to support", "-Send database to support", "-Send form file to support", "-Send screenshot to support". The files are combined in a single ZIP file and uploaded to www.breedmate.com which then sends email to support@breedmate.com with download link for the ZIP file. Have tested with a 213MB .db file which compressed to a 58MB zip file.
• Fixed "Mark Born before parents".
• Changed Table view context menu so if any sire or dam with a name that starts with "#" is clicked, then the Siblings of, Offspring of etc menu items will not be shown. Reason is that "Offspring of #Unknown" yields a potentially huge list.

2022-01-29 4.1.82

• Fixed problem with marking a table when the primary key field is not Name or has a composite key. Also fixed problem where _Marks allows defaults and is thus usually null.
• Changed form design zoom by adding after 300 the following zooms: 350, 400, 450, 500, 550, 600.
• Changed mouse move in form design so it displays width and height in the status bar.
• Changed mouse up in form design so if one object is selected, then it displays width and height in the status bar.

2022-01-12 4.1.81

• Fixed bug in MARK-Born Before Parents not handling null DOBs.
• Fixed bug in TableGridPresenter when view is sorted or filtered and a primary key field is changed resulting in a blank row.

2022-01-05 4.1.80

• Fixed bug when connecting to MySQL where CharacterMaxLength was greater than int.

2021-12-14 4.1.79

• Slight change to TOOLS-Export to PedigreePoint so duplicates are ignored.

2021-11-28 4.1.78

• Changed TOOLS-Import AKC so that "S." is not converted to "s.".
• Changed TOOLS-Import AKC so that incoming data is merged. In the previous version if a record in the AKC input file had a name that already existed then record name would not be added. Now its data will be merged.
• Changed TOOLS-Import AKC so that field widths in the dialog can be modified.

2021-11-07 4.1.77

• Fixed "TOOLS-Export to PedigreePoint" not exporting the percent codes.

2021-10-30 4.1.76

• Fixed display errors in Breed Planner.

2021-10-26 4.1.75

• Added message at start of DataDoctor run as to which table.

2021-10-10 4.1.74

• Fixed can't sort table that doesn't have _Marks.
• Changed PedPub4 to use the same PedCloudUserManual1.pdf file as PedCloud4. Updated manuals on Breedmate website.
• Fixed BMX converter so it adds ForeignTable for Sire, Dam, Owner, Breeder. Sets Format on DOB, Photo.

2021-09-28 4.1.73

• Fixed problem where entry's names containing color were changed to colour.
• Fixed DataDoctor DuplicateRegistration not obeying Exclude Selected.

2021-09-16 4.1.72

• Added "Duplicate registration" test to DataDoctor.
• Fixed Navigator Edit not being able to edit some ancestors in forms.

2021-09-15 4.1.71

• Fixed problem where if you click on an ancestor in any form that calculates COI, the Navigator won't show it in Edit.

2021-09-01 4.1.70

• Fixed MARK-Common Ancestors. Also if less than 10 common ancestors they are listed in the message dialog.
• Fixed [$COI] not working in Family Tree and other forms that use [$COI]
• Fixed clicking on form ancestor not showing it in the Navigator.

2021-08-21 4.1.69

• Fixed DiagramForm select PedChart nodes with matching names.

2021-08-20 4.1.68

• Added "TOOLS-Save text report as...".
• Fixed right click in PedChart menu and also node selection which was broken in last few releases.

2021-08-19 4.1.67

• Fixed Text Reports: Ancestor List, 4 10G Html Pedigree. They were broken in the refactoring in 4.1.64.
• Fixed DOB etc format on GENETICS-Calculate Inbreeding.
• Added "VIEW-Mark added records" which is an option that allows users to mark a record automatically when it is added.

2021-08-18 4.1.66

• Fixed red wavy lines sometimes missing when a foreign table hasn't been opened.
• Fixed FILE-Merge Database merging _tables, _fields etc. Also fixed that it wasn't merging datetime or other non-string fields.

2021-08-14 4.1.65

• Changed FormExpression for ExportSQL so it uses the format for doubles, e.g. [COI:p2].

2021-08-13 4.1.64

• Fixed problem with toolbar "Find Entry" when the primary key field is not Ordinal==0.

2021-07-30 4.1.63

• Fixed problem with calculating COI not ignoring invalid references, i.e. names starting with #.
• Fixed "Pedigree Calculations" Save Results.
• Fixed when single record added or duplicated that it isn't marked.

2021-07-18 4.1.62

• Fixed bug in hosted connection.

2021-07-17 4.1.61

• Fixed "Backup MySQL Schema and Data to PedPub..." .
• FILE-Cloud Connections dialog can now add, edit or delete CH as well as MySQL.

2021-07-07 4.1.60

• Added feature for text reports. An argument can now be followed by a colon and then a string. The string is the .NET format string to apply to the value. E.g. $Subject["DOB"]:"MM-dd-yyyy". The colon was previously the "range" operator. This has now been replaced with "..".

2021-06-30 4.1.59

• Fixed issue when user accidentally changes text in Name field, is prompted with "Change text in linked fields?" clicks Cancel but it still changes Name.
• Fixed line breeding calculation in GENETICS-Line Breeding.

2021-06-25 4.1.58

• Fixed problem that it doesn't detect form file changed if a Text Report was edited. Also changed "Edit report" button text to "Return to report" if in edit mode.
• Fixed TOOLS-Alfirin Export for MySQL which is configured for case sensitive table names.
• GENETICS-Calculate Inbreeding for All is now much faster.

2021-06-23 4.1.57

• Fixed TOOLS-Alfirin Export.
• GENETICS-Calculate Inbreeding dialog can now be left open or floating.

2021-06-22 4.1.56

• Changed GENETICS-Calculate Inbreeding by adding a checkbox "Show linebreeding only". When checked it only shows Name, Sex, Sire, Dam, Linebreeding.
• Fixed EDIT-Insert Records when using SQLite and table has no real primary key, i.e. it is using ROWID. After insertion the rows did not appear.
• With in-grid editing, the Delete key and SHIFT cursor keys now work.
• Fixed add and edit of data in tables with composite primary keys.
• Changed EDIT-"Remove Diacritics"" to "Remove Accents From Characters".
• Merge Manager now pins Name column.
• Changed all database templates so Date fields use format auto.
• Added to dog.db a "Litter Journal" table with Name, Date, Weight, Notes.

2021-06-15 4.1.55

• Changed BMX import so these field names in the pedigree table are changed: "Inbreeding Coefficient" => "COI", "Relationship Coefficient" => "AVK".
• Fixed sorting bug introduced in previous release.
• Fixed "VIEW-Fix Field Order Problem".

2021-06-15 4.1.54

• Swapped "Find Entry" and "Find" buttons.
• Fixed Data Doctor, click on Entry, to hyperlink to record in Grid view. Hyperlink underlines when hovering.
• The Data Doctor configuration is now persisted.
• Added "Exclude Selected" button to Data Doctor. The selected records will be excluded from the relevant test.
• Fixed Data Doctor, "Remove extra spaces and illegals" so it removes illegals. These are classified as control characters. Also fixed problem that if the change caused a duplicate key all changes would fail. It now makes all possible changes and reports that pairs of names that are duplicate when changed.
• Changed Table view, EDIT-Copy so its much faster.
• Added DateTime column to Event view.
• Fixed problem where if you did a SEARCH-Find Replace and one or more of the replaces resulted in a duplicate key, then all the replacements would silently fail.

2021-06-04 4.1.53

• Fixed Alfirin export.
• Added "TOOLS-Calculate AVK for All", and removed AVK calculation from "TOOLS-Calculate COI for All". This was done because COI is usually calculated for all generations whereas AVK is usually calculated for 10 generations.
• Fixed EDIT-Clear of double, integer, datetime fields. Previously if you cleared datetime it would show as four asterisks and throw when opening.
• Fixed EDIT-Insert Records and TOOLS-ImportCSV. They didn't handle double, datetime or int empty strings.
• Update template .db files so they all have AVK.

2021-05-30 4.1.52

• Fixed FILE-Recent Files menu.
• Fixed FILE-Save Copy, Save to Backup.
• Changed MARK-Clear All Colors so it prompts user first with "Are you sure you want to clear all Mark colors?"
• Changed Navigator Edit so dropdown list uses the mouse wheel.
• Changed Event view by adding context menu items: Copy, "Save to File", Delete Selected.
• Changed Data Doctor by adding context menu items: Copy, Save to File, Remove Selected.
• "GENETICS-Calculate Inbreeding for All" now also calculates AVK to N gens and writes back to the database if the table has an AVK field.

2021-05-26 4.1.51

• Adjusted Navigator Relations to be narrower.
• Fixed Relations, subject appearing as full sibling, offspring missing.

2021-05-23 4.1.50

• Fixed MARK-Ancestors and MARK-Siblings.
• In Table form, added context menu items "View ... in Relations" and "View ... in Navigator".
• Double click in Relations form jumps to that entry in the Table form.
• Relations view subject only changes when "View in ... Relations" selected or "Relations" button clicked.
• "GENETICS-Calculate Inbreeding" now warns if the table is missing one of the mandatory fields: Name, Sex, DOB, Sire, Dam.
• In Relations view, added context menu for Delete and Clear.
• In Relations view, when a sibling is added, only the Sire, Dam and Breeder are copied.

2021-05-21 4.1.49

• Changed FILE-Merge Database so it doesn't show dialog with option "Keep duplicates" as this was ignored anyway and is dangerous. Instead it just shows a normal file open dialog. Also it now updates the progressbar.
• Fixed Relations view working with non-pedigree tables.
• Fixed ReportAll view working with non-pedigree tables.
• Fixed DataDoctor working with non-pedigree tables.
• Changed GENETICS-Calculate Inbreeding dialog to also offer calculation for 6, 7, 8, and 9 generations. Also removed "Calculate line breeding" option and made it always true. Changed "LineBreeding" format from e.g. "5, 5, 5 ~ 6" to "5S x 5S x 5S x 6D" as this is standard thoroughbred format.

2021-05-14 4.1.48

• Fixed Enter not working sometimes to move to next grid cell.

2021-05-14 4.1.47

• Fixed VIEW-In grid editing, not saved.

2021-05-12 4.1.46

• Added VIEW-In grid editing.
• Added EDIT-Remove Diacritics.
• Tabbing in same record now doesn't add new search name to Navigator.

2021-05-10 4.1.45

• Fixed Text Reports with siblings. Removed indenting on siblings.
• Text Reports for sireLine and damLine now have an optional third argument to limit number of generations.

2021-04-30 4.1.41

• Fixed problem in Merge Manager where column data doesn't line up between the two databases.
• Much faster to load databases with lots of tables. Created LoadAllTableMetaData() and LoadAllFieldMetaData() to load all tables at once.
• Table name now shown on toolbar.
• Changed Database drop down menu to group table names based on underscore prefix.
• GENETICS menu added separators between menu items.
• GENETICS-Calculate Inbreeding now writes the COI back to the database.
• Changed TOOLS-"Backup MySQL to PedPub" to "Backup MySQL Schema and Data to PedPub" and added TOOLS-"Backup MySQL Schema only to PedPub".

2021-04-27 4.1.40

• Relations view changed so Name field remains on screen when scrolling.
• Fixed not being able to "View primary marked".
• Fixed Data Doctor, Missing Parents.

2021-04-24 4.1.37

• Added drag drop to relations view.
• Refactored MarkFunctions so all versions inherit from MarkFunctionsBase.
• Relations view now uses the table field order.
• Relations view now has right click context menu with options to view selected cell in the Grid, Relations or Navigator.

2021-04-22 4.1.36

• Changed relations view to not show siblings of sires or dams that are invalid references, i.e. n ames that start with a #, and to not show litters of an invalid reference.
• Relations view now has +/on some headers to fold up the contents of that list, e.g. Full Siblings.
• Fixed TOOLS-Export CSV outputting one line less.
• Fixed Merge Manager, "Show new plus differences".

2021-04-17 4.1.35

• Fixed Mark-Substring for datetime fields.

2021-04-13 4.1.34

• Changed MARK-Mark N Generations so user has option to mark generations of ALL marked records.

2021-04-09 4.1.33

• Fixed TOOLS-Import CSV.
• Changed TOOLS-Export CSV so the separator combo lists the separator names as well, same as Import CSV.

2021-04-07 4.1.32

• Changed Mark functions so they work on any table not just the "pedigree" table.
• Added MARK-No Match. Rearranged MARK menu to put all "pedigree" commands grouped at the bottom.
• Fixed Merge Manager so the primary record comes after the secondary record same as Pedigree Publisher and Pedigree Explorer.
• Added "Check case sensitive" to DataDoc. It will check if any names in the current table are different case versions of each other. If there none then it proceeds to check all sire and dam fields for any that match a name case insensitively but are a different case and changes that field to match the name exactly.
• Merge Manager now shows the _Marks field.
• Relations view changed so litters are grouped by DOB and mate and ordered by DOB. Ancestors in the generations are now in the same order as Pedigree Explorer, i.e. Sire, Dam recursively.

2021-03-29 4.1.31

• Changed MySql so they are faster when connecting to a database which has a large number of tables.
• When selecting multiple rows in table view it will display number of rows selected in status bar.
• Changed link expressions. The join expression must now start with =. It is now of the form "=[source]=[target]" where source or target can be either the field index or the field name. A continuation link expression must now be "=>".

2021-03-21 4.1.30

• Added "Male Line" and "Female Line" forms to Forms.
• Changed depth on CompileForm from 15 to 40.
• Add detection in CompileForm for "small" objects.
• Fixed problem sorting table with ROWID primary key, e.g. Ownership.
• Fixed marking a table with a primary key not called Name. Note still only works with tables that have a single primary key.
• Completed "Entries Owned" form and added it to DogForms2.fox and UsDogForms2.fmx.
• Fixed StartMulti/ContinueMulti links in forms. Major fix to CompileForm() which never implemented it.

2021-03-14 4.1.29

• Fixed DateTime parsing of "yyyyddmm" format.
• Fixed problem with entering DateTime in Norway and possibly other countries.
• Fixed LocalDatabase.AlterTable when removing field it did so correctly but what was displayed in the grid was shifted. Also if the table had no primary key, such as the Ownership table, then if there was any significant change to the table the fake ROWID became a real string field and the table could no longer be edited.

2020-03-13 4.1.28

• To assist with finding bad dates the cell is shown as "*****".
• Changed form design mouse actions: select, drag, resize, so they work with objects outside the page bounds.
• Fixed GENETICS-Calculate Inbreeding for all failing due to a DOB field being cleared.
• Changed "Insert Photo" so it recognises the .JPEG file extension as well as .JPG.
• Fixed Forms-Record of Litter. It wasn't showing the contact details. Also reformatted columns etc.
• Changed limit of Report-Reverse Pedigree from 8 to 20. Changed Reverse Pedigree etc to include generations of 10, 15, 20.
• Semicolon added as a separator option to the Import CSV dialog.
• Changed the way Relations view so adding a sibling always applied to the subject not the currently selected record. This is how PedEx works also.
• UsDogForms2.fox and DogForms2.fox fixed 4G Pedigree and 5G Pedigree so Photo field is displayed in parent generation.

2021-01-03 4.1.27

• Changed AddRecord, so if the table has an integer autoincrement primary key it will add the text to the first field rather than to the primary key field.

2020-12-24 4.1.26

• Added EDIT-"Add missing links to Lookups".
• Fixed "FILE-Print to PDF" and FILE-Print missing the watermark.
• Fixed some exceptions when no database open and adding, searching etc.
• TableForm changed so if user tries to add empty text it pops up a message box. Did this because a few users kept saying they couldn't make any changes!

2020-12-12 4.1.25

• Added COI to the Report tab of the TOOLS-Calculate Inbreeding dialog.
• Fixed SetValue() and Delete() for tables with composite keys where one of the keys is DateTime.

2020-11-22 4.1.24

• Fixed inability to change case on a primary key. This was initially fixed in 4.1.19 but was undone by 4.1.22 which fixed "where selecting an entry while in the primary key column and hitting enter does not take you to that entry".
• When a cell or cells is cleared, it now also clears the toolbar combobox so that hitting enter does not cause the cells previous text to be written back into it.

2020-11-21 4.1.23

• Fixed photos not appearing. Reason was that there was a space at the end of the connection string and if the photopath parameter was the last parameter in the connection string it got a space at the end of the folder name AND this is enough for a photo path to look correct but not be correct.
• Fixed Mark-Substring for integer fields, in particular colour fields.

2020-11-17 4.1.22

• Updated User Manuals for Relations view including Add Sibs, Added Main Menu commands for EDIT and right click menu commands including "Offspring of" and "Siblings of".
• Added HELP-Update User Manuals.
• Fixed bug where selecting an entry while in the primary key column and hitting enter does not take you to that entry.

2020-11-15 4.1.21

• Relations view now has "Add Full Sib", "Add Sire Sib" and "Add Dam Sib" buttons.
• Double click on ancestor in Forms view now takes you to that ancestor in Grid view.

2020-11-12 4.1.19

• Fixed inability to change case on a primary key.

2020-11-12 4.1.18

• Added [%N] as an allowed variation of just %N. In this variation you can also apply formatting: [%N:format-string], e.g. [%6:yyyy-MM-dd].
• Fixed Merge Manager, "Merge Selected" not redrawing grid.

2020-10-21 4.1.17

• Fixed form field handling of Option parameter. It was always showing it as a colour block.

2020-10-18 4.1.16

• Add "Color Tables". These have a name and a "Color field". When a field links to one, the background color of the cell will match the color from the lookup table. In the form design a field should have its "Option" parameter set to "~Colour" so that it displays the color from the color table rather than the text in the field.
• Changed saving forms so if it fails, a dialog pops up.
• Fixed problem when opening a form file and the SQLite database does not have a "_" table.

2020-10-10 4.1.15

• Added Form design context menu items Hide All-Rectangles, Select All-Rectangles.
• Added CompileForm() test for links with an empty field name.
• Fixed Pedigree Explorer form conversion. Fixed page and padding. Wasn't using table names to convert table ordinals to names. Had problem working out which record a field belonged to if it was inside more than one so changed it to use closest.

2020-10-09 4.1.14

• Fixed Repeated ancestors not showing for MySQL.

2020-10-09 4.1.12

• Fixed Reports-Offspring
• Fixed exception in CompileForm() and RefreshForm().
• Fixed user being prompted that form file has been modified.
• Fixed text reports assuming the ordinals for the Sex, DOB, Sire and Dam fields. Theese are now calculated.

2020-10-07 4.1.11

• Added string file ~Link format. Right click on a Link field will show file open dialog. Selected file path will be stored in the selected cell. Double clicking the cell will open that file with the application associated with that file.

2020-10-04 4.1.10

• When connecting to MySQL, if it fails the error message only briefly appears in the status bar.
• Fixed saving and display of static images in debug and normal. Note all static images must always be stored relative to the form files folder.
• Form design changes: Added context menus "Select All": Records, Fields, Links, Lines, Images, Text and "Unlock All", "Lock Selected", "Duplicate Selected". Changed Hide to "Hide All". Rearranged menu items to group by selection type, i.e. All or Selected.
• Changed selection code so points outside the PageBlock bounds are not excluded.
• Fixed forms render of rectangles which didn't show the correct colour or line width.
• Changed "Calculate Inheritance for All" so if the required fields aren't there it adds them, shows a message that its added them then exits before running the command.
• Changed ReportAllForm to use FileSettings instead of Settings for FullPrecision and Separator.

2020-09-20 4.1.9

• Added VIEW-"Fix Field Order Problem" which is a MySQL Alter Table command to increase the field size of FieldX fields to 768.

2020-09-18 4.1.8

• Fixed "Import PedPub into MySQL...". Problem was it was not run on a background thread. This meant the main message loop wasn't being pumped.

2020-09-09 4.1.6

• Changed context menu on PedChart to add "Edit" which shows the Navigator with that node as subject.
• Implemented GENETICS-Calculate Inheritance for All.

2020-09-09 4.1.5

• Fixed sorting problem on tables where the primary key field is not called "Name".
• Fixed (9999) appearing in DataDoctor self-parenting loop message.
• Fixed PedCharts etc displaying nothing if there was self-parenting. Now only the F= and R= are blank.
• Fixed Descendants chart throwing an exception.

2020-09-04 4.1.4

• Added FILE-Open Cloud Connection to make it easier for people connecting for the first time.
• Changed database templates. Dog: added "Elbow Score". For all others renamed "Inbreeding Coefficient" as "COI" and removed "Relationship Coefficient".
• Have verified that the installer uses the "onlyifdoesntexist" option when installing the sample databases and have verified that it does work, i.e. if the samples already exist, they won't be overridden.
• Fixed HELP-User Manual so it downloads the PedCloud manual instead of the PedPub manual.

2020-09-01 4.1.3

• Added "Enter Long Text" to form designer.

2020-08-30 4.1.2

• Fixed error when loading old database with aliases and duplicate field names.
• Added "FILE-Save to Backup", "FILE-Restore Backup", "FILE-Open Backup File" menu commands. Also when a database file is opened, if there is no backup, it will automatically create one.
• Changed manuals to Pedigree Cloud ones.

2020-08-26 4.1.1

• Fixed problem when "Add Record" is clicked, then next field entered and Enter pressed resulting in that field being added as a record.

2020-08-19 4.1.0

• Fixed exception when closing app, in Relations form.
• Fixed some fields not being displayed in Navigator when field order is changed.

2020-08-08 4.0.50

• Changed "Import PedPub into MySQL...". Removed the static create table scripts for session and account.

2020-08-08 4.0.49

• Changed "Import PedPub into MySQL..." so it rounds up string field sizes to nearest multiple of 8 instead of 16. The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. For example, the maximum row size is slightly less than 8KB for the default 16KB InnoDB page size. For 64KB pages, the maximum row size is slightly less than 16KB. See Section 15.22, “InnoDB Limits”.

2020-08-08 4.0.48

• Hiding password in connection string displayed in app title.

2020-08-04 4.0.47

• Fixed Data Doctor Self Parenting.
• Fixed double click in Navigator edit, then lost focus causing change in CurrentCell.

2020-08-01 4.0.46

• Added Data Doctor
• Diagram form: added context menu: Delete Selected, Hide:Records, Fields, Links, Text; Show All.

2020-07-27 4.0.45

• Fixed Navigator edit
• Fixed MARK-Common Ancestor

2020-07-26 4.0.44

• Fixed Navigator exception

2020-07-25 4.0.43

• Fixed TOOLS-Export CSV marked records only.

2020-07-23 4.0.42

• Added wait cursor to updating linked fields and added messagebox message reporting number of rows updated.
• Fixed: if there was a duplicate record being added, it failed silently.
• In TOOLS-Alter Table, hiding "Character Max Length" if Type is not string.
• Added click on draw object in design now shows its error message.
• Major refactor of RecordReference and BackTracker to try and fix issues with backtracking.
• Changed TOOLS-Alter Table and Create Table to show estimated row size. Also added wait cursor.
• Fixed back tracking. It would add duplicates to the top after the 20 item limit was hit.

2020-07-19 4.0.41

• Put Relations back into Navigator BUT selecting a cell in Edit All records does not cause the relations to be recalculated. Added "Calculating..." message in relations list.
• Fixed TOOLS-Import ~ Forms: now converting table names, rejects objects that are too small such as links that were stopping the form working. If a non-existant expression was referenced then instead of ?! it now puts "Expr N?!". In all cases examined the expressions didn't exist in PedEx either!!

2020-07-18 4.0.40

• Fixed TOOLS-Delete Table for MySQL. Didn't handle lowercase table names for _Tables and _Fields.
• Fixed TOOLS-Create Table problem where Format, ForeignTable and ~Id were not saved.
• Fixed problem when closing the application with a filtered Table view.
• Added TOOLS-"Add Lookup Table to this Field", "Normal", "With Color".
• Fixed Relations form, click on field with no lookup, showing a list of names from the pedigree table.
• Fixed Relations form, editing the Name field causing the record to disappear.

2020-07-16 4.0.36

• Fixed not marking if max then min rows selected in that order.
• Modified MarkFunctions to use transactions and increased chunk size from 100 to 1000.
• Fixed Mark N Generations
• Fixed problem when copying color fields.

2020-07-15 4.0.35

• Fixed repeated backtracks. This happened when user kept hitting the left or right arrow keys on a row.
• Changed MySQL table creation so that all string primary keys use utf8_general_ci collation. MySQL will use the associated CHARACTER SET for this COLLATE, i.e. utf8. Was going to use this to speed up updates by using ranges but can't replicate collation used by MySQL.

2020-07-14 4.0.34

• Relations Form: added EDIT-Copy, Paste, Clear, Duplicate Record, Delete Selected Records. Added MARK-Set, Clear, Invert, Set All, Clear All, Invert All, Clear All Colors, Primary and Secondary, Primary or Secondary. Can now edit. Now shows red wavy line if no match.

2020-07-12 4.0.33

• Changed TOOLS-Alter Table, so "Delete Field" becomes "Delete Selected Fields".
• Fixed exception when using VIEW-Set Tooltips dropdown dialog.
• Fixed repeated fields appearing in Navigator edit.
• Fixed Navigator edit, enter on non-existant sire or dam not prompting to add.
• Speed up of marking

2020-07-12 4.0.32

• Removed relations from Navigator. Main reason it it slows every change in selection due to calculation of offspring, siblings etc.
• Right click menu in grid now has Offspring and Siblings menu items.

2020-07-12 4.0.31

• Records no longer marked when typed in.
• Fixed edits in Navigator not appearing.
• Fixed MetaData not handling case insensitive table names.
• VIEW-Set Tooltips now works. If not tooltips defined for pedigree table then default added "[Name]!S=[Sire]!D=[Dam]!DOB=[DOB]".
• Fixed marks in Relations form.

2020-07-10 4.0.29

• Changed Table form context menu to put "Find 'XXXX'" at the top and added "Duplicate Record" menu item.
• Fixed editing primary key field.
• Fixed EDIT-Duplicate record.

2020-07-09 4.0.28

• Slight speed up when clicking ancestor in form changed call to SetSubject() to not calculate relations.
• Double click on ancestor in form now displays the current form with that ancestor.
• Form display is now much faster. Added CompileForm.LoadLinkRecords() which uses prefetch to load layers of links.

2020-07-08 4.0.27

• Sped up scrolling in grid.

2020-07-07 4.0.26

• Changed TOOLS-Import PedPub into MySQL so all columns have a default of NULL.

2020-07-05 4.0.25

• TOOLS-Calculate COI for All no longer changes to Modified field. Also rounded COI to six decimal places and if < 0 then set to 0.
• EDIT-Clear now sets fields to null, including integers. FTR when we add an integer field it does allow nulls so need to change any of our create or alter table code.

2020-07-04 4.0.24

• Fixed TOOLS-Alter Table for MySQL when a primary key is being added to a table that doesn't have one.
• Fixed TOOLS-Create Table when a primary key is specified.
• Added test for field names in form design that do not exist in table. Previously this was unreported.
• Fixed form render of colour fields so that 0 renders as no colour rather than black.

2020-07-02 4.0.23

• Coloured fields transfer from SQLite to MySQL has a problem that DBNULL or null in SQLite becomes 0 (the default for an integer field in MySQL), so they appear as black. Changed presenter so 0 means no colour rather than black.

2020-06-30 4.0.22

• Fixed "Pedigree Calculations" view throwing an exception due to select from Pedigree. Changed to "pedigree".
• Fixed Field order not appearing if none persisted.

2020-06-28 4.0.20

• Fixed exception in Navigator if you search without having clicked on a record in Table view.
• Added TOOLS-Export MySql to PedPub.
• Changed TOOL-Import PedPub into MySQL so it gets maximum field size of character fields and uses this rounded up to multiples of 16 to set the size of character fields when creating the MySQL tables.