Hi Dan, What is the text after "revdberr"? Strange that the row is being deleted but here's a couple of things that come to mind.
You've probably already checked that tTableName and entryID contain valid information but one other thing to check is if the tablename includes any special characters or if entryID contains non-numeric data. In the first case, the table name would have to be enclosed in double quotes and in the second case, entryID would have to be enclosed in single quotes. I'm not sure it really matters but I always use revExecuteSQL when executing anything other than a SELECT statement. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sun, Aug 17, 2014 at 9:41 AM, Dan Friedman <d...@clearvisiontech.com> wrote: > Hello, > > Can anyone tell me why this results in "revdberr"? > > put "DELETE FROM" && tTableName && "WHERE entryID=" & entryID into tSQL > put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData > > What's interesting is that the record is being removed from the database. > So it's all working server side, just that LiveCode is reporting "revdberr". > > Anyone have any ideas? > > Thanks in advance, > Dan > _______________________________________________ > 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
