Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid row changes after calling a form
Message
From
31/05/2011 02:04:28
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01511669
Message ID:
01512297
Views:
89
Hi Robin,

I only use REPLACE for cursors (I use ODBC/Informix), so my POV might be a bit different, but when using REPLACE I always take care that VFP has the correct cursor in scope via the IN clause

REPLACE myField1 WITH m.myValue1, myField2 WITH m.myValue2 IN myCursor

but as an alternative you could use the UPDATE-SQL command to update the record.

UPDATE myCursor SET myField1 = myValue1 where myIndex = myIndexValue

>Hi Thomas
>
>I'm using REPLACE to save the details.
>
>>Hi Robin,
>>
>>as you use memory vars in the form, what do you do to write those values back in the grid cursor?
>>REPLACE , GATHER or something else?
>>
>>>Hi
>>>
>>>I have a grid on my 1st form that lists jobs.
>>>
>>>When a user clicks on one of the columns I run a modal form that allows the user to edit some of the jobs details for the row selected,
>>>
>>>The modal form uses memory variables
>>>
>>>I then save the changes, and release the form, the row changes to the 1st row in my grid on the 1st form?
>>>
>>>As a test I've even changed the form I call to an empty one, it still moves the grid row to the top?
>>>,
>>>
>>>I don't get it?
>>>
>>>TAI
Best Regards
-Tom

Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.

Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform