At 12:52 AM 6/5/2010, Steve Breen wrote:
The only issue I am struggling with is that I only need two columns
from the table and one (notes) has to editable.
Basically you have to be able to read the history of the incident
and then edit the notes not the data and time as needed.
Steve,
Use the DB Grid with customized options to make the desired column(s)
"Read Only", and not the column for history of the incident.
In addition, update the R:BASE settings to "Show Hint" for NOTE column.
You can further customize the Cell Hint options as follows:
R:BASE eXtreme 9.0|Form Designer|Enhanced DB Grid Properties ...
Cell Hint [x]
Options | Background Color
Options | Font (Name, Style, Size, Effects, Color, Script)
When using EDIT USING formname WHERE clause ORDER BY clause ...
Double-clicking on the NOTE column will open the R:BASE BLOB Editor
with Note/VarChar option to update the editable data. After modifying
the data, clicking on the [OK] button will save all changes.
That should get you started.
Very Best R:egards,
Razzak.