$NO: Frontbase and Primary Key generation

[David Walton]

Thanks George,

Yes, I saw that already - I don't remember having to do this for every table, but maybe I did.

David

On Dec 11, 2014, at 12:31 PM, George Ziemann wrote:

> 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
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com