Good morning,
In using execute(sql) to update a false always results for the record set . I typically setup and test statements in Postico and/or
SEQUEL . In this case an update - UPDATE "CRM_Pat" SET lastname = 'harrison' WHERE id = 1, executes on these platforms .
Variations in Creo for the method execute(sql) as seen in the select(sql) doesn't seem to work.
// load window variables
Console.write(lastnameText.text);
Console.write(firstnameText.text);
Console.write(patid.text);
//var sql = 'UPDATE "CRM_Pat" SET "lastname" = "Jackson" ,WHERE id =/(patid.text) ';
//var sql = 'UPDATE "CRM_Pat" SET "lastname" = "Jackson" ,WHERE "id" =/(patid.text) ';
//var sql = 'UPDATE "CRM_Pat" SET lastname = "Jackson" ,WHERE id =/patid.text) ';
//var sql = 'UPDATE "CRM_Pat" SET lastname = "Jackson" ,WHERE id = "1003" ';
var sql = 'UPDATE "CRM_Pat" SET lastname = "Jackson" ,WHERE id = 1003) ';
var rs = PostgreSQL1.execute(sql);
Console.write(rs)
false
Anyone else working with Postgres your comments are appreciated .
Regards
Joel