Sounds like you somewhere issued a BEGIN and then stopped processing without a ROLLBACK or COMMIT, maybe while debugging and stopping part way through a handler. The INSERT in psql works because you don't have that situation. Try issuing a COMMOT or ROLLBACK from the message box then try the INSERT again.
Pete lcSQL Software <http://www.lcsql.com> On Sat, May 11, 2013 at 5:01 PM, Dr. Hawkins <[email protected]> wrote: > I have an open database debtorDb of 11. I have a text window with psql > running on the same database. uniq_sfky is > > psql likes my query: > dhbk_dbtrs=# INSERT INTO try1_____________001_sofa VALUES(DEFAULT) > RETURNING uniq_sfky; > uniq_sfky > ----------- > 9 > (1 row) > > INSERT 0 1 > dhbk_dbtrs=# > > > Livecode does not: > > put "INSERT INTO " & dhtbl_sofa & " VALUES(DEFAULT) RETURNING uniq_sfky;" > & return into dcmd > put dcmd > > shows > > INSERT INTO try1_____________001_sofa VALUES(DEFAULT) RETURNING > uniq_sfky; > > --the exact same query (well, I did cut & paste!) > > Then using this in a couple of ways > > put revDataFromQuery(tab,vtab,debtordb,dcmd) into theRes > put theRes > yields > revdberr,ERROR: current transaction is aborted, commands ignored > until end of transaction block > > > Then also trying, > put revdb_execute(debtorDb,dcmd, res1, res2, res3)into theRes > put theRes > > yields the same error message > > > Originally, I had these inside BEGIN/COMMIT, but couldn't make sense out of > the errors. > > This seems to be valid postgres, and works in psql (which is a minimal > wrapper, I believe). > > What is going on here? > -- > Dr. Richard E. Hawkins, Esq. > (702) 508-8462 > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
