-
Sybase Date Format problem when editing
I am receiving the following error when applying updates in APS-DB
to a table with a field of type timestamp on a Sybase 6.0.2.2188 database.
I am using the EP eval.
Error # = 80004005(-2147467259)
Description = [Sybase][ODBC Driver][Adaptive Server Anywhere]
Restricted data type attribute violation: cannot convert
08/18/1999 10:55:08 AM to a timestamp
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 07006
Native Error = -157
MY CODE IS AS FOLLOWS:
<%@ Language=VBScript %>
<% Response.Buffer=True %>
<HTML>
<HEAD>
<BODY>
<CENTER>
<%
Set MyDb = Server.CreateObject("ASPdb.EP"
MyDb.dbDBType="SYBASE"
MyDb.dbDSN="DSN=etrack6; UID=dba; PWD=sql"
MyDb.dbColor = "4,auto"
MyDb.dbMode = "form"
s="Select * from CSC.UnitDescr where UnitIdx="&Session("UnitIdx"
MyDb.dbSQL = s
MyDb.dbImageDir="images/"
MyDb.dbNavigationIcon = "std"
MyDb.dbNavigation="Top"
MyDb.dbNavigationItem="formcol,update"
Mydb.dbEditParams = "TableName=CSC.UnitDescr, BookMarkFlds=UnitIdx, TableTag=Border=2, RecordScope=single, CriteriaSize=4x25"
Mydb.dbEditHideFlds="UnitIdx"
MyDb.ASPdbEP
%>
</CENTER>
</BODY>
</HTML>
The problem does not occur if, before I push the Apply Updates button,
I change the data value from 08/18/1999 10:55:08 AM to 1999/08/18 10:55:08 AM.
So I thought I might be able to use dbMagicCell to change the data format. It turns
out that dbMagicCell changes the format for the FORM, but not for the edit box; the
same error still occurs.
I hope I am not the only Sybase user using ASP-DB! Thanks for any help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|