-
Problem dbCalendar in Tornado
Hello,
using dbCalendar in Tornado EP. Couldn't format date in German dd.mm.yyyy. No Properties at dbcalendar are functional. All Tests with Options doesn't affect.
Below Code used
<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim XL As New Tornado.Z()
With XL
.dbQP = "S=10|M=G!sys=t!Rowedit=t|Ni=b5,Update,GridUpdate, Add,GridAdd,Delete,search|egu=t|ega=t|Th=Ti=Bearbe itung Wochenendarbeitsanmeldungen"
.dbUnit = "29"
.dbMode="Ty=Grid|sysindex=false|Indexfld=0"
.dbSuppressMsg = True
.dbPageSize = 100
.dbProvider = "ODBC"
.dbDSN = "DSN=mysqlmeister"
.dbDBType = "MYSQL"
.dbSQL = "SELECT * FROM uebantrag"
.dbSQLDateFormat = "yyyy-MM-dd"
.dbEditDateFormat = "yyyy-MM-dd"
.dbCalendar = "Mask=yyyy-MM-dd| IsUSADateFormat=False"
.dbBookMark = "uebantrag;lfd"
.dbGridDisplayFlds= "0,1,2,3,4,5,6,7,8,9"
.dbSkin = 25
.dbEditUpdateFlds = "0,1,2,3,fi=Arbeitstag|ty=TextCalendar,5,6,7,9,fi= lfd|ty=RNOUPDATE"
.dbBoolText = "DisplayTrue=Ja|DisplayFalse=Nein"
.dbMagicCell = "fi=Arbeitstag|mac=#Arbeitstag::dd.MMM.yyyy#,fi=Vo rarbeit|mac=(#Vorarbeit#|EQ|0||nein~|EL|||ja)"
.dbDebug = "FilterSetup, FilterAction, EditSetup, EditAction, ActiveSQL, Fields, Request"
.ASPdbNET()
End With
End Sub
</script>
That is the last code tested. Have tested many more options and syntax. Nothing runs on dbcalendar.
Writing date in correct format for mysql yyyy-mm-dd in field Arbeitstag all ok an ist saved good. But I need to input as dd.mm.yyyy or get this format from dbcalendar.
Please help.
Hartmut Rudorf
-
dbCalendar is a GOLD ersion function
It is because dbCalendar is a GOLD version function. Check the online manual and also the product matrix.
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
|
|