Subject Re: can I use a CDM the same way as I use a DMD? From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 28 Sep 2020 08:25:44 +0530 Newsgroups dbase.getting-started Good Morning Gaetano, Thank you for the custom data module. This was a missing piece of puzzle for me. Now the whole app can use the same connection string. No changing it in different places. I was using a public variable till now. > > Then in the DMD  - you'll recognize the SQL statement ;)  : >        sql = "SELECT test_site.siteNum,all_timestamps.etimestamp FROM > test_site,all_timestamps "+; >                  "WHERE concat(test_site.siteNum,' > ',all_timestamps.etimestamp) "+; >                  "NOT IN (SELECT CONCAT(siteNum,' ', etimestamp) FROM > energydata_temp) "+; >                  "AND all_timestamps.etimestamp BETWEEN :dStart and :dEnd" I remember the sql very well. The thrill of successfully building a difficult sql like this is unmatched. Regards Akshat