TDO

Hi VDB,

thank you for your reply. Maybe you are right, but I found this thread:

I downloaded and installed the library in this thread for PostgreSQL VIs.

The statement I posted above is working fine with the VIs from this library.

Hey Guys,

I am facing a similar problem. I don`t really have experience in SQL statements, so a colleague of mine created a pretty complex SQL Statement for me to get some information of a postgre SQL table.

The statement should return some numbers and strings from the table. This works fine with a little tool, called HeidiSQL and in SQL Server Management studio from Microsoft.

If I use this statement with Labview it returns just the strings, but not the numbers. I have no idea, why it returns just the strings.

So, I hope here are maybe some SQL/LabView experts who can help me.

The statement is the following:

SELECT
     vk2.id,
     vk2_bestellnr,
     vk2_pos,
     vk2_upos,
     art_nrx25,
     art_bez_50,
     tb.text_block,
     vk2_liefmenge2,
     vk2_bestmenge,
     art_gewichtnetto,
     art_f1
FROM vk2
     LEFT JOIN ar ON 
           vk2_art_nrx25 = art_nrx25
     LEFT JOIN ( 
           SELECT 
                 text_schl,
                 text_sa,
                 STRING_AGG(text_textzeile, ' '||E'\n') AS text_block
           FROM
                 text
           WHERE
                 text_sa = '02'
           GROUP BY
                 text_schl,
                 text_sa
           ) tb ON vk2_art_nrx25 = text_schl
WHERE
     vk2_bestellnr = 1046421

Here is also the code snippet, where the statement is executed:

I would really appreciate if someone could help me.

Best regards

TDO