Bsbosa.com
07-09-2010, 01:20 PM
Greetings,
Before I start tearing my hair out I wondered if anyone might be able to help.
Thus far I have no problem in using OLEDB with SQL Compact via an accessor BUT I simply cannot find out what native data type to map a 'bit' value to.
At present I have the following which compiles fine.
class CDBMain
{
public:
// Data Elements
BOOL f_HubDel;
...
// Column binding map
BEGIN_COLUMN_MAP(CDBMain)
COLUMN_ENTRY(1, f_HubDel)
...
However at runtime I have binding errors like this.
Binding entry 0 failed. Status: 2
Now I am about to rework the SQL DB schema to use a CHAR[1] but if anyone can tell me what I am doing wrong then you will save me a lot of work.
Many thanks
Alan
Before I start tearing my hair out I wondered if anyone might be able to help.
Thus far I have no problem in using OLEDB with SQL Compact via an accessor BUT I simply cannot find out what native data type to map a 'bit' value to.
At present I have the following which compiles fine.
class CDBMain
{
public:
// Data Elements
BOOL f_HubDel;
...
// Column binding map
BEGIN_COLUMN_MAP(CDBMain)
COLUMN_ENTRY(1, f_HubDel)
...
However at runtime I have binding errors like this.
Binding entry 0 failed. Status: 2
Now I am about to rework the SQL DB schema to use a CHAR[1] but if anyone can tell me what I am doing wrong then you will save me a lot of work.
Many thanks
Alan