WriteV (OpenInsight 16-Bit Specific)
At 07 JAN 2004 10:10:29PM Marty Rosenbloom wrote:
Hi,
I have a six column edittable. Column 1 to 3 are protected. Using the "Change" event, I am using WriteV to update the changes to columns 4 to 6. Columns 4 and 5 work correctly, but column 6 does not update the database.
After opening the table the following is part of the code being used.
WriteV Col6 On Table_Var, Key, 7 Else
Status=Set_FSError()End
How do I get Column 6 to update?
TIA,
Marty
At 08 JAN 2004 04:42AM [email protected] wrote:
Have you dropped to the debugger to see what the value of Col6 is before writing?
My guess is that what you think you are writing is not what you are writing.
Phone: 971-570-2005
OS: WinXP Pro
OI: 7.0
At 08 JAN 2004 08:27AM Marty Rosenbloom wrote:
Hi,
After much ado I have checked the debugger (see other post). The Newdata is correct, but the Rowdata collected is from the next row after the cursor moves. Columns 4 and 5 update the table correctly. I suspect further or different coding is needed for the last column.
Marty
At 08 JAN 2004 08:32AM [email protected] wrote:
It sounds like a mixup of SELPOS.
On Poschange SelPOS=where the focus has gone to. You will want to look at prevSelPos and compare with SelPos .. this lets you decide if you have a row or column change. IF row change then you want to use prevSelPos as it points to the last row it was at
Phone: 971-570-2005
OS: WinXP Pro
OI: 7.0
At 08 JAN 2004 05:32PM Marty Rosenbloom wrote:
That is exactly what I ended up doing. I used the SELPOS property and everything is doing as planned.
Thanx,
Marty