That is a native InterBase error. What does the SQL trace monitor reveal?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Eddie Bush" <eddie@...>
To: <IBObjects@egroups.com>
Sent: Monday, January 22, 2001 8: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]
>
>
>
>