Sorry if this is in the wrong section but there really is no category that matches what i need to ask, I only posted here because it seems a lot of Delphi people use DBISAM.
Basically, I read the manual and see where I can read the current auto_inc value of a table using LASTAUTOINC('tablename') but for some reason its not working.
here is the SQL I am trying to run
INSERT INTO ChannelListings (ChannelNo, ChannelAccountNo, ProductNo, SKU, Price, IsUseCurrentRetailPrice, IsOnSale, IsActive, IsRemove, IsDelete, IsGiftwrapAvailable, IsGiftMessageAvailable, IsUseProductNoAsSKU, CategoryNo)
VALUES (4, 2, '080689000270', LASTAUTOINC('ChannelListings'), 1.6, True, False, True, False, False, False, False, False, 20)
But when i try to run it I get the error
Expecting NULL, FixedChar, GUID, String, Memo, or BLOB expression but instead found LASTAUTOINC in INSERT SQL statment
Yet right from the DBISAM manual they show
INSERT INTO orders (custno,empno) VALUES (LASTAUTOINC('customer'),200);
Hopefully someone has used DBISAM and seen this issue
Thanks Don