reset auto increment value

[mark]

Hi all,


Iam trying to make the dadabik program work for my company. It seems most things are ok now, but i have one question.
I'd like the database auto increment function to reset if i delete a record (i.e. reset to the previous value). i know the sql command for that and i tried to paste it in the dadabik code but it didn't work.
the command: ALTER TABLE (mytable) AUTO_INCREMENT = 1

Can someone point me to the solution?

regards,

Marco

 

[mark]

*bump!*

 

[Eugenio]

mark wrote:
>
> Hi all,
>
>
> Iam trying to make the dadabik program work for my company.
> It seems most things are ok now, but i have one question.
> I'd like the database auto increment function to reset if i
> delete a record (i.e. reset to the previous value). i know
> the sql command for that and i tried to paste it in the
> dadabik code but it didn't work.
> the command: ALTER TABLE (mytable) AUTO_INCREMENT = 1

Could you please explain better?
When a user delete a record what do you want to do with other records IDs?

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)