Re: New problem with Firebird dialect 3

Geoff Wass [dBVIPS] Wrote:

> Jaime,
> 
> In dBASE, do this:
> 
> ? 2^16			//  65,536
> ? 800*150		// 120,000
> 
> What you are seeing is exactly right and WAD. An INTEGER is 16-bit. If 
> this is happening when you assign yourField = 150 * 800, then try BIGINT 
> instead of INTEGER. If this is happening in all calculations, including 
> just any variable, like x = 150 * 800, then do it this way:
> 
> x = 150 * 800.00
> 
> to get a floating point value which has a greater range of values.
> 

Thanks Geoff... what buffled me is that those stored procedures were working Ok
when the database was in dialect 1, and the fields involved are not INTEGER but
NUMERIC...  But I'll check once more.. maybe there is something like that in
some place... I'll check

Thanks for the tip & have a nice weekend

Jaime Escobal








> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
> 
> .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.