Omnis 4 to 10 difference

Mike Matthews - Omnis omnis at lineal.co.uk
Thu Sep 22 15:23:19 UTC 2022


Hello Andrew,

Hmm, if the system detects you are the only user connected, does the CRB get reloaded with the Prepare for edit command?  In a multi user scene, it must be.  Must it?

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>

www.lineal.co.uk<http://www.lineal.co.uk/>

www.sqlworks.co.uk<http://www.sqlworks.co/>



On 21 Sep 2022, at 05:31, Paul Mulroney via omnisdev-en <omnisdev-en at lists.omnis-dev.com<mailto:omnisdev-en at lists.omnis-dev.com>> wrote:

Hi Andrew

That doesn't sound quite right.

The fields in the main file will be loaded from disk at the Prepare for Edit stage, assuming that it was successful in getting a lock. Does your code look something like this:

Set main file {myFile}
Set read/write files {myFile}

Prepare for Edit
If flag true
# make changes here
update files
else
# record locked by someone else?
end if

Regards,
Paul.



On 21 Sep 2022, at 10:07 am, Andrew McVeigh <surfway at bigpond.com<mailto:surfway at bigpond.com>> wrote:

Just found a weird difference in execution of the same code in Omnis 4 and Omnis 10 (not using SQL)

The coding is probably not the best but anyway

Calculate DTPAID as 10 ##DTPAID is a field in the Main Data File
Prepare for Edit ##This rereads the CRB and DTPAID becomes zero

This is what happens in Omnis 4

In Omnis 10 the DTPAID field maintains it’s value of 10 when you do the Prepare for Edit

Is this meant to happen?

Andrew McVeigh
Surfway Real Solutions
Phone 02 44412679 Mobile 0418428016
www.surfway.com.au<http://www.surfway.com.au>
www.berrarabeach.com.au

_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com


No matter how much you push the envelope, it'll still be stationery.
--
Paul W. Mulroney                                            We Don't Do Simple Pty Ltd
pmulroney at logicaldevelopments.com.au<mailto:pmulroney at logicaldevelopments.com.au>       Trading as Logical Developments
www.logicaldevelopments.com.au<http://www.logicaldevelopments.com.au>                   ACN 161 009 374
Ph: +61 8 9458 3889                                       86 Coolgardie Street
                                                                        BENTLEY  WA  6102



_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com



More information about the omnisdev-en mailing list