BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Name of the Table through the TClientDataSet ?

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (dbExpress)
View previous topic :: View next topic  
Author Message
Adriano
Guest





PostPosted: Mon Sep 11, 2006 7:05 pm    Post subject: Name of the Table through the TClientDataSet ? Reply with quote



Hi,

BDS 2006, SQL Server 2005 and DBexpress connection.

I'm using TSQLConnection, TSQLDataSet, TDataSetProvider, TClientDataSet and
a TDataSource to access the datas.

Is it possible to know the name of the table through the TClientDataSet ?

CommandText of TSQLDataSet
select * from "CadRede"

I'd like to get the original Table Name from SQLServer.
Ex.: myTableName := myClientDataSet.TableName;


Thanks
Back to top
Bill Todd
Guest





PostPosted: Mon Sep 11, 2006 10:48 pm    Post subject: Re: Name of the Table through the TClientDataSet ? Reply with quote



What would you expect if the the CommandText property of the SQLDataSet
was:

SELECT * FROM CUSTOMER C JOIN ORDERS O
ON O.CUSTNUM = C.CUSTNUM
JOIN ORDERDETAIL D
ON D.ORDERNUM = O.ORDERNUM

That is why there is no property that will return the table name.

--
Bill Todd (TeamB)
Back to top
Adriano
Guest





PostPosted: Mon Sep 11, 2006 11:27 pm    Post subject: Re: Name of the Table through the TClientDataSet ? Reply with quote



Ok. I understood !!!

Thanks

Adriano



"Bill Todd" <no (AT) no (DOT) com> escreveu na mensagem
news:4505a157$1 (AT) newsgroups (DOT) borland.com...
Quote:
What would you expect if the the CommandText property of the SQLDataSet
was:

SELECT * FROM CUSTOMER C JOIN ORDERS O
ON O.CUSTNUM = C.CUSTNUM
JOIN ORDERDETAIL D
ON D.ORDERNUM = O.ORDERNUM

That is why there is no property that will return the table name.

--
Bill Todd (TeamB)
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.