Deleting in Arev32 (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Mat Kelly, Dave Harmacek, Mike Ruane, Bob Orsini, Warren Auyong, //www.sprezzatura.com]The Sprezzatura Group[/url], Barry Stevens

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 17 AUG 2009 05:50:12PM Mat Kelly wrote:

I am attempting to delete an entity in Arev32 (that was originally written in Arev31) using the syntax:

DELETE FILE_NAME,ID THEN

SUCCESS=1

END ELSE

CALL MSG("RECORD ":ID:" COULD NOT BE DELETED!")

END

but it appears that the record is never deleted contrary to it existing. Is there a different way to accomplish this in Arev32? Does some document exist for those that are porting applications from Arev to Arev32 that address issues of this nature?

At 18 AUG 2009 07:23AM Dave Harmacek wrote:

Now we guess….what could an "entity" be? Since not part of the syntax of Arev31.

Is this a row that is the target of a relational index? If so, you can't delete it unless the source has a null entry, or you remove the index.

At 18 AUG 2009 08:17AM Mike Ruane wrote:

Mat -

Are there any relational indexes updating information in the 'entity'?

Mike

At 18 AUG 2009 06:01PM Mat Kelly wrote:

Mike,

There aren't any relational indexes for the table in which the row (i.e. entity) resides - only 4 btrees and a Xref. Please correct me if I'm mistaken about what qualifies as a relational index. Any idea why I can't delete the entry?

At 19 AUG 2009 08:10AM Bob Orsini wrote:

What happens if you do the delete from the TCL command line.

At 19 AUG 2009 06:33PM Warren Auyong wrote:

Is the ELSE clause executing?

Record keys are case-sensitive, is the case correct?

At 24 AUG 2009 07:37PM Mat Kelly wrote:

Bob,

DELETE FILE_NAME ID does work at TCL, but I can't seem to replicate this behavior programatically. If DELETE FILE_NAME ID works at TCL but neither DELETE FILE_NAME,ID nor DELETE FILE_NAME ID work in a program, how do I go about deleting a row from within a program?

Thanks!

At 24 AUG 2009 07:42PM Mat Kelly wrote:

Warren,

It doesn't appear that the else clause is executing, as the alert message placed in the ELSE doesn't seem to popup, albeit I've found this to not be a successful means of debugging in the past.

Also, the key is wholly numeric, so case isn't an issue? Do you know of any other issues that might be going on? Please see my response to Bob Orsini as well.

Thanks!

At 25 AUG 2009 01:55AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Without wishing to teach our Grandmother to suck eggs you imply that the you're using FILE_NAME at TCL and in the program, rather than FILE_NAME at TCL and FILE_HANDLE in the program. Is this the case?

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

At 25 AUG 2009 08:56AM Bob Orsini wrote:

Mat, I tested your command here and it works correctly both on failure and success. You can try using PERFORM 'DELETE FILE_ID ID' but you will not be able to capture the failure, it will display a message if failed.

At 25 AUG 2009 08:33PM Mat Kelly wrote:

In the program it's used through a variable, i.e. DELETE AVARIABLE,AROW

At TCL it seems to work with DELETE CLIENTS 12345

Disregard the inconsistency in my previous messages.

At 25 AUG 2009 11:37PM Barry Stevens wrote:

Can you do

open "CLIENTS" to AVARIABLE then
AROW=12345
DELETE AVARIABLE,AROW
end

How are you determining that it does not work…record 12345 is still there with all data?, or is there but mostly blank with one field containing data?, if the latter, then you have a relational index using that field.

View this thread on the Works forum...