VisualFoxProWiki http://fox.wikis.com Wiki for Microsoft Visual FoxPro development, software engineering, and object-oriented software development using Visual FoxPro. en-us Wed, 01 Sep 2010 10:07:08 EST Copyright 1999-2010 Steven Black Consulting. Visual FoxPro 09.00.0000.2412 for Windows 30 VisualFoxProWiki http://fox.wikis.com http://fox.wikis.com/foxpaw.gif OpportunisticLocking http://fox.wikis.com/wc.dll?Wiki~OpportunisticLocking 2010.09.01-http://fox.wikis.com/wc.dll?Wiki~OpportunisticLocking Win9X, Win 2 K, etc.? Specifically, any best practices for managing this setting in a network environment?

We continue having infrequent strange messages show up in our application error log that defy any logic and are not readily re-producible.

We've exhausted all sorts of general network issues being the cause.

Such things as trying to "USE somedbf SHARED IN 0" and getting "file in use by another" when we know darn well the table is not opened exclusively anywhere else, etc. Or "memo file missing/invalid" - but there is absolutely nothing wrong with the memo file. Simply trying to launch the app again and it works.

These type of errors typically show up during application startup - like early in the AM when several users would be logging in around the same time. I've been coming across bits and pieces of information about opportunistic locking but I'm not sure I want to try and remotely administer this change at the client site due to it involving registry settings at the server and/or client PC. What would be ideal would be programatically turning it off at the client during application startup if it is determined to be on. Any suggestions on Win API calls to make to read the current setting and if on, turn it off?

What I'm really looking for are stories where turning opportunistic locking off causes other problems? For instance, can it hurt SQL Server performance/stability?

Any thoughts or feedback is appreciated. Please re-factor into document mode as other input arrives.

class= You should check out UT Bug List ID # 26 and #30. NOT re 'opportunistic locks' but mention your symptoms. Good luck. ]]> Wed, 01 Sep 2010 10:07:08 EST ApiStructures http://fox.wikis.com/wc.dll?Wiki~ApiStructures 2010.09.01-http://fox.wikis.com/wc.dll?Wiki~ApiStructures Q: In VFP, how do I pass a pointer to a structure?
A: Pass by reference a string that contains the structure.
Either: ]]> Wed, 01 Sep 2010 07:48:48 EST ChristofWollenhaupt http://fox.wikis.com/wc.dll?Wiki~ChristofWollenhaupt 2010.09.01-http://fox.wikis.com/wc.dll?Wiki~ChristofWollenhaupt FoxPro development. He writes the FoxPro Advisor Answers column with Tamar Granor and Pamela Thalacker and has contributed several articles to the magazine. He is also a Sysop on the CompuServe MSDEVAPP forum and a Microsoft Most Valuable Professional since 1997.

[UPDATED] At ProLib, he is the Lead programmer of the AFP development team (Active Foxpro Pages)

Formerly also known as "Christof Lange", he changed his Lastname after his marriage in May 2004.

Christof Wollenhaupt
Foxpert Software Development and Consulting
Apmannsweg 21
22846 Norderstedt
Germany

Telephone: +49-40-68267080
Fax: +49-40-68267082
EMail: Christof.Wollenhaupt@foxpert.com ]]> Wed, 01 Sep 2010 07:47:24 EST CompuServe http://fox.wikis.com/wc.dll?Wiki~CompuServe 2010.09.01-http://fox.wikis.com/wc.dll?Wiki~CompuServe the place for Software support before the internet became popular. The CompuServe VFox Forum is probably the best threaded environment because of its very high Signal To Noise Ratio compared to NewsGroups.

Of course, when you are paying $30 an hour to access a service like this, you don't fool around and chit chat. CompuServe has since moved to a much more reasonable monthly flat rate since then, but it was only in response to the internet and much lower access fees which caused many software companies to establish much less expensive and accessible web support pages.
You must be in Europe :-). CompuServe cost me maybe $50 a week back when I was online all the time. Yes, it's true that a metered service is more seriously used, and that's no bad thing. Regardless, CompuServe was cheap at three times the price, and I never regretted a dime I spent online, and I'm sure a majority of experienced developers would agree.-- Steven Black
class= I'd certainly agree re this. Those CompuServe days were salad days. -- John Ryan ]]> Wed, 01 Sep 2010 07:45:02 EST LarrySerflaten http://fox.wikis.com/wc.dll?Wiki~LarrySerflaten 2004.08.05-http://fox.wikis.com/wc.dll?Wiki~LarrySerflaten LARRY SERFLATEN

Born and raised in Minnesota, I studied electronic product repair for 2 years right out of high school and spent a few years after that in the manufacturing field with local giants like Honewell and Sperry. I joined the Armed Service in 1981. While touring in Germany, I purchased my first ATARI 800 home computer and began experimenting with its Basic language to write simple programs. Out of the service in 1985 I enrolled at Brown Institute Campus (MPLS) to study for an Associates degree in computer design and repair. I started playing with VB (Microsoft Visual Basic) in 1995 with Version 3. In 2000 I passed the MCP exam (Desktop VB6) and by 2004 I was awarded Microsoft's MVP status for my participation in answering technical questions in their Visual Basic newsgroups. Programming is still more or less, my hobby! Another pass-time I enjoy is playing electric guitar. I sound pretty good when playing along with the older 70's and 80's era tunes! As of JUL 2010, I can be reached via email using the address serflaten@gmail.com ]]> Thu, 05 Aug 2004 10:00:47 EST VisualFoxProDataFromSQLServer http://fox.wikis.com/wc.dll?Wiki~VisualFoxProDataFromSQLServer 2009.05.27-http://fox.wikis.com/wc.dll?Wiki~VisualFoxProDataFromSQLServer minor changes
You can query VFP data in SQL Server using the Ole DB driver

Example 1: Querying VFP free tables from SQL Server. Run the following code in QueryAnalyzer/SSMS. 
-- Example of using VFP free tables in SQL Server
sp_addlinkedserver @server = 'VFPoledbDbf',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB.1',
@datasrc = 'C:\VFP9\Samples\Data'
GO
SELECT * FROM VFPoledbDbf...products
GO
sp_dropserver @server = 'VFPoledbDbf'
GO


Example 2: Querying a VFP DBC from SQL Server. Run the following code in QueryAnalyzer/SSMS. 
-- Example of using tables in a VFP DBC in SQL Server
sp_addlinkedserver @server = 'VFPoledbDBC',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB.1',
@datasrc = 'C:\VFP9\Samples\Data\testdata.dbc'
GO
SELECT * FROM VFPoledbDBC...Products
GO
sp_dropserver @server = 'VFPoledbDBC'
GO


Example 3: Querying a VFP free table from SQL Server without using a linked server. Run the following code in QueryAnalyzer/SSMS. 
select * from openrowset ('VFPOLEDB.1', 'c:\vfp9\samples\data'; ' '; ' ','select * from customer')


Example 4: Querying a VFP DBC from SQL Server without using a linked server. Run the following code in QueryAnalyzer/SSMS. 
select * from openrowset ('VFPOLEDB.1', 'c:\vfp9\samples\data\testdata.dbc'; ' '; ' ','select * from products')


If SQL 2005 Express Provider not work correctly: 
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB.1', N'AllowInProcess', 1

]]> Wed, 27 May 2009 10:26:28 EST BlogWatch http://fox.wikis.com/wc.dll?Wiki~BlogWatch 2010.08.29-http://fox.wikis.com/wc.dll?Wiki~BlogWatch Corrected Calvin Hsia's RSS feed link.

Links to blogs that have something to do with VFP, or by VFP folks


