Thanks Andrew and everyone.

I'll see what I can get with it.

Thanks for your attention,

Bruno

On 6/28/07, Andrew Finkenstadt <[EMAIL PROTECTED]> wrote:
On 6/28/07, Bruno S. Oliveira <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> Now I see the what's happening.
> But what if I need to create a table with two primary keys and one
> auto incremented (and I DO need that!)? Isn't this possible?
>

If by primary key you mean alternate (unique) key, then yes.


create table andy_loves_sqlite (
  pk integer not null primary key autoincrement,
  ak integer not null unique
);



--
/**
* Bruno Silva de Oliveira
* Bacharel em Ciência da Computação
* Mestrando em Inteligência Computacional
* http://www.inf.ufpr.br/brunoso/
*
* http://www.last.fm/user/bsoliveira/
*/

Reply via email to