SQL ROUND and (

  • Hi everyone, I totally love the plugin and it really works like a charm!
    However, I have one problem: I have a perfectly valid sql statement which includes a SELECT ROUND (XY, 2) statement. I tried it in phpmyadmin. It works. However, abase does not seem to work with the ROUND argument in the query. But I definitly need to round these values. Any help?

    Second I have another query where there is a “< 10” statement in it. This does not work either. The other way around (“> 10”) works. Does anybody have a tip on either of these issues?

    Thank you in advance.

    Cheers,
    Florian

    https://www.ads-software.com/plugins/abase/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter florian_r

    (@florian_r)

    okay people, the SMALLER THAN Isseu is solved: it works if you use the html-reference of the “<“- sign which is < (i.e. less than = lt)

    See all the reference names here: https://www.ascii.cl/htmlcodes.htm

    The ROUND Problem mentioned above persists. Please help me out on how to make the regular SELECT ROUND statement work in ABASE.

    Thanks!

    Thread Starter florian_r

    (@florian_r)

    Hey folks, I’m still struggeling with the ROUND-error in the ABASE statement: In my installation ABASE does not deal with the otherwise (e.g. phpMyAdmin) working MYSQL statement. Please someone respond with a hint.

    Sincere thanks!

    Thread Starter florian_r

    (@florian_r)

    and it is still going on… listen guys, even if its a total nobraine: I dont see it right now – please help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL ROUND and (’ is closed to new replies.