Helen, thanks for your reply!

<clip>

>
>"arithmetic exception

e.g. division by zero

>>k

>numeric overflow

e.g. trying to push too large a number into a numeric type

>>yep

> or string truncation"

string being inserted is longer than the declared length

>>understood that as well...

>i saw the borland post on the workaround

?? workaround ??

>>the solution on borland's site, which is more of a workaround, is to use

CAST

>>http://community.borland.com/article/0,1410,25767,00.html
>>although i'm not using a UDF, so it confused me...

>but i'm just doing a simple insert..!?!

A simple insert can overflow. What are you using as a client? Can you
inspect your input?

>>i'm using access as a client for the app (unfortunatly)
>>but when i executed the query in workbench->same error, then in isql->same

error

>>so my deduction was that the client was not invloved in the problem.

>why does UDF add characters to my cute little insert?

If there is a UDF call in your insert, it's not a "simple insert". Can you
provide information about the UDF and how you know that it adds characters?

>>i wasn't clear on UDFs - now I am...and I'm not calling one, I got

misdirected by reading the borland post which states that in all versions of
IB

>>UDF adds a character (more in the above link), so I assumed this was true

of FB.

>quick fixes? workarounds?

Describe the problem adequately and let's see.

>>apologies for my inadequate description, i've been using the product for

all of a week...my bad.

>>As an aside, I imported the data and structures from MS Access...would

that affect this? I noticed it changed notes (255) to a BLOB (80)...

Database, version and client might help too.

>>FB RC2

>>Helen, thank you very much for taking the time to help me out...I will try

to describe all future problems adequately. again, apologies.

>>Cheers!

>>jon-david

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/