Capture function for a record instead of a field only

Applications Forms
#1

Dear all,

imagine to have a normal single row entry form (with lots of fields) and i.e. 20.000 records on table to look through (in my case it’s items/products table) and have to search a record to modify. Using next record arrow it’s crazy.

On normal single row form there isn’t a search button so I’ve attempted to use Capture feature (close to Id field) but it works well only on single field not for a record.
What I’m trying to do is search a record to modify and then with a “select” link to take it into the single row form. After that I will modify and save it again.

I’ve searched on samples too but it seems to me that all them are about only the field capture I mentioned above.

How can I implement my needing ?
Many thanks in advance
Giovannino

#2

Re: Capture function for a record instead of a field only

You can integrate filter with form.

http://www.scriptcase.net/phpgenerator/basesamples/basesamples.php

Making a capture linking with a filter
http://www.scriptcase.net/systems/v5/exemplos_en_us/search01/search01.php
You can change this field to be autocomplete …

see this example “search01” at the samples project.

#3

Re: Capture function for a record instead of a field only

@Diogo

I do not think this matches the given task as giovannino decribed.

As I understand, there is a form with one capture field. By capturing the field, the value of the selected field is written into the field. Focus is set to somewhere,nobody knows and thats all.
But it would be usefull, to capture not only the value of the field, which has the capture option but the whole record or some selected fields.

As workaround at the moment, it would be possible to set manually the focus to the field connected with the capture. Now the field also must have a blur event, which searchs the captured field in the database in order to get the record for the other fields.
Please do not forget to save the field value when entering the field with the capture option. You also have to check manually by code in the blur event if the value is changed or not. Otherwise the changes in the other fields might be overwritten, if you accidently enter and leave the field without capturing.
The onchange event does not work with capturing option. The system does not recognize that the field is changed.

BR

Eric

P.S.: that is the same problem or task as I asked in code after capture