[Gambas-bugtracker] Bug #1677: Read the complete error info that return the database engine

bugtracker at gambaswiki.org bugtracker at gambaswiki.org
Thu Nov 7 09:44:17 CET 2019


http://gambaswiki.org/bugtracker/edit?object=BUG.1677&from=L21haW4-

Martín BELMONTE reported a new bug.

Summary
-------

Read the complete error info that return the database engine

Type             : Bug
Priority         : Low
Gambas version   : 3.13
Product          : Bugtracker


Description
-----------

Hi,
when I try to read the error that occurs in an sql statement (with sqlite3) in Gambas I only get the first line of error but not the rest.
SQL statement:
BEGIN TRANSACTION;
DROP TABLE IF EXISTS `tabla`;
CREATE TABLE IF NOT EXISTS `tabla` (
        `id`    INTEGER PRIMARY KEY AUTOINCREMENT,
        `name`  TEXT UNIQUE,
        `desc`  TEXT,
);
COMMIT;

> Error text in Gambas (using  Print Error.Text)
Query failed: near ")": syntax error

> Error text in DB Browser
Resultado: near ")": syntax error
En la línea 12:
CREATE TABLE IF NOT EXISTS `tabla` (
    `id`    INTEGER PRIMARY KEY AUTOINCREMENT,
    `name`    TEXT UNIQUE,
    `desc`    TEXT,
)
So is it possible to get the full text?
Tanks.


System information
------------------

.




More information about the Bugtracker mailing list