Thread: Re: New ID

Re: New ID

From
"Josh Berkus"
Date:
Brian,

> Anyway, I found out with pgaccess that my sequence id that increments
>  the
> record id is called phpgw_notes_note_id_seq so my SQL statement was
> SELECT CURRVAL( "phpgw_notes_note_id_seq" )
>
> and the error I got was
> failed : Attribute 'phpgw_notes_note_id_seq' not found
>
> Any ideas?

SINGLE quotes, Brian.  Not double quotes.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco