Is there a way to find the autonum number or the last autonum number
used. I tried :
SELECT PartRef +
INTO test IND v1 +
FROM Invent +
WHERE COUNT = LAST
But this gives me the last record inserted, even if it was a updated
record, that had to insert because the notes field added more than the
record pad allowed.
SET VAR Test TEXT = NULL
GETPROPERTY TABLE 'Invent->RECORDCOUNT' Test
--From the R>Prompt gives me
On XP x86 gives -- NULL
On Windows 7 x64 -- Access violation at address 004047A8 in module
'rbg8ee.exe'. Read of address 53552039
SELECT MAX(PartRef) +
INTO test IND v1 +
FROM Invent
This seems slow
SET ERROR MESSAGE 2441 OFF
SELECT PartRef +
INTO test IND v1 +
FROM Invent +
ORDER BY PartRef +
SET ERROR MESSAGE 2441 ON
I figured if I could get the autonum number it might be faster yet,
without errors.
Thanks
Jack Mathis <mailto:ja...@ericksonaircrane>
Erickson Air-Crane Incorporated
Computer Software Applications Programmer
