revDataFromQuery and DELETE FROM

[Bob Sneidar]

Or use sqlYoga! ;-)

Bob S


On Aug 18, 2014, at 02:43 , John Craig <john at splash21.com> wrote:

> 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 <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
>>> 
>> _______________________________________________
>> 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
>> 
> 
> 
> _______________________________________________
> 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