Development Tools Forum

Re: How to use construct statement with formon....

Posted By: Mike Aubury
Date: Monday, 21 June 2010, at 9:52 a.m.

In Response To: Re: How to use construct statement with formonly f (Art Kagel)

I dont think theres any problem using FORMONLY fields in a CONSTRUCT - as the
table/columns can be specified separately from the fields (unless you're doing
a BY NAME).

Now - how much use that is - I dont know :-)
It really depends on what you want to use those fields for as part of the
CONSTRUCT.

FWIW - Aubit4GL has a "filter callback" you can use with a CONSTRUCT to
'adjust' whats actually put into the generated string :

....
CONSTRUCT lv_str ON a,b FROM a,b VIA c_callback
...

function c_callback(lv_tabname, lv_colname, lv_string,lv_dtype,
lv_dtypelength)
define lv_tabname char(18)
define lv_colname char(18)
define lv_string char(300)
define lv_dtype,lv_dtypelength integer

# you return with no values - the construct will complain with
# an error in field...
if lv_colname="a" and lv_string="456" then

return
end if

# Normally - we'd want to generate the construct portion -
# but with maybe different column names
# In this callback we want to map 'a' to be 'blah'...
#
if lv_colname="a" then

# aclfgl_get_construct_element takes 5 parameters

# tablename, column name, search string,

# datatype and datatype length(eg for decimal or character length)

let lv_string=aclfgl_get_construct_element(lv_tabname ,

"blah", lv_string , lv_dtype, lv_dtypelength)
else

let lv_string=aclfgl_get_construct_element(lv_tabname ,

lv_colname , lv_string , lv_dtype, lv_dtypelength)
end if

return lv_string

end function

You can therefore have fields in the CONSTRUCT which are never passed into the
generate string, but that you still have "seen" (maybe storing them in some
module level variables for example)...

On Monday 21 June 2010 14:19:54 Art Kagel wrote:
> I actually don't remember if CONSTRUCT will work pointed at a FORMONLY
> field, but even if it does, I don't think that the WHERE clause filters
> built for them would be useful. Do the FORMONLY field names correspond to
> database table columns? Are the datatypes the same or compatible with the
> table columns you would filter against? I would think that the constructed
> filter would name the columns as "formonly.fieldname" which would not
> correspond to real columns in any query anyway.
>
> I would just use INPUT and build the filters myself. Note that even for
> integer fields the formonly "construct" fields will have to be CHAR type
> unless you only permit the entry of discrete numeric values. In order to
> permit the user to enter lists, ranges, inequalities, or wildcards you will
> have to make the formonly fields CHAR type. You may also have to parse the
> input to determine if you are generating an equality, inequality, IN()
> clause, LIKE clause, or MATCHES clause.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated
> nor those of the entities themselves.
>
> On Mon, Jun 21, 2010 at 1:14 AM, K CHANDRA <chandra.kala00@gmail.com> wrote:
> > We have a construct statement on several fields in a table. We want to
> > add more fields that are formonly. If there a way to use the construct
> > statement
> > with few formonly fields along with table fields or do we have go for
> > input statement?
> >
> > Thank you,
> > Chandra.K
>
> ***************************************************************************
> ****
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> --000e0cd70dc2b3957604898a28b4
>
>
> ***************************************************************************
> **** Forum Note: Use "Reply" to post a response in the discussion forum.

--
Mike Aubury

http://www.aubit.com/
Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ

Messages In This Thread

• How to use construct statement with formonly field
  K CHANDRA -- Monday, 21 June 2010, at 1:14 a.m.
  • Re: How to use construct statement with formonly f
    Art Kagel -- Monday, 21 June 2010, at 9:19 a.m.
    • Re: How to use construct statement with formon....
      Mike Aubury -- Monday, 21 June 2010, at 9:52 a.m.
    • Re: How to use construct statement with formonly f
      RAVI PASUPULETI -- Monday, 21 June 2010, at 10:42 a.m.
      • Re: How to use construct statement with formonly f
        Mike Aubury -- Monday, 21 June 2010, at 10:53 a.m.
      • Re: How to use construct statement with formonly f
        Art Kagel -- Monday, 21 June 2010, at 10:59 a.m.
        • Re: How to use construct statement with formonly f
          RAVI PASUPULETI -- Thursday, 24 June 2010, at 8:59 a.m.
          • Re: How to use construct statement with formonly f
            Art Kagel -- Thursday, 24 June 2010, at 9:26 a.m.
          • Re: How to use construct statement with formonly f
            Jonathan Leffler -- Thursday, 1 July 2010, at 2:33 a.m.

Development Tools Forum is maintained by Administrator with WebBBS 5.12.