Answer Questions

• Grotius SQL order by - anyway to use string operations?

  Hi all; Is there a way to do something like that The following statement will result in "Order clause is Invalid". SELECT * from SomeTable order by left(somefield,6) Thanks. Use ordinal instead of name. Sorry. Found the answer finally through MS KB. http://support.microsoft.com/kb/157188 Thanks. thx. SELECT left(somefield,6), * from SomeTable order by 1 ...Show All

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

• Salvatore Di Fazio 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 yes its a column in both tables, i mean in table_1 and all the files i want to look in the directory... sorry but this really very complicated.... hi thanks again... what i really like to do is like this i=0; WHILE i NOT EQUAL numbersOfFiles in the directory THEN DO DELETE FROM tabelle_1 WHERE nr IN(SELECT nr FROM this file in the directory) NEXT ...Show All

• scuudz 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)) && create a temp table to store table names sele b use xxx shared alias xxx &&open that dbf DIMENSION TEMPARRAY(1,5) && declare array to store table names =ADIR(TEMPARRAY,"c:\temp\*.dbf") &&use adir to get tabl ...Show All

• Rustynails Showing one form from another

  Situation: I am in a form A, click on a cmd, and it opens another form B and hides the current form A. In form B, I click on a cmd and I would like to show form A and release form B. The release of form B works, of course, but not the showing of form A. I have never seen anything about whether it is possible to make changes in or affect one form from another. Is it (I guess it would work with a form set ) Hans L Makes sense in general. In my case, many of my apps will be of the kind that you click on a main menu, get a list of, say, individuals (friends, relatives, etc.), then click on the record you want to see details of. No need, in my view, to have the first window (the list) open. But as I get furth ...Show All

• wmysu 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. VFP will be in production and supported to at least 2014, probably longer since this is such a well known language.   I used to be a VFP-only developer. But with the advent of .NET plus user requirements where a web ap ...Show All

• VinuM Sequential Transaction Number

  I'm working on a form that needs to have a sequential transaction number. I have a Database/Table (named Trans) in place that has a single record that holds the next transaction number. I'm not sure what the best way is to have the next transaction number appear in a field on my form. Right now I have a field named T_TRANSNUM that has it's data property set to w_trans.t_transnum. t_transnum is the name of the database field where I want the transaction number stored when the form is saved. In the INIT method of T_TRANSNUM I have the following: STORE 0 TO T_VALUE SELECT TRANS GOTO 1 STORE trans.trans_num to T_VALUE REPLACE trans.trans_num with T_VALUE + 1 this.value = T_value What is happening is that the value is displayed in the form, but ...Show All

• Socrates Kapetaneas switching pages in pageframe

  I want to be able to detect when I am clicking on a page tab to switch pages, so I can control which portions of a lostfocus event on an object in the current active page will execute. I appears that I can't use mouseenter on the target page, like I do on command objects. You could set tabs to false and place command buttons instead. Actually I didn't undesratnd what you mean, if you place a comandbutton on a pageframe then it's in front of zorder already. I don't think this is a good solution. I also don't understand why mouseenter,mouseleave would be the ideal place. User might simply bypass it not using mouse (if one day you enable keyboard accelarators and boom). I also do not understand ...Show All

• msp0815 Edit field in Browse do not respond

  *=====================================  In the following module Item code entered in the "Datafile"  is checked with codes in stock master in the order of codes. The code exists in the Stock master, and the Return 1 is effective. But the cursor is not moving to enter the next  Name field.   *========================== SELE 1 USE STKMAST ORDE CODE SELE 2 DATAFILE *---------------- 50 Blanks added to Datafile CTR = 1 DO WHILE CTR <= 50          APPE BLAN        CTR = CTR+1 ENDDO *----------- Data Entry GO TOP BROW FIEL SRNO:H="Ser#", CODE:H="tem Code"; :V=CHKITEM(CODE)>0,:E="Code Error":F,NAME:H="Customer Name" CLOS ALL RETU *----------- ...Show All

