Zeoslib Portal

Hi,

Would could be the problem, retrive the datatime field result become

pField->AsString it display "2007/03/18 12:03:52 12:03:52 PM"

Database : MsSQL
FieldType : DateTime
Zeos : 6.1.5

Regards,
KL Chin

Hi Mark,

Sorry for the un-clear message, what I meant was for MySQL I can easy
patch the code, but for ADO/MsSQL I cannot get the similar code.

Yes, you can close for bug for MySQL.

Thx.

Regards,
KL Chin

Hi Mark,

Sorry for the late testing.

How about the type was Real for ConvertMySQLTypeToSQLType ?

For MsSQL, I was using the ADO connection, but under the pas I did
not see any similar convertion, what needed to be changes?


Regards,
KL Chin

Hi Mark,

Thx for your help. I will verify the code.

Regards,
KL Chin

Hi ALLs,

FYI, the same problem did happended with MsSQL also.

Regards,
KL Chin

Hi,

Pls check this link http://zeos.firmos.at/viewtopic.php?t=919

Regards,
KL Chin

Hi Dave,

Thx for your code and idea, sound ok to me.
So, I needed to check for every field type b4 I apply the setting.

Regards,
KL Chin

Hi Davidb,

Thx for your suggestion. It was good idea.
The had problem, bcoz the query was dynamic, table unknown.

If it do not connect to DBGrid, will the result correct if it obtain
from query.FieldByName( 'xxx' ).AsString?

Regards,
KL Chin

Hi Jay,

Thx for your info.
I used C++Builder 5.0. I conncet to DBGrid, and it shown the
wrong value. I obtained the value by Field->AsString, it gave
the same problem also.

Regards,
KL Chin

Hi,

I have the same problem for MySQL with older Zeos 6.15.
I think due to the convertion.

Regards,
KL Chin

Hi,

Is your SQL using grouping or Distinct?

Regards
KL Chin

Hi,

Do you select the right protocol .ie. MySQL or MSSQL or etc?

Regards
KL Chin

Hi,

Have you try explicitly free/delete the object after close?

Hi Pengwin,

Is there any different if you runtime create the
both TZConnect and TZQuery?

Regards
KL Chin

Hi,


Hv u edit the pg_dba.conf to add the IP

and postgreSQL

listen_addresses = '*'