Database

Select * 
From Table1 T
 Left Join Table2 T2 on T.Name = T2.Name
Where T2.Name is NULL

anthasaurus wrote:

Is this possible?

I are Troll

Spawn@Melmac wrote:

could this be integrated into the ACCESSOR class mechanism I am using at present?

Spawn@Melmac wrote:

So when I came across the @@IDENTITY I thought I was sorted

using (var con = new SqlCeConnection(connectionString))
using (var cmd = new SqlCeCommand())
{
  con.Open();
  cmd.Connection = con;
  cmd.CommandText = "INSERT ...";
  cmd.ExecuteNonQuery();

  // execute a second command;
  cmd.Parameters.Clear();
  cmd.CommandText = "SELECT @@IDENTITY";
  object recordId = cmd.ExecuteScalar();
}

I are Troll

class CDBHubDetails
{
public:
// Data Elements
	TCHAR	f_LocSub[255];
	int		f_HubID;						// Input field

// Column binding map
BEGIN_COLUMN_MAP(CDBHubDetails)
   COLUMN_ENTRY(1, f_LocSub)
END_COLUMN_MAP()

// Parameter binding map
BEGIN_PARAM_MAP(CDBHubDetails)
   SET_PARAM_TYPE(DBPARAMIO_INPUT)
   COLUMN_ENTRY(1, f_HubID)
END_PARAM_MAP()

DEFINE_COMMAND_EX(CDBHubDetails, L" \
     SELECT  Hub.SubLoc \
     FROM    Location  \
     WHERE   Hub.id = ?")
};

CCommand<CAccessor<CDBHubDetails > > rs;

rs.f_HubID = pHub->m_iHubID;                                                 // pull the HubID from the CDevice object
hr = rs.Open(m_oDB->session);