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:28:44 +0200

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!




Archive powered by MHonArc 2.6.24.

Top of Page