I'm sorry for blaming you Helen. I'm sorry for being so reactive when you
posted about the great leap. And, yes, Duilio..you were correct...I was
having an absolutely terribe day. I've had a terrible week as well, but
that's a story for another time.

As I read them now, my first two posts WERE lacking any flavor of helpful
information, and all you were trying to do was help me...I reacted like a
child, and that is not acceptable. You made a joke and it was the end of my
day and I just lost it. I actually laughed when I re-read the whole thread
this morning, and I'm also more than a little embarassed.

Please accept my sincerest apologies.

I'm going to go back over the thread which got helpful despite my best
efforts :) and try to fix my tables so they play nice.

And after much ado, here's what I should've posted the first time

the dll:

RECREATE TABLE "Products3"
(
ID INTEGER,
"Product_Type" VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
"eSKU_ID" VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
MFG_UPC_ID VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
SKU_ID VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
"A_And_Q" BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER
SET NONE,
"Product_Title" VARCHAR( 255) CHARACTER SET NONE COLLATE
NONE,
"Product_Lead_In" BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER
SET NONE,
"Product_Desc" BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER
SET NONE,
"Comp_Acc" BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER
SET NONE,
"Included_Acc" BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER
SET NONE,
"ReadyPrint" SMALLINT,
"Sub_To_BB" SMALLINT,
"FrontImg" VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
"ThumbImg" VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
"EnThumbImage" VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
"HiResImage" VARCHAR( 50) CHARACTER SET NONE COLLATE
NONE,
"FntImg_Ready" SMALLINT,
"Thumb_Ready" SMALLINT,
"EntThuImReady" SMALLINT,
"Layer1_Approval" SMALLINT,
"Layer2_Approval" SMALLINT,
"Rejected" SMALLINT,
"Sent" SMALLINT,
"Modified" SMALLINT,
"Ready_For_XML" SMALLINT,
"Exported_XML" SMALLINT,
"Export_XML" TIMESTAMP,
"Drop From Asst" SMALLINT

and the statement:

INSERT INTO "Products3"
("Product_Type", "eSKU_ID", SKU_ID)
VALUES
('foo', 'foo', 'foo');





-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, February 14, 2002 6:50 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] arithmetic exception, numeric overflow, or
string truncation


At 06:12 PM 14-02-02 -0600, jon-david schlough wrote:

>thanks for you condescention helen! it helps a lot :)

Apologies for the offence taken, which was *not* intended.

Rather than leap off a tall building as you recommend, may I just put it to
you that it's extremely difficult and frustrating to try and provide problem
solutions when people provide no pertinent information? A problem
involving a failed SQL statement in insoluble if we don't know what the
statement was.

Consider the time (freely given) that responders spend trying to extract
information from people who don't want to share the essential details of
their problems. So far, your thread has taken three postings from me (and
about 30 minutes) and we still have no information that would help to solve
it.

>i'm just not as experienced or as capable as you are...bummer:

This is not a prerequisite to describing your problem.

>( i guess getting laid off from web design then trying to learn new

technology....like, oh, say

>enterprise level RDBM and Perl would be no problem for you! How silly of me
>to get frustrated!

I understand your frustration but please don't blame me for it. I hope you
understand mine.

>I'm surprised...generally open source folks are respectful, even to newbies
>who make mistakes, because they'd rather people participate than be
>discouraged into not participating.

I find it hard to relate to offence taken from a request to supply
sufficient information to understand a problem. This is what I said:

"I guess the next great leap forward will be when you show us the statement
that failed and the DDL for the table you were trying to insert to."

>I'm not discouraged,

Good.

>in large part
>because Ann took the time to respond privately to a newbie post I made with
>the utmost class and respect...and she "wrote the book" on IB/FB.
>http://www.ibphoenix.com/ibp_config.html literally. I'm reading it slowly
>trying to absorb as much as I can.

That's an excellent document, of biblical importance, and Ann is undoubtedly
the fount of all knowledge of our great database. It's encouraging to see
that you appreciate the time she spared to help you.

>forget it. all apologies for wasting everyone's time.

I doubt that you wasted anyone's time but mine and I'm fairly philosophical
about that. But, if you are serious about solutions to the inevitable
problems you (like all newbies) are going to bump into, then do please try
to post useful problem descriptions. In general, we need to know which
database and version you are using, which client environment the problem
occurs in and, for SQL problems, we need to see the statement and the
structure of the data it is operating on.

>and helen, feel free to "show us" a "great leap forward" off a tall

building.

Thanks for that, I'll consider it when I am slightly less busy. I'm sure
you will get a solution to your problem from someone, once you provide
adequate information.

regards,
Helen


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/