Answer Questions

• ClaudiaHelpOnVSTO FoxPro9.0 Report - View all the records resulting from a sql query

  Dear friends, My sql query based on a table customer_charge has two fields currency and total, so I am requesting a query which is like this: select distinct currency as value, sum(total) from customer_charge group by currency which gives the result of each currency and its total summed. Good this is what i need, but how to get the result displayed in my report, I have just created two fields in my report . Presently I am able to see only one record of the result in my report, how to get all the records viewed in the report. currency total EUR 1256.00 GBP 1254.00 Thanks Satish Probably rep ...Show All

• inzel Font Size Randomly Changing

  Has anyone experienced a problem in a FoxPro 9 application, where the font size of some controls on a form change It could happen going from form1 to form2, or form3 to form2.  The size changes from 9 to 8, 12, or 18. There doesn't seem to be a pattern, and it could happen today day and not happen for several days later. It could be a themes issue. Try setting _Screen.Themes = .F. at the beginning of your code. Tamar Was this an older Fox 2.6 for Windows application that was ported to Visual FoxPro When the application was converted to FoxPro 9, _screen.Themes was set to False in the main.prg. gdiplus is an option we have not explored. Is there a specific versi ...Show All

• Bertrand Caillet Clip art suitable for VFP 9

  Hello -- I am just starting out with 9 (have done just a little in 7 before). I am going systematically, creating classes now. The first problem I came across was where to get (free, preferably) graphics files (.bmp mainly) that would be fit for menu buttons and the like (e.g. the exit symbol, a man running towards/though a door). I do not think the .bmp files in VFP9 are enough. I know, this is a simplistic question, but it is important to me. Thanks in advance for your help. Hans L Philip, I'll try it. Thanks. Hans L Not in this case. Users become used to how things work and then use that. A different way many times confuses them. While Microsoft does not have the bes ...Show All

• fschaller How to calculate the data connection time?

  I tried to add 2 fields, time_on, datetime, time_off, datetime to calculate user's log on time in the Users.dbf. How do I calculate the total time between the 2 value Any better way to capture users' activity Thank you, you are right. it works in VFP9. Standard dateTime type, can be any date, any time. Thanks. You may create a clock like: http://support.microsoft.com/kb/139390 and start it when user log on ... Thank you for both of your replies. Can I wish to do is hide the timer codes, somewhere so that user won't notice. I figured out this formula, could you verify for me a=time_on b=time_off x= ...Show All

• Attila Fogel reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle first get the list of files from your directory into a dbf/cursor crea table xxx ; (tblnm c(8),delflag c(1)) && create a temp table to store table names and flag to store whether to be deleted or not sele b use xxx shared alias xxx &&open that dbf DIMENSION TEMPARRAY(1,5) && declare array to store table names =ADIR(TEMPARRAY,"c: ...Show All

• DavidShen IntelliSense - Unique Key

  I would like to add a new code definition for IntelliSense (I'm using VFP 7) I inserted everything into the FoxCode.dbf except for the uniqu identify key, how do i know which one is next, and is this the right way ...I just want FoxPro to insert: 'ebParm(13)' whenever i type 'ebp ' Spangltk wrote: I would like to add a new code definition for IntelliSense (I'm using VFP 7) I inserted everything into the FoxCode.dbf except for the uniqu identify key, how do i know which one is next, and is this the right way ...I just want FoxPro to insert: 'ebParm(13)' whenever i type 'ebp ' You don't really need a UniqueId for custom records: the Intellisense Manager doesn't add one when you use it. Any pa ...Show All

• Jeremy Jarrell Converting a DAT file into a BDF file

  Hello all I am trying to import a file into FoxPro, it has a DAT extension, is there any way I can convert this to a DBF file Thanks Hello My trouble is that I do not have a data layout of the file. It was a COBOL program that created the file. Thanks .dat may be a text file output from cobol. first try to open in excel and save it as dbf. else if u can findout the layout u can create a dbf and give the following command use <filename> appe from <filename.dat> type sdf Try to open it with notepad. Maybe you can parse it as a text file Sammy. Maybe. What is a DAT extension The name ...Show All

• manukahn Two Things >>Index<< and >>Help Docs<<

  All, Running Ver 6.0 and need help docs as somehow they are no longer working on my system. Also what I'm looking for is how to link in INDEXes It have two tables: mine.dbf and mine.edb with indexes of mine.ddx and mine.edx First .dbf is contact info, but email resides in the .edb file. Need a join on this, through the idexes to port to new table. All help appreciated! Tbotnik In VFP 6, the Help was installed as part of MSDN. You should have a separate CD that lets you install Help. As for your other question, I strongly recommend that you don't use alternate extensions for tables. Make your changes in the filestem, not the extension. Trying to maintain indexes with an extension other than CDX i ...Show All

• GroZZleR How to manipulate BROWSE NAME objects?

  I am trying to manipulate a browse object. I'm doing a browse nowait and then I make changes to some properties of the object. But then, I can't set focus to the browse window. The following runs through the code all the way to the 'Done'. How can I activate the browse window Thanks. CREATE CURSOR tmprug (rugno c(6) ) INSERT INTO tmprug VALUES ("000001") INSERT INTO tmprug VALUES ("000001") GO top define wind rugs from 06,0 to 18,90 font "Tahoma",10 grow brow fields item=recno():4:w=.F.,rugno NAME oBname wind rugs nowait oBname.AllowAddNew = .T. oBname.column1.setfocus() ACTIVATE WINDOW tmprug WAIT "Done" wind Marcia; I understand that a grid in a form would solve ...Show All

• ParkerJ21 getting things working on a network

  im having problems when 2 people save at the same time on my network. the person who saves last is going to over write everyone else. PRIVATE B DO WHILE !THISFORM.MULTIUSER() WAIT 'Getting Network Attention... Please Wait' WINDOW NOWA NOCLEAR ENDDO B=THISFORM.SAVEUPDATE() SELECT CLIENT UNLOCK WAIT CLEAR IF B=1 MESSAGEBOX("Client Successfully Updated",'KM SYSTEMS') ENDIF IF B=2 MESSAGEBOX("Client Successfully Saved",'KM SYSTEMS') ENDIF _______________________________ this is what is in the method multi user SELECT CLIENT IF FLOCK() RETURN .T. ELSE RETURN .F. ENDIF save update is this _______________________________ PRIVATE A SELECT CLIE ...Show All

• Milad.a.p FoxPro Downgrade Help

  I recently formatted my pc at work and and to reinstall all of my applications. I tried installing Visual FoxPro 9.0, however it was not working correctly. It kept giving me the error "Cannot locate the Microsoft Visual FoxPro support library." So I uninstalled this, and tried installing Visual FoxPro 8.0. The program now runs fine on it's own, however, whenever I try to run a FoxPro-based application (i.e. Mail Order Manager), I still get the same error. I don't know if the application is still trying to use remnants of FoxPro 9.0, or what. Does anybody know what I can do to fix this Thanks in advance, Steve Ok, you all were right. I was just misunderstanding my own situation. Installing the ...Show All

• dagfari COM Automation with Excel

  Here's my problem...I have the program writing to Excel and then opening just fine. What I want it to do though is save the spreadsheet in a newer version (I used "copy to 'filename.xls' type xl5") without having to actually see a prompt from Excel. The reason I'm doing this is for workbook consolodation (I'm writing to several workbooks and want to put them together). You can read more about it in my previous post here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=782622&SiteID=1 In this one note that you might skip 'VFP copy part' but just kept that to signify it's not VFP slowing this down. lnTotal = 200000 * Create a test cursor Create Table (ADDBS(SYS(2023))+'xltest') (Rcno i,cType c(10), nType i, dTy ...Show All

• Martyn775 Scripting Visual Foxpro Database

  I want to generate a database creation script that is Transact-SQL compliant for a Visual Foxpro database. The code generated by the Gendbc program will not run if I execute it in SQL Server for instance. Is there any way I can do this using Visual Studio 2005 Or is there a tool that can facilitate this process I am writing a program (in C#) to dynamically create a SSIS package that will transfer a Foxpro database to SQL Server 2005 Express and will need to generate a script dynamically when the user points to a source Foxpro database. Any ideas Visio Enterprise Architect will also allow you to forward engineer a Foxpro database and create a SQL compliant script. You may also want to look at Stratra ...Show All

• wendling lionel New to InstallShield need help

  I recently resumed writing Visual Foxpro applications. I have not done much with VFP since Visual FoxPro 5.0. I'm currently using VFP 9.0 w/Installshield 5.0. When I create a distribution set and attempt to run it after the install, the form flashes on the screen for a half second and disappears. When I run the prg or exe from inside the VFP environment, they perform as expected. What could I be missing   Rick is right. You seem to be missing a READ EVENTS. VFP needs a wait state. This is provided by the IDE when in development. You need a READ EVENTS while in production (EXE) and a CLEAR EVENTS executed from your exit menu option or exit button on a form or similar. See the very last ...Show All

• mclagett One basic question, one not so basic

  I am attempting to write some functionality using the winsock control with VFP 6.0. I have a pretty good understanding of winsock itself, but I'm having trouble accessing the object from my code. So here are my two options, neither of which I can figure out right now: 1) The object is defined on a form, but needs to be accessed from code in a .prg. I have never been able to figure out how to access an object on a form from a .prg in FoxPro. In VB, no problem, but in FoxPro, if I say form1.objectname.member, it says it doesn't know what form1 is. 2) I can create the object in the .prg (which I would prefer). I have no idea how to go about this in FoxPro. I am currently attempting to do the whole thing in a form, but thi ...Show All