Pleased with SQL

[Terence Young]

Welcome to sql Das 😉

terry


Terence J. Young, DC

System Administrator

IT

(608) 280-2679

________________________________
From: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> on behalf of Das Goravani <das at Goravani.com>
Sent: Thursday, April 30, 2020 4:53 PM
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Subject: Pleased with SQL


A bunch of you said “Never looked back” about SQL conversion.

Now I agree.. I’m loving it and not looking back.

It only took mostly search replace code, that replaced Single File Finds, Finds, Nexts. Those were all replaced with code that does search and replace within my code. I’m going to share these methods.

Update Files took a personal touch because you have to figure out what files were changed, are being addressed by the Update Files.. too complex to do in code, for me anyways.

I only have a couple Search Formats and places where I have searches involving more than one find field.. so those I had to do manually and replace the search format or calculated search with WHERE statement generating code.

Bottom line is that if someone handed me the generic routines I’ve written for Single File Find, Find and Next.. along with the search and replace code… I could’ve converted within a day for most of it, and then update files taking a little longer to do them one by one. I did about one hundred of them by hand.

I’m just really pleased at how quickly the conversion went.. true I didn’t do it fully the way where all fields reference rows and lists.. in all code and on all windows.. I haven’t done that.. what I did was I do my SQL calls.. then I run a loop that spins the data out from the row to the CRB and I roll it back up into the row when it’s time to save to disk. Simple. I was worried something wouldn’t work.. would be restricted from me by some little fact of Omnis life, but no, it worked out great.. it’s working.. my app is working, and in SQL.. and you can barely tell any difference.. either speed or otherwise there’s no difference.. backend is backend.. you don’t see it upfront..

I’m SO PLEASED I am writing this to try to convey my joy.

Thanks to those of you who helped me figure things out on the way. I really appreciate you.

I’m putting the stuff I made to do it together in a single window, with the intent to share it as a little library, so others might benefit from my journey.


_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
If you received this e-mail in error, please notify the sender, delete the e-mail, and do not use, disclose or store the information it contains. This e-mail and any attachments may contain confidential information, including records protected by WI Mental Health 51.30 and/or AODA federal confidentiality rules (42 CFR Part 2) – both prohibit you from making any further disclosure of this information unless further disclosure is expressly permitted by the written consent of the person to whom it pertains or as otherwise permitted by 51.30 or 42 CFR Part 2. A general authorization for the release of medical or other information is NOT sufficient for this purpose. Federal rules restrict any use of this information to criminally investigate or prosecute any alcohol or drug abuse client.