[Mysql]select count(*) ????

[Mysql]select count(*) ????

am 04.04.2006 09:21:02 von slowik

Defference mysql 4.0 and 4.1
My code:
strSelKoresOczek = "SELECT COUNT(*) il_Oczek";
+ " FROM dekretacje d";
+ " left join dekret_realiz dr on d.dekr_id=dr.dekr_id";
+ " left join rejestr_glowny rg on d.prej_id=rg.prej_id";
+ " left join jorg_slownik on
d.jorg_id=jorg_slownik.jorg_id";
+ " WHERE d.symb_rej='RKP' and d.p_rodz='Z'";
+ " and d.dekr_uzytk_id="+ALLTRIM(STR(giUzytkID));
+ " and d.data_czas_dekrwyc is null";
+ " and dr.dekr_id is null"

ok_wyk = SQLEXEC(gnConnHandle,strSelKoresOczek,"cur_sel_koresoczek")

In version 4.0.18 cur_sel_koresoczek.il_oczek is type Numeric
In version 4.1.16 cur_sel_koresoczek.il_oczek is type Char.

Why it is?
Artur