Answer Questions

• softstor how to change field values?

  I am looking for a way to address fields to change their values. I cannot understand how it can be done in VFP. For instance, if I use two statements which open a database table with a few fields in it, what do I do next USE DatabaseVfp1 tcp_ip IN 0 as cTableAlias SELECT ALL FROM cTableAlias cTableAlias.fieldName1 - what does this expression give me Is it the field value or just a field name Can I write: cTableAlias.fieldName1 = ...Show All

• pcletson Load Data

  Hello, Can I know how to load the data/information from text file to Visual FoxPro Thanks a lots for help. Jarron, It all depends in what format the data is in. If it is a simple comma delimited file (CSV) or an SDF file (a flat file with no separators or delimiters), you create a table with the proper structure to receive the data then do an APPEND FROM . Read the help file for APPEND FROM as it has man ...Show All

• ShootingStar 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 Aparently the PRG is not in the compiled EXE. Rebuild the EXE, this time checking the "Recompile All Files" box. Normally you  wouldn't&n ...Show All

• Bernard Yves Problems with Command REN ???

  Hello!!! I usually use the following command in VFP6 (in Win98): !Ren Folder1 Folder2 to rename the name of Folder Folder1 to name Folder2. It is OK. But I can't use this command in WinXP (SP2). I don't know why Can any one help me Thanhs a lot. You could use Windows Script Host: oFSO = CreateObject("Scripting.FileSystemObject") oFSO.MoveFolder("c:\folder1","c:\folder2") You must have enough permissions in Wind XP/Win2K/Win2003 to do ...Show All

• Matthy de Hoog How to visualize an SQL server table in MSDE?

  Hi! I want to visualize an sql server table in a grid, and then, modify my data, and upgrade the original table in sql with a button! Is it possible using sqlexec( ), and without using wizard tool Il I want to make a select in a sql server table, how I can visualize that in visual fox Thank you! Thank you! But, perhaps I have ask you so much things... I want only this... SQLEXEC(connetti,"SELECT * from contatti","Results")   ...Show All

• Naiem VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• WiltsDBA How do I create a random table or cursor name?

  Hi all, I know that should be simple. How do i create a random table or cursor name and then use it I remember there is a function for this but i cannot find it! Could you please give me an example as well Thanks!!! Athan hi and thanks once and again for all your answers. I will have two different users on two monitors,keyboards etc by using a softwrae called betwin xp ( www.thinsoftinc.com  is the address ...Show All

• eyalgreenblatt show certain record in gridbox

  dear all, i dont want my form show ZZZZ product code that i make hardcode to my table. sele b SET ORDER TO 2 GO TOP thisform.grdSales.RecordSource = "b" thisform.grdSales.RecordSourceType = 1 thisform.grdSales.column1.Bound = .F. thisform.grdSales.column2.Bound = .F. thisform.grdSales.column3.Bound = .F. Thisform.grdSales.column1.text1.ControlSource = "P_name" Thisform.grdSales.column2.text1.controlsource ="P_c ...Show All

• Hanuman_Sinha Use or not BLOB fields with SQL Server

  Hi: We are deciding which would be the better approach for managing a lot of files ( PDF, JPG, DOC, DWG, ETC. ). We are speaking about thousand of files and thousand of megabites. As far as we are developing with VFP 9.0, we would be able to use BLOB fields. But we are not sure if it will be the best choice for us, taking in account, the amount and sizes of the files. Could anyone help us Regards, Ana Madrid, Spain www.amby.net www.PortalFox.c ...Show All

• kal11 Connecting VFP applications on Wide Area Network (Client-Server).

  How do I connect VFP Application running on windows Small Buisness Server through WAN For Hardware: HP server with Xeon processor, 2GB Ram & 80 GB SCSI HDD is ok, but if you want a better system, get a server with at least dual processor, 2GB RAM min., HOTPLUGABLE SCSCI HDD 73GB X 3 or higher capacity, configure it to use RAID level 1/5, install the system OS and data separately on the  ...Show All

• Tazzmann How random is the RAND() function?

  Hi, Is the RAND() function in FoxPro based on a well-known algorithm - i.e. is it certified or have anybody performed a diehard test ( http://en.wikipedia.org/wiki/Diehard_tests ) Thanks in advance for any replies, /Michael I don't know what algorithm they're using, but I have done some tests on it and found it's pretty good. I published code for Chi-squared and Coupon Collector's tests in HackFox. Tamar ...Show All

• Salanitro foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

  foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you...   modify command <insert your prg file here> modify form <yourformname> use <yourdatabasename>        Excuse me sir, what do you mean by "Access sucks in Networks" I am just c ...Show All

• alche Need help on a small open table code

  Hi, I m trying to make a general opentable function that I will use with all my apps in the future. Now I need someone to explain to me a few things to see things more clear. Here is my code: function OPENTABLE(TABLENAME)  LOCAL TABLETOOPEN *Ok this is just a full path I make for the dbf file. I do not know if it the right way.what it gives is  eg. c:\program files\my app\data\mytable.dbf  TABLETOOPEN=TOSTRING(checkpathf ...Show All

• mbriscoe html in textbox

  Hi How do I open an html file inside a textbox   this doesnt work               thisform.veld14.Value = c:\winvis\htmlbody.htm  or can I make some kind of field inside my form to load the html page in     Dave M. wrote: thisform.veld14.Value = FILETOSTR("c:\winvis\htmlbody.htm") I see Dave. I ...Show All

• erso Combobox

  Hello Experts This might be a simple one. I have to display 2 columns in a combobox (DriverName, DriverCode). I want the first column to be DriverName but want to save DriverCode instead. The reason is that i want incremental search on DriverName. Thanks Guys Jitendra Shahani Set the BoundColumn property to 2 - then the combo Value property will have the Code and will store that to the controlsourc ...Show All