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 <doch...@gmail.com> wrote: > On Mon, May 13, 2013 at 6:41 PM, Peter Haworth <p...@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; > > yields > 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 > > SWITCH > CASE lots > CASE of > CASE conditions > put somenumber into theRes > break > DEFAULT > put "revdberr," into theRes > SWITCH > CASE condition 1; > put cr & gizmo after theRes > break > ... > <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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode