Dotaz SELECT:

SELECT "NodeID","PositionX","PositionY","PositionZ","Timestamp","Type" FROM "public"."ActiveNodes"'



Dotaz INSERT:

INSERT INTO "public"."Measurements" ("NodeID", "PosX", "PosY", "PosZ", "RealX", "RealY", "RealZ", "FailX", "FailY", "FailZ", "FailAbs", "TimeStamp", "Note") VALUES ('+obj.nodeID+', '+obj.positionX+', '+obj.positionY+', '+obj.positionZ+', '+popCompCords.newPosXTInput.text+', '+popCompCords.newPosYTInput.text+', '+popCompCords.newPosZTInput.text+', '+popCompCords.label_diffPosX.text+', '+popCompCords.label_diffPosY.text+', '+popCompCords.label_diffPosZ.text+', '+popCompCords.label_absErr.text+', \''+formatDateTimeForDbInsert.format(getTimeStmp().toString())+'\', \''+popCompCords.textInput_note.text+'\');