Java Error in Nested Tab Find

Classic Servoy
1

I have a simple three level database: ‘main’, ‘line’, ‘inv’. This is an exploratory solution, with no real functionality, so it has extremely limited complexity. I have a form for ‘main’ that contains a tab panel showing a ‘line’ form with a tab panel showing a ‘inv’ form.

I do a find and enter data into a field in ‘inv’ in the two-level nested tab. When I click out of the field, the data I entered is replaced by: java.lang.Object@c70f32.

Anybody know what’s going on here?

Buck

2

That error if usually a result of trying to enter data into a empty record, are you sure you are in find mode?

3

ebrandt:
That error if usually a result of trying to enter data into a empty record, are you sure you are in find mode?

Yes, I’m in find mode. Good point about the empty record though. When I go into find mode, the first tab (line) shows 1 record, but the nested tab (inv) shows 0 records.

So that explains the error message, is there a reason why the request record is not generated for the nested tab?

If I go to the line layout and then enter find mode, there is a request record in the inv tab. So it’s definitely an issue with the tab inside a tab.

Buck

4

When you go into find mode on a form then you have 1 request available to type in. When you want to broaden your query to the related records (your nested tabpanels) then you need to create a new request (newRecord() function) for that relation. In that sense it’s no different than with FileMaker Pro.

Hope this helps.

5

ROCLASI:
When you go into find mode on a form then you have 1 request available to type in. When you want to broaden your query to the related records (your nested tabpanels) then you need to create a new request (newRecord() function) for that relation. In that sense it’s no different than with FileMaker Pro.

Hope this helps.

OK, that makes sense. So now I need to find a way to add a record/request while in Find Mode. I’ve been poking around and playing with my solution and I can’t figure out how to add a related record/request while in Find Mode.

Can somebody point me to instructions on how to do this?

Thanks,

Buck

6

just do another: controller.newRecord()

so like this:

controller.find()
//do a search here
field = 1
controller.newRecord()
//do another search here
field = 2
controller.search()

Or if you do it mannually than hit the CTRL-N button while you are in find-mode

7

HJK:
just do another: controller.newRecord()

so like this:

controller.find()
//do a search here
field = 1
controller.newRecord()
//do another search here
field = 2
controller.search()

Or if you do it mannually than hit the CTRL-N button while you are in find-mode

I need a manual find. Hitting CTRL-N creates a new request in the main table, not the nested tab table. I tried assigning a method to onNewRecordCmd that creates a record in the tab table, which works to create a nested tab record in browse mode, but creates a main table record in find mode.

Buck