problem with autonum?

[jbpelletier]

using d5 with an acces database...

the key of my table is an autonum (access)

problem:
when im inserting a record into the table, after the post the field "key" , witch is an (autonum) still empty.

ex)
MyTable.Insert;
DBEdit1.Field.Text:='Field 1';
MyTable.Post;

result)
ShowMessage(MyTable.Fields[0].AsString); //show nothing
ShowMessage(MyTable.Fields[1].AsString); //show Field 1

how can i get the key value?

jb

 

[jbpelletier]

well.. i whant to catch the value of the PrimaryKey witch is an access autonum... any idea about how too do that?

jb

 

[bbegley]

If the key field has a name you can use
MyTable.FieldByName('WhateverTheFieldNameIs').AsString;

 

[NicolasDeMarco]

I have do this:
1) Table.Close; // to flush the buffers
2) Table.Open;
3) Table.Last;
And then I get the autonumber value

Saludos de Argentina
Nicolás

 

[jbpelletier]

tanx nicolas,

In fact that is exactly what i've done to solve my problem. I was wondering if there wasn't a way to do it without having to use such a "patch".