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