Only Title

Answer Questions

• Evdin URSAN 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

• Ponnaravi How to receive record ID???

  The subject is: I want to select some records from some table ("TableA", "TableB", ...) using Select SQL to a temporery table, then I will choose one record from this Temp Table. How can I know the exact position of this record on the source table "TableA". Please give me some advices!!! Thanks Do you have a primary key on the tables If not, how will join them Whatever the join condition that you use in your SQL will uni ...Show All

• pschmidt =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks I had planned on looking into this more over the weeke ...Show All

• Alexander Klizhentas a bug or i miss something?

    This is how it goes,  i make a prg with this coding below;    lcdir=GETDIR()   SUSP   IF !DIRECTORY(lcdir)       //some code here   ENDIF  then I run the prog, it works fine, the window that shows the directory tree pop-ups, then I click the button SELECT, the window's gone,but instead of the debugger will comes-up next or I will select the debugger from the menu, the wi ...Show All

• ShawnReed Receipt Printer Problem

  Hi to All! I am using Epson Partial Cut receipt printer for our POS system. my problem is that the printer will eject or automatically cut the paper when the lenght of the paper riches 11 inch from the start of printing. the result is ok if the customer will buy only a few items, but when the customer buy plenty of items the problem start on, the receipt is cut every 11 inch of lenght.i already select the paper for Receipt when i design th ...Show All

• RameshKoniki Delete Printer Information from Reports

  Dear Experts Out side Exe, I use following procedure to delete printer information from reports. lcPath = '' With Exe I do not distribute REPORTS Folder to clients. How is it possible to use following procedure in Exe, where there is no Reports Folder. Please Help LOCAL lnHand lcPath = "D:\GIN2006\REPORTS\" && modification is needed here in this line of lcPath lnFiles = Adir (laFiles,lcPath  + '*.frx' , "A" , 1 ) lcMsg = '' FO ...Show All

• satyam FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All

• Alberto Ferreira VFP querying records with same ID

  Hi all, I have a table with the same id numbers and different dates(ex. below) ID field1 field2...............date 1 01/03/06 1 09/04/05 1 03/13/06 3 05/25/04 5 12/12/06 5 08/05/06 I need one record for every id with the max date(date closest from today) ID field ...Show All

• mdanshin records disappear forom tables

  A few days ago I ran into yet another problem with Fox. i have a database where the tables were supposed to be filled with the content of some text files. Those files are dumps of my old dBase tables. I have a routine in Fox code that reads the text file, generates necessary number of records and fills the fields with the content between some delimiters in the text file. Anyway, it is not the first time I do it with almost the same code. I tr ...Show All

• Aseem Bansal 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

• fugu996 FoxPro character fields in .Net showing as blank strings.

  Not sure if this should be in the FoxPro forum, or the C# forum. I have a dBase database, with a table (table1). table1 contains a field (myField) which is a fixed length, 4-character field. With each record this field contains 4 ASCII characters (which were created by converting decimal values into ASCII). Now ... I think that the first 2 or 3 characters are ASCII value 0 (null). Also, some of them contain Extended ASCII codes. My problem ...Show All

• Tobin Titus Obtaining a web page's title

  I'd like to get the titles of web pages, and would prefer not to do this by loading all the web pages into a webbrowser, because that seems a bit heavy handed. In VB6 I used some APIs to achieve this, but I'm not having any luck in getting it to work in .net. Here's the code I'm trying: Module Module2 Private Const INTERNET_FLAG_RELOAD = &H80000000 Private Declare Auto Function InternetOpenUrl Lib "wininet" Alia ...Show All

• Brian OByrne MSGraph.Chart.8 control

  I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All

• moobah How to know where a class is being used.

  Is there a way to know where in an app a certain class is being used thx. The Code References tool can be useful here. Tamar ...Show All

• GeoffK 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