DBGrid1 and zeos in BCB6 ?

[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.

[klchin]

Hi,

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

Regards,
KL Chin

[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/

[Helu Jar]

These are screenshots:



ZQuery1 SQL code: select * from mesaj









What is wrong?

[klchin]

Hi Helu Jar,

All of your image files did not show out.

Regards,
KL Chin

[gto]

The don't appear here too.. try to use this service:
http://imageshack.us/

[Helu Jar]

Do they appear now?

[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

[Helu Jar]

Thanks.