Database

<br />
SELECT Key, Value FROM MyTable WHERE Value Like 'RED*'<br />
UNION SELECT Key, Value FROM MySecondTable WHERE Value Like 'RED*';<br />

<br />
CHelperRecordset::CHelperRecordset(CDatabase* pdb)<br />
: CRecordset(pdb)<br />
{<br />
  //{{AFX_FIELD_INIT(CHelperRecordset)<br />
  m_lFetchedCount = 0;<br />
  m_nFields = 1;<br />
  //}}AFX_FIELD_INIT<br />
  m_nDefaultType = forwardOnly;<br />
}<br />
<br />
void CHelperRecordset::DoFieldExchange(CFieldExchange* pFX)<br />
{<br />
  //{{AFX_FIELD_MAP(CHelperRecordset)<br />
  pFX->SetFieldType(CFieldExchange::outputColumn);<br />
  RFX_Long(pFX, _T("ZAEHLER"), m_lFetchedCount);<br />
  //}}AFX_FIELD_MAP<br />
}<br />
<br />
long CHelperRecordset::GetCount(const CString& strTableName, const CString& strIndexName) <br />
{<br />
  CString strSQL = _T("");<br />
  strSQL.Format("Select Count(%s) As ZAEHLER From %s", strIndexName,  strTableName);<br />
  Open(CRecordset::forwardOnly, strSQL);<br />
  Close();<br />
  return m_lFetchedCount;<br />
}<br />

<br />
SELECT Key, Value FROM MyTable WHERE Value='RED'<br />
UNION SELECT Key, Value FROM MySecondTable WHERE Value='RED';<br />

<br />
SELECT Key, Value FROM MyTable WHERE Value Like 'RED*';<br />

public __gc class NewSQLParameterCollection: public ArrayList, public IDataParameterCollection{};<br />

bool Contains(String *p)<br />
{<br />
//if IndexOf returns a value less than 0, then we know that<br />
//the item doesn't exist<br />
if (this->IndexOf(p) >= 0)<br />
return true;<br />
else<br />
return false;<br />
}<br />

function test::sometest()<br />
{<br />
NewSQLParameterCollection *p = new NewSQLParameterCollection(S"Name", Object);<br />
}<br />

DECLARE @dates TABLE([date] smalldatetime)
INSERT INTO @dates
SELECT [date] FROM dbo.dates_with_complete_data(@start_date, @end_date)

SELECT calc.*
FROM @dates as fd
INNER JOIN (dbo.calculation(fd.[date])) as calc
ON cc.[date] = fd.[date]

EuroCPian Spring 2004 Get Together[^]
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

1. A row, let's call it <code>R</code>, is updated using SQL an not the updateXXX API.
2. <code>R</code> is fetched into a resultset and a <code>long</code> value, L, is retrieved.
3. <code>L</code> is incremented and <code>R</code> gets updated, again using simple SQL.