Be the first to post a text review of Office Database Addin. Rate and review a project by clicking thumbs up or thumbs down in the right column.

• Code committed

  r_kapl committed revision 250 to the dbaddin SVN repository, changing 2 files

  posted by r_kapl 7 days ago

• Code committed

  r_kapl committed revision 249 to the dbaddin SVN repository, changing 5 files

  posted by r_kapl 14 days ago

• Code committed

  r_kapl committed revision 248 to the dbaddin SVN repository, changing 4 files

  posted by r_kapl 23 days ago

• Code committed

  r_kapl committed revision 247 to the dbaddin SVN repository, changing 5 files

  posted by r_kapl 48 days ago

• Forum thread added

  jrbade created the Pervasive connection string forum thread

  posted by jrbade 104 days ago

• Code committed

  r_kapl committed revision 246 to the Office Database Addin SVN repository, changing 2 files

  posted by r_kapl 155 days ago

• DBAddin binary 1.2.7 file released: DBAddinSetup1.2.7.msi

  ------------------------------------------------------------------------ Version 1.2.7 ------------------------------------------------------------------------ r244 | r_kapl | 2009-06-18 23:57:29 +0200 (Do, 18 Jun 2009) | 2 lines BUG: fixed non-working DBMakeControl loading in cell config loader CHG: now saving of one contiguous block of cells is possible in cell config loader. ------------------------------------------------------------------------ r243 | r_kapl | 2009-06-12 14:56:54 +0200 (Fr, 12 Jun 2009) | 2 lines BUG: fixed inaccurate specification of special folders in DBConfigs leading to not filling correctly the entries of the resp. folder CHG: Added first character grouping for really large databases in DBConfigs ------------------------------------------------------------------------ r242 | r_kapl | 2009-04-12 01:31:55 +0200 (So, 12 Apr 2009) | 1 line CHG: upgraded alternative sql builder to sqldrill (formerly sqlexcel) ------------------------------------------------------------------------ r241 | r_kapl | 2009-04-08 15:19:35 +0200 (Mi, 08 Apr 2009) | 3 lines BUG: fixed DBMApper bug with empty optional params CHG: Empty/Erroneous DBMApper primary columns are now giving an error message, except when they are specifically marked as containing empty/error values (parameters specialExceptionTable/specialExceptionField) CHG: Empty DBMApper Columns now stop proceeding through columns, except they are explicitly excluded (parameter excludeColumns). ------------------------------------------------------------------------ Version 1.2.6 ------------------------------------------------------------------------ r237 | r_kapl | 2009-01-29 15:25:11 +0100 (Do, 29 Jn 2009) | 2 lines added another error protection for dorefresh screen updating. Updated documentation with "purge" possibility. ------------------------------------------------------------------------ Version 1.2.5 ------------------------------------------------------------------------ r235 | r_kapl | 2009-01-27 18:56:59 +0100 (Di, 27 Jn 2009) | 1 line fixed another issue with DBListFetch refresh (freezing screen display) ------------------------------------------------------------------------ r234 | r_kapl | 2009-01-26 13:25:57 +0100 (Mo, 26 Jn 2009) | 1 line fixed Test environment selection with Mapper ------------------------------------------------------------------------ Version 1.2.4 ------------------------------------------------------------------------ r233 | r_kapl | 2009-01-22 23:46:07 +0100 (Do, 22 Jn 2009) | 1 line added known issue with DBFuncs when compile errors in VBA exist. ------------------------------------------------------------------------ r232 | r_kapl | 2009-01-22 23:35:09 +0100 (Do, 22 Jn 2009) | 1 line fixed refresh Dbfuncs issue with no screenupdating after refresh. ------------------------------------------------------------------------ Version 1.2.3 ------------------------------------------------------------------------ r229 | r_kapl | 2009-01-10 01:06:56 +0100 (Sa, 10 Jn 2009) | 1 line fixed clipboard issue with DBSheets ------------------------------------------------------------------------ r228 | r_kapl | 2008-12-28 04:43:22 +0100 (So, 28 Dez 2008) | 2 lines found problem with strange behaviour in defining DBsheets (schema changes), which was due to table renaming (only case changes but this also matters!) Improved error message and added Known issue. ------------------------------------------------------------------------ r224 | r_kapl | 2008-12-28 02:56:42 +0100 (So, 28 Dez 2008) | 1 line fixed bug (no reaction) when calling "refresh data" on selected (single) data targets ------------------------------------------------------------------------ r217 | r_kapl | 2008-12-24 02:11:24 +0100 (Mi, 24 Dez 2008) | 2 lines fixed where clause bug in test of DBSheet check into problem with foreign table lookup in DBsheet def GUI ------------------------------------------------------------------------ r212 | r_kapl | 2008-11-10 16:48:16 +0100 (Mo, 10 Nov 2008) | 2 lines harmonized error logging added some logging to find out more about strange behaviour with DBfunctions when starting Excel from commandline. ------------------------------------------------------------------------ r210 | r_kapl | 2008-11-09 04:34:58 +0100 (So, 09 Nov 2008) | 5 lines enhanced createTableViewConfigs.vbs to produce also WRD config files included createTableViewConfigs.vbs into installer changed specialConfigStore path definition to subpath. changed doRefresh to only refresh current DBfunc if invoked withing it's area. completed documentation on specialConfigStore ------------------------------------------------------------------------ r205 | r_kapl | 2008-11-02 03:30:13 +0100 (So, 02 Nov 2008) | 2 lines separated doc packaging from source packaging abandoned source packaging in build process ------------------------------------------------------------------------ r204 | r_kapl | 2008-11-01 23:57:41 +0100 (Sa, 01 Nov 2008) | 3 lines Added refresh ConfigStore Button removed auto-refresh of ConfigStore on Addin Launch removed auto-refresh of ConfigStore on std refresh Button ------------------------------------------------------------------------ r201 | r_kapl | 2008-10-31 00:59:50 +0100 (Fr, 31 Okt 2008) | 2 lines added CamelCase clustering to special Config store folders (useful for large configfile lists typically found for all tables in a database) added createTableViewConfigs.vbs to produce configfiles for a given database ------------------------------------------------------------------------ r199 | r_kapl | 2008-10-22 22:46:08 +0200 (Mi, 22 Okt 2008) | 3 lines started subscribeTo extension for accepting published notifications corrected documentation/DBAddin.htm ------------------------------------------------------------------------ Version 1.2.2 ------------------------------------------------------------------------ r195 | r_kapl | 2008-09-29 02:53:17 +0200 (Mo, 29 Sep 2008) | 1 line BUG: Tree Menu of configs now refreshed after saving a config item ------------------------------------------------------------------------ r193 | r_kapl | 2008-09-24 04:19:52 +0200 (Mi, 24 Sep 2008) | 1 line BUG: create customTemplate now on the fly for WordAddin ------------------------------------------------------------------------ r192 | r_kapl | 2008-09-16 22:29:22 +0200 (Di, 16 Sep 2008) | 3 lines BUG: fixed continuous increase in Normal.dot BUG: fixed adding to sort dropdown in DBSheet Creation dialog ------------------------------------------------------------------------ r191 | r_kapl | 2008-09-09 15:46:23 +0200 (Di, 09 Sep 2008) | 3 lines BUG: fixed ignoring of saveWB setting in parameters dialog Made DoConcatCells and DoconcatCellsSep private (not viewable for Excel) ------------------------------------------------------------------------ r190 | r_kapl | 2008-09-08 01:50:59 +0200 (Mo, 08 Sep 2008) | 2 lines fixed strikethrough fill down issue when having autoformat in DBSheets included developerDoc (VBDOX generated) into documentation tree ------------------------------------------------------------------------ r189 | r_kapl | 2008-09-02 19:27:25 +0200 (Di, 02 Sep 2008) | 1 line fixed DBSHeet unlock crash ------------------------------------------------------------------------ r188 | r_kapl | 2008-09-01 21:02:05 +0200 (Mo, 01 Sep 2008) | 1 line whole build process now in build.cmd ------------------------------------------------------------------------ r185 | r_kapl | 2008-08-30 06:51:05 +0200 (Sa, 30 Aug 2008) | 2 lines removed copy/paste workaround again ------------------------------------------------------------------------ r184 | r_kapl | 2008-08-30 06:47:50 +0200 (Sa, 30 Aug 2008) | 1 line created developer doc on VBDOX ------------------------------------------------------------------------ r180 | r_kapl | 2008-07-04 15:19:43 +0200 (Fr, 04 Jul 2008) | 3 lines added preference for query builder (sqlexcel or msquery (empty)) Bug: fixed err logs when saving workbooks (from special modifications of DBfuncs) Bug: fixed DBFunc find dialog leftover ------------------------------------------------------------------------ Version 1.2.1 ------------------------------------------------------------------------ r175 | r_kapl | 2008-06-28 23:43:19 +0200 (Sa, 28 Jun 2008) | 3 lines BUG: implemented workaround for GUID columns not displaying with SQL-Server BUG: fixed unwanted clearing of Query Target when creating DB funcs with query builder tool. updated documentation ------------------------------------------------------------------------ r174 | r_kapl | 2008-06-27 12:25:13 +0200 (Fr, 27 Jun 2008) | 2 lines DBListFetch: changed to leave formats in case autoformat = false BUG in DBRowFetch: target was cleared with Clear instead of ClearContents -> formats loss ------------------------------------------------------------------------ Version 1.2.0 ------------------------------------------------------------------------ r172 | r_kapl | 2008-06-22 02:00:11 +0200 (So, 22 Jun 2008) | 2 lines BUG: fixed Excel freeze on right clicking when whole sheet selected BUG: fixed internal error message when "close switching" (automatic activation of dbsheet after the other sheet was closed) to a DBsheet from another sheet being in copy mode. ------------------------------------------------------------------------ r171 | r_kapl | 2008-06-17 16:21:23 +0200 (Di, 17 Jun 2008) | 3 lines Added improved support for Query tool "SQL-Excel" BUG: fixed out of bounds range naming when columns > Excel max. columns Enhanced Config tool & DBFuncs insert to also handle ranges > 1 cell (e.g. QueryTargets !!) ------------------------------------------------------------------------ r170 | r_kapl | 2008-06-13 13:19:39 +0200 (Fr, 13 Jun 2008) | 1 line BUG: WB save skipping for DBSHeets was ignored ------------------------------------------------------------------------ r168 | r_kapl | 2008-06-09 00:54:11 +0200 (Mo, 09 Jun 2008) | 2 lines combined adUseClient setting for ALL DBfunctions added backgroundquery = false to Querytable refresh in dblistfetch (higher responsiveness). ------------------------------------------------------------------------ r166 | r_kapl | 2008-06-07 02:43:20 +0200 (Sa, 07 Jun 2008) | 2 lines added possibility to cancel refresh while still retaining DB saving capabilities... enhanced DBSheet Parameter Assignments tickboxes to allow for third (cancel) state ------------------------------------------------------------------------ r164 | r_kapl | 2008-06-03 03:48:09 +0200 (Di, 03 Jun 2008) | 4 lines readded DBConfig dropdown menu (alternative to DBConfig load file dialog) added possibility to skip refreshing DBSheets in special occasions ------------------------------------------------------------------------ r159 | r_kapl | 2008-05-29 23:07:48 +0200 (Do, 29 Mai 2008) | 3 lines BUG: fixed Excel bug in DoConcatCellsSep BUG: fixed DB clearing when storing ------------------------------------------------------------------------ r158 | r_kapl | 2008-05-29 17:50:59 +0200 (Do, 29 Mai 2008) | 1 line updated doc for DBFunction behaviour modifiers ------------------------------------------------------------------------ r157 | r_kapl | 2008-05-28 01:23:00 +0200 (Mi, 28 Mai 2008) | 3 lines enhanced DBFclear custom doc property to work now with single DBFunctions DBFclear now named DBFCC (Content clear) or DBFCA (All clear) DBFCA* and DBFCC* now clear everything, DBFCA<DBFuncSheetname!DBFuncAddress> clears single DBfunctions... ------------------------------------------------------------------------ r156 | r_kapl | 2008-05-26 20:22:09 +0200 (Mo, 26 Mai 2008) | 4 lines Added Data area clear when saving and Excel custom property DBFclear is set (DBFclearAll for including formats) Added Excel custom property DBFskip to prevent refresh on opening workbook Data area is usually refreshed after DBFclear, DBFskip prevents that refresh. ------------------------------------------------------------------------ r154 | r_kapl | 2008-05-12 01:07:18 +0200 (Mo, 12 Mai 2008) | 2 lines added DBFskip custom doc property for skipping refreshing DBFunctions at Worbook opening added DBFclear custom doc property for clearing DBfunctions target ranges when saving ------------------------------------------------------------------------ r152 | r_kapl | 2008-05-08 13:27:12 +0200 (Do, 08 Mai 2008) | 1 line BUG: fixed "formula too long" when recalculating from workheets different than the DBMakeControl/DBCellFetch one while having a cell containing special text (lots of "=") with length > 1024 ------------------------------------------------------------------------ r150 | r_kapl | 2008-04-30 17:53:45 +0200 (Mi, 30 Apr 2008) | 4 lines added Build date/time to About box added current DBSheet Def file info to DBSheetCreateForm Caption added user registry settings to .DEFAULT for installer ------------------------------------------------------------------------ r149 | r_kapl | 2008-04-25 22:32:40 +0200 (Fr, 25 Apr 2008) | 2 lines BUG: fixed saveDefinitions not saving in the DBSheet definitions folder BUG: fixed foreign lookup and foreign key assignment problem when first clicking on DBsheetCols ------------------------------------------------------------------------ r148 | r_kapl | 2008-04-25 01:14:14 +0200 (Fr, 25 Apr 2008) | 3 lines added error line numbering to DBFuncBuilder added conflict resolution in DBFunc insertForm when having overlapping target ranges selected (aplies also to default ranges) exception handling in DBSheet checking for Workbooks containing compile errors ------------------------------------------------------------------------ r146 | r_kapl | 2008-04-16 19:20:44 +0200 (Mi, 16 Apr 2008) | 2 lines BUG: fixed concatCellsSepText problem with "0" values removed Mapper.makeHistoric as there is no real use to it. ------------------------------------------------------------------------ r141 | r_kapl | 2008-04-06 22:46:12 +0200 (So, 06 Apr 2008) | 1 line fixed autoformat/autofit defailt settings in insertForm ------------------------------------------------------------------------ r135 | r_kapl | 2008-04-03 00:11:22 +0200 (Do, 03 Apr 2008) | 2 lines Added Text versions of concatCells and concatCellsSep ------------------------------------------------------------------------ r132 | r_kapl | 2008-04-01 18:19:49 +0200 (Di, 01 Apr 2008) | 5 lines added lots of error handlers fixed interface inconsistencies BUG: fixed copy/paste restoreclip when source WB is closed BUG: fixed foreign table vanishing when directly changing to a different column with a different foreign database BUG: fixed database mixup when directly clicking clear All Columns having a column active with a different foreign database than the DBSheets main database ------------------------------------------------------------------------ Version 1.1.0 ------------------------------------------------------------------------ r130 | r_kapl | 2008-03-31 16:18:26 +0200 (Mo, 31 Mr 2008) | 1 line Issue: Improved/fixed RefEdit behaviour in DBSheetCreateForm ------------------------------------------------------------------------ r126 | r_kapl | 2008-03-27 02:30:52 +0100 (Do, 27 Mr 2008) | 2 lines added named range adding added Button in DBSheetDefinition to allow direct insert of DBSheets during definition creation ------------------------------------------------------------------------ r124 | r_kapl | 2008-03-21 01:03:26 +0100 (Fr, 21 Mr 2008) | 2 lines changed default setting of AutoFormat and AutoFit in DBFuncBuilder updated documentation ------------------------------------------------------------------------ r114 | r_kapl | 2008-03-04 10:24:29 +0100 | 3 lines added local help button and config for setting the local help location added unlock menu item in DBSHeets menu added workaround documentation for copy down problem with forms ------------------------------------------------------------------------ r112 | r_kapl | 2008-03-03 19:57:16 +0100 | 2 lines changed DBSheetCreateForm layout to always have load defs and save defs available BUG: fixed load DBSHeet definitions loading problem inside DBSheetCreateForm ------------------------------------------------------------------------ r111 | r_kapl | 2008-03-03 00:59:57 +0100 | 2 lines changed workflow, removed DBSheet create button in DBSheetCreateForm ------------------------------------------------------------------------ r105 | r_kapl | 2008-02-28 02:13:14 +0100 (Do, 28 Feb 2008) | 2 lines Detached DBSheetConfig from Workbook Changed DBWbookID to come from CustomDocumentProperty now. ------------------------------------------------------------------------ r101 | r_kapl | 2008-02-20 20:37:23 +0100 (Mi, 20 Feb 2008) | 2 lines restructured CommonFuncs into ConfigFiles, Logging_Keyboard and Settings_Help (now really only contains functions) BUG: fixed adding of old query when calling build dbfunc with SHIFT ------------------------------------------------------------------------ r100 | r_kapl | 2008-02-20 00:48:32 +0100 (Mi, 20 Feb 2008) | 1 line changed config file loading to load from explorer/DDE ------------------------------------------------------------------------ r87 | r_kapl | 2008-02-09 01:05:51 +0100 (Sa, 09 Feb 2008) | 1 line BUG: fixed bug with copying data to DBSheets ------------------------------------------------------------------------ r85 | r_kapl | 2008-02-07 20:10:16 +0100 (Do, 07 Feb 2008) | 5 lines concatCellsSep now replaces verketteZellen added saveRangeToDB and makeHistoric removed search remainder after workbook open in DBFuncs ------------------------------------------------------------------------ r82 | r_kapl | 2008-01-30 19:16:56 +0100 | 1 line changed DBAddin commandbar Menu handling to fixed menus (strange behaviour with remembering menu positions) ------------------------------------------------------------------------ r81 | r_kapl | 2008-01-29 20:15:03 +0100 | 3 lines BUG: fixed endless loop with query errors (mutual invocations) in DBFuncs improved error messages in DBFuncs ------------------------------------------------------------------------ r80 | r_kapl | 2008-01-29 02:07:18 +0100 | 2 lines added possibility for querystring being in multiple cells BUG: fixed missing propagation of error messages back to DBListFetch and DBRowFetch when nothing was changed (errors before initial filling) ------------------------------------------------------------------------ r79 | r_kapl | 2008-01-29 00:00:53 +0100 | 2 lines improved exception handling for missing DBConf.xml file added concatCellsSep for concatenating with separators ------------------------------------------------------------------------ r78 | r_kapl | 2008-01-21 02:21:03 +0100 | 2 lines Ctrl-d now deletes prepared (empty) insert rows inserted with Ctrl-i Asks before change marks are done for whole-column changes (otherwise takes a long time to do those marks). ------------------------------------------------------------------------ r72 | r_kapl | 2008-01-15 20:50:50 +0100 | 7 lines Excel Clipboard is now not lost when changing to a DBSheet Improved exception handling with complex lookup aliases (clearer error message) warning with parameterized dbsheets when retrieving incomplete records (not all from table). BUG: fixed issue with changed dbsheets leaving old headers BUG: excel event handlers only react now to own worksheet/workbook of DBSheetHandler/DBSheetWBHandler Save to DB message only when changes made to DBSheetAppHandler BUG: delete was not regarded as change made. ------------------------------------------------------------------------ r71 | r_kapl | 2007-12-22 01:47:27 +0100 (Sa, 22 Dez 2007) | 1 line enhanced dbheet change warning to changing workbooks ------------------------------------------------------------------------ r70 | r_kapl | 2007-12-21 16:00:34 +0100 (Fr, 21 Dez 2007) | 1 line fixed colheader/primCol display in edit parameters ------------------------------------------------------------------------ r69 | r_kapl | 2007-12-21 15:07:38 +0100 (Fr, 21 Dez 2007) | 2 lines added "leave DBSheet ?" Warning message on unsaved data fixed header row / fixed primary columns by default. ------------------------------------------------------------------------ r67 | r_kapl | 2007-12-06 12:21:34 +0100 (Do, 06 Dez 2007) | 1 line ISSUE: MenuHandler.addDBContextMenus error message now only logged (no dialog) ------------------------------------------------------------------------ r66 | r_kapl | 2007-12-03 18:50:32 +0100 (Mo, 03 Dez 2007) | 1 line BUG: avoid DisplayAlerts error with opening inside IE (http://support.microsoft.com/kb/165435/en), DBSheets won't work inside IE, as I don't want to catch that stupid MS Bug everywhere.... ------------------------------------------------------------------------ Version 1.0.1 ------------------------------------------------------------------------ r62 | r_kapl | 2007-11-28 19:24:41 +0100 (Mi, 28 Nov 2007) | 1 line BUG: endless calculation loop in special circumstances when database engine errors introduced in query. ------------------------------------------------------------------------ r61 | r_kapl | 2007-11-28 17:42:09 +0100 (Mi, 28 Nov 2007) | 3 lines BUG: no updating done directly after modifications to a DBSHeet via DBSheetCreateForm BUG/WORKAROUND: added explanation, how to work around false conflict resolutions when dealing with floating point value columns. BUG: no cleaning of DBsheet data was done when saving from a non-Dbsheet worksheet. ------------------------------------------------------------------------ r60 | r_kapl | 2007-11-28 15:06:18 +0100 (Mi, 28 Nov 2007) | 1 line added ChangeLog ------------------------------------------------------------------------ r59 | r_kapl | 2007-11-28 14:34:04 +0100 (Mi, 28 Nov 2007) | 1 line fixed mysterious sheet select bug (reading headers) when workbook is invoked e.g. by clicking on a menubar that invokes a macro in that workbook. ------------------------------------------------------------------------ r58 | r_kapl | 2007-11-28 14:16:58 +0100 (Mi, 28 Nov 2007) | 2 lines fixed strange window behaviour during saving dbsheets in foreign sheet mode (two windows open). ------------------------------------------------------------------------ r57 | r_kapl | 2007-11-26 19:15:35 +0100 (Mo, 26 Nov 2007) | 2 lines added fix colum/row to initial dbsheet creation create dbsheetid on initial dbsheet creation ------------------------------------------------------------------------ Version 1.0.0 ------------------------------------------------------------------------

  posted 197 days ago

• File released: /DBAddin binary/1.2.7/DBAddinSetup1.2.7.msi

  posted 197 days ago

• DBAddin binary 1.2.6 file released: DBAddinSetup.1.2.6.msi

  ------------------------------------------------------------------------ Version 1.2.6 ------------------------------------------------------------------------ r237 | r_kapl | 2009-01-29 15:25:11 +0100 (Do, 29 Jn 2009) | 2 lines added another error protection for dorefresh screen updating. Updated documentation with "purge" possibility. ------------------------------------------------------------------------ Version 1.2.5 ------------------------------------------------------------------------ r235 | r_kapl | 2009-01-27 18:56:59 +0100 (Di, 27 Jn 2009) | 1 line fixed another issue with DBListFetch refresh (freezing screen display) ------------------------------------------------------------------------ r234 | r_kapl | 2009-01-26 13:25:57 +0100 (Mo, 26 Jn 2009) | 1 line fixed Test environment selection with Mapper ------------------------------------------------------------------------ Version 1.2.4 ------------------------------------------------------------------------ r233 | r_kapl | 2009-01-22 23:46:07 +0100 (Do, 22 Jn 2009) | 1 line added known issue with DBFuncs when compile errors in VBA exist. ------------------------------------------------------------------------ r232 | r_kapl | 2009-01-22 23:35:09 +0100 (Do, 22 Jn 2009) | 1 line fixed refresh Dbfuncs issue with no screenupdating after refresh. ------------------------------------------------------------------------ Version 1.2.3 ------------------------------------------------------------------------ r229 | r_kapl | 2009-01-10 01:06:56 +0100 (Sa, 10 Jn 2009) | 1 line fixed clipboard issue with DBSheets ------------------------------------------------------------------------ r228 | r_kapl | 2008-12-28 04:43:22 +0100 (So, 28 Dez 2008) | 2 lines found problem with strange behaviour in defining DBsheets (schema changes), which was due to table renaming (only case changes but this also matters!) Improved error message and added Known issue. ------------------------------------------------------------------------ r224 | r_kapl | 2008-12-28 02:56:42 +0100 (So, 28 Dez 2008) | 1 line fixed bug (no reaction) when calling "refresh data" on selected (single) data targets ------------------------------------------------------------------------ r217 | r_kapl | 2008-12-24 02:11:24 +0100 (Mi, 24 Dez 2008) | 2 lines fixed where clause bug in test of DBSheet check into problem with foreign table lookup in DBsheet def GUI ------------------------------------------------------------------------ r212 | r_kapl | 2008-11-10 16:48:16 +0100 (Mo, 10 Nov 2008) | 2 lines harmonized error logging added some logging to find out more about strange behaviour with DBfunctions when starting Excel from commandline. ------------------------------------------------------------------------ r210 | r_kapl | 2008-11-09 04:34:58 +0100 (So, 09 Nov 2008) | 5 lines enhanced createTableViewConfigs.vbs to produce also WRD config files included createTableViewConfigs.vbs into installer changed specialConfigStore path definition to subpath. changed doRefresh to only refresh current DBfunc if invoked withing it's area. completed documentation on specialConfigStore ------------------------------------------------------------------------ r205 | r_kapl | 2008-11-02 03:30:13 +0100 (So, 02 Nov 2008) | 2 lines separated doc packaging from source packaging abandoned source packaging in build process ------------------------------------------------------------------------ r204 | r_kapl | 2008-11-01 23:57:41 +0100 (Sa, 01 Nov 2008) | 3 lines Added refresh ConfigStore Button removed auto-refresh of ConfigStore on Addin Launch removed auto-refresh of ConfigStore on std refresh Button ------------------------------------------------------------------------ r201 | r_kapl | 2008-10-31 00:59:50 +0100 (Fr, 31 Okt 2008) | 2 lines added CamelCase clustering to special Config store folders (useful for large configfile lists typically found for all tables in a database) added createTableViewConfigs.vbs to produce configfiles for a given database ------------------------------------------------------------------------ r199 | r_kapl | 2008-10-22 22:46:08 +0200 (Mi, 22 Okt 2008) | 3 lines started subscribeTo extension for accepting published notifications corrected documentation/DBAddin.htm ------------------------------------------------------------------------ Version 1.2.2 ------------------------------------------------------------------------ r195 | r_kapl | 2008-09-29 02:53:17 +0200 (Mo, 29 Sep 2008) | 1 line BUG: Tree Menu of configs now refreshed after saving a config item ------------------------------------------------------------------------ r193 | r_kapl | 2008-09-24 04:19:52 +0200 (Mi, 24 Sep 2008) | 1 line BUG: create customTemplate now on the fly for WordAddin ------------------------------------------------------------------------ r192 | r_kapl | 2008-09-16 22:29:22 +0200 (Di, 16 Sep 2008) | 3 lines BUG: fixed continuous increase in Normal.dot BUG: fixed adding to sort dropdown in DBSheet Creation dialog ------------------------------------------------------------------------ r191 | r_kapl | 2008-09-09 15:46:23 +0200 (Di, 09 Sep 2008) | 3 lines BUG: fixed ignoring of saveWB setting in parameters dialog Made DoConcatCells and DoconcatCellsSep private (not viewable for Excel) ------------------------------------------------------------------------ r190 | r_kapl | 2008-09-08 01:50:59 +0200 (Mo, 08 Sep 2008) | 2 lines fixed strikethrough fill down issue when having autoformat in DBSheets included developerDoc (VBDOX generated) into documentation tree ------------------------------------------------------------------------ r189 | r_kapl | 2008-09-02 19:27:25 +0200 (Di, 02 Sep 2008) | 1 line fixed DBSHeet unlock crash ------------------------------------------------------------------------ r188 | r_kapl | 2008-09-01 21:02:05 +0200 (Mo, 01 Sep 2008) | 1 line whole build process now in build.cmd ------------------------------------------------------------------------ r185 | r_kapl | 2008-08-30 06:51:05 +0200 (Sa, 30 Aug 2008) | 2 lines removed copy/paste workaround again ------------------------------------------------------------------------ r184 | r_kapl | 2008-08-30 06:47:50 +0200 (Sa, 30 Aug 2008) | 1 line created developer doc on VBDOX ------------------------------------------------------------------------ r180 | r_kapl | 2008-07-04 15:19:43 +0200 (Fr, 04 Jul 2008) | 3 lines added preference for query builder (sqlexcel or msquery (empty)) Bug: fixed err logs when saving workbooks (from special modifications of DBfuncs) Bug: fixed DBFunc find dialog leftover ------------------------------------------------------------------------ Version 1.2.1 ------------------------------------------------------------------------ r175 | r_kapl | 2008-06-28 23:43:19 +0200 (Sa, 28 Jun 2008) | 3 lines BUG: implemented workaround for GUID columns not displaying with SQL-Server BUG: fixed unwanted clearing of Query Target when creating DB funcs with query builder tool. updated documentation ------------------------------------------------------------------------ r174 | r_kapl | 2008-06-27 12:25:13 +0200 (Fr, 27 Jun 2008) | 2 lines DBListFetch: changed to leave formats in case autoformat = false BUG in DBRowFetch: target was cleared with Clear instead of ClearContents -> formats loss ------------------------------------------------------------------------ Version 1.2.0 ------------------------------------------------------------------------ r172 | r_kapl | 2008-06-22 02:00:11 +0200 (So, 22 Jun 2008) | 2 lines BUG: fixed Excel freeze on right clicking when whole sheet selected BUG: fixed internal error message when "close switching" (automatic activation of dbsheet after the other sheet was closed) to a DBsheet from another sheet being in copy mode. ------------------------------------------------------------------------ r171 | r_kapl | 2008-06-17 16:21:23 +0200 (Di, 17 Jun 2008) | 3 lines Added improved support for Query tool "SQL-Excel" BUG: fixed out of bounds range naming when columns > Excel max. columns Enhanced Config tool & DBFuncs insert to also handle ranges > 1 cell (e.g. QueryTargets !!) ------------------------------------------------------------------------ r170 | r_kapl | 2008-06-13 13:19:39 +0200 (Fr, 13 Jun 2008) | 1 line BUG: WB save skipping for DBSHeets was ignored ------------------------------------------------------------------------ r168 | r_kapl | 2008-06-09 00:54:11 +0200 (Mo, 09 Jun 2008) | 2 lines combined adUseClient setting for ALL DBfunctions added backgroundquery = false to Querytable refresh in dblistfetch (higher responsiveness). ------------------------------------------------------------------------ r166 | r_kapl | 2008-06-07 02:43:20 +0200 (Sa, 07 Jun 2008) | 2 lines added possibility to cancel refresh while still retaining DB saving capabilities... enhanced DBSheet Parameter Assignments tickboxes to allow for third (cancel) state ------------------------------------------------------------------------ r164 | r_kapl | 2008-06-03 03:48:09 +0200 (Di, 03 Jun 2008) | 4 lines readded DBConfig dropdown menu (alternative to DBConfig load file dialog) added possibility to skip refreshing DBSheets in special occasions ------------------------------------------------------------------------ r159 | r_kapl | 2008-05-29 23:07:48 +0200 (Do, 29 Mai 2008) | 3 lines BUG: fixed Excel bug in DoConcatCellsSep BUG: fixed DB clearing when storing ------------------------------------------------------------------------ r158 | r_kapl | 2008-05-29 17:50:59 +0200 (Do, 29 Mai 2008) | 1 line updated doc for DBFunction behaviour modifiers ------------------------------------------------------------------------ r157 | r_kapl | 2008-05-28 01:23:00 +0200 (Mi, 28 Mai 2008) | 3 lines enhanced DBFclear custom doc property to work now with single DBFunctions DBFclear now named DBFCC (Content clear) or DBFCA (All clear) DBFCA* and DBFCC* now clear everything, DBFCA<DBFuncSheetname!DBFuncAddress> clears single DBfunctions... ------------------------------------------------------------------------ r156 | r_kapl | 2008-05-26 20:22:09 +0200 (Mo, 26 Mai 2008) | 4 lines Added Data area clear when saving and Excel custom property DBFclear is set (DBFclearAll for including formats) Added Excel custom property DBFskip to prevent refresh on opening workbook Data area is usually refreshed after DBFclear, DBFskip prevents that refresh. ------------------------------------------------------------------------ r154 | r_kapl | 2008-05-12 01:07:18 +0200 (Mo, 12 Mai 2008) | 2 lines added DBFskip custom doc property for skipping refreshing DBFunctions at Worbook opening added DBFclear custom doc property for clearing DBfunctions target ranges when saving ------------------------------------------------------------------------ r152 | r_kapl | 2008-05-08 13:27:12 +0200 (Do, 08 Mai 2008) | 1 line BUG: fixed "formula too long" when recalculating from workheets different than the DBMakeControl/DBCellFetch one while having a cell containing special text (lots of "=") with length > 1024 ------------------------------------------------------------------------ r150 | r_kapl | 2008-04-30 17:53:45 +0200 (Mi, 30 Apr 2008) | 4 lines added Build date/time to About box added current DBSheet Def file info to DBSheetCreateForm Caption added user registry settings to .DEFAULT for installer ------------------------------------------------------------------------ r149 | r_kapl | 2008-04-25 22:32:40 +0200 (Fr, 25 Apr 2008) | 2 lines BUG: fixed saveDefinitions not saving in the DBSheet definitions folder BUG: fixed foreign lookup and foreign key assignment problem when first clicking on DBsheetCols ------------------------------------------------------------------------ r148 | r_kapl | 2008-04-25 01:14:14 +0200 (Fr, 25 Apr 2008) | 3 lines added error line numbering to DBFuncBuilder added conflict resolution in DBFunc insertForm when having overlapping target ranges selected (aplies also to default ranges) exception handling in DBSheet checking for Workbooks containing compile errors ------------------------------------------------------------------------ r146 | r_kapl | 2008-04-16 19:20:44 +0200 (Mi, 16 Apr 2008) | 2 lines BUG: fixed concatCellsSepText problem with "0" values removed Mapper.makeHistoric as there is no real use to it. ------------------------------------------------------------------------ r141 | r_kapl | 2008-04-06 22:46:12 +0200 (So, 06 Apr 2008) | 1 line fixed autoformat/autofit defailt settings in insertForm ------------------------------------------------------------------------ r135 | r_kapl | 2008-04-03 00:11:22 +0200 (Do, 03 Apr 2008) | 2 lines Added Text versions of concatCells and concatCellsSep ------------------------------------------------------------------------ r132 | r_kapl | 2008-04-01 18:19:49 +0200 (Di, 01 Apr 2008) | 5 lines added lots of error handlers fixed interface inconsistencies BUG: fixed copy/paste restoreclip when source WB is closed BUG: fixed foreign table vanishing when directly changing to a different column with a different foreign database BUG: fixed database mixup when directly clicking clear All Columns having a column active with a different foreign database than the DBSheets main database ------------------------------------------------------------------------ Version 1.1.0 ------------------------------------------------------------------------ r130 | r_kapl | 2008-03-31 16:18:26 +0200 (Mo, 31 Mr 2008) | 1 line Issue: Improved/fixed RefEdit behaviour in DBSheetCreateForm ------------------------------------------------------------------------ r126 | r_kapl | 2008-03-27 02:30:52 +0100 (Do, 27 Mr 2008) | 2 lines added named range adding added Button in DBSheetDefinition to allow direct insert of DBSheets during definition creation ------------------------------------------------------------------------ r124 | r_kapl | 2008-03-21 01:03:26 +0100 (Fr, 21 Mr 2008) | 2 lines changed default setting of AutoFormat and AutoFit in DBFuncBuilder updated documentation ------------------------------------------------------------------------ r114 | r_kapl | 2008-03-04 10:24:29 +0100 | 3 lines added local help button and config for setting the local help location added unlock menu item in DBSHeets menu added workaround documentation for copy down problem with forms ------------------------------------------------------------------------ r112 | r_kapl | 2008-03-03 19:57:16 +0100 | 2 lines changed DBSheetCreateForm layout to always have load defs and save defs available BUG: fixed load DBSHeet definitions loading problem inside DBSheetCreateForm ------------------------------------------------------------------------ r111 | r_kapl | 2008-03-03 00:59:57 +0100 | 2 lines changed workflow, removed DBSheet create button in DBSheetCreateForm ------------------------------------------------------------------------ r105 | r_kapl | 2008-02-28 02:13:14 +0100 (Do, 28 Feb 2008) | 2 lines Detached DBSheetConfig from Workbook Changed DBWbookID to come from CustomDocumentProperty now. ------------------------------------------------------------------------ r101 | r_kapl | 2008-02-20 20:37:23 +0100 (Mi, 20 Feb 2008) | 2 lines restructured CommonFuncs into ConfigFiles, Logging_Keyboard and Settings_Help (now really only contains functions) BUG: fixed adding of old query when calling build dbfunc with SHIFT ------------------------------------------------------------------------ r100 | r_kapl | 2008-02-20 00:48:32 +0100 (Mi, 20 Feb 2008) | 1 line changed config file loading to load from explorer/DDE ------------------------------------------------------------------------ r87 | r_kapl | 2008-02-09 01:05:51 +0100 (Sa, 09 Feb 2008) | 1 line BUG: fixed bug with copying data to DBSheets ------------------------------------------------------------------------ r85 | r_kapl | 2008-02-07 20:10:16 +0100 (Do, 07 Feb 2008) | 5 lines concatCellsSep now replaces verketteZellen added saveRangeToDB and makeHistoric removed search remainder after workbook open in DBFuncs ------------------------------------------------------------------------ r82 | r_kapl | 2008-01-30 19:16:56 +0100 | 1 line changed DBAddin commandbar Menu handling to fixed menus (strange behaviour with remembering menu positions) ------------------------------------------------------------------------ r81 | r_kapl | 2008-01-29 20:15:03 +0100 | 3 lines BUG: fixed endless loop with query errors (mutual invocations) in DBFuncs improved error messages in DBFuncs ------------------------------------------------------------------------ r80 | r_kapl | 2008-01-29 02:07:18 +0100 | 2 lines added possibility for querystring being in multiple cells BUG: fixed missing propagation of error messages back to DBListFetch and DBRowFetch when nothing was changed (errors before initial filling) ------------------------------------------------------------------------ r79 | r_kapl | 2008-01-29 00:00:53 +0100 | 2 lines improved exception handling for missing DBConf.xml file added concatCellsSep for concatenating with separators ------------------------------------------------------------------------ r78 | r_kapl | 2008-01-21 02:21:03 +0100 | 2 lines Ctrl-d now deletes prepared (empty) insert rows inserted with Ctrl-i Asks before change marks are done for whole-column changes (otherwise takes a long time to do those marks). ------------------------------------------------------------------------ r72 | r_kapl | 2008-01-15 20:50:50 +0100 | 7 lines Excel Clipboard is now not lost when changing to a DBSheet Improved exception handling with complex lookup aliases (clearer error message) warning with parameterized dbsheets when retrieving incomplete records (not all from table). BUG: fixed issue with changed dbsheets leaving old headers BUG: excel event handlers only react now to own worksheet/workbook of DBSheetHandler/DBSheetWBHandler Save to DB message only when changes made to DBSheetAppHandler BUG: delete was not regarded as change made. ------------------------------------------------------------------------ r71 | r_kapl | 2007-12-22 01:47:27 +0100 (Sa, 22 Dez 2007) | 1 line enhanced dbheet change warning to changing workbooks ------------------------------------------------------------------------ r70 | r_kapl | 2007-12-21 16:00:34 +0100 (Fr, 21 Dez 2007) | 1 line fixed colheader/primCol display in edit parameters ------------------------------------------------------------------------ r69 | r_kapl | 2007-12-21 15:07:38 +0100 (Fr, 21 Dez 2007) | 2 lines added "leave DBSheet ?" Warning message on unsaved data fixed header row / fixed primary columns by default. ------------------------------------------------------------------------ r67 | r_kapl | 2007-12-06 12:21:34 +0100 (Do, 06 Dez 2007) | 1 line ISSUE: MenuHandler.addDBContextMenus error message now only logged (no dialog) ------------------------------------------------------------------------ r66 | r_kapl | 2007-12-03 18:50:32 +0100 (Mo, 03 Dez 2007) | 1 line BUG: avoid DisplayAlerts error with opening inside IE (http://support.microsoft.com/kb/165435/en), DBSheets won't work inside IE, as I don't want to catch that stupid MS Bug everywhere.... ------------------------------------------------------------------------ ------------------------------------------------------------------------ Version 1.0.1 ------------------------------------------------------------------------ r62 | r_kapl | 2007-11-28 19:24:41 +0100 (Mi, 28 Nov 2007) | 1 line BUG: endless calculation loop in special circumstances when database engine errors introduced in query. ------------------------------------------------------------------------ r61 | r_kapl | 2007-11-28 17:42:09 +0100 (Mi, 28 Nov 2007) | 3 lines BUG: no updating done directly after modifications to a DBSHeet via DBSheetCreateForm BUG/WORKAROUND: added explanation, how to work around false conflict resolutions when dealing with floating point value columns. BUG: no cleaning of DBsheet data was done when saving from a non-Dbsheet worksheet. ------------------------------------------------------------------------ r60 | r_kapl | 2007-11-28 15:06:18 +0100 (Mi, 28 Nov 2007) | 1 line added ChangeLog ------------------------------------------------------------------------ r59 | r_kapl | 2007-11-28 14:34:04 +0100 (Mi, 28 Nov 2007) | 1 line fixed mysterious sheet select bug (reading headers) when workbook is invoked e.g. by clicking on a menubar that invokes a macro in that workbook. ------------------------------------------------------------------------ r58 | r_kapl | 2007-11-28 14:16:58 +0100 (Mi, 28 Nov 2007) | 2 lines fixed strange window behaviour during saving dbsheets in foreign sheet mode (two windows open). ------------------------------------------------------------------------ r57 | r_kapl | 2007-11-26 19:15:35 +0100 (Mo, 26 Nov 2007) | 2 lines added fix colum/row to initial dbsheet creation create dbsheetid on initial dbsheet creation ------------------------------------------------------------------------ ------------------------------------------------------------------------ Version 1.0.0

  posted 335 days ago

• File released: /DBAddin binary/1.2.6/DBAddinSetup.1.2.6.msi

  posted 335 days ago