public static extern ODBCResult SQLBindCol(
ODBCHStatement StatementHandle,
short ColumnNumber,
ODBCDataType TargetType,
StringBuilder TargetValue,
int BufferLength,
out int StrLen_or_ind);
public IndexStatementDefinition()
{
Indexes = new short[] { 4, 6, 8, 9, 10 };
Types = new ODBCDataType[] { ODBCDataType.Integer, ODBCDataType.Char, ODBCDataType.Integer, ODBCDataType.Char, ODBCDataType.Char };
Lengths = new int[] { 4, 80, 4, 80, 4 };
Names = new string[] { "isUnique", "indexName", "orderNumber", "ColumnName", "sortOrder" };
}
public int ColumnIndex; //индекс колонки в сокращенном локальном наборе
public ODBCData(short columnNumber, ODBCDataType columnType, int columnDataLength)
{
ColumnNumber = columnNumber;
ColumnType = columnType;
ColumnDataLength = columnDataLength;
ColumnData = Marshal.AllocHGlobal(ColumnDataLength);
ColumnStringData = new StringBuilder(ColumnDataLength);
InternalData = new BufferData();
}
internal static bool SQLBindColumn(ODBCHStatement statementHandle, short ColumnNumber, ODBCDataType TargetType, StringBuilder TargetValue, int BufferLength, out int StrLen_or_ind)
{
var result = ODBCNativeMethods.SQLBindCol(statementHandle, ColumnNumber, TargetType, TargetValue, BufferLength, out StrLen_or_ind);
if ((result != ODBCResult.Success) & (result != ODBCResult.SuccessWithInfo))
{
throw GetException(statementHandle, "Error binding columns");
}
return(true);
}
public ForeignKeysStatementDefinition()
{
Indexes = new short[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 };
Types = new ODBCDataType[] { ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Integer, ODBCDataType.Integer, ODBCDataType.Integer, ODBCDataType.Char, ODBCDataType.Char };
Lengths = new int[] { 50, 50, 50, 50, 50, 50, 50, 50, 4, 4, 4, 50, 50 };
}
public PrimaryKeyStatementDefinition()
{
Indexes = new short[] { 4, 5 };
Types = new ODBCDataType[] { ODBCDataType.Char, ODBCDataType.Integer };
Lengths = new int[] { 80, 4 };
}
public TablesStatementDefinition()
{
Indexes = new short[] { 2, 3, 4 };
Types = new ODBCDataType[] { ODBCDataType.Char, ODBCDataType.Char, ODBCDataType.Char };
Lengths = new int[] { 80, 80, 80 };
}
public ColumnsStatementDefinition()
{
Indexes = new short[] { 4, 5, 7, 9, 18, 11 };
Types = new ODBCDataType[] { ODBCDataType.Char, ODBCDataType.Integer, ODBCDataType.Integer, ODBCDataType.Integer, ODBCDataType.Char, ODBCDataType.Integer };
Lengths = new int[] { 150, 4, 4, 4, 150, 4 };
}
