Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT buffering and related parameters
Message
From
06/03/2006 22:23:19
 
 
To
06/03/2006 14:05:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01101595
Message ID:
01101926
Views:
11
Hi Michel,
You can check the options thru VFP system menu
1)"tools"->"options..."->Tab "Data"->item "Buffering",should be OFF better.
2)"tools"->"options..."->Tab "Remote Data"->item "Records to fetch at a time","Maximum records to fetch","Asynchronous execution"-be unticked usually.Or you can check the SQl connect handle settings "Asynchronous" and "BatchMode" with SQLGETPROP()
3) check if there is any Trigger on the SQL table impacting your Select result.
I supposed you are quite familiar with them,but easy to ignore checking them.
To verify the buffering issue,you can also try to execute the SQLEXEC() into different cursors such as test1,test2 ...,and observe the results.
above is all i can bethink of, just a clue for you.

quote
----------------------------------------------------------------------
To provide the proper environment, here it is:
lnHandle=SQLStringConnect(gaConnectionString[3])
SQLExec(lnHandle,'SELECT Video.Numero,Video.Active,Video.Date,Video.Notes_A,'+;
 'Video.Notes_F,Video.Running,Video.Title,Video.Type,Video.Amount,'+;
 'Master.FirstName,Master.LastName,Video.Language,Video.NoMaster,Video.NoMaster2,Video.NoMaster3,Video.NoMember '+;
 'FROM Video '+;
 'INNER JOIN Master ON Video.NoMaster=Master.Numero '+;
 'INNER JOIN Favorite ON Video.Numero=Favorite.NoVideo '+;
 'WHERE Favorite.AddUser='+ALLTRIM(STR(gnMember))+' ORDER BY Video.Title','test')

addjavascriptmessage(STR(RECCOUNT()))

a='SELECT Video.Numero,Video.Active,Video.Date,Video.Notes_A,'+;
 'Video.Notes_F,Video.Running,Video.Title,Video.Type,Video.Amount,'+;
 'Master.FirstName,Master.LastName,Video.Language,Video.NoMaster,Video.NoMaster2,Video.NoMaster3,Video.NoMember '+;
 'FROM Video '+;
 'INNER JOIN Master ON Video.NoMaster=Master.Numero '+;
 'INNER JOIN Favorite ON Video.Numero=Favorite.NoVideo '+;
 'WHERE Favorite.AddUser='+ALLTRIM(STR(gnMember))+' ORDER BY Video.Title into cursor temp1212'

&a
addjavascriptmessage(STR(_tally))
This is access after I have done an insert, and update or a delete in the table. So, we are just seconds away from the most recent change. In the test I am doing, I just inserted a record in the table Favorite by the use of SQLExec(). As you can see, the first SQL is done with SQLExec() and it returns 4. However, the second SQL is done locally and it returns 5. If I redo the same query for the next two minutes, sometimes the SQLExec() will return 4 and sometimes 5. But, the local SQL will always return 5, which is the correct number of records. After two minutes, the SQLExec() will always return the proper number of records, thus 5.

I have never seen anything like this. This is the lowest common denominator I can use to simulate the environment. Do you know what could be in cause here?
----------------------------------------------
unquote
Steven
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform