Subject RE: [ib-support] Help with query
Author Helen Borrie
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