||Re: OODML... querry and help
Akshat Kapoor <email@example.com>
||Sat, 2 Nov 2019 14:20:04 +0530
Printing _UPDATE statement.pdf
On 02/11/2019 08:44, Alex Safian wrote:
> Hi Prem:
> Ken's article "XBase to dBASE's Object Oriented Database Manipulation Language (OODML)" is probably the best treatment of the translation from xbase to the new language -- http://www.dbase.com/Knowledgebase/INT/xb2vdb7oodml/x2oodml.htm
> At the top of the article there is a link to examples.
> For replace all there is no direct equivalent -- you just do a loop with ...rowset.next() to enforce the skip.
I would say you are 50% correct. There is no direct equivalent but with
local sql you can achieve the desired result by a single command.
I have attached the local sql help for the concerned
Using sql is the fastest way of updating a table.
A word of warning,
The table will get updated but the rowset already in memory will NOT be
updated till a requery() is executed.