Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid row changes after calling a form
Message
 
 
To
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:
01515156
Views:
168
It seems that after coming back from my child form something is causing a grid refresh on my original form .

I've got around it by saving recno of my grid before calling the child form, then going to the recno in my grid from within the refresh method

Love to get to the bottom of this, but now it works don't suppose I will

Thanks everyone


>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
Rob
Previous
Reply
Map
View

Click here to load this message in the networking platform