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