revDataFromQuery and DELETE FROM

[Peter Haworth]

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 <dan at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>