Page 1 of 1

DBGrid1 and zeos in BCB6 ?

Posted: 15.08.2007, 21:35
by Helu Jar
I installed Zeos. And I start to build a program which using zeos. But I can't see the datas in DBGrid1 can you help me? I'am using BCB6.

Posted: 16.08.2007, 03:28
by klchin
Hi,

Did you set the datasource/dataset correctly or
is your query correct?

Regards,
KL Chin

Posted: 16.08.2007, 04:02
by cipto_kh
Yes, I think klchin is right, I not use BCB here (I use Delphi 7) but as I know the BCB dataset concept is same with Delphi (CMIIW).

So you need to drop TZConnection (Zeos), TZQuery (Zeos), TDataSource and TDBGrid (sorry if the the name is only valid for Delphi, but maybe you can find the similiar component in BCB).

Then make right connection with TZConnection, link your Connection property of TZQuery with that TZConnection.

Write your query in TZQuery, link the Dataset property of TDataSource with TZQuery

Then link the DataSource property of TDBGrid with TDataSource. Set the Active property of TZQuery to true and it will work.

--
Know more from here:
http://firebird-with-delphi.blogspot.com/
http://cipto-kh.blogspot.com/
http://best-dating.blogspot.com/

Posted: 16.08.2007, 15:29
by Helu Jar
These are screenshots:

Image

ZQuery1 SQL code: select * from mesaj

Image

Image

Image

Image

What is wrong?

Posted: 17.08.2007, 02:41
by klchin
Hi Helu Jar,

All of your image files did not show out.

Regards,
KL Chin

Posted: 17.08.2007, 12:11
by gto
The don't appear here too.. try to use this service:
http://imageshack.us/

Posted: 18.08.2007, 22:42
by Helu Jar
Do they appear now?

Posted: 19.08.2007, 06:22
by klchin
Hi Helu Jar,

From the screen there were data shown in your component,
only that all your data wer not "char" type. But not sure the
"tarikh" do you put in any valid value/

Can you create a field that was "char" type like length 8 instead
of var char or text base. Or may be you can try to compile the
sample code to verify your data with MySQL 5.

Hope this hint can you.

Regards,
KL Chin

Posted: 19.08.2007, 11:23
by Helu Jar
Thanks.