sqlYoga: failing to do simple record deletion?

Trevor DeVore lists at mangomultimedia.com
Thu Apr 8 09:25:05 EDT 2010

On Apr 6, 2010, at 3:09 PM, David Bovill wrote:

> What am I doing wrong - must be something simple and obvious, but I  
> can't
> figure out how to delete records, I'm adding them OK - but somewhere  
> in the
> stew is a bug stopping me deleting them. This is what I do:
> on hdb_DeleteHandler
>>   put GetSelectedID() into handlerID
>>   put sqlrecord_CreateObject ("handler") into theRecordA
>>   sqlrecord_set theRecordA, "id", handlerID
>>   sqlrecord_delete theRecordA
>>   put the result into someError
>>   display_HkeyDataBase
>> end hdb_DeleteHandler

I imagine this fails because the SQL Yoga schema doesn't know that the  
'id' column is the primary key. If we figure out the cause of that  
then this should start working.

Trevor DeVore
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com

More information about the Use-livecode mailing list