Problem Expecting float actual string - quite urgent!

Forum related to all 5.x versions of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply

Which version of Zeos ar you using?

Poll ended at 19.11.2005, 18:25

5.4.1
1
17%
5.5.0
0
No votes
6.0.12
0
No votes
6.1.5
0
No votes
6.5.1
5
83%
 
Total votes: 6

zippo
Silver Boarder
Silver Boarder
Posts: 322
Joined: 12.10.2005, 18:01
Location: Slovenia

Problem Expecting float actual string - quite urgent!

Post by zippo »

Hi!

I have a problem with the "old" Zeos. An Query opening that always worked is not working anymore! I KNOW the field CENA_PROD is float, but Zeos insists that it's a string...

Here's the error, from the Delphi IDE

---------------------------
Debugger Exception Notification
---------------------------
Project Prodaja.exe raised exception class EDatabaseError with message 'qryZaloga: Type mismatch for field 'CENA_PROD', expecting: Float actual: String'. Process stopped. Use Step or Run to continue.

What can I do? :cry: Yes, I will migrate the project to 6.x, but first I have to patch it, so I won't be under pressure during the migration.
User avatar
tomazeli
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 21.11.2005, 17:08
Location: Montreal, Canada

Post by tomazeli »

I have the same problem, this poblem started when I change to mySQL 5 and updated to zeos 6.5.1

Please help us!!!!???? It's Urgent!!!
Odimar Tomazeli
niofox
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 13.07.2006, 17:29

Same here - In depth

Post by niofox »

I get these problems alot. Both new and old versions of Zeos

Usually I have to remove the offending fields from the dataset, close all connections then add the fields back using 'Add All'.

This used to solve my problems, which usually only occured when I made data-type related changes to my database fields in mysql.

Now, however, I'm getting this problem when using a UNION or 2 in my queries, and I'm trying to figure out how to fix it myself.

I'm about to try using Cast functions to make all the data conform to the same type and hopefully this should solve the problem :shock:


EDIT:

Yep that worked. All the fields now come up as floats in both designtime and runtime. I used "CAST(field1 AS Unsigned) AS field1name"
Signed can work too. I dunno how you'd cast it to an integer tho ...
Post Reply