Subject Re: [firebird-support] Generator
Author Abhishek Sharma
Dear Alan
 
I am having an occational error in my fdb while executing sql saying 'gds internal error Software consistency check',
1. What does this error mean and why does it happens occassionaly
2. Is there any way we can correct the FDB so that this error does not occur in future
 
Waiting for your reply
 
Thanking you
 
Abhishek Sharma
Topsys Solutions
Bangalore
+919741007981

--- On Sat, 18/10/08, Kurt Federspiel <federonline@...> wrote:

From: Kurt Federspiel <federonline@...>
Subject: Re: [firebird-support] Generator
To: firebird-support@yahoogroups.com
Date: Saturday, 18 October, 2008, 1:08 AM






Alan assumes the field is set up as an AUTOINCREMENT, which is what MySQL uses to increment integer index fields.

Kurt.

----- Original Message ----
From: Alan McDonald <alan@.... au>
To: firebird-support@ yahoogroups. com
Sent: Friday, October 17, 2008 5:29:20 AM
Subject: RE: [firebird-support] Generator

> Hi,
>
> Sorry if this is off topic, I have been using Firebird for a long time,
> the generator is the one I
> use often too, now, I'm trying to convert a Firebird db to MySql, and I
> can not find generator
> in mysql, does anybody now what is the equivalent in mySQL? Thanks.
>
>

MySQL has no generators, you need to insert a record, then ask the server
the ID of the last record inserted. The server gives you back the ID on a
per connection basis.
Alan

____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. yahoo.com

[Non-text portions of this message have been removed]















Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

[Non-text portions of this message have been removed]