Subject | SQLDA Version/Structure |
---|---|
Author | Alan McDonald |
Post date | 2004-04-21T03:57:55Z |
Can someone confirm or deny/clarify..
What version of SQLDA is running on FB1.5 and what is the structure of the
VAR and DA record? I have the following but I have some problems getting an
update working with this structure and I want to know if it's the structure
or something else causing it. Thanks
Alan
XSQLVAR = record
sqltype: Smallint; {* datatype of field *}
sqlscale: Smallint; {* scale factor *}
sqlsubtype: Smallint; {* datatype subtype - BLOBs & Text
*}
{* types only *}
sqllen: Smallint; {* length of data area *}
sqldata: pointer; {* address of data *}
sqlind: ^Smallint; {* address of indicator variable
*}
sqlname_length: Smallint; {* length of sqlname field *}
sqlname: array [0..31] of Char; {* name of field, name length + *}
{* space for NULL *}
relname_length: Smallint; {* length of relation name *}
relname: array [0..31] of Char; {* field's relation name + space *}
{* for NULL *}
ownname_length: Smallint; {* length of owner name *}
ownname: array [0..31] of Char; {* relation's owner name + space *}
{* for NULL *}
aliasname_length: Smallint; {* length of alias name *}
aliasname: array [0..31] of Char; {* relation's alias name + space *}
{* for NULL *}
end;
PXSQLVAR = ^XSQLVAR;
XSQLDA = record
version: Smallint; {* version of this XSQLDA *}
sqldaid: array [0..7] of Char; {* XSQLDA name field *}
sqldabc: isc_long; {* length in bytes of SQLDA *}
sqln: Smallint; {* number of fields allocated *}
sqld: Smallint; {* actual number of fields *}
sqlvar: array [0..0] of XSQLVAR; {* first field address *}
end;
PXSQLDA = ^XSQLDA;
[Non-text portions of this message have been removed]
What version of SQLDA is running on FB1.5 and what is the structure of the
VAR and DA record? I have the following but I have some problems getting an
update working with this structure and I want to know if it's the structure
or something else causing it. Thanks
Alan
XSQLVAR = record
sqltype: Smallint; {* datatype of field *}
sqlscale: Smallint; {* scale factor *}
sqlsubtype: Smallint; {* datatype subtype - BLOBs & Text
*}
{* types only *}
sqllen: Smallint; {* length of data area *}
sqldata: pointer; {* address of data *}
sqlind: ^Smallint; {* address of indicator variable
*}
sqlname_length: Smallint; {* length of sqlname field *}
sqlname: array [0..31] of Char; {* name of field, name length + *}
{* space for NULL *}
relname_length: Smallint; {* length of relation name *}
relname: array [0..31] of Char; {* field's relation name + space *}
{* for NULL *}
ownname_length: Smallint; {* length of owner name *}
ownname: array [0..31] of Char; {* relation's owner name + space *}
{* for NULL *}
aliasname_length: Smallint; {* length of alias name *}
aliasname: array [0..31] of Char; {* relation's alias name + space *}
{* for NULL *}
end;
PXSQLVAR = ^XSQLVAR;
XSQLDA = record
version: Smallint; {* version of this XSQLDA *}
sqldaid: array [0..7] of Char; {* XSQLDA name field *}
sqldabc: isc_long; {* length in bytes of SQLDA *}
sqln: Smallint; {* number of fields allocated *}
sqld: Smallint; {* actual number of fields *}
sqlvar: array [0..0] of XSQLVAR; {* first field address *}
end;
PXSQLDA = ^XSQLDA;
[Non-text portions of this message have been removed]