var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: PROGRESS problems with ODBC UPDATE
I'm trying to get an UPDATE to work on a table with a single row.
I've tried several methods, but am now stumped.
The ONLY result I get, no matter what format of SQL UPDATE I use is the dreaded:
Which means PROGRESS hates the syntax...
[MERANT][ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "DECLARE". (247)
ODBC Error -2147467259
The stage I've got to so far is:
SELECT autoline-dublin, autoline-cork, autoline-galway FROM parameters FOR UPDATE OF autoline-dublin, autoline-cork, autoline-galway
What seems to be happening is that the ' (single-quite) is being stripped off the string inside the "" (double-quotes), so that the string being passed to the EXECUTE appears to be:
UPDATE parameters SET autoline-dublin='newname', autoline-cork='newname', autoline-galway='newname'
I'm currently coding in VBA.
UPDATE parameters SET autoline-dublin=newname, autoline-cork=newname, autoline-galway=newname
Is there a QUOTE() function in PROGRESS?
i also have the same problem
I figured it out, this is the syntax you have to use for ADODB Update statements in VB6/VBA
sSQL = "SELECT field[,...] FROM table FOR UPDATE OF field[,...]"
Set RS = New ADODB.Recordset
RS.Open sSQL, conn
sSQL = "UPDATE table SET field=value[,...] "