Go to the source code of this file.
Classes | |
struct | TZASADECLTYPE |
class | TZASASQLDA |
Typedefs | |
typedef interface IZASASQLDA[' '] | AllocateSQLDA (Word NumVars) |
Functions | |
CheckASAError (IZASAPlainDriver PlainDriver, PZASASQLCA Handle, TZLoggingCategory LogCategory, string LogMessage= '') | |
Checks for possible sql errors. | |
TZSQLType | ConvertASAJDBCToSqlType (SmallInt FieldType) |
Converts an ODBC native types into ZDBC SQL types. | |
TZSQLType | ConvertASATypeToSQLType (SmallInt SQLType) |
Converts a ASA native type into ZDBC SQL types. | |
String | ConvertASATypeToString (SmallInt SQLType) |
Converts a ASA native type into String. | |
DescribeCursor (IZASAConnection FASAConnection, IZASASQLDA FSQLData, String Cursor, String SQL) | |
FreeSQLDA () | |
Extended | GetBigDecimal (const Integer Index) |
Boolean | GetBoolean (const Integer Index) |
ShortInt | GetByte (const Integer Index) |
TByteDynArray | GetBytes (const Integer Index) |
IZResultSet | GetCachedResultSet (string SQL, IZStatement Statement, IZResultSet NativeResultSet) |
Create CachedResultSet with using TZCachedResultSet and return it. | |
PASASQLDA | GetData () |
TDateTime | GetDate (const Integer Index) |
Double | GetDouble (const Integer Index) |
Integer | GetFieldCount () |
Word | GetFieldIndex (const String Name) |
Word | GetFieldLength (const Word Index) |
string | GetFieldName (const Word Index) |
integer | GetFieldScale (const Word Index) |
TZSQLType | GetFieldSqlType (const Word Index) |
Single | GetFloat (const Integer Index) |
Integer | GetInt (const Integer Index) |
Int64 | GetLong (const Integer Index) |
PChar | GetPChar (const Integer Index) |
SmallInt | GetShort (const Integer Index) |
string | GetString (const Integer Index) |
TDateTime | GetTime (const Integer Index) |
TDateTime | GetTimestamp (const Integer Index) |
Variant | GetValue (const Word Index) |
InitFields () | |
Boolean | IsAssigned (const Integer Index) |
boolean | IsBlob (const Word Index) |
Boolean | IsNull (const Integer Index) |
boolean | IsNullable (const Word Index) |
Prepare (IZASAConnection FASAConnection, IZASASQLDA FSQLData, IZASASQLDA FParamsSQLData, const String SQL, PSmallInt StmtNum, Boolean &FPrepared, Boolean &FMoreResults) | |
PrepareParameters (IZASAPlainDriver PlainDriver, TZVariantDynArray InParamValues, TZSQLTypeArray InParamTypes, Integer InParamCount, IZASASQLDA ParamSqlData) | |
string | RandomString (integer Len) |
Generate specific length random string and return it. | |
ReadBlobToMem (const Word Index, Pointer &Buffer, LongWord &Length) | |
ReadBlobToStream (const Word Index, TStream Stream) | |
ReadBlobToString (const Word Index, string &str) | |
ReadBlobToVariant (const Word Index, Variant &Value) | |
UpdateBigDecimal (const Integer Index, Extended Value) | |
UpdateBoolean (const Integer Index, boolean Value) | |
UpdateByte (const Integer Index, ShortInt Value) | |
UpdateBytes (const Integer Index, TByteDynArray Value) | |
UpdateDate (const Integer Index, TDateTime Value) | |
UpdateDouble (const Integer Index, Double Value) | |
UpdateFloat (const Integer Index, Single Value) | |
UpdateInt (const Integer Index, Integer Value) | |
UpdateLong (const Integer Index, Int64 Value) | |
UpdateNull (const Integer Index, boolean Value) | |
UpdatePChar (const Integer Index, PChar Value) | |
UpdateShort (const Integer Index, SmallInt Value) | |
UpdateString (const Integer Index, string Value) | |
UpdateTime (const Integer Index, TDateTime Value) | |
UpdateTimestamp (const Integer Index, TDateTime Value) | |
UpdateValue (const Word Index, Variant Value) | |
WriteBlob (const Integer Index, TStream Stream) | |
Variables | |
const | BlockSize = 20 |
const | MinBLOBSize = 256 |
const | StdVars = 20 |
typedef interface IZASASQLDA [' '] AllocateSQLDA(Word NumVars) |
Definition at line 88 of file ZDbcASAUtils.pas.
CheckASAError | ( | IZASAPlainDriver | PlainDriver, | |
PZASASQLCA | Handle, | |||
TZLoggingCategory | LogCategory, | |||
string | LogMessage = '' | |||
) |
Checks for possible sql errors.
PlainDriver | a MySQL plain driver. | |
Handle | a MySQL connection handle. | |
LogCategory | a logging category. | |
LogMessage | a logging message. |
Definition at line 2630 of file ZDbcASAUtils.pas.
TZSQLType ConvertASAJDBCToSqlType | ( | SmallInt | FieldType | ) |
Converts an ODBC native types into ZDBC SQL types.
FieldType | dblibc native field type. |
Definition at line 2572 of file ZDbcASAUtils.pas.
TZSQLType ConvertASATypeToSQLType | ( | SmallInt | SQLType | ) |
Converts a ASA native type into ZDBC SQL types.
Converts a ASA native types into ZDBC SQL types.
FieldHandle | a handler to field description structure. |
SQLType | Field of TASASQLVar structure. |
Definition at line 2452 of file ZDbcASAUtils.pas.
String ConvertASATypeToString | ( | SmallInt | SQLType | ) |
Converts a ASA native type into String.
SQLType | Field of TASASQLVar structure. |
Definition at line 2510 of file ZDbcASAUtils.pas.
DescribeCursor | ( | IZASAConnection | FASAConnection, | |
IZASASQLDA | FSQLData, | |||
String | Cursor, | |||
String | SQL | |||
) |
Definition at line 2688 of file ZDbcASAUtils.pas.
FreeSQLDA | ( | ) |
Extended GetBigDecimal | ( | const Integer | Index | ) |
Boolean GetBoolean | ( | const Integer | Index | ) |
ShortInt GetByte | ( | const Integer | Index | ) |
TByteDynArray GetBytes | ( | const Integer | Index | ) |
IZResultSet GetCachedResultSet | ( | string | SQL, | |
IZStatement | Statement, | |||
IZResultSet | NativeResultSet | |||
) |
Create CachedResultSet with using TZCachedResultSet and return it.
SQL | a sql query command | |
Statement | a zeos statement object | |
NativeResultSet | a native result set |
Definition at line 2663 of file ZDbcASAUtils.pas.
PASASQLDA GetData | ( | ) |
TDateTime GetDate | ( | const Integer | Index | ) |
Double GetDouble | ( | const Integer | Index | ) |
Integer GetFieldCount | ( | ) |
Word GetFieldIndex | ( | const String | Name | ) |
Word GetFieldLength | ( | const Word | Index | ) |
string GetFieldName | ( | const Word | Index | ) |
integer GetFieldScale | ( | const Word | Index | ) |
TZSQLType GetFieldSqlType | ( | const Word | Index | ) |
Single GetFloat | ( | const Integer | Index | ) |
Integer GetInt | ( | const Integer | Index | ) |
Int64 GetLong | ( | const Integer | Index | ) |
PChar GetPChar | ( | const Integer | Index | ) |
SmallInt GetShort | ( | const Integer | Index | ) |
string GetString | ( | const Integer | Index | ) |
TDateTime GetTime | ( | const Integer | Index | ) |
TDateTime GetTimestamp | ( | const Integer | Index | ) |
Variant GetValue | ( | const Word | Index | ) |
InitFields | ( | ) |
Boolean IsAssigned | ( | const Integer | Index | ) |
boolean IsBlob | ( | const Word | Index | ) |
Boolean IsNull | ( | const Integer | Index | ) |
boolean IsNullable | ( | const Word | Index | ) |
Prepare | ( | IZASAConnection | FASAConnection, | |
IZASASQLDA | FSQLData, | |||
IZASASQLDA | FParamsSQLData, | |||
const String | SQL, | |||
PSmallInt | StmtNum, | |||
Boolean & | FPrepared, | |||
Boolean & | FMoreResults | |||
) |
Definition at line 2712 of file ZDbcASAUtils.pas.
PrepareParameters | ( | IZASAPlainDriver | PlainDriver, | |
TZVariantDynArray | InParamValues, | |||
TZSQLTypeArray | InParamTypes, | |||
Integer | InParamCount, | |||
IZASASQLDA | ParamSqlData | |||
) |
Definition at line 2771 of file ZDbcASAUtils.pas.
string RandomString | ( | integer | Len | ) |
Generate specific length random string and return it.
Len | a length result string |
Definition at line 2862 of file ZDbcASAUtils.pas.
ReadBlobToMem | ( | const Word | Index, | |
Pointer & | Buffer, | |||
LongWord & | Length | |||
) |
ReadBlobToStream | ( | const Word | Index, | |
TStream | Stream | |||
) |
ReadBlobToString | ( | const Word | Index, | |
string & | str | |||
) |
ReadBlobToVariant | ( | const Word | Index, | |
Variant & | Value | |||
) |
UpdateBigDecimal | ( | const Integer | Index, | |
Extended | Value | |||
) |
UpdateBoolean | ( | const Integer | Index, | |
boolean | Value | |||
) |
UpdateByte | ( | const Integer | Index, | |
ShortInt | Value | |||
) |
UpdateBytes | ( | const Integer | Index, | |
TByteDynArray | Value | |||
) |
UpdateDate | ( | const Integer | Index, | |
TDateTime | Value | |||
) |
UpdateDouble | ( | const Integer | Index, | |
Double | Value | |||
) |
UpdateFloat | ( | const Integer | Index, | |
Single | Value | |||
) |
UpdateInt | ( | const Integer | Index, | |
Integer | Value | |||
) |
UpdateLong | ( | const Integer | Index, | |
Int64 | Value | |||
) |
UpdateNull | ( | const Integer | Index, | |
boolean | Value | |||
) |
UpdatePChar | ( | const Integer | Index, | |
PChar | Value | |||
) |
UpdateShort | ( | const Integer | Index, | |
SmallInt | Value | |||
) |
UpdateString | ( | const Integer | Index, | |
string | Value | |||
) |
UpdateTime | ( | const Integer | Index, | |
TDateTime | Value | |||
) |
UpdateTimestamp | ( | const Integer | Index, | |
TDateTime | Value | |||
) |
UpdateValue | ( | const Word | Index, | |
Variant | Value | |||
) |
WriteBlob | ( | const Integer | Index, | |
TStream | Stream | |||
) |
const BlockSize = 20 |
Definition at line 68 of file ZDbcASAUtils.pas.
const MinBLOBSize = 256 |
Definition at line 67 of file ZDbcASAUtils.pas.
const StdVars = 20 |
Definition at line 66 of file ZDbcASAUtils.pas.