SQL Result

#1 · June 16, 2023, 3:10 pm

Hy, can you please help me.

How can I get the result ?

The Variable [NN] are emtpy, but MS SQL Browser give a result.

dbpExecSQL "JTL" "SELECT fVKNetto FROM dbo.tArtikel WHERE cBarcode='[Suche]' or cArtNr='[Suche]'" "[NN]"

MessageBox "Test" "[NN]" "[NN]" ""

Thanks

Steven

#2 · June 16, 2023, 9:30 pm

NN should be the table with the results and not a variable, you should use it like this:

dbpExecSQL "JTL" "SELECT fVKNetto FROM dbo.tArtikel WHERE cBarcode='[Suche]' or cArtNr='[Suche]'" "NN"

SetVar "[NN]" "[JTL.NN.fvkNetto]"

salu2

luishp has reacted to this post.

#3 · June 17, 2023, 10:37 am

thank you

SQL Result - Forum