Subject RE: [ib-support] Help with query
Author Dan Cumpian
Helen,

No, I am not using the BDE. I am using ZEOS database objects. I am using
these components because this application also supports connection to
MySQL (which, BTW, accepts this data as a blob without any problems).

Also, if it makes a difference, I am using Firebase, not Interbase.

Thank you,
Dan



-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, January 15, 2003 10:43 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Help with query

At 10:17 PM 15/01/2003 -0500, you wrote:
>Helen,
>
>I changed the TMemeoryStream to a TBlobStream, created a persistent
>field that referenced the blob field and still received the exact same
>error. The data I am trying to insert contains a UUencoded binary file.
>It is all text (ASCII), but Interbase is choking on one or more
>characters in the body of the text.
>
>Here is a sample (in case you've never worked with UUE data):
>
>M85B57(YZY5X;<I6BF'[)@HNC+DMKBG]#7E+D65?C[QWZ8NIOB"BDIK)#\7RG
>MHLI(5140=2,I#7\ME0S]$JB5I%VNTMN($&?QM?&;/%7'X]I*=5A<YWY7X:FJ
>MS=2Q"L4VLM2D48GDIUGAP^F@"1:7(Y=V\>('!BWJ>F.A[RBZK<1'W"&]N,=9
>MD%NS*?21S,<QL10\7:VMV[9'UMVZH=Y1=5N(;A#>W&25-V@K*;&X7=ZL3#7B
>MMY4V`A1\L;<46_JW02=BEQ&S%(%@/*C73M>_''HT(,MY"[LP?^?H;^K=`V*7
>M%$S!*,E.IH>K/YJFJW8P.I=$RO+<R.BH'HU,6NN9[DWXOY4U56Y$),V4BHME
>MA7TV4#0QR7,-YCELJA<X&U]-KAOX@&UM5_V=I.ZGBS@FV6JY2LF0(]4SE_J6
>MV<F?%5CB[$?>,O'AI)T*`D'H[T/$9ZF1CD^4EFLT+C51IQ=B'%VL62;.A1ZV
>M>IQ)@-1F@]0)U)$M6O@SSH=.(=K9&SF6RA1@/]=<ST?R=!Z@7S8PFJ<C$JW,
>M=!KL1_0R_G+GB!!F1IYX+2=1\@P>H'PH0 @=!=YC0"AQ2]N56 ?,DNF?1-(?
>M9R*$JE5%TMI),VN>],S:"G2C##TR/EP\Q#S(@NX=7LUFQL+N$@'N8MJ>@R8H
>MY]!1:2Z753*W&5<VN2Q6\PQR_,1%4PN-F-%B**S >F)V!)-A?'S ZZ=L/^AX
>MDR?#R1:JJWZ1*F5VJWV#'.&-YB0Y@8X>DY:Z5L9PNYV3G:4A8I\.9D0V?4X3
>MYQ7[3%K+\*01N1<K=LJIF,10JKTR-U1]D/&^F>S&'(Q^2*R[+CB:!PET$-M2
>M@ @8H#<\;?2+TQJB++#J7#:IZ+!DTQ\Z$7OR+K\G]$L924L$Q:>(R^$&+5Z%
>M`\Y2[?[ET>*]'Y;ODO1\T]>9]0^C85^&87*MV>33'HTCOR+K\G]$IQWAIBV>
>M>3(?DB3YJF.8Z)RIM3ES-(H[+[.7;IH#7L'#G,M^T5Q68?(E0H]V5]^@;Y%>
>MW$75@&!>XA89H+2E,=U,=8W]+<R"RH&QS&&$FI+,4&+[S@K^#PKU@@LS9^0;
>
>As you can see, there are all kinds of characters in there...
>
>Any ideas?


Whatever it's passing can't be a blob, can it?

Look at CreateBlobStream...AFAIK, you can't create a TBlobField in
isolation from a database column. Furthermore, I doubt that TBlobField
is
valid unless you are using a BDE driver (are you?).

Once your client makes that connection then, if, as you said, your blob
is
sub_type 0, InterBase won't care what it gets in there, as long as it's
a
blob. At the moment, something is passing your alphabetti input to the
DSQL parser, which is seeing the resulting statement as invalid SQL.
The
DSQL parser shouldn't be reading what's inside the blob ("black box") at
all.

heLen




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/