General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a table : Contracts
In a form I have a button: Add
Code of button Add:
***
SELE contracts
APPE blank
flush
recnu=recno()
thisform.pageframe1.page1.txtRate_sc.readonly=.f.
thisform.pageframe1.page1.txtRate_ro.readonly=.f.
thisform.pageframe1.page1.add.enabled=.f.
thisform.pageframe1.page1.save.enabled=.t.
thisform.pageframe1.page2.enabled=.f.
thisform.pageframe1.page3.enabled=.f.
go recnu
thisform.pageframe1.page1.refresh
thisform.refresh
***
However when I am trying to Input data in the fields txtRate_sc and txt_Rate_ro Fields are getting disabled, sice through experimenting with wait windows in buttons i found out that the recno() is jumping to EOF for some reason! ... ex. if a record was appended on 400 and I check what is the recno after I click on the Add button, i found that it is on 401!!! therefore Input can't be done!!
can any one help me please?!!?!?!
Thanx!!!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only