Active Blogs See also Twitter Gallery /
Author Home Page Feed
Alex Feldstein http://feeds.feedburner.com/blogspot/alexfeldstein/
Andrew Coates class= http://blogs.msdn.com/b/acoat/ class=
Andrew MacNeill - AKSEL Solutions http://akselsoft.blogspot.com/
Andrew MacNeill - Learning Visual FoxPro http://learningvfp.blogspot.com/
Andrew MacNeill - Fox Show Pod Cast http://www.thefoxshow.com/
Andy Kramek http://weblogs.foxite.com/andykramek/
class= Arnon Rotem-Gal-Oz http://www.drdobbs.com/blog/bioPages/author/Arnon/index.jhtml
AtoutFox http://www.atoutfox.org/
Beth Massi http://blogs.msdn.com/b/bethmassi/
Bernard Bout - Making VFP look cool. http://weblogs.foxite.com/bernardbout
Bo Durban http://blog.moxiedata.com/
Boudewijn Lutgerink http://weblogs.foxite.com/boudewijnlutgerink/
Calvin Hsia http://blogs.msdn.com/b/calvin_hsia
class= Cathy Pountney http://cathypountney.blogspot.com/
Cetin Basoz http://cetinbasoz.spaces.live.com/blog
Christof Wollenhaupt http://www.foxpert.com/knowlbits.htm
John Koziol - Gonzo Maximus Blog - Musings on VFP, SDLC, and whatnot http://gonzmax.blogspot.com/
Chris Sainty http://csainty.blogspot.com
Craig Bailey Main blog http://blog.craigbailey.net/
Craig Berntson http://www.craigberntson.com/blog class=
Craig S Boyd http://www.sweetpotatosoftware.com/SPSBlog/
Dave Bernard http://davebernard.blogspot.com/
Dave Crozier http://www.replacement-software.co.uk/blog
David T Anderson http://detah.blogspot.com/
David Stevenson http://talkingfox.blogspot.com/
class= DeCiacco.com Blog http://deciacco.com/blog/
class= Del Lee http://deltonlee.blogspot.com/
Doug Hennig http://doughennig.blogspot.com/
Esparta Palma http://weblogs.foxite.com/esparta
Franklin Garz�n http://weblogs.foxite.com/fgarzonhz
Frank Perez http://www.pfsolutions-mi.com/blog/default.aspx
class= Nancy Folsom http://nancyfolsom.wordpress.com/
Foxite Community Blog -- All http://weblogs.foxite.com/
class=Guineu Release Blog http://guineu-blog.blogspot.com/
Richard Camelo K. Base - foxpro.catalyst http://foxpro.ntsl119.com/scr/
class= Joel Leach http://weblogs.foxite.com/joel_leach/default.aspx
Ken Levy http://blogs.msdn.com/b/klevy/
Kevin Cully class= http://cully.biz
Kevin McNeish http://msmvps.com/kevinmcneish/
Kevin Ragsdale http://kevinragsdale.net/
Jochen Kirst�tter (aka JoKi) class= http://jochen.kirstaetter.name/
Juan Calcagno http://blog.jlcconsulting.com/ class=
Kok Kiet John Jones http://weblogs.foxite.com/kkchan/
class= Lisa Slater Nicholls http://spacefold.com/lisa/
Martin Salias http://msalias.blogdrive.com/
class= Martin Pirringer MYSQL Blog (VFP -> MYSQL migration) http://pirringers.com/mysqlblog/
Matt Slay http://mattslay.com/blog
Maurice De Beijer http://msmvps.com/blogs/theproblemsolver/default.aspx
Nadya Nosonovsky http://blogs.lessthandot.com/index.php/All/?disp=authdir&author=218
Patrick Bibro BROKEN: http://bibro.blogspot.com missing
Paul McNett http://paulmcnett.com/cgi-bin/blosxom.cgi
Paul Mrozowski http://www.rcs-solutions.com/blog
class= Philadelphia VFP User Group http://vfpphilly.blogspot.com/ class=
ProSys Plus ( Hank Fay ) http://www.prosysplus.net/blog/pspblog.html class= Offline
Rahul Desai http://RahulBlog.nationalcom.com
Rick Borup http://rickborup.blogspot.com/
Rick Schummer Shedding Some Light v2.0 class= http://www.rickschummer.com/blog
http://rickschummer.com/blog2/index.php class=
Rick Strahl General/.NET http://www.west-wind.com/WebLog/default.aspx
Rick Strahl FoxPro/Web Connection http://www.west-wind.com/wconnect/WebLog/default.blog
class= Rod Paddock OLD: http://blogs.officezealot.com/rod/
NEW: http://codebetter.com/blogs/rodpaddock/Default.aspx
Ronald Ramirez Moran http://weblogs.foxite.com/dlanorok
Sergey Berezniker class= http://sergey.berezniker.com
Simon Arnold http://weblogs.foxite.com/simonarnold/
class= Southwest Fox http://www.swfox.net/blog/
Stephen Bodnar http://www.geeksandgurus.com/blogs/sjb/
Steve Davis http://foxpro-optimal.blogspot.com
class= Steve Ellenoff http://sellenoff.blogspot.com/
Stuart Dunkeld http://weblogs.foxite.com/stuartdunkeld/
Ted Roche class= http://blog.tedroche.com/
Tod McKenna TodMeansFox http://blog.todmeansfox.com. class=
Visionpace Blog http://blog.visionpace.com/
VFP Imaging - GDI+ articles and tips http://weblogs.foxite.com/vfpimaging/
VS DATA Team's Blog http://blogs.msdn.com/b/vsdata/
F 1 Technologies http://f1technologies.blogspot.com/
Randy Jean http://www.randyjean.com
Tom Borgmann Tom's VFP Blog (in German) http://tomsvfpblog.blogspot.com/
Tom Meeks' Beginning Visual FoxPro Tips http://vfpstart.blogspot.com/
William Sanders TerraFox Publishing http://www.terrafox.net/ class=
Victor Espina (in Spanish / en Espanol) http://vespina.blogspot.com/ (not available at this time)
Y Alan Griver http://blogs.msdn.com/b/yag/
Alan Stevens http://netcave.org/
Walt Krzystek http://wkrzystek.blogspot.com/
VFP Developers http://visualfoxpro-developers.com/blog/
Vassilis Aggelakos http://weblogs.foxite.com/vassilisaggelakos/
Mark Gordon http://dotbloat.blogspot.com
Portal Fox (In Spanish) class= http://www.portalfox.com
Planet FoxPro class= http://www.tedroche.com/planetfox/
foxpro rss feed agregator
wOOdy's Blog (in German) class= http://woody-prolib.blogspot.com/
]]> Sun, 29 Aug 2010 08:56:23 EST