Answer Questions

• Cool Screen Name can't find object after compiling

  After I create an error free form and build an Application for testing, I find that I get an error - Object "appt" is not found- (error 1923). This occurs when calling ths form from a complied menu pull down, with the code "Do form c:\apptbook\forms\appt.scx in it. This occurs when I exercise some code in a combo box like " appt.combo4.value". I don't get it, because I can run the same form with a command - Do form C:/apptbook/forms/appt.scx in the command window and all works fine. Regards...Al I thank you for your help. this was one of those "can't see the forest because of all the trees". I normally use thisform.xxx command all of the time, however th ...Show All

• helsingfors Produce error when running the form

  Hi, When running the form, I got the error. The error is "Error loading file - record number 61. grid_detail < or one of its members>. ControlSource : Alias 'NEWDETAIL' is not found." I'm not sure where i go wrong on my form. Thank you. I ran through the errors in the program and found nothing wrong with the codes. My senior IT said that there is a bug in the Visual Foxpro 6 software itself. The codes in the open file and close file method in the Data Environment has switched places. So have to correct them in the right form method. Now the form runs well. OOO normally i wont much depends on database environments. i know its fast retrieve data but i wan more control on my data. just an ad ...Show All

• Super_user Error trapping - lacks info.

  Hi; I am using an error trapping routine in my new VFP app. I am using the ERROR( ), MESSAGE( ), MESSAGE(1), PROGRAM( ), LINENO( ) and SYS(2018) functions to log info into my error log. Often message(1) in the log would be empty. And sometimes I would get the following as the source: "Foxcode table not found, is not correct version or is incompatible." Help... From the Help file: Note MESSAGE(1) is not available in the runtime. If the program source code is not available, MESSAGE(1) returns one of the following: The entire program line if the line is macro-substituted. A command if the line contains a command without any additio ...Show All

• Casper Thomsen Tiff files

  Hi gurus I am very new to VFP, so go easy on me. I would like to create a tiff file from a report, I dont want to view the tiff file or to open the tiff file once created, once the report runs, I just want to be able to give it a name and to save it on a folder as a tiff file. Can some help me with some code that I can see and learn or point me to the right direction or let me know where can I find some help on this matter. Thanks a bunch gurus OHHH.- VFP9 almost forget Thanks again gurus You may use ReportListener for tiff file.You will find a code exaple here: http://msdn2.microsoft.com/en-us/library/ms965281.aspx That is the way to do it from vfp. The "easiest way& ...Show All

• i386 Help on Report Writer Wizard

  Hi guys, Hellllpppppp. I am very new with VFP and already getting frustrated. I would appreciate a little help from you gurus. Using the Report Writer Wizard always gives me this error message: "The DBC containing the selected table was previously opened non-exclusively and the field(s) you chose for sorting are not in existing index tag. Please select field(s) which already have an existing index tag or exit the wizard and reopen the DBC exclusively." I have done ALL of them and I still get the same error message. Thanks You may find the solution here: http://support.microsoft.com/kb/141074 I'm not a guru but would consider one of the following object clean up c ...Show All

• csann Auto test a vfp form of exe

  Dear Experts, Is there any testing tools that can work with a vfp form or exe to repeat a set of mouse click say 10000 times for a stress test Any suggesion and thank you in advance. Milton You may repeat in a loop, a click method on a control and increment a variable... As per DNI, with MOUSE command For lno to 100 Mouse click AT nRow1 + lno , nColumn1 + lno && etc. endfor ...Show All

• Michael_317 VFP6: Problem saving data

  Hi all The VFP database system is running in the server so that all the workstations can share it. The user complained that she could not save the data after amending. I tested to see whether I was able to save it on my side. It works successfully. I went back to the user’s workstation to verify it but still the same problem. I tried other workstations and found no problem so far. Assuming that there are a few possible causes: 1) Computer in the workstation is not maintained well. 2) Email virus will affect the database system if anti-virus software cannot detect it. 3) There is file caching problem in the workstation. The workstation will "hold" certain data and then release it to th ...Show All

