Re: [Firebird-odbc-devel] VFP 8 and BLOBs

[Dorin V. <dor...@ya...>]

Hi
Thanks for the answer, but, to be honest, I don't understand.

>     You have deceived ODBC!!! :-)
>
Me or VFP8  :-) ?


""Vladimir Tsvigun"" <pr...@hm...> wrote in message
news:c99rqj$4mo$1...@ne......
> Hi, Dorin!
>
> > Never mind, it works if SUB_TYPE = TEXT. Before was 0 - binary. But why
> > doesn't work with binary type BLOB?
> >
>     Oooo! :-)
>     You break rules ODBC!
>
>     See your messages:
> 1)
> > If I update a BLOB from Visual Foxpro 8 SP1 through ODBC (image
usually),
> it
> > is corrupted. Can this be done, or I need to rely entirely on API?
>
>     image usually -- it is binary data (has in the format meaning 0 )
>                             it is SQL_C_BINARY not SQL_C_CHAR
>
> 2)
> > vfp8            b6c-cd0 ENTER SQLBindParameter
> >   HSTMT               01F71ED0
> >   UWORD                        1
> >   SWORD                        1 <SQL_PARAM_INPUT>
> >   SWORD                        1 <SQL_C_CHAR>
> >   SWORD                       -1 <SQL_LONGVARCHAR>
> >   SQLULEN               231021
>
>     Here you promise ODBC
>       - Your line will be completed by meaning 0
>       - Yours of binary data will look like 16 hex (FF AA AC 4A...)
>       - Your length of a line 231021 hence binary data length 231021/2 =
> 115510
>
>     You have deceived ODBC!!! :-)
>
> --
> Best regards,
> Vladimir Tsvigun
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>