SQL Mobile Bitmap Bug or Me?
- From: richard@xxxxxxxxxxxxxxxxxx
- Date: 19 May 2006 06:57:52 -0700
Hi I've just upgraded and app from SQL CE 2.0 to SQL Mobile.
All was going well, (or so I thought)
If I run the following bit of SQL into a SqlCeDataReader
SELECT
ImageBlob < image field type
FROM
MOB_PromoImages
When I run the following code.
SqlCeDataReader result_set = <snip run our sql>
if (result_set != null)
{
if (result_set.Read())
{
MemoryStream msimageblob = new
MemoryStream(result_set.GetSqlBinary(0).Value);
imageblob = new Bitmap(msimageblob);
msimageblob.Close();
}
}
I throw the following exception.
{"Internal error: The column ordinal cannot be found. [ Table name (if
known) = {051D69CE-48DE-4DB8-EF7D-2FC9BFE4E7F2} ]"}
System.Exception
{System.Data.SqlServerCe.SqlCeException}
I can run the same query using SQL Analysiser on the device and it does
look like it is returning data.
Similarly from code, I can type string colname=result_set.GetName(0);
which works fine.
+ I have just found that ExecuteScalar works.....
Is this a bug, or me?
.
- Prev by Date: I Need a count(distinct <myColumn>) from ...
- Next by Date: SQL problem with Backup Exec
- Previous by thread: I Need a count(distinct <myColumn>) from ...
- Next by thread: SQL problem with Backup Exec
- Index(es):
Relevant Pages
|
