Howdy!

Search Problem:

I created a couple of records. No problem. When I go into View, Delete, or Modify, if I use one of the fields on the database form (select or otherwise) to search with I get: No Matching Records. These records do exist. (I can put the info in the Keyword Search field and the matching records will display.)

Modify Problem:

Same as related search problem above, but in addition, after I use a Keyword search to display the record I want to modify, the record is blank (no data from the record is displayed, just the blank fields).

I've posted the %db_def, sub html_record_form, & sub html_record information at:

http://thepitchergroup.com/DBMan/dbman.txt

Any help would be appreciated.

In your .cfg file:

For the last field remove the ending ,

Tray_Matrix_XxY => [109,'alpha', 10,30,0, '', '']

Same for how you defined your select, radio and checkboxes, remove the ending comma from the last selections

Tray_Matrix_XxY => 'DataA,DataB,DataC,DataD,Other'

Quality_ESD => 'OK,No'

Stop_Plate_PN_NA => 'Not Applicable'

------------------
In your sub html_record_form:

Text fields would be defined for example as:

<INPUT TYPE="TEXT" NAME="Date" SIZE="12" VALUE="$rec{'Date'}" MAXLENGTH="15">

Radio fields:

|; print &build_radio_field("Validated",$rec{'Validated'}); print qq|

Checkbox fields:

|; print &build_checkbox_field("Power Steering",$rec{'Power Steering'}); print qq|

Select fields:

|; print &build_select_field("Category",$rec{'Category'}); print qq|

Be sure that you have entered a field reference for each and every field you have defined in your .cfg file.

You may want to visit JPDeni's DBMan Tutorial site to learn how to define your fields and perhaps use her configurator which will automatically create your html_record_form and html_record setups for you. Then you can just adjust the display to meet your needs.

http://www.jpdeni.com/dbman/



Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Thanks Lois, I'll give it a shot.

Jeff