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]