Thanks guys, I grabbed this little gem off the internet - guy called Andy Kramek. Sounds pretty much just what you're doing Tracy. It's working a treat!
****The little gem*************************************** LPARAMETERS tcSql, tcAlias LOCAL lnSelect, lcSql *** Preserve Work Area lnSelect = SELECT(0) *** Cursor does not exist IF NOT USED( tcAlias ) *** Create it directly lcSql = tcSql + " INTO CURSOR " + tcAlias + " READWRITE" &lcSql ELSE *** Cursor does exist, use a safe select here lcSql = tcSql + " INTO CURSOR curdummy" &lcSql *** Clear and Update the woirking cursor SELECT (tcAlias) ZAP IN (tcAlias) APPEND FROM DBF( 'curdummy' ) USE IN curdummy ENDIF *** Restore work area and return status SELECT (lnSelect) RETURN USED( tcAlias ) *********************************************************************** All the best, Tina ----- Original Message ----- From: "Tracy Pearson" <[email protected]> To: <[email protected]> Sent: Thursday, August 20, 2009 11:35 PM Subject: RE: Quirks of using controls within a grid >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/d786eca199d547a09553cf91b666b...@tinapc ** 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.
