I have a procedure that uses posturl() in Panorama X to get the next numeric value from a Panorama Enterprise shared database. The Enterprise server is set to return text (cgiContentType=“text/plain”). The posturl() result is put in a variable called vcgiResults. Everything works great except when I am trying to assign the value in the variable vcgiResults to an integer field in Panorama X called mRecordID. Here is the code.
mRecordID=int(val(vcgiResults)). It will work if I assign the contents of vcgiResults to a text field but not a number field with the integer type.