MapInfo Pro

 View Only
  • 1.  Value "0" (Zero) is cut when using SQL Dialog (MIPro 2021/2023)

    Posted 15 days ago

    Hi.

    Hope both pictures can illustrate the issue/problem:

    It's a small sample statistics of male (männlich) an female (weiblich).

    I wonder why the list box "offers" me "1" and "3" instead of "100" and "30" (column: männlich/male)

    I wonder why the list box "offers" me "1" , "5", "6" and "21" instead of "50" , "60", "100" and "210" (column: weiblich/female)

    Both Colums are "Integer".
    To index the columns did not change the thing.




    Best regards
    Oliver



    ------------------------------
    Oliver Best
    Marketing + Training Manager
    AGIS Anwender-Geo-Informations-Systems GmbH
    Bad Homburg
    ------------------------------


  • 2.  RE: Value "0" (Zero) is cut when using SQL Dialog (MIPro 2021/2023)

    Employee
    Posted 15 days ago

    That looks weird.

    Can you share the table, Oliver? Send it to peter.moller@precisely.com

    Thanks



    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------



  • 3.  RE: Value "0" (Zero) is cut when using SQL Dialog (MIPro 2021/2023)

    Posted 15 days ago

    Hi Peter.

     

    Thanks for getting back so quickly.

     

    Yes, I was surprised.

    I wanted to offer/show this feature in my upcoming training course for our customers.

     

    First I did not understand the result but then I found the „system".  

     

    Hopefully it did not make any faults using the sql dialogue.

    You'll find out! 😊

     

    Mit freundlichem Gruß
    Oliver Best
    Geodatenmanager und Schulungsleiter

     

    AGIS Anwender-Geo-Informations-Systeme GmbH

    Im Atzelnest 3

    61352 Bad Homburg v. d. Höhe

    Telefon:

    +49 6172 59531 - 17

    E-Mail:

    oliver.best@geoas.de

    Internet: 

    www.geoas.de

    Geschäftsführer Michael Jäger, Klaus Schacht, Handelsregister
    Amtsgericht Bad Homburg v. d. Höhe HRB 15522, USt-IdNr. DE 114 115 374

    GeoAS • MapInfo • FME • WebGIS • Mobiles GIS

     






  • 4.  RE: Value "0" (Zero) is cut when using SQL Dialog (MIPro 2021/2023)

    Employee
    Posted 11 days ago

    As you saw, Oliver, I raised a bug request against this with our support team.

    Thanks for bringing this to our attention



    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------