|
-
Input does not work with Oracle
This was previously fixed with Update. I asked to make sure that it was fixed with Input but that has not happened.
Because I do not have access to the demo/demo database I have added a date field to the scott/tiger emp table.
The following example will not allow me to input a date into oracle. Please fix ASAP.
Thanks
<%@ Page %>
<HTML>
<HEAD>
<Title>Savvis Communications</Title>
</HEAD>
<BODY BGCOLOR="white" TEXT="black" LINK="black" ALINK="white" VLINK="black">
<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim Contracts_Add As New Tornado.Z()
With Contracts_Add
.dbMode = "ty=dual-horiz|sysind=t"
.dbSkin = "Plain"_
.dbDBType="Oracle"
.dbDSN = "Provider=MSDAORA.1;User ID=scott; Password=tiger; data source=siebel_report"
.dbSQL = "Select * from emp"
.dbGridDisplayFlds = "EMPNO,ENAME,HIREDATE"
.dbEditaddFlds = "fi= EMPNO,fi=ENAME,fi=MGR,fi=SAL,fi=COMM,fi=DEPTNO,fi= HIREDATE|ty=TextCalendar,fi=RELEASEDATE|ty=TextCal endar"
.dboptions="DateFormat=dd-MMM-yyyy"
.dbEditDateFormat = "dd-MMM-yyyy"
.dbCalendar = "Mask=dd-MMM-yyyy"
.dbNavigationItem = "top,bottom,prev,next,add,download"
.dbBlankText = ""
.dbBookMark = "emp;0"
.ASPdbNET
End With
End Sub
</script>
</FONT>
</BODY>
</HTML>
-
I suppose you mean you cannot ADD a record due to the bad SQL date format. If so, then please contact support for a patch release for this fix (Ver 4.2.25.10).
Following is the test code -
Dim T As New Tornado.z()
T.dbSkin = 1
T.dbProvider = "Oracle"
T.dbDBType = "ORACLE"
T.dbDSN = "UP;scott;tiger"
T.dbSQL = "SELECT * FROM EMP"
T.dbEditDateFormat = "MM-dd-yyyy"
T.dbEditUpdateFlds = "0,1,4,2"
T.dbBookMark = "EMP;0"
T.dbNavigationItem = "b5,update,add"
T.ASPdbNET()
FK
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
|
|
Reply With Quote