我想在SQLSERVER中动态的改变一个表控件的所用表名(100分)

C

chen66

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-28

• #1

我在程序运行时希望能动态的给表控件更换表名，
我先table1.close;table1.tablename:=table2;
但运行到这里总是告诉我说不能在打开的DATASET中进行次操作。
我用的是sqlserver

 

J

jqw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-28

• #2

table1.close;
table1.tablename:=table2.tablename;
table1.open;
ok?!

 

C

Croco

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-28

• #3

table1.tablename:=table2;
编译通过么？(String:=TTable
table1.tablename:=table2.tablename;
对否？

 

W

wumeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-28

• #4

This is all right,I already test it.
procedure TForm1.Button4Click(Sender: TObject);
begin
Table1.Close;
Table1.TableName:='dbo.Bank';
Table1.open;
showmessage('dbo.Bank');
Table1.Close;
Table1.TableName:='dbo.Departments';
Table1.open;
showmessage('dbo.Departments');
end;

 

C

chen66

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-28

• #5

还是不行，你真的试过了？
我在第二次打开表时报错cann't perform this operation on an open dataset

 

温

温柔一刀

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-28

• #6

把整段程序（赋值的这段）帖上来看看

 

温

温柔一刀

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-10

• #7

如果调用过prepare，或者table是prepared属性，需要先unprepare.

 

W

wjiachun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-10-05

• #8

接受答案了.