$NO: Frontbase and Primary Key generation

George Ziemann gzieman54 at gmail.com
Thu Dec 11 12:31:52 EST 2014


I don't use front base, but maybe this will help (from
http://www.frontbase.com/docs/6.5.html):

   SELECT UNIQUE FROM <table name>;

Returns a value that can be used as a primary key (of type INT) for the
given table.

   SET UNIQUE FOR <table name> (<primary key column>);

Sets the value that will be returned by the next SELECT UNIQUE... The value
is calculated as SELECT MAX(<primary key column>) FROM <table name>;

   SET UNIQUE = <unsigned number> FOR <table name>;

Sets the value that will be returned by the next SELECT UNIQUE...



On Thu, Dec 11, 2014 at 10:23 AM, David Walton <omuser at roundog.com> wrote:
>
> Hi $list,
>
> Long time... Wondering if anyone remembers how to set primary keys to
> start at a number like 1 (rather than the default million) in frontbase. I
> remember getting this done with one command... just not remembering what it
> was.
>
> Thanks!
>
> David_____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>


-- 
George Ziemann
(480) 278-9746



More information about the omnisdev-en mailing list