revDataFromQuery and DELETE FROM

John Craig john at splash21.com
Mon Aug 18 05:43:09 EDT 2014


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
>





More information about the use-livecode mailing list