Answer Questions

• vdv_phuong How to let user choose a data path?

  I wish to let the user choose a folder to dump data. How can I achieve that    To be user friendly, I whish to give them an interface like putfile() or getfile() screen. Not a text box to manualy enter the path.  Thanks. Good! That's what I need. Thank you both. However, getdir() cannot create a new folder. Great! Thank you, CetinBasoz. cmyDir= GETDIR ("c:\data\","Select a folder","test",64) You may use getdir(). The easiest way is using GETDIR([ cDirectory [, cText [, cCaption [, nFlags [, lRootOnly ]]]]]) which calls a Windows interface window familiar to users. & ...Show All

• fafnir Building Exe

  Dear all, When I run my program from command windows, it shows perfectly in my screen depends on rows and columns, but after generating exe after building project, it goes too right in my screen for example, @ 10,30 say "Name " shows perfect but in exe it shows in colum 10,70 approx. How do I solve this Pareshbel, It's been far too long so I don't remember the exact commands to use, but the differences in the screen/form default fonts in your dev environment and the runtime environment are causing this. Your foxuser file is providing this at dev time and it's not available at runtime. The solution is to explicitly set these fonts in your code. ...Show All

• TheViewMaster Additon in character type data

  Dear Experts Field1 of Table1 has character type data, but digits. In Field2, I want to replace data as under 801 -------- 801 803 -------- 802 807 -------- 803 809 -------- 804 902 -------- 901 905 -------- 902 906 -------- 903 908 -------- 904 Please help   yanyee wrote:   Tariq Mehmood wrote: Dear Experts Field1 of Table1 has character type data, but digits. In Field2, I want to replace data as under 801 -------- 801 803 -------- 802 807 -------- 803 809 -------- 804 902 -------- 901 905 -------- 902 906 -------- 903 908 -------- 904 Please help changed this to mfield2 = "" if substr(field1,1,2)<>mfield2   ...Show All

• Bhanu Prakash Nunna - MSFT About imgscan.ocx

  Hi, I had a prgram in Windows 2000 using imgsan.ocx that registered in window 2000. It was running good. But When I change the platform in Window xp. It occurs an error that It doesn't locacate the class. Even though I copy this class imgscan.ocx into the current dir. It still doesn't work. Can anybuddy help me Thx a lot. If the file is in c:\mydir\ and if the file is ok(not corrupt) it should work. You may try to register with (at start>run command): regsvr32 imgscan.ocx Hi, Could you please give the download from where you got the file Thanks i want to know the download location too I download a new imgscan.ocx. Now it is working. Thanks a lot! I tr ...Show All

• jatwood Help with expression (one more time...)?

  Hello All...many thanks to all who helped with my previous post. I have hit one more 'snag' in preparing my data. Here's a sample of three fields in my table... MRC REQUIRED DETAILS 4720-00-001-0057 ADLF HOSE OR TUBING SPEC/STD DATA MIL MIL-H-5593,SIZE 4 SPECIFICATION ADJM INNER CONVEYING TUBE MATERIAL RUBBER, SYNTHETIC MEDA MEDIA FOR WHICH DESIGNED AIR CRWL INSIDE SURFACE CONDITION SMOOTH CQCS LAYER COMPOSITION AND LOCATION 1ST LAYER ANY ACCEPTABLE CQCS OUTER LAYER MOLDED RUBBER CRJM OUTER COVERING ENVIRONMENTAL ABRASION RESISTANT AND PROTECTION CRJM ...Show All

• yabansu Random Sample

  I have a table containing 3773 records, and i need a random sample of 2500 of these records. Does is there any easy way to to this w/ foxpro or do i have to come up w/ an algorithm myself Thanks in advance, Mike rand(-1) select top 2500 rand() as randomVal, * from myTable order by 1 into cursor random2500   cetinBasoz wrote: rand(-1) select top 2500 rand() as randomVal, * from myTable order by 1 into cursor random2500 If I execute your (cetinBasoz) statement I get randomVal in fractions, But if I change rand () as randomVal to Int(nRec * Rand ())+1 as randomVal (by Tamar E.Granor) it gives me the required result He used _Tally which gets update if tab ...Show All

• Samahith Dynamic Grid Highlighting via Mouse?

  Is there a way or trick you might contrive to highlight a grid row during a mouse-over a row without activating the row(s) If not, what about DynamicFontBold or DynamicBackColor based on Mouse coordinates or such (I use mouseenter and mouseleave triggers for other objects.) Thanks in advance for your valuable time. Is there a way or trick you might contrive to highlight a grid row during a mouse-over a row without activating the row(s) If you need to do this, I would suggest getting an activeX grid that has this type of functionality. I can recommend VSFlexGrid8 from www.componentone.com . Thank you so much, Marcia. It isn't mandatory, just hopeful for aesthetics sake. I'll look into your web and/or comm ...Show All

• Tom v E Grids to remember their last formatting

  Hi everyone; Before I start writing code for the grids to remember their last formatting per user - is there a setting I don't know of which will do that Simillar to Browse Last in 2.6 Thx. Marcia; Now you're pampering me... I was prepared to write this myself... Its not interesting anymore :-) Thanks so much! Aleniko   Aleniko wrote: Hi everyone; Before I start writing code for the grids to remember their last formatting per user - is there a setting I don't know of which will do that Thx. Here is your solution: Create a table called grid_prefrence with this structure: grd_id I user_id I path_name C(250) column_name C(50 ...Show All

• Shibu Bhattarai how to open a url from a command button on a form???

  A real basic question for everyone... Can anybody please tell me how to open a url from a command button on a form. Just insert the code in click method of a command button: DECLARE INTEGER ShellExecute IN shell32.dll; INTEGER hnd, STRING Action, STRING FileName,STRING Parameters, STRING Dir, INTEGER Show Action="Open" FileName=" www.microsoft.com " ShellExecute(0,Action,FileName,"","",1) declare integer ShellExecute in shell32.dll ; int owner,; string verb,; string command,; string params,; string working,; int shwnd ShellExecute(0,"open","your url here",0,0,1) ...Show All

• Reta Print Jobs Incomplete or Corrupt with Serial Printing

  Hi to All! I'm using EPSON TMU-200 POS printer with only serial port available. OS = WinXP2. Print Jobs Incomplete or Corrupt if we print large chunk of data. Does anyone knows how to fix the problem Thanks in advance. Holden What version of vfp are you using (if any). May be from printer drivers.You may try, for test, to use Windows Generic/Text driver to check if you have the same error. Try to set the comport flow control to "hardware", it may help. Milton Hi Dni! i'm using VP9 SP1. ...Show All

• Ben Weber Error when building exe in VFP 9.0.

  Hi All, I am getting the following error while building the exe in VFP, i am not able to clearly locate the area of problem The Error : " Object File <exe name & location> is in use and cannot be reoved from the memory " please suggest me a solution. Thanks in advance Venkatram Issue a CLEAR ALL and a RELEASE ALL before building the project. Before I build an exe for distribution, I always exit out of foxpro and restart, just to make sure nothing interferes with the build. The build exe command is the first line of code after restarting. (actually I have a command called DO BUILDNEW that sets everything up for me then builds the exe, copies the files to the distrubution d ...Show All

• AdeptBlue Execution of function or command is not allowed in context of SQL command.

  Hi; I got this error when I try to issue a quit command from my error trapping routine. Clicking help (Just like many other cases) is no help at all. I couldn't find this error anywhere in the VFP help or in google... Any ideas why this happens, and how I can avoid it Thanks. >> I got this error when I try to issue a quit command from my error trapping routine. Nope, can you post some code that might give us a clue... Initial error happens here and the error is "Alias name is already in use": SELECT SUM(qopen)FROM krcbp!polgr; WHERE design = tmpcpo.design AND size = tmpcpo.size AND qopen <> 0; INTO CURSOR curPoSum My error trapping routine tr ...Show All

• andy_Lee VFP Certification Reg.

  Hi, I'm working in foxpro for more than 10 years. But most of the time I's working with the DOS version( till 2002). Now I'm learning VFP... I started with 6.0 and now I'm working with 9.0. I'm interested in doing some certifications. Please guide me in this regard. Please let me know the certifications and the formalities to go through. Thanks in advance, Regards, Markish. R Unfortunately MS does not offer Visual FoxPro certifications anymore. Exams were discontinued a few years ago due to lack of interest. Hi all, Thanks a lot for all your inputs. Regards, Markish As Alex said, MS doesn't offer certifications anymore for VFP, however there are a fe ...Show All

• logtorahul excel and foxpro

  Dear friends, when exporting datas to excel from foxpro using the copy to command, there after trying to do some calculations and formating the excel file using automatation macros how could I integrate this in foxpro, I don't know where to start. thanks for explaining me the functionality satish For simple calculations might be. However in general, Excel knows how to 'calculate'. Dear friends, I found out the great prg file and my project works as I wanted. nice weekend, thanks for all your kind suggestions especially for cetin satish Dear Cetin, Finally I succeeded. my code looks like this LOCAL o ...Show All

• Thomas Madsen Combo Quick fill while combo is expanded.

  Hi all; I have a class which uses code Marcia Akins posted here (Thanks Marcia). The code uses the InteractiveChange of the combo in order to produce a quick fill functionality. The problem: This won't work when the combo is expanded. I've tried to utilize the kepress method but it didn't work. Is there a place I can disable the inherent functionality of the combo when its expanded so it won't interfere with the quickfill functionality Thank you all. >> For some reason the combo does some sort of incremental search regardless of the setting. A stupid question, but the IncrementalSearch property really is .F. isn't it Using a textbox,button and grid you can mimi ...Show All