/// create an odbc parameter for the given column
public static OdbcParameter CreateOdbcParameter(short ATableNumber, TSearchCriteria ASearchCriteria)
{
TTypedColumnInfo columnInfo = GetColumn(ATableNumber, ASearchCriteria.fieldname);
if (columnInfo.odbctype == OdbcType.VarChar)
{
return(new System.Data.Odbc.OdbcParameter("", columnInfo.odbctype, columnInfo.length));
}
return(new System.Data.Odbc.OdbcParameter("", columnInfo.odbctype));
}
/// create an odbc parameter for the given column
public static OdbcParameter CreateOdbcParameter(short ATableNumber, Int32 AColumnNr)
{
TTypedColumnInfo columnInfo = TableInfo[ATableNumber].columns[AColumnNr];
if ((columnInfo.odbctype == OdbcType.VarChar) ||
(columnInfo.odbctype == OdbcType.Text))
{
return(new System.Data.Odbc.OdbcParameter("", columnInfo.odbctype, columnInfo.length));
}
return(new System.Data.Odbc.OdbcParameter("", columnInfo.odbctype));
}
/// constructor
public TTypedTableInfo(short AId,
string AName,
string ADBName,
TTypedColumnInfo[] AColumns,
int[] APrimaryKeyColumns,
int[] AUniqueKeyColumns)
{
id = AId;
name = AName;
dbname = ADBName;
columns = AColumns;
PrimaryKeyColumns = APrimaryKeyColumns;
UniqueKeyColumns = AUniqueKeyColumns;
}
/// constructor
public TTypedTableInfo(short AId, string AName, string ADBName, TTypedColumnInfo[] AColumns, int[] APrimaryKeyColumns)
: this(AId, AName, ADBName, AColumns, APrimaryKeyColumns, new int[]
{
})
{
id = AId;
name = AName;
dbname = ADBName;
columns = AColumns;
PrimaryKeyColumns = APrimaryKeyColumns;
}