asked on

lock a Table

I'm working on a DBgrid and I'm having some trouble with a table : How can I lock the table for insert ? I would like to modify the existing records but I don't want insert new one. Second question : How can I check the data insered ?? If I set the EditFormat of a TIntegerField it doesn't work.

kretzschmar

hi gianluca,

if u use paradox or dbase or access,
you've nothing additional to for locking a record,
the bde does it for u.

what for an editformat did you apply?
(the editformat comes only during editing this field,
if you want it for display, then do it in the displayformat or displaymask)

meikl

gianluca

ASKER

I have a paradox table, I first add some record then (in another form) I just want the user change the value of this records, but I don't how to do.

yes, I want control what the user is editing, but editformat does not works.

kretzschmar

hi gia
can you show the editformat you want to apply?
meikl

gianluca

ASKER

I want limit the user edit to 3 digits, so I set the "editformat" of the TNumericField to "###", but in the DBgrid (that I use to edit the table) I can write anything (more than 3 digits).

kretzschmar

hi gia,

an editformat does not limit the input in a tnumericfield, it defines only the inputformat, unlike the editmask in a tstringfield.

to limit the input you can set the min and max property, which will validated by leaving this field.

meikl

gianluca

ASKER

Thanks kretzschmar for your answer; regarding the first question (how to lock a table) I don't know how to do it.

ASKER CERTIFIED SOLUTION

kretzschmar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial