Compare Schema classes to database

Sten-Erik Björling s-e.bjorling at
Fri Sep 16 07:08:14 UTC 2022


Sorry for forgetting names - I use an approach presented by a Canadian professor at one of the Omnis events - defining the SQL row and list classes directly from the actual database model at the server. When choosing between the map and reality I choose reality. Those variables as templates are then stored in a core list after they also has been prepared for worker approach for data access. When I need a SQL row variable class I copy it from the list - use of $definefromsqlclass is three times more performance expensive than copying an existing row variable. Not great impact in fat client but might create heavy workloads in heavily used mobile app systems.

Take care, all the best..



Sten-Erik Björling
Enviro Data
Kyrkogatan 5A 2 tr
SE-972 32  Luleå

E-Mail: s-e.bjorling at
Mobile: +46-70-655 11 72
Wire: @stenerikbjorling
Skype: stenerikbjorling
iChat: stene at
Signal: +46 70 655 11 72
FaceTime: stene at
Telegram: @stenerikbjorling
Hotmail / Messenger: stenerikbjorling at
GMail: stenerikbjorling at

This email and any files transmitted with it are confidential, may be legally privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please note that any use, distribution, or reproduction of the contents of this email is strictly prohibited and may be unlawful. If you are not the intended recipient, please notify the sender by return email and destroy all copies of the original message including any attachments thereto. Thank you.

Please note that we take reasonable precautions to prevent the transmission of viruses; however, we cannot guarantee that this email or its attachments are free from viruses. We only send and receive emails on the basis that we are not be liable for any loss or damage resulting from the opening of this message and/or attachments.

> 15 sep. 2022 kl. 18:39 skrev Andrew Stolarz <stolarz at>:
> Hi All,
> Is there an easy way to compare my Schema classes in Omnis to my MySQL
> schema?
> Anyone else do something like this?
> Andrew

More information about the omnisdev-en mailing list