Version: 1.2005.0.416 (April 16, 2005 1445)

1.       Fixed a bug that prevented ‘Commit’ from working when the table included a Field that was ‘AutoIncrement’.

2.       ISSUE: After editing in a RichText Box the saved file will no longer be sans-preamble. This means that there will be some ‘bloat’ as you edit.

3.       Fixed the Bug that prevented viewing of some files, like the Utmost.dev file in the RichText environment.

4.       If you Right-Click with Text Selected in either the Rich Text Box or the Text Box on the Main/Import screen a window will pop-up listing the character codes of the selected characters. This is useful if you’ve created a User-Defined delimited text file and can’t remember what the delimiter character was.

5.       Added ability to Change Column(Field) Names in the Import Window. NOTE: There is NO validation Code, yet.

6.       Added code to test for Duplicate Column(Field) Names during Importing a Delimited Text File, when editing a Column(Field) Name or adding a column. NOTE: This test is Case-Insensitive.

7.       Added a ‘Save-As’ for the Open Delimited Text File in the Import Window. The reason ‘Save-As’ and not ‘Save’ was added was because I am trying to prevent casual overwrites of the users source files. It is possible to ‘Save’ back as the same file name. But, you have to intend to do so.

8.       Added Database Save-As and Save-Copy-As. Both allow the Saving of the Currently Open Database with a New Name. Save-As Opens the Newly Created File… Save-Copy-As reopens the Original File.

9.       System now disables the ability to Open a Database if the Dataview Window is already Open.

10.   Added ability to truncate Text Fields to less than 255. Was required to test Dataviews Auto Assignment Button.

11.   Worked on the Auto Assignment Button. It should now automatically Assign all fields to a display Resource.

12.   Added Icons (such as they are) to the various Forms.

13.   Added improved Overwrite protection. WARNING: If you click yes to the question of Overwriting a file the file will be irrevocably lost. Always maintain good back-ups during development.

