Nevermind --- the stored proc was making use of a field who's width had
changed. It was complaining because the variable I had defined was too
short.

Thanks Much!

----- Original Message -----
From: Eddie Bush <eddie@...>
To: <IBObjects@egroups.com>
Sent: Monday, January 22, 2001 7:44 AM
Subject: [IBO] IB_Query / IB_Transaction Problem


> Hey Guys/Gals -- little problem I hope you can help me with.
>
> My app starts a transaction and inserts a record into the table controlled
by qryIssue just above where this line is executed:
>
> qryIssue.FieldByName('DISTRIBUTEDBY').AsString := FrmMain.cnMain.Username
>
> The field DISTRIBUTEDBY is defined as char(31), yet I get the following
message back:
>
> Project raised exception class EIB_ISCError with message 'ISC ERROR
CODE:335544321
>
> ISC ERROR MESSAGE
> arithmetic exception, numeric overflow, or string truncation'
>
> Process stoped .. etc, etc.
>
> Any help would be greatly appreciated.
>
> I commented that line out just to see what would happen, and the next line
does the same thing -- it assigns a date value to a DATE field -- nothing
unusual, but it gives the exact same error message as above.
>
> I did change some column widths, but not in this table. I do have,
however, on the same form, a select from a stored proc that MIGHT be
affected by this -- though I cleared the cache files out, so I wouldn't
think this would be affecting me.
>
> Thanks in Advance!
>
> Eddie
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>