Answer Questions

• mNilysg FoxPro 6.0 not using CodeBase Index

  Hi, I'm creating a table (.dbf) with and index (.cdx) a driver : deBaseOdbcStandFoxPro. I'm using this driver because with after creation i'm using some optimize insertion of code base to the table. after that i'm closing the table and the connection to the data dase, and opening it with "Visual FoxPro 6.0 ODBC driver" to perform querys. My problem is that the the visual foxpro driver isn't using the index i created (a query takes the same time with or without the index). i asked codebase what seems to be the problem and they said that there files are foxpro compatible and that i create the index correctly and the problem is probably with microsoft driver and maybe it's because foxpro allows deleted records. does a ...Show All

• Abhayc how to backup data to CD using vfp 6?

  Hi I'm trying to backup my data in zip format to CD through foxpro 6. Anyone know the solution Ms Yap To compress files use one of the many libraries (generally DLL or OCX) that create ZIP files: DynaZip http://www.dynazip.com Xceed ZipLibray http://www.xceedsoft.com/products/ZipCompL/ EEVA ZIPMASTER http://www.eetasoft.ee/zipmaster.htm X-ZIP http://www.xstandard.com/download/x-zip.zip   To copy to CD you'd have to send it to the CD drive and use the CD provided software (e.g. Nero) to do the actual writing. ...Show All

• Viren Kapadia Beginner in Foxpro (version 7) - need help in input/print on chinese character

  hi, i am beginner in this software can anyone share with me, how should i go about inputing and printing of chinese character using version 7 or can someone direct me to some useful links for self learning would appreciate on any help. thanks hi lighting, 你也好~ i did download njstar, and as u can see, i manage to type and display the chinese words above. but the problem just happened in foxpro, i tried copy from njstar, paste to foxpro text box, and it will become funny character. anymore help realli appreciate all who can help me out rgds u have to set the code page for the table to unicode. and try this link http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/Inst ...Show All

• Acco1953 Genral question about FoxPro

  Hi, I'm using VFP 6.01 ODBC driver to connent perform querys, etc. When I'm using VFP 9.0 i'm and creating a query with the "query wizard" the query take less time then it's taking me (i'm using SQLExecDirect). what can I do to get better resualt can work with FoxPro driver directly Or maybe OLE DB is more efficient I have someother question can i get the number of records returning from the query Now i'm using A Count query to get the number or recods. Thanks Ishay Both ODBC and OLEDB drivers are fast and OLEDB driver is preferred. There were even some reports that VFPOLEDB driver results were faster than native VFP (I have never tested myself). ODBC driver isn't updated si ...Show All

• CharlieRomeo Form titlebar color

  Is there a simple way to change the color of a form's titlebar Thx. No. This is controlled by the user's settings in windows and changes to it will affect not only your application but all apps running on that machine. I may say that if I installed an application that altered something like this on my PC it would not stay there for long! One of the key elements of windows programming is to respect the user's choices for their settings and not to change them wholesale. So this is NOT a good idea anyway. Hi Aleniko There are a couple of samples in VFP9 which illustrate things you can do with the titlebar and GDIPlus: do (_samples + "solution\solution.app") Then choose New in VFP9 \ ...Show All

• Abdul Muheed SQL Server Express & Foxpro-populating SS from Foxpro

  I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastname) values ("Kareen","Abdul-Jabar")'. If I use: lcStr = ['INSERT INTO SAUTHORS (firstname,lastname) values ("] + m.firstname + [","] + m.lastname + [")'] lnResult= SQLEXEC (m.lnConn, m.lcStr) I get an error that says Invalid Syntax. Can someone steer me in the right direction I want ...Show All

• Erik_Olofsson How do I creat a print button?

  How do I create a print button in Form of VFP9 that will print only the current record Will appreciate and thanks in advance... Thanks all of you It only work until "Preview" command button pressed,  the code of "Preview" button is: REPORT FORM monthly.FRX PREVIEW   Once the "Preview" execute the "Print" command button ask for and locate the DBF file but won't do anyting The code of "Print" command button is: REPORT FORM invoice NEXT 1 TO PRINTER preview First, create a report that presents the data from the record in the format you want. Then, add a button to your form and put code in it somethin ...Show All

• Nimrod_ 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 No I'm not referring to any message. I haven't read the mes ...Show All

• jschroeder Passing multiple variables from forms w/ VFP7SP1

  I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form to recognize the 5 existing parameters in the main prg, permit user input and then pass any changes back to the calling procedure or function using a array embedded in the form when the user clicks [OK]. Clicking [Cancel] should leave the parameters unchanged. Can somebody please suggest a technique for passing multiple variables back and forth be ...Show All

• Kyle Key visual foxpro query

  Hai, i have a table with the following records. month,dealercode,branch,netqty can anybody kindly give me SQL Command which will sum netqty group by dlrcod and month but for each dealer monthqty should appear vertically. select dlrcod,branch,sum(netqty) from <table name> group by dlrcod,month with this query i get month totals horizontally but i want months to appear vertically. if any body can kindly give me a query, i would be greatful eg. mnth delaer code branch netqty january a0001 blr 1000 april a0001 blr 500 feb a0001 blr 300 may b0001 blr 400 june b0001 blr 300 january a0001 b ...Show All

• creditl Set printer to NAME

  Hi; I am using "Set printer to NAME getprinter()" to select a printer. I also have tried "Set printer to name \\somePC\someprinter" In both cases an error is produced. "Error accessing print spooler" The network is a win2003 server with both XP pro and Win98 stations. The printer is on a win98 station. I was wondering if I should use "set printer to \\somePc\somePrinter" without the NAME clause Thanks. what vfp version are you using I tried in Win98/Vfp6 Set Printer To Name GetPrinter() and it works fine... Have you any printer installed on Win98 Here's what I have found: "Name" requires that the network p ...Show All

• WaywardMage Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• Timothy Wilson Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. >> Are you (and/or others on this forum) certain there won't be a VFP 64-bit version, verily http://msdn.microsoft.com/vfoxpro/roadmap/ >> Are you (and/or others) certain 32-bit VFP software is doomed in 7 years To say I'm certain w ...Show All

• Nordy Why VFP locks this table?

  I have the following code: SET EXCLUSIVE OFF CLOSE DATABASES ALL USE KRCBP!RUGINV ORDER RUGNO IN 0 USE TMPRUG IN 0 SELECT TMPRUG SET RELATION TO RUGNO INTO ruginv BROWSE FIELDS RUGNO,DESIGN=ruginv.DESIGN When the user starts typing in the first field (rugno, in the tmprug table), it locks the ENTIRE second file (ruginv). The lock gets released only when moving the record pointer. Any ideas why VFP locks the second file Is there a way out of this Thanks. I'm still not sure why VFP lock the related file, but I have found a solution. BROWSE FIELDS RUGNO,DESIGN=getfval("ruginv.DESIGN") procedure getfval parameters cField return &cFi ...Show All

• Karlo using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay I opened the database created with vfp 7 and I used the option export to (from file menu tab), to change format in foxbase+ (it was the only format who worked). I re-create a new cdx index file (compound index file).I did not spent to much time with this because I wa ...Show All