|Subject||Re: [firebird-support] creating next record|
At 07:58 AM 10/05/2006, you wrote:
> I have a single picture in a blob. I can read and write theDon't even think of doing that. Use a generator.
> I created the table with this command.
>CREATE TABLE PATIENT (PATIENT_IMAGE BLOB SUB_TYPE 0 SEGMENT SIZE
>80,PATIENT_ID INTEGER NOT NULL)")
> I filled the record the blob with the command
>insert into PATIENT (PATIENT_ID,PATIENT_IMAGE) values ('1001',?)",
> I am now looking for the command that will allow me to create a
>new PATIENT_ID with the number of 1002. (one number larger than the
>last PATIENT_ID #.)
> is there a way to retrive the last record created value?
>I also know that there is a special command that will assign a numberSee
>to a record and will never allow that record number to be reused.