Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Sqlite3Schema AUTO_INCREMENT
Sqlite3Schema AUTO_INCREMENT [message #61408] Fri, 24 January 2025 02:20 Go to next message
superdev is currently offline  superdev
Messages: 31
Registered: August 2022
Member
Why AUTO_INCREMENT macro is empty and not "INLINE_ATTRIBUTE("autoincrement")"?


Win7x64, upp-win-17799
Re: Sqlite3Schema AUTO_INCREMENT [message #61652 is a reply to message #61408] Fri, 18 April 2025 14:22 Go to previous message
mirek is currently offline  mirek
Messages: 14255
Registered: November 2005
Ultimate Member
superdev wrote on Fri, 24 January 2025 02:20
Why AUTO_INCREMENT macro is empty and not "INLINE_ATTRIBUTE("autoincrement")"?


If I remember well, it is because Sqlite does it by default

https://sqlite.org/autoinc.html

Is defined (as empty) mostly to make .sch compatible between SQL dialects (e.g. Mysql .sch with AUTO_INCREMENT will likely work with Sqlite3 as well).

[Updated on: Fri, 18 April 2025 14:23]

Report message to a moderator

Previous Topic: Help with Optimizing Large Dataset Processing in Ultimate++
Goto Forum:
  


Current Time: Fri Apr 25 07:57:22 CEST 2025

Total time taken to generate the page: 0.00622 seconds