List of Procedure s

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - addobject - loses original class methods? Using addobject to add say a preprepared custom checkbox class seems to lose the method code in that class? Is that right? e.g. I have a class lmcheckboxgrid based on checkbox which has code in the When and Valid methods. After using addobject to add an instance of that class inside a grid column, the when and valid methods don't fire. The only way I can get it to work is to drop the checkbox class into each of the columns of the grid class which I was hoping not to have to do. Is this standard behaviour for addobject? Regards, Bernie Tag: List of Procedure s Tag: 211397
  - 2
    - switching to other open programs!! Hi friends this is interesting problem.we've vfp8 application (vip).we recently released a new build to clients. sometimes VIP is jumping to other applications that are open. we've found since the new upgrade that for no particular reason when users hit random keys in the middle of various procedures within VIP that it will jump to any other application users have open. It mostly skips to Outlook Express but on occasions when MYOB is open aswell it will go to that. Once in the other application they simply have to use the mouse to click on the VIP on the taskbar and it will take them back to VIP and they can continue. any ideas on where to start. initially we thought it was some application having hot keys but looks like it is unlikely as we've received complaints from more than a handful. Thanks for the ideas -- cheers Tag: List of Procedure s Tag: 211389
  - 3
    - Refresh data from Remote View In VFP 6.0, when users add or edit records in remote views, other users on the network can not see the changes. Atleast until they exit the application and reenter it. The views are from Oracle 9 tables. Besides issuing a Requery(), what can be done so that the users can see the updated data in these tables? Thanks for the help, Dale Tag: List of Procedure s Tag: 211371
  - 4
    - Show non-table value inside grid Hi all, I've had this question for long, but haven't found a solution in VFP8, I wonder if maybe VFP9 can do something extra. I have a table with some data that I want to show in a Grid. However the data has codes like "F" for Phone, "X" for Fax, etc. This information is stored in a 2-dimensional Array (discription, code). I'd like to show the actual discription instead of the coded value in the grid ofcourse. I can't figure out how to do it in VFP 8 without creating a cursor for it. Also I'd prefer not using combo-boxes cause they make the grid alot "heavier" to look at, but even with Comboboxes I didn't find a working solution. Can anybody help with this ? thankx !! Xavier, CPS Tag: List of Procedure s Tag: 211362
  - 5
    - Finding rows affected by T-SQL Update or Delete I'm doing some T-SQL queries and am encountering some strange issues. I did most of my development in VFP9, where I did something along the lines of: SQLEXEC(hSQL, 'DELETE FROM table1 WHERE Value = 'Bad'' + CHR(13) + CHR(10) + 'SELECT @@RowCount AS SQLTally', 'SQLTally') m.nRowsAffected = SQLTally.SQLTally When I went to test this in our production VFP6 environment, the SQL statement refuses to generate the SQLTally cursor. It appears to execute fine, just doesn't return any results. If I execute the two lines as two seperate SQLEXEC() statements, I can get the result cursor. My question is, does anyone know why this works in VFP9 and not in VFP6, and how to make it work in VFP6? Also, when executing the query in Query Analyzer I get a nice (X row(x) affected) summary in the Messages tab. Is there anyway to capture and parse this Messages info in VFP after a SQLEXEC, rather than executing a @@ROWCOUNT query? I think I've seen code in the past that captures this type of info (can also be generated SQL side with PRINT) but I can't find any examples anywhere. This would seem to be the more accurate and efficient way to get the information I want. Tag: List of Procedure s Tag: 211341
  - 6
    - c0000005 when previewing two reports at the same time. If, in VFP8 SP1 (Or VFP7), create two simple reports. Open both reports in report designer at same time. Preview one. While it is in preview mode, right click the other report. C0000005, Menu manager internal consistency occurs. I have duplicated this on three different machines, it is surprisingly easy to duplicate. VFP7 also does this, and if I get a chance I'll try it with 6 and 9. Tag: List of Procedure s Tag: 211340
  - 7
    - FormulaR1C1 i have an excel spreadsheet that uses a Formula. it all works fine with one exception, the Formula results are based on data from A fospro table. i am holding them in an area of the table that dosent matter. and then showing them in the proper fields. my problem is, when looking at the XLS in excel its fine, but when printing it prints out the formula results. is there anyway to Hide the formula so it wont print? Tag: List of Procedure s Tag: 211334
  - 8
    - Duplicate program?? Started a new project, the Main Program is "czmain.prg" in my programs sub-folder. On a Build I get: The name of the object file for "d:\czhouston\programs\czmain.prg" is already used by another program in the project. Not in my project, any ideas? Frank Tag: List of Procedure s Tag: 211321
  - 9
    - Accpac Guy .. Do not know whether it is a propper forum or not but want to know about any person having some expertise in Accpac Version 7.? Tag: List of Procedure s Tag: 211316
  - 10
    - To inpute lines in win.ini file I want to input some lines in win.in file. for eg: I want to add 'Run =backup.exe' under [windows] braces. Is there any code under in vf9. ? pls write with code thanks in advance Sameer Tag: List of Procedure s Tag: 211308
  - 11
    - VBA in VFP, how to determine the selected table index I have 8 table in one document and has been point cursor to one of the table by bookmark. How do i determine the table index of current cursor position ? Tag: List of Procedure s Tag: 211302
  - 12
    - receive pop mail I wish to make a free .pop. e-mail client, simple. I know to send e-mail using CDO, but how to get it from server? I've tried some winsock examples, but always got message "Class is not licenced....." nothing works... Found a few ocx on web, but they are not free... Please help... -- Tag: List of Procedure s Tag: 211297
  - 13
    - How to call Outlook Express from VFP I am making an application to send mail thru Outlook Express I want to call Start Outlook Express and set the To Email, Subject, and add a attachment to the Outlook Express. After that the outlook express would leave it for the user to enter message detail and send out manually. Does anyone know how to do it. ? Tag: List of Procedure s Tag: 211292
  - 14
    - Import BTR files? I have in the past imported files from an AS400, and files from MS SQL, or access etc. Now I have a need to import the customer master table from a pervasive database. Having no experience with importing these types of files Iwanted to ask first. Can it be done, what do I need to know etc? Thanks you (the files end in .btr) Tag: List of Procedure s Tag: 211280
  - 15
    - FRX to PDF os: windows xp pro sp2 vfp: 6 sp5 hi, how is the best and fast way to do PDF reports and free? :D TIA, AP Tag: List of Procedure s Tag: 211278
  - 16
    - Select Alias vs Data Session I have a strange problem here: In my app (VFP 7), I have a bunch of tables opened. Let's say Table1 is opened in area 1 as alias Table1, and Table2 is opened in area 2 as alias Table2, from DatabaseABC. I have Form1 in which Table1 is the source of data. In Form1, I click on one of the listed items and this opens Form2 with the details coming from Table2. To show data from Table2, I do a SELECT TABLE2. The data is not showing properly. I kept the Data Session window opened to see what is happening and after I issue SELECT TABLE2, the alias TABLE1 is still highlighted as selected. How could this be??? (To go over this, I issue a BROWSE, and only then TABLE2 is selected... stranger, no?) Please help... I'm supposed to ship this app to my client this weekend! Pat Tag: List of Procedure s Tag: 211273
  - 17
    - VFP9 and vfpcom.dll Any one here know when the vfpcom.dll will be fixed to work with the VFP9 runtime files? Thanks and regards - Bill Tag: List of Procedure s Tag: 211268
  - 18
    - How to read Windows User-id Can you give me some vis fox 6 code to read the Windows user-id? TIA. Joe Kelly Tag: List of Procedure s Tag: 211264
  - 19
    - Install application on Windows 2003 SBS We are attempting to install a VFP 8 application on the above mentioned Windows 2003 Small Business Server. We get a problem during installing the runtime file, namely the following error message appears when trying to upgrade STDOLE2.tlb. Error 1931: The Windows Installer Service cannot update the system file: C:\Windows\System32\Stdole2.tlb because the file is protected by Windows. You may need to update your operating system for this program to work correctly. I understand what the error means but the installation file build usind the version of Installshield that came with VFP 8, uses the MS supplied merge modules to install the VFP runtime files and their dependencies. Does anyone have any ideas on how to get around this error? TIA John Tag: List of Procedure s Tag: 211255
  - 20
    - question about limitations etc over vpn? I am considering helping/consulting a small oilfield company to have a "specific to their operation" VFP program developed that will allow them to enter information about maintenance details on Pumps and Compressors etc, and have it create automated Work orders etc. They have looked at several canned programs, but all offer way more than what they want. The question is, if it is written in fox pro, will it easily handle say 2 to 25 users simultaneously using it, and even more important is that not all users are in the same building. Their company is connected via ADSL. Right now this ADSL connection affords them the connectivity to use their existing business system, so the connectivity I know is good. Feedback greatly appreciated. As well, if there are any experienced developers (that can allocate the time) that are interested in a project as such. Dan Tag: List of Procedure s Tag: 211250
  - 21
    - ZIP files Hi, Do you know how to use windowsXP library to make ZIP programaticly from Foxpro? Thanks Tag: List of Procedure s Tag: 211249
  - 22
    - ZIP files Hi, Do you know how to use windowsXP library to make ZIP programaticly from Foxpro? Thanks Tag: List of Procedure s Tag: 211248
  - 23
    - Here's a question you don't see everyday! Thanks in advance for the help... I'm sure most of you know that if you press Ctrl-F in the VFP IDE you get a "Find" window. Is there any way to move the Find window using the keyboard? Those of you that are curious as to why I would need to do this can read the rest of this message. I have two monitors connected to my PC and there are times when I use gotomypc to work remotely. gotomypc only displays one of the monitors (the one on the left) and I usually keep VFP on the one on the right. I have no difficulty moving VFP itself using the keyboard but the Find window always re-opens in the last place it was opened which in this case is on a monitor that I can't see. Thanks, Jeff Tag: List of Procedure s Tag: 211245
  - 24
    - select multiple printer option dear members i have created a report in vfp9 using one printer say (HP640). But If I select different printer by using (SET PRINTER TO NAME) from the network, it is going to the previous one which i used to create. I want to send to both printer(more than one). If any member can help me in this matter, I would be thankful. Regards, Sameer Tag: List of Procedure s Tag: 211241
  - 25
    - RUN command fails Hi All, The follwing flash executes successfully from the command window, but gives an error when tried through vfp8 tmp = "RUN /N3 " + filepath + "Demo\Demo.swf" &tmp Error message: RUN|! command failed. An attempt was made to load a program with an incorrect format. Any help would be greatly appreciated. Thanks. kd Tag: List of Procedure s Tag: 211239
