Problem with XML form and QBE
Vince Callaway <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <CAL=AZZaX8xrj=FfgBiOYiuRoAee2sBFHKJn-rzJ4WjCra0PDAg@mail.gmail.com> |
This one took me FOREVER to track down.
So I'm playing with forms in VDC and data being returned in my test
was not as expected. So I did a pop up window with the generated
query. Found an oddity.
Here is some snippits:
The construct:
CONSTRUCT BY NAME where_part ON
railhead.yard_name, railhead.yard_location,
railhead.yard_address,
railhead.yard_city, railhead.yard_state, railhead.yard_zipcode,
railhead.yard_incity, railhead.yard_contact,
railhead.yard_phone,
railhead.yard_url
LET query_text = "select yard_name, yard_location, yard_address, ",
"yard_city, yard_state, yard_zipcode, yard_incity, ",
"yard_contact, yard_phone, yard_url from railhead
where ", where_part CLIPPED
In my form I have:
c = railhead.yard_incity, upshift, default="N";
What is happening is that the query_text gets a WHERE
railhead.yard_incity = 'N'. A closer look at the form shows that the
field is filled in on the screen during the construct. I had to blank
the field manually.
I tried adding WITHOUT DEFAULTS to the CONSTRUCT but that made no
difference. I've never had to use that with any constructs anyways.
Do I need to move default values into the program or is this a bug???
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/