14.   File Save/Open/Create Window can no longer be re-sized. This prevents the fatal error (item #7) noted in the previous version.

15.   Program now traps Database Open Errors so that the Program does not crash. Not perfect. But, if you open a Password Protected Database the Program gives you a chance to handle it.

16.   Added .not (Study Notes) and .ovl (Overlay) file types to the available Database File Extensions. NOTE: Additional Extensions can be opened by typing the extension in the ‘Filter Text Box’. EX: for Study Notes you would have typed .not instead of *.not.

17.   Added more e-Sword filename extensions.

18.   Removed the inhibit on saving database filenames with other than .MDB extensions.

19.   When Saving the Database with a New name the System now automatically re-opens the database with the New name.

 

Version 1.2005.0.3152

1.       Code added to prevent the  program from dying when a User Minimizes or Maximizes either the Dataview or Import Forms

2.       Added the ability for the program to 'follow' a User's Resizing of the form with the associated Text Boxes.

3.       There is now a File Filter that initially loads to show either all Text type files or all Database type files.

4.       Allows you to restrict the filter to a singleFile Extension Type.

5.       Can rename database extensions in FileView.

6.       Known Bug: Can only create a database from imported text as an .MDB.

7.      Critical bug that is not fixed:  Until I finish the File Save/Open/Create Window it is also vulnerable to the Resizing Bug as it also contains some auto sizing code.

Version 1.2005.0.3151

1.       The program left itself in memory all of the time. This bug has been fixed.

2.       added a Plain Text Box to the Import Window Form and a 'Write-Back' Button to allow you to edit the Data in the Flexgrid before Creating a Database.

 

Version: 1.2005.0.310 (Posted on e-Sword Group)

1.       Added a ‘Busy’ indication so that it would not appear the system had ‘Hung’ or gone ‘Bye-Bye’.

2.       Reworked the File Selection Window allow ‘Mouse-a-holics’ an ‘Accept’ Button to Click for all File selection tasks.

3.       Started displaying the Filename entry Textbox (disabled) during file ‘Open’ Tasks to allow the viewing of long filenames.

4.       Added the ability to Specify a Table Name before Creating a Database.

5.       Added a Rich Text Box to display the currently selected cell on the Main/Import window to allow viewing of large blocks of data. ? Do we also need a Plain Text Version like a Multi-Line TextBox ?

6.       Added code to Import Quote Delimited Fields with Embedded Delimiters.

7.       Added auto sizing of Column Widths on the Import Grid to Match the width of the Header Names.

8.       Added rudimentary support for ‘other’ Field types so that the ‘Long Integer’ in ‘Topic Notes’ could be edited. Basically, I can check for is the entry a Numeric or is it a Valid Date… No check for ‘Currency’ Fields is being made at all. So, You’ll have to manually check that. I expect problems with the date field. Both ‘Currency’ and ‘Dates’ and even ‘Time’

9.       Added ‘Long Integer’ to the Field types List and changed the ‘Number’ selection to use ‘Double’ as the Data Field Type.

10.   Added ability to save the current database as a different FileName. WARNING: There is **NO** Overwrite Check!

11.    

 

Version: 1.2005.0.2283 (Posted to Site)

1.       Corrected a ‘prettiness’ where the labels and textboxes in Dataview didn’t disappear when not defined.

 

Version: 1.2005.0.2282 (Posted to e-Sword)

1.       Fixed a bug where you were prevented from creating a new file if no Filename had been clicked in the FileList.

2.       Fixed a bug where was caused when Memo Fields were assigned to Text Boxes and I hadn't made allowances for the reported 'Field Size' for a 'Memo' field being Zero... So every time the Record was changed the program would scream about the Zero Length Fields

 

Version: 1.2005.0.228 (Posted to e-Sword)

1.       Changed how I do the Revision Numbers to a MajorVersion.Year.0.MonthDay As soon as I figure out how to change that confounded ‘hidden’ Zero… It will become the Month.

2.       Removed initial text in Rich Text Box to (hopefully) eliminate a potential problem if the program is used in a different ‘locale’. See: MS ID: Q189480 I stumbled on this while looking for something else… J

3.       Fixed bug with Export Table that allowed embedded CRLF’s to be exported causing corruption of RTF information when imported into Excel. (Please let me know if this breaks other uses.)

4.       Added a rudimentary Auto Assignment feature to the DataView Window to allow more quickly setting up the Fields to Display Resource assignments. The case where there are no Memo Fields is incomplete and has not been tested.

5.       Program now automatically pre-selects ‘Memo’ field type if Max Characters in a given column are greater than 255.

6.       Program now detects if a Database File already exists. Offers either Overwrite or Cancel.

7.       Added and ‘About’ Menu Selection to display the License. The hyperlink does not work.

8.       Added Code to Display only the First 10 Label & TextBoxes in the Dataview. With ‘Move Fields Up’ and ‘Move Fields Down’ Command Buttons to bring additional pairs into view if they exist.

9.       Added Code to Set Font Bold, Font Italic, Strikethrough, and Underline.

10.   Applied fix to allow Tabs to be typed ‘naturally’ while in the Rich Text Box.

11.   Changed the Captions on the File Selection Menu.

12.   Added a ‘File not Found’ check before opening Database File.

13.   Changed Initial Focus on File selection Menu from Drives to Files.

14.   Added a check in the Dataview Text Entry Boxes to limit the Number of Characters to the Field Size specified in the Database.

15.   Added support to make the Selected Column in the Import Grid Wider or Narrower by about a column width.

16.   Added code to limit the Import Grid to less than the actual Screen Width.

 

Version: 1.1.0.0 (Posted on e-Sword Group)

Changes:

1.       Replaced the Data Control with a Horizontal Scroll Bar to allow faster access to items in the Database.

2.       Added an ‘Auto Update’ chkbox to allow the user to get the same ‘Live’ Database functionality as with a Data Control. Ie., Updates to underlying database occur as soon as you change Record Position.

3.       Created first pass at Exporting a Single DB Table. Works but is Flaky

 

Version: 1.0.0.2 (Posted on e-Sword Group)

 

Changes:

1.       Changed the Import Text File Function to allow User Selection of Delimiter Character. NOTE: While the user may use more than a single character in this mode. Excel and other programs will not accept multiple character strings. (Might be a good way to insert a short string in front of each fields, though?)

 

Fixes:

1.       Fixed a Bug that prevented importing another Text File by properly clearing the FlexGrid array upon accepting a FileName to import.

2.       Creation of Database from Text Import now changes the file Extension to .mdb automatically.

3.       Fixed a bug that left the leading Quote in place after a delimiter was found.

4.       Fixed a bug that occasionally left a leading Space in Field Names.

5.       Placed a maximum width limit in how wide the FlexGrid can go as a default.

 

Version: 1.0.1 (Posted 2005-09-10)

 

Fixes:

1.       Added Code to Replace [Space] Characters in field names with [Under Score] Characters

2.       Added Code To Remove Quotation Marks unless there are two back-to-back

3.       Added Code to Force Text Field Size to a Maximum of 255

4.       Added Code to Truncate Text Fields larger than 255 characters to a maximum of 255 characters

5.       Most e-Sword extensions added.

 

Version: 1.0.0 (Released 2005-02-09) Initial Working ‘Beta’ Release