Answer Questions

• zcr passing parameters to vfp com servers using createobject

  Is it possible to pass a parameter to a vfp com server using CreateObject("COMServer.Class", eParameter) It seems to me that whatever I pass in eParameter it is always .F. within the INIT method and PCOUNT() always gives 0. Regards Darren Woodford Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk It's not a VFP issue. Passing parameters to the Init is not supported by ...Show All

• Radwanh form caption

  Hy guys! I want to put on the form's caption an word which is in a table when the form appears. I wrote this code in the init event of the form:  sele user  this.caption = "Borderou " + alltrim(user.name)  this.refresh but the form's caption doesn't appear as i want. Sorry for my weak english. Liviu, If you put a SET STEP ON immediatley after your THIS.Caption = "Borderou " + ALLTRIM(User.Name) line of code, what is the val ...Show All

• Ananda85 Numeric value

  hi, Do you have any idea how to save a numeric value with two decimal places to a character field thank u VFP Developer wrote: Do you have any idea how to save a numeric value with two decimal places to a character field Use the STR() function and make the parameters for STR() the same as the definition of the field (e.g. 10,2): lnValue = 12345.67 REPLACE numfield WITH STR( lnValue, 10, 2 ) ...Show All

• jimmyx 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

• mralbert Call a store procedure in MS SQL

  Does any body have experiences to call a store procedure in MS. SQL Server with Foxpro V8 command How about :- lnHandle = SQLStringConnect("Driver={SQL Server};Server=(local);Database=master;Trusted_Connection=yes;") SQLExec(lnHandle, "sp_who", "temp") BROWSE SQLDisconnect(lnHandle) HTH, Robbo. Thanks guys for all of your replies. The answer is quite clear for calling a store proce ...Show All

• rumblespaul VFP9 printing issue with multiple detail bands and group subtotals and/or summary totals

  I have a report with one group and a summary total. Adding a new detail band, a big new feature added by VFP9, lead to incorrect totals/subtotals. I am using VFP9 SP1, behavior80, but is the same with behavior90. Steps to duplicate: 1) Run this code create table PRINCIPALE ;   (AGENTE     C(2), ;    N_DOCUMENT C(5), ;    D_DOCUMENT D, ;    TOTALE     N(5), ; & ...Show All

• Rajat Tripathi Clearing a cursor

  I am working with a cursor that I use to import XML information to. When I am done with the XML information, I want to clear the cursor for other input from the same area; however, I am unsure as how to go about this. Any ideas Like Cetin said, if it's R/W you can always ZAP as if it were a table. The question is, if you generate the cursor by importing data, once you are done, why not regenerate and get a new cursor What's the ...Show All

• realview Can't write to new tables.

  Hey, I was given the task of updating a project in .NET and foxpro. I opened up the foxpro database and added a couple tables. I can write to them from the command line, but I can't insert or update records through the oledb. The users have write access, and can write to any of the old tables, but not the new ones. I am doing this in VFP 6.0. I don't know what the version to make the originals was. What am I missing ...Show All

• Jake Reynolds Reading binary data

  Dear all, I want to read binary data from a FoxPro database. The data in the table contains a MS Word document. I don't have clue how to do this. I tried to read the data in a string but only the first 8 characters are returned. When I try to store the data in a byte array I got a InvalidCastException. When reading a datafield which contains plain text everything works fine. I use Visual Studio .NET 2005 with C#. My Code: sQueryDoc + ...Show All

• Bob Lyden Starting EXE fails, asks for missing FXP

  Hey, I have an app, usually works fine, and it works at many other client sites. But at one it will occasionally hose, and starting the EXE goes to the VFP window (even in my top level form app) and brings up a find file dialog, looking for an FXP. Anyone know why this happens Thanks Alex and happy new year BTW. What I'm saying is a little different however. Even if the file is included (manually or via a fake procedure) ...Show All

• Niall Ryan VFP 9 and Installshield

  When I try to create a setup for my app written in VFP 9, I am getting the following error in Installshield: ISEXP : warning -4354: The build was unable to extract COM information from the file C:\MyApp\MyApp.DLL in component MyApp.DLL. Please ensure that the file is self-registering and verify that the self-registration process does not fail. I am running Windows 2003. Any tips or leads on why this is happening As the foxpro install walkthrou ...Show All

• nkabirwa Set talk, set deleted in forms.

  Hi; I am issuing SET TALK OFF and SET DELE ON in my application. Later on, when the user opens up a form, set TALK goes ON and in some cases SET DELE goes OFF. I have used the debugger, and I can't seem to find where exactly this happens, although its at the load event. There is nothing there to turn it on. So - what am I missing Aleniko Hi Aleniko To add to what Dave says (he is dea ...Show All

• LarsMohekan Find Object by caption

  Dear Experts There are some command buttons on a form and one button's caption is "Close". I want to findout that button and click on it. How is it possible What commands should I write on the click event of another command button to findout "Close" button I got following codes from somewhere but did not work. Please modify or suggest some others. LOCAL i FOR i= 1 to thisform . controlcount IF thisform . controls (i). baseclass = 'commandB ...Show All

• ruppuk Leading zeros

  I am trying to create a numeric field without decimals with leading zeros. This could also be a character field as long as the number is right justified. How do I do this Thank you This should also work: cFormattedWage = Transform(nWage*100,"@L 99999999999") I'm not sure if I am using the answer correctly. Let me explain further. I'm creating a text file f ...Show All

• Kiz Using controls to display info from a table.

  I have a table with employee info in it ranging from Pay scale to date of birth.  I have 3 fields: Full-Time, Part-Time & Temp.  If the field is true I have a 1 in it & if false a 0.  I'm creating a form to display info from my table yet I'm not quiet sure how to display the full-time/part-time or temp info.  Would a check box section work or option buttons.  I don't want the person viewing the form to ...Show All