One of the really nice things about Witango Search/Update/Insert actions is that they transparently handle data binding (those '?' marks in your SQL debug), instead of inserting the data in the SQL statement itself.. [You can manually bind data in DirectDBMS using the <@BIND> tag, which is what I prefer]. The server relies on a <DataDictionary> within the xml that tells it what kind of data is in each column.
Sometimes the Studio gets confused by the ODBC connections and messes up the <DataDictionary>. When it doesn't know what kind of column, it use !CST. Some types of data must be bound in the SQL statements, but if the Server sees !CST, it won't know that it's DATETIME (for example). You can spend a lot of time in a text editor trying to fix the DataDictionary (always have a backup), or like me, you can just use DirectDBMS, so the <DD> stanza doesn't even appear in the taf. -- Bill ---------- Original Message ----------- From: Kent Swisher <[EMAIL PROTECTED]> To: Witango Talk <[email protected]> Sent: Mon, 02 Apr 2007 11:57:25 -0700 Subject: Witango-Talk: What is !CST bug? > Wow, I just searched the forum for info on the !CST bug. > > None of the postings really described what the bug symptoms are. > One posting mentioned that switching an insert action from using > <@ARG> to <@VAR> caused a problem and they fix by editing xml > datatype from "Text" to "!CST". > > I have just completed converting all our T2k Mac tafs to Witango 5.5 > on PC using ODBC and are going live in two days. Have ~50 TAFS with > ~500 lines using DataType=!CST. Do I have a disaster waiting to happen? > > -> Kent Swisher Engineering Services > -> Alcatel-Lucent Application Support Engineer > -> Wireline Access Products [EMAIL PROTECTED] > -> Petaluma, CA 707-792-7116 > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ------- End of Original Message ------- ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
