Re: ResultField.Type=-2

[T Lee Davidson <t.lee.davidson@xxxxxxxxx>]

On 3/19/25 4:12 AM, BB wrote:
> Thanks Ian, but it really doesn't answer my question.
>
> On 19/3/25 2:50 pm, Ian Roper wrote:
> > *Case -2 ' not in the Gambas standard types*
>
> That's the reason I asked.
>
> b

I am assuming that Ian is correct that a ResultField.Type of -2 signifies a serial field type.

A serial datatype is an auto-incrementing type.

From https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html :
"SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE."

From DuckDuckGo's Assist for the query, "sqlite serial type":
"SQLite does not have a specific 'serial' type like some other databases. Instead, it uses the INTEGER PRIMARY KEY type, which 
automatically increments and serves a similar purpose for unique identifiers."
And as far as I can tell, that statement is largely accurate.


--
Lee

--- Gambas User List Netiquette [https://gambaswiki.org/wiki/doc/netiquette] ----
--- Gambas User List Archive [https://lists.gambas-basic.org/archive/user] ----