Answer Questions

• eldiener How to print the current page in VFP?

  Can we do this in VFP 9 Thanks. I wish to add a new button to print just the current page. sometimes the report contains up to a hundred pages. But only one or two have corrections and need to be printed out. If you use the ReportListener, you can use Reportlistener.outputpage(1) to print the first page. The type has to be 0 or 2 for page at a time mode. See ReportListener help for code samples. Thanks, alwayslearning. I will try to learn. But if anybody can give some samples Yes, as was suggested, see the ReportListener Help for examples.... Or you could check the white papers on the VFP website - there are three there, ...Show All

• psi_0 application and webdata interacting.

  ok first off here is some info about my webserver: i dont no if you needed the information but maybe you do General server information: Operating system Linux Kernel version 2.6.17.11-grsechg Machine Type i686 Apache version 1.3.37 (Unix) PERL version 5.8.7 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail PHP version 4.4.4 MySQL version 4.1.21-standard cPanel Build 10.9.0-CURRENT 117 Theme cPanel X v2.6 ...Show All

• Corinna Vinschen DataEnvironment open tables, sometimes fails.

  Considerations: a) This application ran several years in VFP6 without problems. b) The problem appeared after compilation on VFP9. c) She runs on VFP9-SP1 - Windows Server 2003 SP1 - Terminal Services. d) The server holds 1GB RAM; (15 users max in simultaneous) e) The application is composed by 280 forms; 250 tables in 4 databases. EXE file 10.5MB. f) All forms hold the following configuration: .DataEnvironment.AutoCloseTables = .T. .DataEnvironment.AutoOpenTables = .T. (No code in DataEnvironment events) .DataSession = 2 (Private DataSession) f) The error happens occasionally independently the user, form or server load. (I don't get associate any server load variation.) g) We regi ...Show All

• DukeZZZ Preventing key strokes to be passed to control

  Hi, I have a form that needs to read data from a bar code reader. The bar code reader connects to the keyboard plug and functions like a keyboard. So what I would like to do is to have the user click a "Barcode Read" button and then scan all the bar codes he needs to scan and then click a "Done" Button. I was going to intercept the barcode data in the forms "Keypress" event and store it in a table. Problem is that I have so far found no way to stop the keypress data to be passed to the current control. As each set of data is terminated by a CR each time a barcode is read you jump to the next control and when you get to one of the buttons <CR> just clicks that button. So what I need is to intercept the ...Show All

• AnaC how could I change the Client's IP address automatically

  Good day to all experts, how could we change the client's IP address automatically from the server . I have a small program running at the workstation and have also a program that monitor the workstation at the server which both works fine. But sometimes the user change the ip address which was manually configure and if i use DHCP they put an IP manually just for fun or just for experimenting or what-ever their motives i don't know. So i am thinking, if why not checking it at the server if one station's IP address has change , why bothering going to the workstation if it can be easily replace automatically from the server Thank you very much for your help regarding this matter. Have a nice day to all OK, I will think ...Show All

• jkmurty Two Things >>Index<< and >>Help Docs<<

  All, Running Ver 6.0 and need help docs as somehow they are no longer working on my system. Also what I'm looking for is how to link in INDEXes It have two tables: mine.dbf and mine.edb with indexes of mine.ddx and mine.edx First .dbf is contact info, but email resides in the .edb file. Need a join on this, through the idexes to port to new table. All help appreciated! Tbotnik In VFP 6, the Help was installed as part of MSDN. You should have a separate CD that lets you install Help. As for your other question, I strongly recommend that you don't use alternate extensions for tables. Make your changes in the filestem, not the extension. Trying to maintain indexes with an extension other than CDX i ...Show All

• Alex2200 Valid event

  Hi, I need to put a validation to a textbox field. I put some code in valid event. But when users enters a wrong value appears a message generated by visual fox pro: "entrada no valida"; How can I disabled this system message and use a messagebox to display my own messages . When user enters a wrong value, I write that valid event return false. Thanks, ON ERROR * is almost never a good idea. Hiding errors doesn't cure them. Tamar You may put (berfore or in form init): ON ERROR * and you will never receive a message error from system or use: ON ERROR [ Command ] Command may be a small error handler with a messagebox included... ...Show All

• Raju Sreenivasan Tables Relation

  Dear reader, I hope you can help me. I dont know how to relate two dbf free tables files. Table Sub (submenus Items belongs to) ID OWNERID USERNUMBER SHORTNAME LONGNAME EXCEPTIONS ITEM01 ITEM02 ITEM03 ITEM04 1000 0 1000 Entradas Entradas 0 1001 1002 1003 1004 1100 0 1100 Ensaladas Ensaladas 0 1101 1102 1103 1104 1200 0 1200 Sopas Sopas 0 1201 1202 1203 0 1300 0 1300 Cremas Cremas 0 1301 1302 1303 0 1400 0 1400 Ex tico Ex tico 0 1401 1402 1403 1404 1500 0 1500 Aviant\nCuisine Aviant Cuis ...Show All

• TedSA Suggestion for VFP-MySQL Multiuser env.

  Hi all, I've just shifted from Foxpro tables to MySQL server based application. For a multiuser environment in VFP I used to have the temporary tables for the individual users in their own local machines. But in case of Mysql / oracle how to handle this situation The temporary table that I 'm speaking of are generated when I want to create some reports or perform some maintenance on tables. For example consider a scenario of producing a Sales analysis report. In VFP based application I created a local table say temp and put the data from invoice, invoice return and all related tables. then I manipulated the temp table to suit my reports. There was no problem in multiuser env. since each user created their own 'temp' table in thei ...Show All

• MLee11 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. Thank you so much, Marcia. It isn't mandatory, just hopeful for aesthetics sake. I'll look into your web and/or comment later. 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 ...Show All

• Rohit Ghule Calculation in a excel sheet

  Dear Friends, Is there a clue for how to calculate a value from the datas transfered to an excel sheet from Foxpro. eg: there are three columns in an excel sheet those are the columns filled with datas, I want to use these comumns for creating a fourth column which is the result of the calculation done using the three columns. Thanks again for your valuable comments Satish D1=SUM(A1+B1+C1) A B C D 1 10 11 12 33 2 3 4 You can use offset() function with sum(). ie: Dimension aTest[10,3] Local ix,jx For ix=1 To 10 For jx=1 To 3 aTest[m.ix,m.jx] = m.ix*1000 + m.jx*Int(100*Rand()) Endfor Endfor ox = Create ...Show All

• StairCounter character fields to numeric

  I have a table with some fields like as below which are characters. i want to convert them to numeric and store them in another table. can someone assist me please field_1 field_2 field_3 000000057770.00 000000057770.00 000000000000.00 000000154948.00 00000-279204.00 000000434152.00 000000069766.00 000000016928.00 000000052838.00 Oh I thought you understood the code and corrected the typo: SELECT * from myTable INTO TABLE newTable FOR ix=1 TO FCOUNT() lcField = FIELD(m.ix) replace ALL (m.lcField) WITH TRANSFORM(EVALUATE(&lcField)) ENDFOR ALTER TABLE newTable ; alter COLUMN field_1 b(2) ; alter COLUMN field_2 b(2) ; alter COLUMN field_3 b(2) I d ...Show All

• Mark Cryer Setting a date in VP 6

  I want to set a date field to zeros I use to use "replace datefield" with {"00/00/00"} but vp 6 doesn't like it. Any help would be appreciated. Thanks replace datefield with {} this worked great thanks Very nice problem. In mysql it seams to work with datetime but in vfp is not working because I think vfp validate the date expression. You may try to display a character textbox with "00/00/00" over date if date is "blank". A date filled with zeroes is meaningless and not a valid date. If you want to show no date, you could either  set it to empty with Replace DateField with {} (this is a VFP concept, ...Show All

• Dave Gestner vfp online?

  ok well i found a potential client but he needs an online application...... what should i do about this i know vfp pretty well and the only thing i can do online is save/update records in a file using php and my sql..... is there anyway to incorporate vfp to an online application i need to retrieve and update information in a table that is on my server. i have 2 people at 2 different locations and i want them to have access to the same data. Try: www.foxweb.com Define what you mena by online. a) a website (sending HTML from a web server). b) a Windows Form that communicates to a remote server through HTTP c) a Windows ...Show All

• tyaramis Report strategy

  Hi everyone; I am going to develop quite a few reports for a customer. They want to develop a report engine that would let them customize reports both in the scope and in the format of the report. I am wondering if I should use a third party product like CR. Can someone give me some pointers ergarding the benefits of using CR or other reporting engine, and also how difficult is it to incorporate such reports into my application, and letting users customize reports Thanks. You might want to take a look at Stonefield Query for the functionality you need. www.stonefield.com. Tamar Aleniko wrote: How easy is it to customize fields in a re ...Show All