Re: Newbie needs help with Dev 2K form

In article <369c9839.0_at_news.mountain.net>,   "Kenny Gump" <kgump_at_mylanlabs.com> wrote:
> Try executing the form and when you get the error message 'unable to execute
> query', click Help -> Show Error. It sounds like you have a non-database
> item in the block with the Database Item Property set to 'Yes'.
>
> Kenny Gump
> sarlettes_at_ria.army.mil wrote in message <77gcs4$sbb$1_at_nnrp2.dejanews.com>...
> >Hello,
> >
> >I am a complete newbie with Developer 2000. I have a program in Delphi 2
> >which has one screen which I would like to be accessible from the Web,
> >so I am trying to rewrite it as a Dev 2K form. The relevant tables and
> >fields are: (Oracle 7.3)
> >
> >AGENCY agencyno, agencyname
> >
> >EMP agencyno, empno, status
> >
> >VOLUNTEER empno, lname, fname
> >
> >HOURS agencyno, empno, hours_date, hours
> >
> >All the agencyno and empno fields are defined as number.
> >
> >First I would like to have a drop-down list of the agency names.
> >
> >Then I want a list of the names of people who work for the selected
> >agency -- select lname, fname from volunteer
> > where volunteer.empno = emp.empno and
> > emp.agencyno = <selected agencyno>
> >
> >Then I want to show a list of the hours records for the selected empno
> >and agencyno, which the user can update.
> >
> >I tried to set up a master-detail relationship agency -> emp -> hours,
> >but when I select an agency, I can't execute the query to get the emp
> >record. No explanation, just "unable to execute query".
> >
> >I would appreciate it if any readers of this newsgroup could help me
> >get started. I have a fairly good understanding of SQL, but I am
> >finding it difficult to get a handle on Dev 2000.
> >
> >Thanks very much,
> >
> >Sue Sarlette
> >
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

Thank you Kenny Gump, and George Giles who e-mailed me asking what version I have (it's Developer 2000 2.1). I started over, and simply created a data block for each of the 4 tables and didn't try to do anything with lists. I didn't get an error "unable to perform query" this time. I made Agency the master of Emp, and Emp the master of Volunteer and Hours. That way at least I can see the name corresponding to the selected Emp record. I would like to show the name in the Emp block as if it were a field of the emp record, so I could show more than one at a time (it's a tabular block with 5 records visible). I suppose I could create a view to do that. Is there any other way? In my Delphi program this was a DBGrid with a SQL statement as the data source.

Thanks again,

Sue Sarlette

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 13 1999 - 21:45:16 CET