Michael,
Just some ideas here, but it looks like a weird one.
1. Are you using buffered tables i.e is the initial select ignoring the
buffered updates?
2. If VFP9 and buffering problem suspected: SET SQLBUFFERING ON | OFF or add
the with "buffering=lExpr" to the select statement.
3. If you are using VFP9 try adding "rewrite" after the initial "into
cursor" for the initial select. This will force the result cursor to
physically exist on disk.
4. Have you got any other actual tables around named "curAppIDs3" - grabbing
at straws here!
5. If NOT VFP9 can you do the following (obviously in 9 you can do it also),
but worthwhile trying anyway:
Select distinct ;
TradingLoadHeaderID ;
from curLoads_tmp ;
where Val(LineType) = 3 and LineAccountID == lcOrgID ;
into cursor curAppIDs3
Use dbf("curAppIds3") again in 0 alias curResult
Select curResult
Browse
This gets the initial cursor open readwrite and the "select
curResult/browse" should see all the record. Now can you do "select * from
curResult"? If not then that is one WEIRD problem.
Just in case you didn't know already this allowed a cursor to be opened for
R/W access prior to VFP9 (or was it 8 which I never used).
Dave Crozier
"A computer is a stupid machine with the ability to do incredibly smart
things, while computer programmers are smart people with the ability to do
incredibly stupid things. They are, in short, a perfect match" - Bill
Bryson
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Michael Hawksworth
Sent: 13 July 2006 09:34
To: [email protected]
Subject: Re: Cursor problem
Dave
foxuser file makes no difference, the cursor is created from a sql select of
another cursor (below).
Select distinct TradingLoadHeaderID from curLoads_tmp where
Val(LineType) = 3 and LineAccountID == lcOrgID into cursor curAppIDs3
As you can see I have changed the name as well just to be sure it isn't
that.
:(
--
Michael Hawksworth
Visual Fox Solutions
[EMAIL PROTECTED]
www.foxpro.co.uk
[excessive quoting removed by server]
_______________________________________________
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
** 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.
