用odbc访问access数据库，用insert增加一条记录然后post，可是recordcount值为什么还是原来的值？(50分)

L

lhy9988

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #1

 

教

教父

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #2

是不是要Refresh一下，我没用ODBC访问过ACCESS，只是猜的 ：）

 

L

lhy9988

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #3

refresh了，就是不行！

 

H

hnzgf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #4

同志，不要用RecordCount了，用Eof去判断吧，听说RecordCount会出现记录不准的情况

 

L

lhy9988

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #5

可是我想根据记录数生成序号，而且在增加、删除时都能自动重新排列序号

 

H

hapcoer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #6

自己写了
function myrecord(mytable:Ttable):integer;

begin
myrecord:=1;
with mytable do
begin
first;
while not eof do
begin
inc(myrecord);
next;
end;
end;

end;

 

L

lhy9988

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #7

也不行，你可以新增两条试一试

 

W

WorldCreater

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #8

你把代码贴出来看看

 

C

celeries

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-28

• #9

应该用refresh.

 

L

lhy9988

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #10

begin

table1.post;
table1.refresh;
no:=1;
table1.first;
with table1 do
begin
while not eof do
begin
showmessage(inttostr(no));

if no<10 then r:='00'+inttostr(no)
else
if (no>9) and (no<100) then r:='0'+inttostr(no)
else
if (no>99) and (no<1000) then r:=inttostr(no);
edit;
fieldbyname('序号').asstring:=loginform.bm+r;
post;
no:=no+1;
next;
end;
end;

 

J

jammi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-29

• #11

table1.close;
table1.Open; //代替refresh试试

 

L

lhy9988

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-09

• #12

接受答案了.