Subject DMD designer parameter syntax From Gaetano <gaetanodd@hotmail.com> Date Sun, 4 Oct 2020 06:14:53 +1000 Newsgroups dbase.getting-started Hi all, I was creating a DMD where the SQL statement of the ADO query includes calculated fields (e.g. [extract(month from eTimestamp) as mm]) and params. I had entered the params as params["nSite"].value = 1000000 ...etc. but the designer converted it to the following syntax. Any idea why params was converted to parameters? and what is the purpose or requirement of the "signed" property of a parameter please? I found something buried in the Help file under Classes_ADOParameter in Search, but it just shows a default value and no description. this.OADOQ = new ADOQUERY(this)     with (this.OADOQ)        left = 206.0        top = 77.0        width = 122.0        height = 128.0        database = form.so2ado1        connected = true        l0 = "select siteNum, eTimestamp, egen, econs, extract(month from eTimestamp) as mm,    extract(hour from eTimestamp) as Hours from energydata    where siteNum=:nSite and    extract(month from eTimestamp) between :nPstart and :nPend and    extract(hour from eTim"        l0 += "estamp) between :hStart and :hEnd"        sql = l0        with (parameters["nSite"])           signed = true           value = 1000000        endwith        with (parameters["nPstart"])           signed = true           value = 1        endwith        with (parameters["nPend"])           signed = true           value = 12        endwith        with (parameters["hStart"])           signed = true           value = 7        endwith        with (parameters["hEnd"])           signed = true           value = 18        endwith        active = true     endwith