Only Title

Answer Questions

• sanaryans Runing Total

  Dear Experts There are three numeric fields, fld1,fld2,fld3 and data in fields as Fld1   Fld2 1      2 6      8 3      7 0      3 I want to get runing total of fld1+fld2 in fld3 as 3 17 27 30 Please help Is there some reason that: REPLACE ALL fld3 WITH (fld1 + fld2) does not work for you Or is this ...Show All

• borka Image in a Grid

  Hello, I would like to show 3 different images in a gird. My data source is a table, the data type is character "E" for an error image, "O" for an OK image,"N" for a new image The picture property in the image control is "path\" + table.status +".bmp" It works, but all images are the same, like the first record number. (eg. N) Can somebody help me` Thank, ...Show All

• seham Select SQL Problem

  I am trying to select records from a database to determine qualifying order over 3 rounds of competition.  I *thought* I had it working but the results are not always correct. I need to find the lowest number in the field IQUARTER from a list of runs from many different entries listed by the field RACESESSIONS, but I need only the lowest for each contestant.  If there is a tie then the highest Miles Per Hour from the field ...Show All

• chiharu09 How to save whole row in the grid to a table

  I am working with around 4 rows of data in the grid. When user input 4 rows of datas in grid and then press the save button, I want to save all the 4 rows in a dbf table. However, I can only insert the last (active) row of data to the table using the insert SQL statement. I wonder if I need to move the pointer of the grid and then use the insert statement again , but I can't find any function or method that can do so. Please kindly help. ...Show All

• Darren Thurman small test on transaction atomicity

  Need help with small test on table in database with transaction. Could somebody show state of table after execution this code: CLOSE ALL CLOSE DATABASES OPEN DATABASE "c:\ path to database\data1.dbc" SHARED BEGIN TRANSACTION UPDATE data1! table 1 SET name = 'BBBB BBBB BBBB BBBB BBBB' = Messagebox ('END TRANSACTION') END TRANSACTION if in table1 before execution was 500K records with value "AAAA&q ...Show All

• wstrnsky99 Fax using Visual Foxpro

  Is there anyone who knows how to fax a word document inside Visual Foxpro. Thank you Rolly Hi Dave, Tried your code and got an unspecified error at the RESULT=objDocument.Send() line. i've tried a couple of things without luck. any ideas would be appreciated. thx I do faxing with Windows XP. You might need to add SETUP FAXING ...Show All

• cesar.fong creating tables

  Hi all, When i try to create a table such as ==> CREATE TABLE c:\tab2.dbf ; ( year c(20),; enter_md i(20),; enter_do i(20),; enter_tot i(20),; exit_md i(20),; exit_do i(20),; exit_total i(20),; net_md_delta i(20),; net_do_delta i(20),; tot_net_del i(20) ) I get error message 'Field name is duplicate or invalid'... does any1 know why I realize they are similiar, but what is the problem Is there an easy fix Mike ...Show All

• AlbertHo cannot update cursor

  I have a main form that calls a couple of other forms to make some selections. One of them opens a table and after a selection is made a mark is left in a special field that this record has been selected. Then this small form is closed and the same table is opened in the main form. The table is opened EXCLUSIVE in both forms. Before it is opened in the secondary form it is not opened in the main form. The point is that it all works well in ...Show All

• willstewca MySQL and VFP9.0

  Hi. I don't know how to make a connection to MySQL. I used Connector/ODBC 3.51.12 to connect to MySql with no responce. When I clicked on OK after I set up parameters a massage was displayed like User Cancled. Don't know what to do... Can anybody help me Has anybody experience with connectivity with MySQL I have an idea. Can you make a sample project with a database connected to a MySql database. I was told via Connector/ODBC 3.51.12 it'll ...Show All

• jtl8678 UPDATE vs REPLACE record locking

  The VFP 9.0 Help file shows the following: UPDATE - SQL Command ,Remarks, Tip: "When updating multiple records in a table opened for shared access, SQL UPDATE uses record locking, unlike the REPLACE command." Locking Data, REPLACE: Current record and all records from aliased fields UPDATE - SQL: Entire table These statements seem to conflict. The first leads one to believe that the UPDATE - SQL command would lock records and i ...Show All

• roadragedsb Microsoft treeview: Newbie Question

  I'm using VFP6 with Microsoft Treeview. I have a little newbie doubt: Can I programatically collapse and/or expand a tree node What command do I use in order to do it Thanks in advance.   Mark.OSVATH wrote: It's simple. For example: ThisForm.TV.Nodes.Clear ThisForm.TV.Nodes.Add(, 0, "ListRoot", "Lists") ThisForm.TV.Nodes.Add("ListRoot", 4, "Lists", "Printable lists") ThisForm.TV.Nodes.Add(" ...Show All

• M_Hagen Grid objects problems/questions

  Hi everyone. I've just started using Grids in VFP9. I am trying to setup a grid which will collect info about an order. The record source of the grid changes depending on the user. I use the temporary table in the users 'home' folder in order not to conflict with other users. Here are my questions: - First, what is the best way to have a temporary file used in my form: Do I add the table to the dataenvironment at runtime Do I issue 'USE' comm ...Show All

• ChrisErven Help

  I have developed a FOX PRO 2.6 Version application which has developed the following error message when updating the cashbook receipting module.The message is " TOO MANY FILES OPEN".The application is on WINDOWS XP PROFESSIONAL it is running well on WIN 98 with the modification of config.sys " FILES = 100".I have done the same to XP but in config.nt and it still gives the error message what could be the problem . The total ...Show All

• rgallazzi sending email from VFP through MS Outlook

  We have the following code for sending email to Outlook. The email gets sent, but the font size is always 36 px or 36 pt (we tried both). None of the <cr><lf> show up. The email is one big paragraph. Can anyone help   Here is the code: LOCAL loApp, loEmailItem, cHex  lnsize = '"' + str(gaPointsize(Slcrm.nbodysize),2,0)+ '"'  cHex = ''  nDec = Slcrm.nColor    nPower = 8  DO WHILE nPower > 0 & ...Show All

• Dmitry Lomov Remove file acces

  Situation: A program written in FoxPro tries to find a file on a remote computer. It does find it. Then a new file as added to that folder on the server. The client is trying to find the new file, but an error "File access is denied" is generated. The same file is being read from the server without problem. Any ideas Does the client have necessary rights to read it If it has then it might be in use by another ...Show All