"revdberr, " as the returned value on *successful* postgres operations
bonnmike at gmail.com
Mon May 13 22:11:41 EDT 2013
Are you adding the ; at the end of your sql strings? I'm pretty sure rev
appends its own ; so the result would be an extra one. Which might make
postgres a) do whatever you told it to, then b) return a confused error due
to the second ;
Try it without adding the ;
On Mon, May 13, 2013 at 7:52 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
> On Mon, May 13, 2013 at 6:41 PM, Peter Haworth <pete at lcsql.com> wrote:
> > I haven't used LC with postgresql but seems pretty unlikely that a
> > successful operation would return "revdberr". If you post your code and
> > also the full text of the error message you get back, can probably figure
> > out what's going on.
> That's the problem--this *is* the entire result.
> Something like
> UPDATE mytable SET mypet='cat' WHERE food='mice';
> yields this error
> But then checking
> SELECT * FROM mytable;
> cat <delim> mice
> where there was a prior entry of "snake, mice"
> I've seen this message many, many times, and every time I've checked the db
> contents when getting this one-word error, the commit was successful.
> It's as if LC has a structure
> CASE lots
> CASE of
> CASE conditions
> put somenumber into theRes
> put "revdberr," into theRes
> CASE condition 1;
> put cr & gizmo after theRes
> <no DEFAULT CASE in embedded
> END SWITCH
> END SWITCH
> return theRes
> .But I absolutely agree that it makes no sense . . .
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode