Subject | RE: [ib-support] Help with query |
---|---|
Author | Helen Borrie |
Post date | 2003-01-16T03:42:58Z |
At 10:17 PM 15/01/2003 -0500, you wrote:
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
>Helen,Whatever it's passing can't be a blob, can it?
>
>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?
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