I like to create the grid cursor in the form LOAD event (or grid INIT has
been used on a project or two) then a gridrefresh method
selects into gridtempcursor
select gridcursor
zap
append from dbf('gridtempcursor')
use in select('gridtempcursor')
It's more work, but the occasional grid layout going poof is cured.
Tracy
-----Original Message-----
From: Dave Crozier
Sent: Thursday, August 20, 2009 3:23 AM
Sounds like you are resetting the grid Recordsource.
Before you do the query set the recordsource to " " on the grid, then do the
requery and then set it to the cursor you have queried.
If this isn't the reason then is the combobox source an SQL Select or
another type such as alias or fieldlist? Knowing will help to solve the
problem but personally I would make the source an SQL select statement into
a discreet cursor.
Dave Crozier
-----Original Message-----
From: Tina Currie
Sent: 20 August 2009 06:41
Hi all,
First time posting to ProFox - hoping someone can help me as I've wound
myself into a bit of a knot with this challenge.
I have an order table and I'm grabbing a subset (by SQL query) into a cursor
that is readwrite. I use this cursor as the recordsource for a grid on my
form. Purpose of the form is to give the user ability to update 1 field -
they are assigning a truck driver to each order. The driver details are
from a drivers table and I'm using the firstname field as the rowsource for
a combobox within the grid.
User can choose what data to show in the grid by picking a date range from a
date picker control. Doing this runs the query again and updates the grid -
but every time this happens, I lose the combobox control in column2!
What am I missing?
TIA,
Tina
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/000601ca219b$15c4ffc0$414eff...@com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
