| Release |
Problem / Solution / Patches / New Features |
|
Aug, 2005 |
-
ASP-db
Classic
support
team
will
not
provide
application
support
any
more.
You'll
need a
support
contract
in
order
to get
that.
This
never
seen
before
application
support
is
done
ny our
sales
team
on a
good
will
basis
and
since
the
trend
is
going
towards
DotNet,
this
service
is not
free
anymore.
However,
bugs
will
still
be
fixed
if
any.
Classic
sales
is
ended
and
we'll
offer
the
Classic
ASP
products
for
free
with
every
DotNet
product
purchase.
This
is to
encourage
users
to get
on the
DotNet
train
and
have a
bigger
future.
|
|
Feb, 2004 |
-
Fix
dbdisplay
by
reseting
the
value
at
RSclose.
dbDisplay
affect
template,
Navigation
and
StaBar.
-
When
P4 CPU
= 586
will
be
read
as 2
CPU.
If 586
then
increase
UserCPU
by 1.
|
|
Nov, 2003 |
- P4
(HT)
CPU =
586
will
be
read
as 2
CPUs
hence
invalidate
EP
single
license
versions.
For
CPU =
586,
now
UserCPU
increased
by 1
to
overcome
this
problem.
-
MagicCell
#field::format#
failed
-
fixed
X.dbMagicCell
= "EmployeeID,,(|EQ|2||N/A~|EL|||#0::currency#)"
now
works.
|
| Oct,
2003 |
- Edit
Template
DropDown
SELECTED
item
failed
when
it
contains
a
single
quote
-
fixed.
- Looking for "_ASPDB" & DLLYEAR & ".ID"
updated
for
ID
file
debug.
- Display and magiclayout property leaks - fixed
- Supergoto defaults a %text if no lead character
- Clear edit state in RSCLose to avoid edit / update error
- suppressmsg
whichis
not
working.
- modify EMAIL validation for f.kwong@attb.com type address
- Template Update must move first before move to the records > 0
- Fix Format=[ ] again. This time search for format=[..] and repalce first - blind.
|
| 12.31.02 |
- BlankDB test failed becasue of the Export test blank out
- if format= >0 and ":" =0 then old format.
- Support old format -> x.dbMagicCell = "Freight,, format=[currency]"
- previous fix caused template not to work - fixed
- dbNavigationIcon="..." breaks dbRefresh - fixed
- Magic short truncate has no space in it and crash looking for one.
- User edit template blows up at export
- dbRefresh is commented out - put it back
- Get SP editing to work.
- Still probelm in get_good_date. Fixed...
- space in dateformat wrong code to detect space.
- when "aspdb" not present in querystring, session is not considered as new...
- Download inactive fix cause download to activation upon entry.
- Fix get_good_date again. This time parse out the mm,dd,yy and match them with the input, NO more errors
- Toggle drop button hold the wrong active
record
-fixed.
|
| 04.17.02 |
Colgraph text format is incorrect. Only first one shows |
Fixed |
| 04.10.02 |
LargeDownload quits after 32,678 records |
Fixed |
| 03.26.02 |
Euro dates problem and Oracle Edit date problem |
Fixed again! |
| 03.21.02 |
Export fails in Edit |
Fixed |
| 03.20.02 |
Space in name and Netscape blows up |
Change all spaces to %20 |
| 03.13.02 |
Missing lastclick in snake Col >1 |
Fixed |
| 02.28.02 |
Export field when db is blank mess up |
Fixed |
| 02.18.02 |
TYPE=TEXT problem in update corrected |
Fixed |
| 01.18.02 |
Memo "..." wrong when memosize < len(memo) |
Fixed |
| 01.16.02 |
Hard to format in template |
Add template tag [[Field:R:Format]] to format fields and variables |
| 01.12.02 |
Null MEMO fields caused problem in Forms and Templates |
Fixed |
| 01.08.02 |
SuperUpload cut off TEXTAREA input after First <CR> |
Fixed. DLL will be posted. |
| 12.11.01 |
Designer has problem with Text File names in DSNless mode |
Fixed. Put [...] around it. |
| 12.11.01 |
MagicCell has trouble with masking Nulls. |
Turn Nulls into blanks and offer two new operators IS (IsBlank) and NB (NotBlank). Works well. |
| 12.06.01 |
SelectedItemMacro improperly parsed such that 10 will match 100 |
Fixed |
| 10.18.01 |
SendTemplate locked up in to EP |
Open it |
| 10.13.01 |
Equation doesn't work with long / double |
Fixed |
| 10.10.01 |
Template does not work with Enterprise (feature roll down) |
Fixed |
| 10.08.01 |
Aggregate and HideTwin doesn't work right (2002 only). |
Fixed |
| 10.04.01 |
User report memory leaks |
Add special closing routine to catch them all. User reports OK after that. |
| 10.02.01 |
Add dbOptions="MagicDownload=True" Works only with normal and not Large Download. |
New feature. |
| 10.01.01 |
Form and regular NameMap confusion |
Global fix - if one is not declared, it is made to be the same as the other one. Form, Edit and Filter uses the FormNameMap. |
| 10.01.01 |
Error in Multi col Edit layout |
Fixed |
| 9.27.01 |
EditDateFormat problem in EditDateFormat. Also supports mmm/dd on top of mm/dd. |
Fixed |
| 9.18.01 |
Bugs in editadd cancel button disappear when there is a URL variable. |
Fixed |
| 9.14.01 |
Add a new MagicCell local format as #ValueMacro:Length:Format#. Very powerful. See example in the front page. Click the right "Try It" button on the left pane. |
| 9.13.01 |
Add two more MagicCell operators - NV=Not Even EV=Even. These two operator can do pretty amazing display. Use the #ASPdbIndex# to control the odd/even. |
| 9.12.01 |
Export Dates, EditDateFormat not working correctly |
Fixed. |
| 9.12.01 |
Add dbDBType="Informix". User is happy about this addition. It is the same as Oracle except that the internal date format is '[YYYY-MM-DD]'. No HH:MM:SS. |
| 9.10.01 |
Fix Excel Sort and Filter problem when fieldname has space and odd characters. |
| 9.09.01 |
Add Aux buttons to "check all" or "clear all" SelectedItems -> X.dbSelectedItemMacro=(;,)Macro,Qty_T/F,Column_Caption,Input_Size,Aux_Buttons
Also add SelectedItemMacro support to Designer (Display Form) |
| 9.01.01 |
New property - dbLargeDownload. User needs to clear the deposited large .csv files using via a scheduled task. |
| 8.29.01 |
Export Fields fixed to work with Update Icon every row. |
| 8.28.01 |
Add hover buttons options. New images in a separate directory and dbOption="HoverButton=true" (2002). |
| 8.27.01 |
Cannot query for records of the day. Timestamp cause criteria='date' to fail because records has timestamp attached to date. This is a very common problem and you have to use a compound criteria and is not friendly for users. |
Add a new property - dbOneDayFilterFieldName="f1,f2...".
Leave the rest to ASP-db in retrieving the records of the 24 hour day !! (2002)
|
| 8.26.01 |
EditDateFormat only works in Access |
Fixed. Now works for ALL. See documentation. |
| 8.21.01 |
Borrow Validator's Params for regular EDIT box control PASSWORD(3) and TEXTAREA + AddParam (2+7).
AddParam = "COLS=xx ROWS=xx" (2002-Enterprise and Gold) |
|
^2001 and 2002 ^ Activities or ^ 2002 only Activities ^
|
| 8.16.01 |
Add Option dbOptions="IconColHeader=Label_string". |
| 8.15.01 |
Stripping while spaces in filter caused it to fail when searching for phrase with multiple spaces in it. |
Fixed |
| 8.10.01 |
Problem in DropSQL "*" to "%" replacement when formula is present. Replacement Dropped. |
Fixed |
| 8.08.01 |
Add dbDebug=110 for DropSQL dump. Oracle users come up with a mile long SQL and this comes in handy. |
| 08.06.01 |
Add (3) logical operators to MC. ND (Not IsDate), NN (Not IsNumeric), IN (IsNull). |
| 08.06.01 |
Use dbFormNameMap in Filter and Edit instead of Grid dbNameMap |
| 08.06.01 |
Export fields not work in Edit |
Fixed. |
| 08.06.01 |
Problem with double quote in download fields |
Fixed |
| 07.28.01 |
Bool field does not work with MC |
Fixed. dbBoolText will still override the MC operations. When Booltext is blank then Boolfield will go through the MC filter. For example, You can use different IMG for different field's true/false. |
| 07.27.01 |
ASP-dbDesigner dbCountSQL auto generation doesn't take into account of the filter |
Suppressed and user have to input this one manually. |
| 07.27.01 |
Any foreign language that does not recognize the date format MMM DD YYYY where MMM=Jan, Feb etc... in English cannot activate Designer. |
Version Jul 27 Fixed. Need to replace both designer and DLL. |
| 07.25.01 |
* Designer release includes a /Trace command line arg to trace the ID file installation.
* dbColGraphMinMaxSQL allows user to specify the Min/Max via an SQL. see dbColgraph for details. |
| 07.09.01 |
Case non-sensitive lost in formula (calculated field) |
Fixed and in test. |
| 07.06.01 |
Two New StartUp options - dbStartUp="Editdelete, Exit" |
| 07.02.01 |
MEMO fields (201, 203) does not allow Filtering with EXACTLY (=) operator. Issuing that in SQL will result with a system error. |
In Test. 'String' in pas-thru mode or ='String' (EXACTLY) will both be detected and converted to LIKE '%string%'. |
| 06.29.01 |
ExportFlds and LastScreen are lost in Level 1 Templates |
Fixed |
| 06.20.01 |
Validator ISNUMBER numbers with decimal hangs (like 1234.5) 1234 = OK |
Fixed. |
| 06.19.01 |
When SQL has ...Field AS Alias.... - dbCountSQL is disabled and force a count and caused slow down. Designer does not honor dbCountSQL |
Fixed and patched. |
| 06.15.01 |
SuperCal doesn't work with ASP-db |
Correct ! My fault. Now it does, MMS folks have compiled an example together with all the neccessary files. Go get the latest. |
| 06.12.01 |
Designer Chart params "True" should be "true" |
Fixed. |
| 06.12.01 |
Forgot to include the SuperCal DLL for the Gold users |
Release DLL and sample files. |
| 06.06.01 |
Spinning Pie text label checkboxes are not persistent |
Fixed. |
| 06.05.01 |
dbDSN, dbMDB has missing end quotes when using MapPath |
Fixed. |
| 06.04.01 |
Pro version has SP locked out |
Fixed. |
| 05.23.01 |
Form display in Oracle incorrect MoveTo |
Fixed. |
| 05.17.01 |
dbSelectBox implementation is incorrect is both DLL and Designer. SIZE is not effective. |
Fixed |
| 05.16.01 |
Colgraph does not remember Min/Max values hence performs queries every row |
Fixed. |
| 05.16.01 |
Dropdown for datasource using DSN (like Oracle) and has a PWD; UID; etc. fails. |
DSN=...... has DSN= stripped off. Fixed. This fix is done on both DLL and Designer. You need to get both with version number >= 05.16.01. |
| 05.15.01 |
SuperCal has DaysAbbs Typos in Netscape version < 6.0 |
Fixed. |
| 05.10.01 |
Template Edit Boolean field does not use "False=0" upon a no entry. SQL based DB only . Access OK. |
Fixed |
| 05.10.01 |
Designer Chart delimiter defined in Layout does not retain changes |
Fixed. |
| 05.10.01 |
Designer Chart Text color has incorrect RGB syntax |
Fixed. Should be "123456" instead of "#123456" |
| 05.07.01 |
Template 1 & 2; MagicLayout SelectBox, BLOCK opened for Evaluation version. |
| 05.07.01 |
Edit MEMO has no show problem |
Fixed. |
| 05.03.01 |
Designer Chart Axis grid does not retain the selection in some cases. |
Download version of Designer with date after May 03 and it'll be fixed. |
| 05.03.01 |
SV_FILTER lose the filter SQL upon returning with no records |
SV_FILTER is now made to record the current FILTER even when blank and returns no records. This is not the same as FILTERSQL which actually is the effective filter SQL. |
| 04.12.01 |
SQL input with single quote doesn't work |
Fixed |
| 04.12.01 |
Record count > 9999. go to Bottom and then Prev will go to the wrong record |
Fixed |
| 04.12.01 |
Add Export to Filter and Edit - dbEXportFlds MUST be fieldname and not number. |
| 04.09.01 |
Update Readonly with a default value doesn't work |
Fixed. |
| 04.05.01 |
CaseSensitive now applies to Sybase also on top of SQL and Oracle after the 4.05 release. |
| 04.02.01 |
Missing documentation in drop fields. The "NoBlank" parameter can be replaced by "Radio" to produce a Radio box. |
| 03.15.01 |
Filter screen lost the user control connector and operator when assistant is hidden. |
Any release after 3.15 will have this problem fixed. |
| 03.15.01 |
Binary type 128 and 204 turns out not to accept getchunk. Thanks to user T. Kent for reporting this problem while working on TeraData. |
These two types will be send via straight binarywrite. Any release after 3.15 will have this problem fixed. |
| 02.27.01 |
dbMail problem when body is "Select...". |
Fixed. |
| 02.26.01 |
Schema/View does not work when opening a View instead of a table in Designer |
Fixed |
| 02.16.01 |
Designer Connection form has been re-worked and now covers the Text and Excel DSN. When DSN is used, All text files (*.csv and *.txt) and all ranges of the Excel worksheet will be displayed in the table listbox. |
| 02.14.01 |
MapPath in the Designer Connection form does not work properly. Also, Designer needs to be able to work in an environment where the Designer physical data source is in a different location then the actual preview data source. |
A new Preview Data source is added adn MapPath button applies only to this data source.. This data source can be a physical path or a MapPath and will be used by the preview. The Designer will continue to use the local data source. |
| 02.13.01 |
dbColGraph number at the end needs to be formatted |
Add a parameter at the end of the dbColGraph as the NamedFormat of MC to format the number. |
| 02.10.01 |
Designer menu layout changed to vertical. SilentCmdText sticky code problem fixed. ASP-db.Inc exclusion added in Paths. Append application code has Response.buffer and ASP-db.Inc stripped.
Designer help file is now context sensitive. The "last" open form will lead to either the Designer help or ASP-db syntax help for the subject.
User supplied RS (dbRecordSet) navigation blows up just before hitting BOF - Fixed. |
| 02.09.01 |
During Edit Add, SQL UniqueIdentifier (Type=72) will display as regular field which is not appropriate. |
ASP-db now recognize field type 72 and hide the field in EditAdd. There is no need to specify that in Designer. |
| 02.02.01 |
New features in Designer to allow use of help files from local directory or aspdb web site. |
| 02.01.01 |
Click on Connection form Tables and Fields Label to expand the listbox to see long table and field names. Add Count() to Calculated fields lazy keys. Selected fields in Designer Connection form can now be moved via a vertical scroller. |
| 01.26.01 |
Cannot find MagicCell VB style formatting information |
I retrieve that and put it in the Reference section. |
| 01.26.01 |
New equation operators not available in Designer |
Add equation list using the Format list combo box |
| 01.25.01 |
Designer SilentCmdText Form is broken |
Fixed |
| 01.25.01 |
After SilentCmdText if there is no dbSQL then ASP-db will complain. |
Open up restriction such that if dbSQL="" and dbSilentCmdText<>"" then it means user wants to end module after executing the SilentCmd. In this case ASP-db will end will any error messages. |
| 01.23.01 |
Discovered that listing the tables of some SQL databases includes a lot of system tables (dt...) in the Designer |
Borrow the Hide Prefix from the Stored Procedures routines to apply to hide the table names. So, go ahead and use that feature. |
| 01.23..01 |
Blank entries in template Edit / Add creates incorrect INSERT queries |
Fixed. Remember that your field has to accept Null in order to leave it blank during Add. |
| 01.23.01 |
Edit / Add template Boolean checkbox when value=False will produce incorrect INSERT SQL statement |
Fixed. |
| 01.18.01 |
Replace {X+Y+Z+A...} fails in Xtended MagicCell when logic operator is used. |
Fixed |
| 01.11.01 |
Cannot see export variables in Designer especially needed when using ExportMagic=True to Export Magic values |
Add Display Export variables checkbox option to Designer. |
| 01.08.01 |
Template Add and Update's date values has double and missing wrappers. |
Fixed |
| 01.07.01 |
Add template drop field fails when dbSQL returns no records because RS.EOF kicks in. |
Fixed |
| 06.07.01 |
How come I cannot sort the calculated fields and also Joined fields? |
| |
Use dbNameMap to register the calculated field formula. See documentation. |
| 03.16.01 |
How can I persist the querystring variables in ASP-db operations? |
| |
X.dbOptions="KeepUserQueryString=true" |
| 03.15.01 |
I have JOIN fields in my dbSQL with the same fieldnames from different tables. When I use ASP to open the query, duplicated names are being returned and the origin of the fields are lost. How does ASPdb handle this? |
| |
| |
CaseStudy #19 |
| 03.15.01 |
I have trouble with the following large query which doesn?t work in either ACCESS or ASP when I try to filter the field 'COUNT(Bid.JobID)=2'. Can ASPDB help? |
| |
| |
CaseStudy #23 |
| 03.03.01 |
How do I know what functions are NOT available with a certain version of ASP-db when working with the Designer? |
| |
| |
Click on "Support/Lock out functions" in the designer's menu bar. The lockout functions are documented in the introduction.htm file. |
| 01.25.01 |
Specifying CodeBase for Java Charting Applets |
| |
I found out that using the following servervariables will make my code ore portable when specifying the Codebase of the Charting Java Applets -> Y.dbMagicLayout="(;,#)2;CHART_25,http://" & request.servervariables("SERVER_NAME") & "/Training,200,100,1,1; dataset0Labels~dataset0yValues; #0#; needleStyle=3~ labelsOutside=true~dataset0Color=Red~ yAxisStart=20~yAxisEnd=80~ yAxisOptions=noAutoScale,majTickOn~yAxisLabelCount=6~ yAxisTickCount=6"
|
| 02.01.01 |
Create a new DB and trying to add data resulting in a yellow box? |
| |
dbTestBlankSQL is designed just for that. |
| 01.01.00 |
Notes on using ASP-db with Oracle |
| 01.01.00 |
Symptom: "Operation must use an updateable query" when the Update Now button is clicked. |
| |
| |
Probable Cause:
User does not have "write" privileges.
Solution:
Using MTS, when you create a Package, the Account it uses is: 'Interactive user - the current logged on user'. You should really use "This User" then specify a user with WRITE Privileges.
- Open MTS (Internet Service Manager)
- Click on Computers / My Computer / Packages Installed / name_of_aspdb_package
- Right click on that package and choose Properties
- Choose the IDENTITY tab and click on "This user:"
- Enter the user id and password for an ID with read and execute and WRITE privileges for that DLL. As a test only, you can just use an Admin id & password.
- Click OK to apply the changes.
|
| 01.01.00 |
Symptom: Clicking on any button - nothing seems to happen |
| |
Solution: Delete your "global.asa" file (if it's empty)
This problem occurs if you have a global.asa but it has a length of zero. If this is the case, just delete the global.asa file.
Solution: Check your "Cache ISAPI applications" setting
Also be sure that the option "Cache ISAPI applications" (in MTS) is enabled. This is necessary for ASPdb to work correctly and to have access to its session variables.
To check:
Go into MTS, right-click on your server and choose Properties. Go to the Tab marked "Home Dircetory" and click on "Configuration" in the "Application Settings" area. There should be a checkbox for "Cache ISAPI applications".
|
| 01.01.00 |
Symptom: Type Mismatch |
| |
Solution: Remove non-U.S. dll file
To solve the problem, Vb5De.dll (German) or Vb5Es.dll (Spanish) can be renamed or deleted.
REN Vb5De.dll Vb5De-old.dll
and the English version of Vb5Db.dll needs to be used.
Upgrading to -- or even just re-installing ADO 2.1 -- has also been known to help.
|
| 01.01.00 |
Symptom: Class doesn't support Automation |
| |
Solution: Install ADO 2.1
To see what version of ADO you have now, insert this code: <% ' To see what version of ADO you have ... Set ADO = Server.CreateObject ("ADODB.Connection") Response.write("<BR> ADO Version = " & ADO.Version & "<BR>") %> Newer versions of ASP-db require use of ADO 2.1. The update is very easy to do.
|
| 01.01.00 |
Symptom: Server execution failed, Server.CreateObject Failed |
| |
Solution: "This User"
Using MTS, when you create a Package, the Account it uses (by default) is: 'Interactive user - the current logged on user'. That's all well and good until you log off from the server! The solution to having your ASPdb DLL run while your server is logged is simple:
- Open MTS (Internet Service Manager)
- Click on Computers / My Computer / Packages Installed / name_of_aspdb_package
- Right click on that package and choose Properties
- Choose the IDENTITY tab and click on "This user:"
- Enter the user id and password for an ID with read and execute privileges for that DLL. As a test only, you can just use an Admin ID & password. 6) Click OK to apply the changes.
|
ASP-db Classic Release History