search

mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
214 stars 66 forks source link

Invalid integer numeric value #227

Closed mrjohnr closed 2 years ago

mrjohnr commented 3 years ago

HI, with latest snapshot 0.9.3.9,when I try to edit smallint/bigint values using grid I got always the error: Invalid integer numeric value in screenshot I put 1 instead of 0 for TIP column,for decimal works thanks

img

fperana commented 2 years ago

Same there. It also happens when editing String fields when the value contains only digits. The produced SQL is something like set STRING_FIELD = '518.000000'

arvanus commented 2 years ago

Already fixed at 79af8d7291cf8b064a0a9bf9a526d114e22e60c8, I'm just waiting for the full int128 compat to deploy a new snapshot

fperana commented 2 years ago

Hi, is it possible to have a new snapshot compiled with at least the current fixed bugs? It's quite frustrating to use two versions of flamerobin, the last to have support for data type in FB3 and one older to being able to edit numeric and string fields.

mrjohnr commented 2 years ago

Indeed very ugly bug,makes new version of Flame Robin unsless for FB>2.5

arvanus commented 2 years ago

Please update to the latest snapshot (0.9.3.10) and try again, if working please close this issue. Thanks

mrjohnr commented 2 years ago

for me seems it is working.thanks