All,
I've got an application that does not use bind variables. The code is written
in Microsoft Visual C++. I have no background with C++ and need some help in
telling the developers how to use bind variables in their code (they don't
know and aren't sure how to find out). I pulled the following examples out of
the code for different ways they execute SQL. If anyone can assist with
specific examples on how to rewrite this to use bind variables, it would be
immensely helpful.
Thanks,
Karen Morton
Samples
---------------------------------------
Mystring.Format("SELECT AVA_SERIAL FROM avamas \
WHERE ava_tabname = 'sys_node' \
AND ava_nodeid = %-d \
AND ava_wkday = %-d \
AND ava_sdate = %s \
AND ava_stime = '%-s'",
cAvalObject->cItemSerial, m_weekday, ConvertDateToODBCStr (pDatabase,
m_sdatetime), m_schartime);
rSpanRecord.Open (CRecordset::forwardOnly, cSpanSelect);
if (rSpanRecord.IsEOF () == 0)
{ rSpanRecord.GetFieldValue ("AVA_SERIAL", vCDBVariant);
m_serial = atol (ObjectConvert (&vCDBVariant));
vCDBVariant.Clear ();
}
rSpanRecord.Close ();
----------------------------------------------------
CSysNumSet SysnumSet(pDatabase);
SysnumSet.m_TableParam = strFile;
SysnumSet.m_strFilter = "myid = 1234 and yourmom = 'NICE'"
SysnumSet.Open();
if (SysnumSet.IsOpen())
lNewSysNo = SysnumSet.m_file_identity;
else
lNewSysNo = 0;
----------------------------------------------------
strSQL.Format("UPDATE sys_file WITH (ROWLOCK) SET file_identity =
file_identity + 1 WHERE file_table = '%s' ", strFile);
pDatabase->ExecuteSQL(strSQL);
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Karen Morton
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
