Re: Strange column properties in the Employees table of NorthWind

Sorry. Dunno.
Try asking the MSDN forum... there are a lot of smart people over there.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Alex" <Alex@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C21A606D-F39A-4365-A8D9-4816B008DA05@xxxxxxxxxxxxxxxx
Hi Bill,

This can NOT be the case, the data has in it picture of Thumbnail size,
sever KB at most, and the fact is that when I step through it in a debug
session, it spits the dummy when it gets to this column...

This number looks like 1GB in size... unlikely in a Mobile application...
if
you do 1024 x 1024 x 1024 - 1, you get this number, so why would that be
the
case here?

Any other idea?

Cheers
Alex

"William (Bill) Vaughn" wrote:

I expect it's the size of the BLOB.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Alex" <Alex@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E96F3B95-33EC-4F21-890D-323112EFE460@xxxxxxxxxxxxxxxx
Using C++ / Ole DB under Windows Mobile 5

Using the "Server Explorer" inside the IDE within VS 2005, I am looking
at
the Column Properties of the "Photo" column, it says it is Data
Type=Image
and the size=16 which seems all OK.

BUT - when I look at the "Properties" of that same column it shows
Length=1073741823. I am not clear on what is this number?

Also, when I am attempting to Open the rowset with a SELECT *
statement,
it
fails on this column. I I am excluding this column from my open
statement,
it
all works fine.

Any help will be appreciated

Thanks
Alex






.

Relevant Pages
Loading