Small Problem in Oracle Forms Developer

[Dazza203]

Hi,

I have a small problem with a form I am trying to create in Oracle Forms Developer. I have uploaded the 2 files here as a zip:

http://www.geocities.com/bobothechimp2001/d7.zip

When I try running it in Internet Explorer from the traffic light button I get a compile error. It looks simple to fix, or so I thought. I've now spent 2 hours trying to fix this. It looks like just a variable name problem, but I can't figure it out. Any help with this would be appreciated.

Thanks,
Darren

 

[Dazza203]

Hi,

Sorry I can't believe I didn't think of adding my database schema, nobody can help me without
that. At

http://www.geocities.com/bobothechimp2001/db.zip

I have now also added an SQL file
with all my tables, data and constraints so that u can re-construct my database, and of course
the form files are there too in that zip file I have now got the form to open without any
errors in Internet Explorer and I know that I am close with this. When you open it in Internet
Explorer is should be fairly obvious what I want it to do. I have linked the tables in Oracle
Forms Developer using the same keys that I used when I constructed my schema in SQL PLUS, but
when I select a value from the combo box when I run the form in Internet Explorer, the other
fields representing the other attributes from other tables do not change depending on the
value selected in the combo box. I am trying to do a query if you hadn't already guessed. What
I'm talking about will all come clear to anyone that looks at my form in Oracle Forms
Developer and my relationship schema. I know I am very close with this.

Thanks,
Darren

 

[sem]

I don't understand you. How do you compile it from IE???
Can you provide an error message? I don't have time to probe into your code.

Regards, Dima

http://seminihin.narod.ru

 

[Dazza203]

No, the form runs without errors in Internet Explorer now, the problem is that the query does not work, and I cannot find any reason why it shouldn't. I have linked all the tables needed for the query using the Data Block Wizard, but when I select a value from the combo box the other fields from the other tables in the form do not change accordingly. There is not that much code involved and I know I am very close with this.

Thanks,
Darren

 

[sem]

Do you expect that values should change accordingly? Do you change them from trigger? Do you requery that block and apply a new condition based on combo value?

Regards, Dima

http://seminihin.narod.ru

 

[Dazza203]

Yes. I was given a template that was used with another database so it looked like all I had to do was re-create it but with my database. I do not know a lot about Oracle Forms Developer as I have not been using it long.

Thanks,
Darren

 

[sem]

Yes what?

Regards, Dima

http://seminihin.narod.ru

 

[Dazza203]

Yes to your questions in your last post. It's impossible for you to help me without you looking at my code. There's not much of it.

Thanks,
Darren