Time Clock-Code help

[russ Boehle]

Hi everyone,

I have the following code on a button "Punch In" on a form for a time clock app- this is in A5v5 b1050 but the problem is not alpha it's me I'm sure.
The e.punch_status.value="I" doesn't work.It generates an error that the field is locked because it is in use by another process and nothing is put in the field. The field Punch_status is on the form and shows in the object explorer.
I can post the form if necessary. I'm stumped (doesn't take much to stump me!)
Thanks in advance for your help.

'Employee enters employee number, if valid can press punch in or punch out
'of not valid empno pops up filtered lookup on employee where current(.t.) and hourly(.t.)
'can double click on name in lookup to enter empno in field.
'Clicking on punch in or punch out is now allowed.
'When click on Punch In:
'Save record in current form.
topparent.commit()

'put value in field DUMHOUR->EMPNO into variable VEMPNO
t=table.open("dumhour")
dim global vempno as c
vempno=t.EMPNO
t.close()

'Find out if employee "vempno" is punched in (employee->punch_status="I")
if Punch_status.value="I" then
ui_msg_box("Punch In?","Your Are Already Punched In!",UI_ATTENTION_SYMBOL)
end
end if

'do nothing if the empno field is blank
if empno0.value="" then
ui_msg_box("Employee Number","You must enter your employee number!",UI_STOP_SYMBOL)
end
end if

'Make an entry in the HOURSPR table
dim tbl as p
tbl = table.open("hourspr",FILE_RW_EXCLUSIVE)
tbl.enter_begin()
tbl.EMPNO = vempno
tbl.DATE_IN = Date()
tbl.TIME_IN = Time()
tbl.enter_end(.t.)
tbl.close()

e = table.open("employee")
e.change_begin()
e.Punch_status.value = "I" 'this doesn't put value in
e.change_end()
e.close()


'clean out dumhour
t=table.open("dumhour")
t.zap(.t.)
t.close()

parentform.Resynch()

[Steve Dentler]

RE: Time Clock-Code help

e.Punch_status.value = "I" 'this doesn't put value in
------------------------------
You're using a form method here instead of a table method.

Should be"
e.punch_status = "I"

[Peter.Wayne]

RE: Time Clock-Code help

steve is right, but even if you make his change, the code

e = table.open("employee")
e.change_begin()
e.Punch_status = "I"
e.change_end()
e.close()
will always change the first record in the
employee table. Is that what you want? isn't there more
than one record in the table?

[russ Boehle]

RE: Time Clock-Code help

Thanks,
Yes, there are more records in the employee table, I only want to change the current one -which is the one that is displayed on the form. The set is:
Dumhour
|--->Employee

The employee represented by the value un the empno field on Dumhour is the employee that is displayed on the form. I am using a dummy table for the parent so I can zap it after each punch so the next employee is presented a blank field in which to put his employee code. The link is on empno. This is my first try at something more complex than changing forms and setting indexes so I appreciate the help.

I can post the sets tonite if it would help to see them.

Russ

[Steve Dentler]

RE: Time Clock-Code help

I, too, agree with Dr. Wayne. I have no clue why this code works. Your opening a new instance of the table with the table.open command; therefore, the records are no longer synched--you're simply writing and reading from the first record. Unable to fathom your code, I simply indicated why your table write failed. I think you should review this entire procedure to see if it is doing what you really want it do.

[russ Boehle]

RE: Time Clock-Code help

I'll post the form as soon as I get a chance. I see why this wouldn't work as written so I'll try another method before posting it. I can see it'll take a while to get the hang of this.

Russ

[Peter.Wayne]

RE: Time Clock-Code help

you can just make it

Punch_status.value = "I"

assuming that punch_status is the name of the field
on the form. you will then be changing the value
of the field on the form, directly.
if the employee table is displayed as a browse and
not as fields on a form, you can write

e = table.get("employee")
e.change_begin()
e.Punch_status = "I"
e.change_end()

in the second instance "e" becomes attached to the
form's own pointer to the employee table, and is therefore
automatically on the right record. notice when you use
table.get() you do not close the pointer afterwards.

- peter

[russ Boehle]

RE: Time Clock-Code help

Thank you Peter
It now seems so logical! I'll do that. One thing though should I remove the parentform.commit or will it change the field regardless? I guess I shouldn't ask that question since I can try it to find out.

Thanks again
Russ