Answer Questions

• Floele Visual Foxpro tables locked by aspnet_wp.exe process

  Hi! I'm currently using Visual Foxpro 9.0, .NET Framework 1.1, Visual Studio 2003 (VB) for web development. Everything's fine except this little 'quirk'. When i'm doing some testing, and try to open a table with VFP, i have the following message :File access is denied .... with the path of the table. The first solution i found (not very practical in a running environment) is to run a cmd-line and type iisreset to release any ...Show All

• don wingate please interprete this error

  I opened up VFP9err.log file and found a few messages. They are infrequent, I get them about twice a month. They are all the same. What does it mean I think it talks about an OLEdrag. What kind of drag is it Could you explain in detail. Many thanks. Fatal error: Exception code=C0000005 @ 01/11/06 03:21:54 PM. Error log file: C:\Program Files\Microsoft Visual FoxPro 9\vfp9err.log Called from - toolbox.o_1ph0wtk58.otoolcontainer.o_1ph0wtk8t.cmd ...Show All

• Pavel Dournov - MSFT Checking for Additions to a .dbf File

  All, I am wanting to build an interface of sorts for a phone messaging application.  The app writes call entries to a .dbf file that I would like to monitor for additions. Once an addition is made to the table, I would like to insert a new record in to a SQL table and change a status field in .dbf table record to establish that that the new record in SQL was written. My original thought was to use a Linked Server via SQL to the .dbf file. ...Show All

• DCProven A report where deleted record aperas diferent

  Can I do a report where the record that market Deleted (and Set deleted is OFF) to apears in diferent way (diferent color, italic text, etc) Thank you. There's a Report Listener in the Solution Samples that will give you exactly what you want. I wrote about it in the March FoxPro Advisor: http://msvfp.advisorguide.com/doc/17550 Tamar oTestRL = NEWOBJECT ("myRL ...Show All

• WhPonds How using barcode in VFP?

  Hi! Help me use barcode in VFP use ActiveX controls Where download it Thanks! Hi!    No programming done for you to capture a barcode no., what you will do is just to connect the barcode reader device to the CPU on the keyboard port and look for the manual attached to trigger the device. -Dodo Roa- Hi, This is true, but most of us don't like the tedious task of hitting the ...Show All

• batub Visual Foxpro Book Recommendations?

  All, Can anyone recommend a good book for learning VFP 6.0 from scratch   I've looked at SPECIAL ADDITION USING VISUAL FOXPRO 6 but it's not really helping me so far.  All I am trying to do is create a simple .exe that will read amd update some records from a .dbf and insert those records into a MS SQL table.  All the books on Amazon have gotten terrible reviews and MSDN has little to no info on doing thi ...Show All

• talbers report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All

• Ron Beck How to upgrade a menu from FoxPro for DOS

  I'm a very old, retired, CCOBOL and ASSEMBLY programmer with some experience with dBase and FoxPro from the command window. A charity has asked me to get an old FoxPro for DOS program working on a donated used computer which contains VFP6.0. I have gone over the data files and they seem to be OK. The indexes have been converted to CDX type and that works. The old DOS program worked by relying on append and browse commands which all work. The nee ...Show All

• Brian Cheek - MSFT Execute foxpro program using VB.NET

  Hi, I've been trying to execute a program using VB.Net. I read the documentation on the VFPOleDB driver and it mentions the implementation technique. The problem is that all the files are free tables and not associated with a database. So I tried to execute the program by placing it in the same folder as the table on which i was working on. I used the following code to do this: 'Program name: displayRecordset, Procedure name: getRecordset ...Show All

• geraud c Error using SQL to populate grid

  I have a 9 column grid that I'm trying to populate using an SQL statement in the RecordSource property of the grid.  The statement works fine if I only use 8 fields, but when I try to add the ninth field, in any order, I get a "Command contains unrecognized phrase/keyword" error. This statement works -     thisform.grdmatching.RecordSource="select main.main_id, main.prepdate, ;     main.reqby, act.desc, main.e ...Show All

• Sabbadin help~!

  Hi everyine i want to learn about cursoradapter class. for instance ,how do i can browse, modify, add, deleted, restore data into table by using CA.then could you tell where i can find the materials of CA.;=) thank you Jet Go to http://www.mctweedle.com and click the FoxPro Tools link. You can download a file that contains examples. You can also look at my CA builder that will create a class library with a CA for every table you ...Show All

• tomsmi like command

  hi again,i have the below simple line of sql code local temp temp=thisform.TextBox1.Value SELECT costomer from customertable; WHERE costomer_description LIKE temp the command works perfectly and i get the results in a new vfp window. is there a way to change the command in such a way so that i get the recno of the result.the reason is because there is already a grid on the form and i guess that if i had the recno from the select command i could ...Show All

• gray-team editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All

• Kazuryu C. sdtFont object

  I need to create a stdFont object. Once at one computer I was able to do it in the command window" X = CREATEOBJECT ("stdFont"). Once I put a period behind "X." the IntelliSense menu appeared and gave me a list of properties. When I tried to use it in a method I got an error message that the " class definition STDFONT was not found ." At another machine I cannot get it to work even in the command window. Which ...Show All

• KHaines how could i shortened the time of looping in an SCAN...ENDSCAN?

  i have here a part of my code below which work fine for me...but the only problem is that it takes time to show the result. My product profile has only 8,500 records & the tables that were search for exact match has approximately 50,000 or more records added every month. Maybe my coding is not the right way. Can anyone teach me the right code just to shortened the time in accessing the actual output. LOCAL EachItemPurchases, lcpurchases, ...Show All