Weird error when autoinc field has value of -1

If you set an autoinc field to -1, you can get some weird errors when you
run queries on the table. The error I'm getting is "Query execution failed:
Overflow while converting variant of type (LongWord) into type (Integer) [no
error code]". Should it even be possible to set an autoinc field to -1? It
happened when I imported some screwy data. I'm posting tables in binaries
for the following query:

SELECT *
FROM Customer
LEFT OUTER JOIN CustPhone ON ( Customer.CustomerID = CustPhone.CustomerID )
ORDER BY Customer.LastName DESC

--
Nathan Sutcliffe
nsutcliffe at speedlinesolutions period com

> If you set an autoinc field to -1, you can get some weird errors when

That's a bug, issue #744.

Btw, Autoinc is really a DWord type internally, so -1 is really $FFFFFFFF.
Its just the VCL that has no fieldtype that can display unsigned integers,
so values larger than maxint look negative.


--

Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com

> If you set an autoinc field to -1, you can get some weird errors when
>
> That's a bug, issue #744.

Is the bug the issue that the field can be set to -1, or is the bug the
issue that the SQL query fails ?


Terry.

>> If you set an autoinc field to -1, you can get some weird errors when
>>
>> That's a bug, issue #744.
>
> Is the bug the issue that the field can be set to -1, or is the bug
> the issue that the SQL query fails ?

The SQL query. "Autoinc is really a DWord type internally, so -1 is really
$FFFFFFFF"

field.AsInteger will show -1. Cast to DWord for the true internal value.

--

Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com

> If you set an autoinc field to -1, you can get some weird errors when
> you run queries on the table. The error I'm getting is "Query
> execution failed: Overflow while converting variant of type
> (LongWord) into type (Integer) [no error code]". Should it even be
> possible to set an autoinc field to -1? It happened when I imported
> some screwy data. I'm posting tables in binaries for the following
> query:

One caution about the fix: it will not work on Delphi 5! D5 doesnt support
LongWord in variants at all.

--

Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com