Hi Simon, yes reloading datasource and rebuilding the query did fix my problem....... Thank you for the link.....
Farzana -----Original Message----- From: Simon Boddy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 4:48 AM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: String data truncation Hi Farzana, James, Are you sure your problem is fixed. I would say that the proposed fix is not going to do anything, and the real problem is elsewhere. First the real problem... The most likely cause is that T2k SP1 can insert a maximum of 255 chars into a text field. In the 047 FTF build this was extended to 4k chars. Download the FTF from the Witango site, and remember to set Transaction Blocking to false in the .ini file. And the proposed fix... Tango does not remember the length of 'text' type columns. When the Editor loads the data source, it only distinguishes between text types, numeric types and date types. This info is stored in the <DataDictionary> element of the taf file, so the App Server knows at runtime to put single quotes around the text types, and format as timestamp the date types. The app server will happily construct SQL with strings exceeding the length of the target column, and will faithfully display the resulting SQL error message. If you look in the data dictionary element of a .taf file, you can see what details of the data source are remembered. All this to say that changing the length of a text column, or changing the type from char to varchar, text, nvarchar or another text type will have no effect on your Tango apps. Changing a column from a text type to a numeric type will necessitate reloading the data source in the editor. It will also break all previously created insert/update DB actions associated with that column. To avoid your users seeing the DB error, you should be using the maxlength attribute of html inputs, and javascript length checking for text areas, which don't support maxlength. Good Luck, as they say in Dublin. ******************************************************************** This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board). Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems. ******************************************************************** ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
