Re: [RBASE-L] - Know when data has been changed in a row of data in a table.

Myron, when potentially updating a row using a form, I project a temp table for that row and perform maintenance on the temp table. When exiting the form, I update the permanent table from the temp table. To detect if changes were made, I use the AUTOROWVER Operating Condition; see: https://www

RE: [EXTERNAL] Re: [RBASE-L] - logging database value changes in a form

Thx that looks like a good idea. do it at the table level. I will play with that. Dan Goldberg MIS Manager 43120 Venture Street Lancaster, CA 93535 T (661) 949-3322 x 252 LanceCamper.com [cid:image001.png@01DA33DF.20062C50] [signatur

[RBASE-L] - R:Web Reports Order by

I am working on a new R:web report and do not see an option to add a order by or arrange tablename by collist Has anyone been able to add it in? TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you a

Re: [RBASE-L] - logging database value changes in a form

Myron, I think you can use triggers to capture when data changes. You can use an on before update trigger which can be set in the table definition. A stored procedure has to be created first. With the store procedure is created a trigger can be created on the table. There are virtual tables sys_o

RE: [RBASE-L] - logging database value changes in a form

Dan, Based on the post under this one we are still working on making the determination as to when data in a row has been changed. Once there we will make the changes accordingly and will keep everyone posted.. Thought you might want to see how our application starts. Our organization curren