Board index » delphi » Cant get ClientDataSet and IBQuery working?

2005-02-19 02:21:03 AM
delphi8
Hi all , I must be missing something simple cause I cant get these
components
to even return a simple dataset in a datagrid.
First the setup, I think I have all setup for use with CDS correctly. But it
doesnt work
D2005 Arch.
IBX 9.09
I have in a DM , TIBDatabase, connected.
Transaction
IBtransaction1.allowAutoStart = True
IBtransaction1.AutoStopAction = saCommit
Query
IBQuery.transaction = IBtransaction1
IBQuery.Sql := 'SELECT * from Customers'
Provider
DataSetProvider1.Dataset = IBQuery
ClientDataSet
CLientDataSet1.providerName := DataSetProvider1
DataSource
DataSource1.DataSet := ClientDataSet1
In a Customer form, with a DBGrid hooked to DataSource1, I call
DM.ClientDataSet1.close;
DM.ClientDataSet1.open;
No Data in the grid? and the CDS is EOF.
Further I thought the point of CDS was to keep the transaction context
short and provide an in memory set?. But After the call to CDS.open the
IBTransaction1.Intransaction is True!! why is this?? Shouldnt the context be
over?
This is not my first IBX app but the first CDS version, normally I like to
handle the
transaction contexts myself But I need the functioality of the CDS, and what
I;ve read
of them you need to let them handle the contexts for you. That would be fine
if it worked.
But It doesnt. Also I opened some CDS sample apps from Code central, the
using BDE
and TTable and I got that one to work. Now I need to get the IBQuery version
going?
Please....pleasee... I beg of you!! LOL
Thanks in advance
Jarek Bialik
Britec Computer Systems
 

Jarek Bialik writes:
www.dbginc.com/tech_pprs/ibxcds.html
www.dbginc.com/tech_pprs/IBXCDSCode.zip
--
Craig Stuntz . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz/
 

Craig,
I got the Cds sample app working , now I will have to figure out what is
different
in mine.
Thanks
Jarek Bialik
Britec Computer Systems
"Craig Stuntz" <XXXX@XXXXX.COM [a.k.a. acm.org]>wrote in
message news:42163da2$XXXX@XXXXX.COM...

Well I got it going. I opened the sample app , everything was exactly
the same as mine. So as a last resort I just deleted all of the dm
components
added and re-linked everything from scratch. Low and behold its all flying.
Strange, but true! now I can start checkin Clientdatasets. One last question
Now I have to deploy midas.dll with the app correct? Are there any licensing
issues?
Jarek Bialik
Britec Computer Systems
"Jarek Bialik" <XXXX@XXXXX.COM>writes

As long as you are using Delphi 6 or Delphi 7 there are no licensing issues. If the
ClientDataSet and the DataSetProvider it is connected to are executing on
the same machine there are no issues with earlier versions of Delphi.
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
 

of your project.
but if you have many applications using midas then in that case installing
dll's is better choice.
"Jarek Bialik" <XXXX@XXXXX.COM>writes