- Next
  - 1
    - VFP9 Multiple table Report Question Hi, I am using VFP9. I have two tables, both are unrelated. Table1 with 3 records & TABLE2 with 3 records. I need to print in my report: TABLE1 TITLE Table1 Record1 Table1 Record2 Table1 Record3 TABLE2 TITLE Table2 Record1 Table2 Record2 Table2 Record3 How can I print the records of two tables in a single VFP9 Report? Thanks in advance. Regards, Derek Tag: List of Procedure s Tag: 211238
  - 2
    - Ole error code 0x80020006 - Unknown Name Hi All, I seem to be getting an OLE error, the error code is 0x80020006 and the error message is "Unknown name". I have added an Activex Control (of type "Shockwave Flash Object") to one of the pages in the pageframe control of my form The error ocuurs when the url property of the ole control is set. dirname = "C:\Proj\" filepath = dirname + "Showtime\Demo.swf" this.oleAlAreen.url=filepath If anybody knows how to fix this error, please reply ASAP. Thanks. kd Tag: List of Procedure s Tag: 211236
  - 3
    - Cursor Adaptor and Stored Procedures with Output parameters I want to call a SQLserver SP that has both input and output parameters with a cursor adaptor, how do I write the selectCmd? VFP8 thanks LH Tag: List of Procedure s Tag: 211231
  - 4
    - Locating "My Documents" folder Hi to all, I'm trying to locate the current "My Documents" folder programmatically to point the default directory when I call PUTFILE() function. How can I do this? I've tried GETENV() but it doesn't give me the "My Documents" folder... Any help would be much appreciated... Thanks. Allan Tag: List of Procedure s Tag: 211222
  - 5
    - dumb question I have a form that I add a slider to through form designer (VFP 9). For some reason the activex control will not become visible until I click on it. If I put the activex control on a blank form I don't have any problems with it. I've tried hardcoding the activex object in the load of the event, creating it with the drag and drop feature in form designer. The property visible is set to .t. and it is the topmost control of the form. Once the control is clicked on it stays visible and works properly but I am stumped on this one. Thanks for any help Tag: List of Procedure s Tag: 211221
  - 6
    - Automating Excel Chart Creation from Microsoft FoxPro In an Excel workbook, I have a long macro in VBE that creates a chart and sets properties of axes, series collections, etc. I want to automate the process from within FoxPro. I copied the VBE code into FoxPro and much of it works but not all. What do I need to know about getting the VBE code to work from within FoxPro? Any help will be gratefully received. Thanks. Peter Tag: List of Procedure s Tag: 211218
  - 7
    - Excel and Word as attachments hello, i have built an app to create word and excel file after user intervention. if i just print these doc's all is fine. once i select them to e-mail, the excel sheets seem to loose formatting of Font size and merged cells go away. with word, the reciever of the Mail will see the icon of the attachment with titla and all, double click and nothing appears, however if they print it, its all there. very strange things are going on. it varies from computer to computer. is there any way to set formatting of this so they wont get crushed or any other ideas? TOm Tag: List of Procedure s Tag: 211217
  - 8
    - Doug Hennig at LA Fox May 10 -- Mine for Code in XSource Mine for Code in XSource Visual FoxPro comes with source code for most of the "Xbase" tools that ship with the product, including the Class Browser, Code References, Toolbox, and Task Pane. Looking at source code written by top VFP gurus often gives insight into new, powerful coding techniques. This session looks at various files in XSource to show you cool ideas you can incorporate and even better, code you can directly use in your applications today. Jump Start Topic: Update your application over the Internet using Inno Setup -- Michael Cummings Inno Setup compiler is a FREE setup creation utility. It is actually easy to use and powerful too. We will look at a few lines of FoxPro code that will make your application do a version check on startup, and prompt the users to install a new version. We will then look at even *fewer* lines of code that will download and install the latest version of your application using Inno Setup. The really cool part is that you can launch your Setup program from within your application, so the upgrade is seamless to your users. This is not only cool, it is very easy to do. See you at LA Fox!! http://www.lafox.org Tag: List of Procedure s Tag: 211212
  - 9
    - How to get VFP 9.0 in french from Canada Could somebody tell me if there is a way to get VFP in french from Canada? Also, could somebody tell me if i will be able to develop complete french version with the VFP english version? Daniel Massé Tag: List of Procedure s Tag: 211208
  - 10
    - vfp8 parameters and variable question hi all. i am new to foxpro programming. I am not sure that this is the best place for my question but i am not able to find "working" newsgroup and/or forum about foxpro (btw, any hint appreciated) . my problem: I have a form defined procedure and would like to call it and receive 2 parameters back. i tried with: thisform.myproc(parm1,parm2) but it does not work (i read that in this way the parameter are passed by value and not by ref...) so i tried with DO thisform.myproc WITH (parm1),(parm2) ... but it does not work...myproc is not recognised (even without thisform.) so what can i do??? i tried with global variables and it worked but i do not want to use global variable for this kind of stuff...but...it is not possible to define the variable scope for the form? only for the procedure itself or global seem to be the possibilities... if somebody knows other resources for my problem, plese let me know. thanks and ciao. Tag: List of Procedure s Tag: 211195
  - 11
    - - How do I make shape object semitransparent? Is there a way to make Shape object semitransparent (transparency factor)? If not, could someone suggest an alternative. Tag: List of Procedure s Tag: 211194
  - 12
    - Formsets in Foxpro I am using Formset in an application .. but every form I open sets its size to the Form open previously .. How can I Stop this to happen. Tag: List of Procedure s Tag: 211193
  - 13
    - check if drive exist Hi, I have this little code to check if a drive exist yes or no, but it fails on a pentablet. I get an error specifying "Drives does not exist". This pentablet has a drive (the server) only when it is docked (and connected to a lan). And this is just exactly what I want to prevent and checked if it is docked or not to perform some syncronisation with tables on the server. function checkdrive lparameters chkdrive_ o = Create('Scripting.FileSystemObject') lreturnvalue = o.Drives(chkdrive_).IsReady release o return lreturnvalue Anybody a workaround to check when a drive exist (and is ready) ? thanks in advance regards christophe -- Tag: List of Procedure s Tag: 211184
  - 14
    - VFP 9 Installshield question Hi, I am using VFP9. Which minimum Objects/Merge Modules do I need to include in my application distribution? Is it OK if I use the VFP8 Installshield wizard? Thanks in advance. Regards, Derek Tag: List of Procedure s Tag: 211183
  - 15
    - VFP 9 Have a grid with a check box on a logical field. How can I update the grid programatically to clear the check box. i.e. check ten items perform something on just these ten items and then clear the checkbox I have tried thisform.grid1.column1.checkbox.value=0 it does update the underlying cursor if i interupt the program at this line the records referenced have had the logical field set to false. But as soon as my grid displays again, the check boxes are checked and the underlying cursor once again have the logical field set to true. Thanks for any assistance. Tag: List of Procedure s Tag: 211180
  - 16
    - Displaying Two Browse Windows on Same Screen in Foxpro 2.6 Dos ? How can I show Two browse windows of different tables at the same time, I tried following. Define window win1 from 1,1 to 20,39 Define window win2 from 1,40 to 20,70 Activate window win1 Use Rent brow in Window win1 Activate window win2 Use Contract brow in Window win2 But I only see one brow window at a time, where am I mistaken, please help ? Best Regards, Luqman Tag: List of Procedure s Tag: 211175
  - 17
    - Treeview and System ImageList Is it posible to associate the system image list with a treeview control? I've been playing with Shell_GetImageLists but no luck so far. Tag: List of Procedure s Tag: 211165
  - 18
    - Treeview and System ImageList Is it posible to associate the system image list with a treeview control? I've been playing with Shell_GetImageLists but no luck so far. Tag: List of Procedure s Tag: 211164
  - 19
    - System Image List Is it possible to associate the System Image list with a Treview Control in VFP? I've been playing around with Shell_GetImageLists, but no luck so far. Tag: List of Procedure s Tag: 211163
  - 20
    - Events at Run time Dear sirs I've created in my Form some objects (Buttons) at run time, the question is: how can I handle their events (Like: Click Event) at run time best regards thanks Mohammed Abdel-Razzak Tag: List of Procedure s Tag: 211161
  - 21
    - Problem with ADO.Net Using VB.net with .Net Framework 1.1 and using Fox Pro OLEDB to connect to a fox pro database. When I try to load a dataset from a FoxPro database on the network running this line of code for path (\\servername\share\data\abc.dbc) dbAdapter.Fill(dbDs) I get: "The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value." This code works perfectly on the local copy of the FoxPro Database (example c:\data\abc.dbc) any idea why? The people in dotnet.framework.adonet suggested I post here. Tag: List of Procedure s Tag: 211159
  - 22
    - More VFP7 to VFP9 woes I use the below code to create a background image on a Foxpro app. This image is always visible in my test environment, but when I run it on Terminal Services (W2K) in Production, several of my forms clear this image. What Commands/Functions could possibly clear this image?? This never happened with the app when it was compiled with VFP7. Thanks for your help *! Example Code ------- _SCREEN.addobject('logo','image') WITH _SCREEN.logo .picture = 'BackGroundImage.jpg' .width = 220 .height = 160 .backstyle = 1 ENDWITH = updscreen() _SCREEN.logo.Visible = .T. *------------------ PROCEDURE updscreen *------------------ WITH _SCREEN.logo .left = (_SCREEN.width-220)/2 .top = (_SCREEN.height-160)/2 ENDWITH ENDPROC Tag: List of Procedure s Tag: 211155
  - 23
    - VFP Based PM (preventative MTC) program for oilfield industry Does anyone have any first hand experience or recommendation for a program that would be used in the oilfield or gas industry for tracking and managing maintenance on field equipment? Dan Tag: List of Procedure s Tag: 211152
  - 24
    - Strange issue importing text file I am a SQL Server DBA that has a client using FoxPro v8. When the client imports CSV text with character fields delimited with double-quotes, they have random records shift from time to time for no apparent reason. The source records are clean meaning they do not contain commas or double-quotes. Ironically, the same CSV text file imports into SQL Server, ACCESS and other databases without any issues. Has anyone else run into this type of strangeness? How did you resolve it? Thanks! Tag: List of Procedure s Tag: 211150
  - 25
    - SQL SELECT is not executing VFP 8 SP1 on XP Pro SP1 This is the most bizarre thing I've seen in a long time. I had some code in a form that constructed a SQL SELECT statement as a string, then runs the command via macro substituion (&). This was working fine. I decided to move this code into a class. Now, when the macro substitution line is executed, nothing happens. Here is the string that is supposed to be executed: SELECT Employee_name AS fld1, UPPER(Employee_name), Ssn AS fld2, UPPER(Ssn), Employee_id AS fld3, UPPER(Employee_id), Dob AS fld4, UPPER(Dob) INTO CURSOR rptCurs FROM empGrpCurs ORDER BY 2, 4, 6, 8 The source cursor (empGrpCurs) exists and contains data. After this instruction is executed (or not executed in this case), the destination cursor (rptCurs) does not exist and _TALLY has not been updated from the prior value. No error is raised. It's like this instruction never happened. I then placed the actual SQL SELECT statement (rather than the macro version) in this same method a few lines lower and the result was exactly the same - no error, no cursor created, _TALLY unchanged. I'm convinced I'm just missing something very obvious, but lack of sleep must be blinding me. Any ideas? -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: List of Procedure s Tag: 211128

Using VFP 8.0, How can I see the List of Procs/Functions when in a Procedure
File like used to do uptil VFP 6.0 with the Right Mouse Click.

Thanx

Top

Re: List of Procedure s by Gerben

Gerben
Fri May 13 08:47:09 CDT 2005

Hi,

Take a look at the document view, from the tool menu.

HTH,
Gerben Kessen

"Tanveer H. Malik" <tanmalik@hotmail.com> wrote in message
news:uvMg8k7VFHA.548@tk2msftngp13.phx.gbl...
> Using VFP 8.0, How can I see the List of Procs/Functions when in a
> Procedure
> File like used to do uptil VFP 6.0 with the Right Mouse Click.
>
> Thanx
>
>

Top