[ic] 4.6.1 Auto_number - auto_increment

Mike Heins mikeh@minivend.com
Thu, 14 Dec 2000 07:17:19 -0500


Quoting Ton Verhagen (ton@verhagen.net):
> Dear Mike and Akopia staff,
> 
> There was a thread on auto_increment mid August 2000.
> 
> Racke supplied a patch for IC4.5.5 that handled the insertion of new 
> records in a table with an auto_increment field (MySQL).
> 
> Do you have any plans to incorporate auto_increment functionality in the IC 
> admin interface?
> 
> I strongly feel that customers should not need to figure out a key value 
> for themselves. Reason why I, and probably many others, use auto_increment 
> fields extensively. Unfortunately the current release 4.6.1 doesn't support 
> it (properly). Adding this feature to IC would make it even more powerful. 
> I really look forward to IC supporting this feature.

There is strong autonumbering support in 4.7.x. Either you can use the
SQL method your database prefers (by using a stored procedure and trigger
or a special field type), or you can make it database-independent and
use the supplied File::CounterFile counter that can be configured into
any IC database when opened in write mode.

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

I have a cop friend who thinks he ought be able to give a new ticket;
"too dumb for conditions".