Re: Newbie needs help with Dev 2K form

[Quoted] 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
Received on Wed Jan 13 1999 - 13:56:43 CET