Member Avatar for =OTS=G-Man
=OTS=G-Man 26 Light Poster

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

  • 1 Contributor
  • 0 Replies
  • 115 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.