Recent update: 2008-3-21
Hello Experts: I am using FPUTS to write text to a file. At the end of each page I need to insert Form Feed Character. How can I do this?
Hello again, I have a problem using a variable in a thisform. statment. I tried it using the following code: IF v_sichtbar < 10 then DO WHILE v_sichtbar < 11 v_button = "button0"+ALLTRIM(STR(v_sichtbar)) v_label = "label"+ALLTRIM(STR(v_sichtbar)) thisform.v_button.visible = .F. ...
694 byte By
jetsu at 2008-3-5
this sql is okSELECT NA.*, DV.YN_CODE, NA1.NA_COMPANY AS NA_1STNAME,NA.AW_LEVEL,SPACE(30) AS MIG_OFFICE,NT.NT_TYPE,AN.AN_TYPE,AN.AN_WRKRID FROM TmpCurs_AllDonors2 NA LEFT OUTER JOIN TmpCurs_AllDonors3 DV ON DV.CM_ID = NA.CM_ID LEFT OUTER JOIN NAME NA1 ON NA.NA_COID1ST = NA1.NA_ID LEFT OUTER ...
Hi there, I have a maybe dumb question. I would like to use a graphic as a button with text on it that i can change. This is easy with the button object but on that i am not able to place the text over the graphic, showing only the graphic with the text on it. Text cut just be placed obove, ...
HI!I designed a Software in VFP 6 & also developed Some Reports.Problem is when i use Printer Like Epson Dot Matrix & other epson series it works fine but when i install Laser printer & want to use, then my software even System hang.I have to do restart my system. I wanna use any ...
http://www.code-magazine.com/focus/article.aspx?quickid=0404052&page=2 Hello Guys, While reading the above mentioned article i came across a problem. The article talks about the AutoHideScrollbar Property Value to be 2, but i have only two options in this property(0 & 1). Is there ...
hello guys, I post here my problem and hope that there will be certain VFP expert to help. The problem was that when i call the MouseDown event from an OleListView control (this ole is inserted in FORM1). This MouseDown event will show a shortcut menu (1st shortcut). A Command in the 1st ...
hi all,I've just finished a small program to search some filetype on my harddisk. The code run very well but it seems to me that it 's a bit too.... lenghy. Is there anyway else to search file without having to use ADIR function?*//CODE? SearchFile("D:","mp3") &&This will show the ...
274 byte By
Onelle at 2008-2-26
I planned to develop POS in Visual Foxpro, How can I integrate barcode scanner and cash register with the system. I mean How can I control the cash register to open/close.. and barcode also how can i capture the result of the barcode... Thanks in advance.. Im just a begnner
Dear Experts Now, this time I am facing the greatest problem of my life about vfp and my future. For the last about three years all of my softwares were runing properly but unfortunately from the last month I am facing these error messages 1- D:\ginning\accounts.exe is not a Visual ...
I just wanted to say thank you to microsoft for giving us this forum. I know there are a lot of great forums, but this gives us a chance to be a fly on the back of the couch in the living room at microsoft...This may well become my primary forum to turn to now when I have some real questions to ...
I'm working on a project to do some analysis, and difference between versions of ClassLibraries (VCX/VCT), Screens (SCX/SCT), Projects (PJX/PJT), Etc...I'm looking at the Uniqueid field which is a sys(2015) type of value, which is based on a given system date time. I've seen an article that ...
Select * from myTable where isnull(myTable.keyField) = .f. into array myArrayif alen(myArray) > 0** Loop through array and Do processingend ifIn a situation where records selected by the query are 0 then the array is not created and thus the next statement gives an error. How can I check if ...
I have an app that used to run correctly. A few weeks ago I got hijacked and haven't been able to configure the reports correctly again. Here's the scenario:I have an HP LJ 9000 which has the ability to stack and staple and has four paper sources. The app gathers data and then prints a series ...
I've been fighting an almost epic battle these last few days with Foxpro, to try to access its Stored Procedures with ADO.NET.Here is my code: Dim conn As String = "Data Source=Q:\network\Gestion\stage.dbc;Provider='VFPOLEDB.1';password='';user id=''" Dim OleDbConnection2 As ...
Chdir(SOURCE_FILE_DIR)numfiles=Adir(filearry)I know you get files that have a specific extension like this: Adir(filearry, '*.TXT')BUT can you use a negative condition with Adir?Example: get files from a folder where the extension is not .txt or ...
When I try to install VFP 9.0 by clicking the link on the auto run page that appears when you insert the disk, I get the message "Please go to the control panel and add or configure windows components"If I run from the add programs in the control panel I get the setup screen and click ...
Hello Guys Vfp9 overall is very overwhelming for guys like me who have started very small with FoxPro 2.0 for DOS. Learning VFP 5 (on my own) with no decent books and absolutely no training available and getting all these releases and not all that time to get acquainted is really difficult. One ...
Hello Guys The code below works fine (complete code). The problem is, how can one set the number of rows in the following lines. These two lines sets the chart data parameters. Although one can use "oSheet.UsedRange.Rows.Count" but how to encorporate it in the code. Please complete the ...
Report has 3 tables: (Customer, Orders1, Orders2) - Customers Main Table (Group 1- Customer.pkey) - Detail Band 1: Show all orders placed by customer (Group 2 order.pkey) Sample Report appears like this: Customer 1 Order1 Date1 Apples 2 Order2 Date1 Oranges 3 Order3 Date2 Apples 4 Order4 ...
137 byte By
jetsu at 2008-2-15
if not,how can i get the unique numbe of each record? for example in vfp i can do like this select *,recno() from tablename
Hello Guys Can someone redirect me to a page where i could find a simple sample of CA (Native) or if one could send me an email. Please don't use the ca class if you would send me an email. The problem is when i use an access database, it works fine but when i use a vfp database, it shows me ...
How could we show a define window into a top level form, where-in screen visible is set to FALSE? Because I try it, and it doesn't show-up, maybe i got wrong in coding. Thanks for any help Amado
282 byte By
kau at 2008-2-15
Hello, When I run setup.exe for Visual FoxPro 9.0, welcome screen is displayed with two links activated; prerequisites and Visual FoxPro. When I click either on these, setup program hangs and nothing happens. This issue is valid also for Visual FoxPro 8.0. Any ideas? Thanks
303 byte By
jetsu at 2008-2-15
date transfer20050101 200.00 20050103 -100.00 20050530 95.30 ... SQL to get： date transfer balance 20050101 200.00 200.00 20050103 -100.00 100.00 20050530 95.30 ...
872 byte By
jetsu at 2008-2-14
Hi guys i can use ado connect to local .dbf and sql server and get the data from it.but i found i can't use movepriveous,movelast function of ado object and also i can't get the recordcount ,any idea?o=CREATEOBJECT("adodb.connection")o.ConnectionString="Provider=VFPOLEDB.1;Data ...
252 byte By
jetsu at 2008-2-14
my user want the data is sort by the field's content. the content is "I","E","C","A" and BLANK if just ascending and desc ,it's easy. but now they want sort by this sequence "I","C","E","A" then blank so how can i do it? thank you
Technically I don't even fall into the noob category. I have been tasked with using foxpro for a project at work. I have zero experience with vfp. The version we have is 9. The only books I can find detail what is new for version 9. is there a book out there for the absolute beginner that is ...
My installshield will not install properly, it hangs up and sends a message that looks like this. I am on a single user system, no networks."A network error has occured while reading the file (super long file name here) Foxpro Express limited edition .msi"I have v 7, 8, and 9 on the computer.Do ...
I cannot get foxpro to save the path settings in the Environment Manager, every time I exit out and return the path is gone. Any ideas?
I'm trying to get us where we can use the Automated Testing Harness with our products. We're having some difficulty in being able to work it with ActiveX controls such as the listview, toolbar, statusbar etc.I've narrowed the problem down to at least being likely in the GetContainerForm ...
Is there any way I can trap for an F10 in a keypress event? We have a legacy app which is using ON KEY LABEL to capture an F10 key press. I can't trap this in the KeyPress, I assume becasue it has the same key code as ALT which KeyPress can't cope with. Changing from F10 to another key is not ...
Has anyone had any errors migrating the VFP80 menus to VFP90? I have two applications where the strangest errors have occurred. I use the generated menu pad names in my application to call various menu options. This had always worked fine on previous versions. I am developing in XP.In VFP90, on ...
Good day to everyone...My problem is about the active mainform of my application which is top level form. All settings has already been set, compiled with no errors and deployed at the workstation. This small VFP program is just to warn me at the server if a certain workstation is already ...
969 byte By
Pepo at 2008-2-8
I'm trying to execute a stored procedure in my webform, I tried the next code: OleDbCommand cmdtemp;OleDbConnection conn;conn = new OleDbConnection(ConfigurationSettings.AppSettings["strConnection"].ToString());cmdtemp = new OleDbCommand("storeProc_1",conn); cmdtemp.CommandType = ...
Is there a way to launch Adobe Reader with a file name from within VFP90? I want my users to be able to print PDF files without having to search for the files - the search would be done through the GUI. Thank you,
18 byte By
jetsu at 2008-2-7
thank you Jet
The Preview Toolbar in VFP9 is not enabled when a report is generated to Preview from a compiled EXE. _reportbehavior is set to 90. The 90 preveiw toolbar is displayedThe application runs from a main form (modeless, as Top Level Form). Displays all reports to a preview form that is is either ...
How can we get those spaces which comes before and after the text in the grid column. You can see it in the browse form of data explorer. Thanks Guys
130 byte By
Nora at 2008-2-6
How can i create a directory when the app begins but validating if the directory exists avoiding an error code? thanks a lot!
(1) I've made and deployed a simple app. with its own helpfile, but when deployed, nothing happens when I press F1. (It is not, that the app cannot locate the helpfile. If I rename it, I get an error when starting the program.). Any suggestions?(2) The other problem is, that about one in every ...
My app takes up less than 0.5 MB and the required ressoucefiles (vfp8t.dll & vfp8renu.dll) take up 4.8 MB and yet the setup.exe created by Installshield Xpress is more tha 10.5 MB large. Any suggestions to how I can reduce the size of my distribution setup file ?
1295 byte By
glenna at 2008-2-5
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 = '"' ...
Hi! on Visual FoxPro 6.0 I created COM object (my_com.dll) as MULTI-THREADED COM SERVER DLL. but when I try registrated COM object I got the error regsvr32 my_com.dll "DllRegisterServer in my_com.dll failed. Return Code was: 0x80004005" Why?
600 byte By
octav at 2008-2-4
hello. i'm just a beginner and i'll need help to can continue my project in Fox Pro v2.5. i don't know why my print work so hard. i set in program ? char(18) and i must wait almoust 20 seconds to print my page and write on my page what i need and after that the print will stop and my page ...
233 byte By
hebert at 2008-2-4
where I can find a manual of extrinsicos objects of excel and Word (.add, font.value, .HorizontalAlignment, .Font.size , etc, etc )to be used from Vfoxpro urgent. how set a cell in excel to numeric format? grazie
343 byte By
Nora at 2008-2-4
Hi, I need help, I have to modifiy a VFP 6.0 application and everytime I edit the MPR file I lose my changes, What I do is open the file, then I change some captions, then I compile the file and that's all. When I build the exe file, all my changes disappeared. What am I doing wrong? Could you ...
47 byte By
jetsu at 2008-2-3
i found i can't use free table for CA. Jet
236 byte By
jetsu at 2008-2-3
Hi everyine i want to learn about cursoradapter class. for instance ,how do i can browse, modify, add, deleted, restore data into table by using CA.then could you tell where i can find the materials of CA.;=) thank you Jet
489 byte By
Uday at 2008-2-2
Hi there, I am converting old dos program into foxpro 8.0.I am facing problem with below statement.On error lError = Error() the code excuting and throws to error, but I am not getting error number. It is giving always 0. Message() is giving correct error description, I verified in debug ...