| Subject | RE: [ib-support] Help with query |
|---|---|
| Author | Dan Cumpian |
| Post date | 2003-01-16T03:52:51Z |
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:
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/
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,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
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/