Answer Questions

• DonW How to open the table exclusive for ZAPping?

  Hi Sir, To be able to PACK/ZAP a table it must be open exclusive, such as USE myTable EXCLUSIVE .... My question is, Why there isn't a place in data enviroment (TAB DATA) to stated that myTable should always open EXCLUSIVE so I can pack/zap anytime Please tell me where is the proper place (the way) to open a table exclusively SELECT myTable USE USE myTable EXCLUSIVE thanks Joe If the table is open and you want to use it exclusi ...Show All

• Larry T Closing Cursors

  Hi Everyone, I was just wondering if anyone knows how to close an open cursor without closing another. For example, I have two cursors open and I only want to close one. If I use the USE command, this will close both of them. Any Ideas Thanks in advance. Todd Peasley. Thankyou, that worked a treat. Use closes one not all. From any workarea to close cursor with alias myAlias: U ...Show All

• cm6043 editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• KirkB How to get Serial number on usb flash drive.

  I am unable to get the serial number on usb flash drives. I'm using vfp8, but I don't know what to use for get it. I need your help, please! Thanks all..! If you know drive letter of your flash disk, you can use something like this : oFSO = CREATEOBJECT("Scripting.FileSystemObject") FOR EACH oDrive IN oFSO.Drives If oDrive.DriveLetter = "X" TRANSFORM(oDrive.SerialNumber, &quo ...Show All

• Michael Cochran SELECT statement is showing unwanted display of data and is not passing data to a table.

  I'm using a SELECT statement to pull out data from a table... that is working great. What I'm trying to do is feed the selected data to a different table using REPLACE so that it can be used by a report. All of this is triggered from a command button on a form. Here's the code for the CLICK property of the button: SELECT store, stock, year_1, make_1, model_1, auction1, transport, recon, sold_for, fees, net_check, result ; FROM wholes ...Show All

• Vishvas R Trikutkar Container 'when' method?

  Hi; I don't see a when event for a container. I am using 'gotfocus' but if there is a command button in the container, and I want to prevent the user to click it (in some cases), gotfocus is too late bacause the button's click method already fires. Any ideas how would I conditionally prevent a user access to everything contained in a container Thanks, Aleniko Dave; If I use the .enabled p ...Show All

• Gravedigger stop “invalid input”

  I have a form with a text box on it that will be used to enter data via a scanner, After the scan I need to have the text box set focus back to itself for the next scan. The only way I seem to be able to accomplish this is to return false in the valid method (I have additional code in this method for actual validation). Is this the only way to accomplish this And if so how can stop the “invalid input” from popping up Tha ...Show All

• Timo81 Append data from same table

  Dear Experts Table1 has two character type fields as name c(40) country c(40). Data in fields is as follows Mike England Eric France Robert Germany (3 records) I want to append second field's data into first field, new row, as Mike England Eric France Robert Germany (6 records) I want to get above result Please help Tariq don't you read replies http://www.universalthread.com/wc.dll LevelExtreme~2,15,1048384 Create ...Show All

• Technologist empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike Thanks Dave.. I appreciate all your help! mike "This will work for all data Types" - I wish it were true... There is an exception: memo fields. If you have a memory string va ...Show All

• Veena B N import from excel

  how can i import an excel sheet with huge text on some cells... i try it, but the character field is only 254 chars size, i did try to create a table and then append the big text cells to memo fields, but they remain empty... thanks for the help !! Instead of import use SPT to get the data. I'll try, Thanks !! I believe you'll need to use automation to do this manually transferring the cont ...Show All

• loris Median calculation

  Hello, have question about median calculation. I have table like: Name m1 m2 m3 m4 m5 a 1 3 5 2 8 b 3 1 9 7 5 c 4 8 6 3 2 I need to get data in same or another table like: Name median a 3 b 5 c 4 Now I use such program for calculation USE DB!table COUNT TO ...Show All

• yasht How to get the UserID and password login to windows in Visual Foxpro?

  Could you show me the way (in Visual Foxpro) to get the UserID and password that i've logged into windows please Thanks. ChinhNguyen Since you've logged into Windows, you should know the password. Just right it down. If you do not know the pw you are not the owner of this system and God knows what your intentions are. GETENV("USERNAME") Will give you the username. I don’t think y ...Show All

• David Paynter Overload possible

  I need a way to overload a fox function like Empty with a UDF of my own called Empty. Is this possible If Fox doesn't support overloading, is there a class I can inherit from and override the empty function I need help ASAP. Thanks, It will stay. An include file (.H) is read once at compilation time. If you redefine in another program (or another inlcude) you get an error as it is already defined. In that case you would have to use #UNDE ...Show All

• Randomize Noob question

  Technically I don't even fall into the noob category.  I have been tasked with using foxpro for a project at work. I have zero experience with vfp.  The version we have is 9.  The only books I can find detail what is new for version 9.  is there a book out there for the absolute beginner that is still relevent to version 9   Most of the how to books I have found are for versions 3 or 5. Thanks  for any help. &n ...Show All

• Muhammad Abrar use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count Thanks, Alex. It is very helpful. Hi, i think you will need to use COUNT command instead. RECCOUNT() is not affected by SET FILTER. This is how it works for me. Finally . Select * Fro ...Show All