revDataFromQuery and DELETE FROM

[Dan Friedman]

Pete,

Thanks for the reply.   The entire error string is "revdberr," (with the comma).  I tried your suggestion of using revExecuteSQL instead of revDataFromQuery() and I did not get the error. So at least I have a suitable workaround.  Thanks for the assist!

- Dan

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