• Tompom problem with class

  i get the error ole error class is not registered...... what does this mean and how do i fix it i read the vfp help files on it but it was too confusing for me. First, you need to know what ActiveX control is causing the OLE error. Then determine what file its contained in, its usually an OCX or DLL file, i.e. COMCTL32.OCX. Then run the following command either using Start->Run or using the command prompt - REGSVR32 COMCTL32.OCX how do i register it May be is the error OLE error code 0x80040154. Class is not registered... and you will need to register the active x you are using. ...Show All

• JamesCox1968 Create menu or command

  Hi there, How to create a command button or menu to acess 3 different form. Pls advice. Thanks. Hi, I didn't create the from using either way. I copied the form from another program which is in K:\ drive and paste to other location/drive F:\. From there I start to modify the form, and run the form. The form works fine in the beginning. After that it came out program error when I try to create a command or menu to link up the form. Therefore I tried to copy the form and paste to C:\Program Files\Microsoft Visual Studio\Vfp98. Then I try to run the form from my F:\. Now the form able to run. Will I face any problem later on when I create exe or distribution file if i'm using the same form Kindly advi ...Show All

• gpugelni MSCHART AND VISUAL FOXPRO 9

  I am trying to use MSCHART with VFP9 and have some success until I want to set or change Legions, Titles, Colors etc. or to enter data into the second Y axis. Using any of the property / constant names only produces the message "Name Unknown". Any suggestions. Wrong. I don't remember I said something about graphs.vcx (and I don't have an idea what it is). The code I posted is missing only 2 pieces: 1) DibApi32.dll - A well known DLL from MS samples. You can get it from http://support.microsoft.com/kb/130804 2) The report form itself. Create a report from sample cursor (before report form line). ie: create report myReport from alias() column modify report myReport Add a grouping ( by customerID ). In group ...Show All

• Tonton888 Philadelphia Visual FoxPro User Group--Wednesday, July 12, 2006, 7 PM--Mike Feltman plus FREE Pizza

  Philadelphia Visual FoxPro User Group Wednesday, July 12, 2006, 7 PM Location: Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025 FREE PIZZA. Come at 6 PM for a pizza dinner This month's door prizes include a one-year subscription to MSDN Visual Studio Team System Edition; retail value is over $10,000. Speaker: Mike Feltman, F1 Technologies Topic: How’d they do that Inside F1 Technologies Visual FoxExpress F1 Technologies has been actively developing Visual FoxExpress since Visual FoxPro 3.0 first went into Alpha testing. In that timeframe, F1 Technologies has pioneered many techniques that are now commonplace to Visual FoxPro development in general and others that were “leveraged” ...Show All

• lnmthuc Picture position in command button

  In VFP9, I have just put my first picture on a command button. For "Picture position", I have "13 - Above caption, centered with caption along bottom (Default)". For caption "Alignment", I have "9 - Bottom Center." However, the caption does not align center, it aligns left,, the same as "7 - Bottom left". Is this a know glitch in VFP9 Hans L Don, I am leaving this forum because of its terrible UI and behavior in general. Regards, Hans L Is the button tall and wide enough for the graphic Are you using an icon file or a BMP I will check later today and get back with the info. I have used both an ico and a bmp, and in the bmp case, the text went under the i ...Show All

• Exploder what do you do if a dll is corrupt?

  What do you do if an application fails and an error message is that an "entry point for a procedure is not found." You then go find the appropriate DLL file and try to register it and the registration fails and the message is that it does not appear to be a valid DLL file at all. I am talking about DNSAPI.DLL in this case but it appears to be a frequent problem and I want to know what one can do about it. What is the protocol That dll appears to be in 3 different incarnations in my computer, on two different partitions, the latest version is from May 2005. They all failed. Any advice will be much appreciated. Thanks. Thanks, it is a useful piece of info. I use DUMPBIN.EXE to find dependencies. It did not oc ...Show All