Peter's correct - use revExecuteSQL since no records are returned


On 17/08/2014 19:20, Peter Haworth wrote:
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



_______________________________________________
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

Reply via email to