Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to fetch data from uniqueidentifier field?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Velichko Yuriy <velichko.yuriy AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] How to fetch data from uniqueidentifier field?
  • Date: Wed, 22 Jan 2014 19:42:05 +0200

1 Sorry for the unformatted code, the mail was sent accidentally.
2 The crash was fixed by reserving more space for buffer.


On 22 January 2014 19:28, Velichko Yuriy <velichko.yuriy AT gmail.com> wrote:

> Unfortunately, using if function dbconvert leads to crash of my
> application. At this time I can't figure out the reason.
>
> I use similar code to transform datatypes fetched from the server. For
> UniqueIdentifier it looks like:
>
> int dataLength = dbdatlen( mpConn, i + 1 );
> int dataLength = dbdatlen( conn, colIndex );
>
> BYTE* msData = dbdata( conn, colIndex );
>
> if( msData == NULL )
> {
> // BREAK
> }
> else
> {
> switch( fldDataType )
> {
>
> case UniqueIdentifier :
>
> {
>
> if( !dbwillconvert( 36, SYBCHAR ) )
>
> break;
>
>
>
> BYTE* charData = new BYTE[ dataLength ];
>
> dbconvert( conn, 36, msData, dataLength, SYBCHAR,
> charData, ( DBINT ) -1 );
>
>
> AddValue( MyString( ( char *) charData ) );
>
>
>
> delete [] charData;
>
> }
>
> }
>
> }
>
> ........
>
> If I comment this pice of code the app works fine. In other case it
> crashes on processing large amount of data.
>
>
> On 22 January 2014 16:59, Velichko Yuriy <velichko.yuriy AT gmail.com> wrote:
>
>> Please accept my apologies for the silly question. I was confused the
>> lack of a macro for this data type in the documentation and I thought that
>> it is not supported.
>>
>> dbconvert - performs converting properly.
>>
>>
>> On 22 January 2014 16:24, Frediano Ziglio <freddy77 AT gmail.com> wrote:
>>
>>> Did you try dbconvert ??
>>>
>>> Frediano
>>>
>>> 2014/1/22 Velichko Yuriy <velichko.yuriy AT gmail.com>:
>>> > I found the SQL solution for this issue: CAST or CONVERT functions.
>>> > But question still valid - is there a way to convert data by the
>>> freetds
>>> > lib API?
>>> >
>>> >
>>> > On 22 January 2014 12:13, Velichko Yuriy <velichko.yuriy AT gmail.com>
>>> wrote:
>>> >
>>> >> Hello!
>>> >>
>>> >> Point me please how to proper fetch data from uniqueidentifier field.
>>> >> The function
>>> >>
>>> >> dbcoltype()
>>> >>
>>> >> returns 36 for this datatype. How I can convert the data of such type
>>> to
>>> >> the string representation?
>>> >>
>>> >> Here
>>> >>
>>> >> https://lists.ibiblio.org/sympa/arc/freetds/2009q3/024815.html
>>> >>
>>> >> I found the similar question but can't to find the answer.
>>> >>
>>> >> --
>>> >> Best Regards!
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> > Best Regards!
>>> > _______________________________________________
>>> > FreeTDS mailing list
>>> > FreeTDS AT lists.ibiblio.org
>>> > http://lists.ibiblio.org/mailman/listinfo/freetds
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS AT lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>
>>
>>
>> --
>> Best Regards!
>>
>
>
>
> --
> Best Regards!
>



--
Best Regards!




Archive powered by MHonArc 2.6.24.

Top of Page