Thanks Gerard. I will search the Strataframe forum for more detailed information.

Sam

>Hi Sam
>On the last update (I think) of Strataframe, they now have included a property on the business object, if it set to true, the default width of the field in the buiness object becomes the width of the table field, so in essence it prevents you from entering more characters than are in the table.
>The best place to get more info in on the Staratframe forum . Also ensure you have downloaded the most up to date version.
>
>Even if you are just evaluating, you can have acces to the strataframe fora, and I think you can also do searches
>Regards,
>Gerard
>
>
>
>
>>Hi Gerard,
>>Sorry, but your posting got my attention and I have an off topic question for you. You mentioned a "... new option in Strataframe which takes the size of the table field into the BO...". I am presently evaluating Strataframe and I am not aware of such an option. Can you direct me to more information about this option? It sounds like it could be very useful.
>>Sam Tenney
>>
>>>Hi Charles.
>>>I have come up against this in a few projects (Not Strataframe) and it has been a pain.
>>>The new option in Startaframe which takes the size of the table field into the bO is useful ...have not done enough testing on that to see if it overcomes this sort of problem yet
>>>Regards,
>>>Gerard
>>>
>>>
>>>>I've struggled with the same issue and look forward to someone more knowledgeable providing an answer - but I have found that it is a very good idea to control the input of all data in the UI so strings too long never hit the backend in the first place, by limiting the maxlength of character fields in textboxes as a matter of course.
>>>>
>>>>>Hi.
>>>>>This problem happens on a SQL insert where the data being inserted is longer than the Database Table field length.
>>>>>I am cs oming up against thiso issue a lot lately and am finding it very time consuming to identify the problem
>>>>>I might have a table with 50 fields and on an insert , any one of the fields, could be too long and causing the problem.
>>>>>I have had to put some code in each time to display the length of each field.
>>>>>Is there any more generic way or tool available to identify where the field size is too big for the table field ?
>>>>>TIA
>>>>>Gerard