Any chance you can switch to variable length fields in your DB2? Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin "Roger Vicker, CCP" <firstname.lastname@example.org> Sent by: email@example.com 01/21/2003 11:57 AM Please respond to Lotus Domino on the iSeries / AS400 To: Domino 400 <firstname.lastname@example.org> cc: Fax to: Subject: Text field lengths and external DataBases. Hello, We have put a Domino/Notes face on a DB2 application using Domino 5.0.10 (soon Domino 6) and are having problems with text fields. Since this is based on a DB2 application running on an iSeries the text fields have a fixed length however in the Notes client the only way to limit the input is by issuing an error message after the user's input :-( or by truncating :-( :-( in the code. The users really hate having to retype their text or guessing at how much will fit and usually end up with very short lines that waste a lot of database space. In addition there are areas where a memo is attached to a master record. Again, with a DB2 backend this is structured as an unlimited number of fixed length records, each representing a line. Surely with the number of Domino applications interfacing with other databases that use fixed length fields someone has developed a better way of making the Notes client keep the fields compatible. I would appreciate any code _snipits_ or addresses that could help with these situations. Thanks. Roger Vicker, CCP -- *** Vicker Programming and Service *** Have bits will byte *** www.vicker.com *** A conference with the IRS is a taxing proposition. _______________________________________________ This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list To post a message email: DOMINO400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo.cgi/domino400 or email: DOMINO400email@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.