• GazNewt Command contains unrecognized phrase/keyword VB.Net

  Hi I am facing the above problem when I am trying to insert a MEMO data in to the VFP table. I am using a OLEDB connection string in VB.Net My data present in the file is //------------------------------ Pen Pencil Erasier Sharpener //---------------------------- Each an every line has a (Vbcrlf) that is a line feed in it I need the File as in the above format to be stored in the memo file without any change I get the data from the file by the following procedure ---------- Dim lstrData As New String (" ", 500) FileOpen(1, "C:\soc.txt", OpenMode.Binary) FileGet(1, lstrData) FileClose(1) -------- I get the data in the lstrdata Now I use sql statment to insert i ...Show All

• FrankyLi 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" and VFP process was killed after click OK in messagebox and before all trasaction bufers was stored in dbf file (2-3 seconds after click OK) I interested in "select count(*), name from data1!table1 group by name" output Hm ... I can't find connect ...Show All

• LiamD switching pages in pageframe

  I want to be able to detect when I am clicking on a page tab to switch pages, so I can control which portions of a lostfocus event on an object in the current active page will execute. I appears that I can't use mouseenter on the target page, like I do on command objects. UIEnable might be what you're looking for Note that, with command objects, I always use mouseenter and mouseleave (which activate irregardless of the focus) to fill and clear a form property with the object name. That way, I always know if I clicked a button or not. The perfect use is skipping validation code imbedded in a lostfocus if I click a <cancel> button. I can't find a similar ...Show All

• Juan Ignacio Gelos convert text files to certain format

  Hi there, I would like to convert the text file to a text file but with "" and ; to separate the data. How could I do that Pls advice whether foxpro itself can do that or need to convert it to dbf in order to get the format. Need urgent help. Thanks. If it is in a DBF you can copy to text like this: COPY TO myfile.txt DELIMITED WITH ["] WITH CHARACTER [;] If it is in text format already, you can use STRTRAN () but it would depend on its current format. You can also use low level functions ( FOPEN (), etc.) For example, you could convert a standard comma-delimited file (CSV) to semicolon separatos like this: e.g.: "1234","abc","xyz" strtofile(strtran(filetostr("c: ...Show All

• MikeTennor How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! Who is generating the phrases and add them to field1 You may create a loop (do ...while) and read the field and compare strings, or if you ha ...Show All

• Paul Mitchell Clipper bug in record 1220?

  we had an error during rebuilding indexes in a clipper program. we run the records by 100s to see what is really wrong with it. when it reached the last record, that is 1220, an error appeared. but when we added a blank record, the program run smoothly. what could have caused the error What kind of index are you using SharathMum wrote: can u post the error message error in line 99 where 99 is just the line number. the line number consists of set index to abcd where abcd is the indexname Sounds like a corrupted index file. Delete it and rebuild it with INDEX ON, then test again. please check whether u have the ...Show All

• TaiChiMaster Scripting Visual Foxpro Database

  I want to generate a database creation script that is Transact-SQL compliant for a Visual Foxpro database. The code generated by the Gendbc program will not run if I execute it in SQL Server for instance. Is there any way I can do this using Visual Studio 2005 Or is there a tool that can facilitate this process I am writing a program (in C#) to dynamically create a SSIS package that will transfer a Foxpro database to SQL Server 2005 Express and will need to generate a script dynamically when the user points to a source Foxpro database. Any ideas Visio Enterprise Architect will also allow you to forward engineer a Foxpro database and create a SQL compliant script. You may also want to look at Stratra ...Show All

• Eagleguy125 rounding bug in vfp8?

  I have found what seems to be a rounding bug in VFP8. Any ideas how I can get around this please I was doing some testing when I found that I was a penny out on digging deeper it seems that when lnValue = 0.57500000000000, Round(lnValue,2) gives 0.57!!!!! when it should give 0.58. This is causing my validation to fail. Is this a bug The strange thing is that Round(.575000000000,2) gives 0.58 but the extra 0's in the scenario above are causing the difference. same problem also in vfp6 and vfp9... Darren, Since you're dealing with 2 decimals only this might be used as a workaround: round( ntom( m.lnValue ), 2 ) CetinBasoz wrote: Darren, ...Show All