private int InternalInitFieldDefs()
{
if (queryID <= 0)
{
return(0);
}
lock (syncRoot)
{
recordCount = VistaDBAPI.ivsql_RecCount(queryID);
columnCount = VistaDBAPI.ivsql_ColumnCount(queryID);
columns = new VistaDBColumn[columnCount];
char colType;
int len;
int columnCaptionWidth = 128;
StringBuilder columnCaption = new StringBuilder(columnCaptionWidth);
int columnNameWidth = 128;
StringBuilder columnName = new StringBuilder(columnNameWidth);
VistaDBType columntype;
bool allowNull, readOnly, autoIncrement, primaryKey, unique, reservedWord;
int dataSize, columnWidth;
string tempS;
for (int i = 0; i < columnCount; i++)
{
len = VistaDBAPI.ivsql_ColumnName(queryID, i + 1, columnName, columnNameWidth);
columnName.Length = len;
len = VistaDBAPI.ivsql_ColumnCaption(queryID, i + 1, columnCaption, columnCaptionWidth);
columnCaption.Length = len;
colType = VistaDBAPI.ivsql_ColumnType(queryID, i + 1);
tempS = colType.ToString();
columntype = VistaDBAPI.NetDataType(tempS);
dataSize = 0; // default
columnWidth = 0; // default
allowNull = !VistaDBAPI.ivsql_ColumnRequired(queryID, i + 1);
readOnly = VistaDBAPI.ivsql_ColumnReadOnly(queryID, i + 1);
autoIncrement = VistaDBAPI.ivsql_ColumnIsIdentity(queryID, i + 1);
primaryKey = VistaDBAPI.ivsql_ColumnIsPrimaryKey(queryID, i + 1);
unique = VistaDBAPI.ivsql_ColumnIsUnique(queryID, i + 1);
reservedWord = VistaDBAPI.ivsql_IsReservedWord(columnName.ToString());
switch (columntype)
{
case VistaDBType.Character:
columnWidth = VistaDBAPI.ivsql_ColumnWidth(queryID, i + 1);
dataSize = columnWidth;
break;
case VistaDBType.Varchar:
columnWidth = VistaDBAPI.ivsql_ColumnWidth(queryID, i + 1);
dataSize = columnWidth;
break;
case VistaDBType.Date:
dataSize = 8;
break;
case VistaDBType.DateTime:
dataSize = 8;
break;
case VistaDBType.Boolean:
dataSize = 2;
break;
case VistaDBType.Int32:
dataSize = 4;
break;
case VistaDBType.Int64:
dataSize = 8;
break;
case VistaDBType.Currency:
dataSize = 8;
break;
case VistaDBType.Double:
dataSize = 8;
break;
case VistaDBType.Memo:
case VistaDBType.Blob:
case VistaDBType.Picture:
dataSize = 2147483647;
break;
case VistaDBType.Guid:
dataSize = 16;
break;
}
columns[i] = new VistaDBColumn(columnName.ToString(), columntype, dataSize, (short)columnWidth, 0, allowNull, readOnly, primaryKey, unique, autoIncrement, 0, "", columnCaption.ToString(), "", reservedWord, false, false, false, false);
}
}
return(errorNumber);
}
private int InternalInitFieldDefs()
{
if( queryID <= 0 )
return 0;
lock(syncRoot)
{
recordCount = VistaDBAPI.ivsql_RecCount(queryID);
columnCount = VistaDBAPI.ivsql_ColumnCount(queryID);
columns = new VistaDBColumn[columnCount];
char colType;
int len;
int columnCaptionWidth = 128;
StringBuilder columnCaption = new StringBuilder(columnCaptionWidth);
int columnNameWidth = 128;
StringBuilder columnName = new StringBuilder(columnNameWidth);
VistaDBType columntype;
bool allowNull, readOnly, autoIncrement, primaryKey, unique, reservedWord;
int dataSize, columnWidth;
string tempS;
for(int i = 0; i<columnCount; i++)
{
len = VistaDBAPI.ivsql_ColumnName(queryID, i + 1, columnName, columnNameWidth );
columnName.Length = len;
len = VistaDBAPI.ivsql_ColumnCaption(queryID, i+1, columnCaption, columnCaptionWidth);
columnCaption.Length = len;
colType = VistaDBAPI.ivsql_ColumnType(queryID, i + 1);
tempS = colType.ToString();
columntype = VistaDBAPI.NetDataType( tempS );
dataSize = 0; // default
columnWidth = 0; // default
allowNull = !VistaDBAPI.ivsql_ColumnRequired(queryID, i+1);
readOnly = VistaDBAPI.ivsql_ColumnReadOnly(queryID, i+1);
autoIncrement = VistaDBAPI.ivsql_ColumnIsIdentity(queryID, i+1);
primaryKey = VistaDBAPI.ivsql_ColumnIsPrimaryKey(queryID, i+1);
unique = VistaDBAPI.ivsql_ColumnIsUnique(queryID, i+1);
reservedWord = VistaDBAPI.ivsql_IsReservedWord(columnName.ToString());
switch(columntype)
{
case VistaDBType.Character:
columnWidth = VistaDBAPI.ivsql_ColumnWidth(queryID, i + 1);
dataSize = columnWidth;
break;
case VistaDBType.Varchar:
columnWidth = VistaDBAPI.ivsql_ColumnWidth(queryID, i + 1);
dataSize = columnWidth;
break;
case VistaDBType.Date:
dataSize = 8;
break;
case VistaDBType.DateTime:
dataSize = 8;
break;
case VistaDBType.Boolean:
dataSize = 2;
break;
case VistaDBType.Int32:
dataSize = 4;
break;
case VistaDBType.Int64:
dataSize = 8;
break;
case VistaDBType.Currency:
dataSize = 8;
break;
case VistaDBType.Double:
dataSize = 8;
break;
case VistaDBType.Memo:
case VistaDBType.Blob:
case VistaDBType.Picture:
dataSize = 2147483647;
break;
case VistaDBType.Guid:
dataSize = 16;
break;
}
columns[i] = new VistaDBColumn( columnName.ToString(), columntype, dataSize, (short)columnWidth, 0, allowNull, readOnly, primaryKey, unique, autoIncrement, 0, "", columnCaption.ToString(), "", reservedWord, false, false, false, false);
}
}
return errorNumber;
}
