Subject Re: DMD designer parameter syntax From Ken Mayer <dbase@nospam.goldenstag.net> Date Sat, 3 Oct 2020 13:22:48 -0700 Newsgroups dbase.getting-started On 10/3/2020 1:14 PM, Gaetano wrote: > > 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. The designers don't handle custom code well, and the reason for params being changed is most likely because of some internal code that streams out the program. Suggest you use the onOpen event handler (or even the canOpen) to set the parameter the way you need it to be set. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm