public String getSqlParameters()
{
String s = "";
cParameter param = null;
for (int _i = 0; _i < m_parameters.count(); _i++)
{
param = m_parameters.item(_i);
switch (param.getColumnType())
{
case csDataType.CSTDWCHAR:
/*
* case csDataType.CSTDVARWCHAR:
* case csDataType.CSTDVARCHAR:
* case csDataType.CSTDLONGVARWCHAR:
* case csDataType.CSTDLONGVARCHAR:
* case csDataType.CSTDCHAR:
*/
s += cDataBase.sqlString(param.getValue()) + ",";
break;
case csDataType.CSTDTINYINT:
case csDataType.CSTDUNSIGNEDTINYINT:
case csDataType.CSTDSMALLINT:
case csDataType.CSTDSINGLE:
case csDataType.CSTDNUMERIC:
case csDataType.CSTDINTEGER:
case csDataType.CSTDDOUBLE:
/*
* case csDataType.CSTDDECIMAL:
* case csDataType.CSTDCURRENCY:
*/
case csDataType.CSTDBOOLEAN:
case csDataType.CSTDBIGINT:
s += cDataBase.sqlNumber(param.getValue()) + ",";
break;
case csDataType.CSTDDBTIMESTAMP:
/*
* case csDataType.CSTDDBTIME:
* case csDataType.CSTDDBDATE:
* case csDataType.CSTDDATE:
*/
s += cDataBase.sqlDate(param.getValue()) + ",";
break;
default:
cWindow.msgWarning("This data type is not codified "
+ param.getColumnType()
+ ". Parameter: " + param.getName()
+ ". Function: sqlParameters.");
break;
}
}
if (s.Length > 0 && s.Substring(s.Length - 1) == ",")
{
s = s.Substring(0, s.Length - 1);
}
return(s);
}
