Dear developers,
I am currently working with the InterBase Python library (latest version downloaded from Git) for database connectivity, a and I am encountering an issue with specific queries where I request boolean fields in the SELECT statements. When attempting to retrieve a boolean field using the following queries:
example "#SELECT id,<boolean_field> FROM <table_with field_id,<boolean_field>"
or simply "SELECT TRUE FROM "
I consistently receive the following error: "-804: Incorrect values within SQLDA structure."
I have already ensured that the connection to the database is established successfully.
When executing this query using ISQL and IBExpert, I do not encounter any problems, and the results are as expected.
Thank you for your time.
Best regards,
Daniele
Dear developers,
I am currently working with the InterBase Python library (latest version downloaded from Git) for database connectivity, a and I am encountering an issue with specific queries where I request boolean fields in the SELECT statements. When attempting to retrieve a boolean field using the following queries:
example "#SELECT id,<boolean_field> FROM <table_with field_id,<boolean_field>"
or simply "SELECT TRUE FROM "
I consistently receive the following error: "-804: Incorrect values within SQLDA structure."
I have already ensured that the connection to the database is established successfully.
When executing this query using ISQL and IBExpert, I do not encounter any problems, and the results are as expected.
Thank you for your time.
Best regards,
Daniele