Events at Run time

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
    - 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: Events at Run time Tag: 211159
  - 2
    - 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: Events at Run time Tag: 211155
  - 3
    - 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: Events at Run time Tag: 211152
  - 4
    - 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: Events at Run time Tag: 211150
  - 5
    - 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: Events at Run time Tag: 211128
  - 6
    - VFP 9, Class definition is cyclical error Have a container-class which contains two custom-class pageframes, one is placed on the others page. inputctrl1 <or one of its members>. Parent : Error loading file - record number 1976. FWPAGEFRAME_B1 <or one of its members>. Parent : Cannot add FWPAGEFRAME_B1. Class definition is cyclical This error occurs when running the application, not during class editing. With only one instance of the pageframe class in the container-class the application runs fine. It also works if the second pageframe is not placed on the other pageframe's page. As far as I can tell this does not match: "You have attempted to specify a class in an ADD OBJECT statement whose class definition is the same as the class being defined. " Any idea's ? TIA Michael S. J. Tag: Events at Run time Tag: 211100
  - 7
    - Printing a BMP bitmap Hello all and thanks in advance for the help. How do you print a bitmap where the bitmap that you will be printing is to be decided at runtime? Can you use the VFP report writer? Is there another way? Thanks. Jeff Tag: Events at Run time Tag: 211093
  - 8
    - Convert 3.0 resource file format to 6.0 I have a VFP8 exe file which runs every night on two separeted Win2003 servers. One of them is OK. The other sometimes /not every time/ stops and there is the following question on the screen: Convert 3.0 resource file format to 6.0? /YES or NO/ Could anyone explain me why do I have this message? Many thanks -- Sandor Tag: Events at Run time Tag: 211090
  - 9
    - Frontpage Automation - Help I need to automate FrontPage to update a website i.e. to publish it. How does on do this from within VFP? Some Code Samples would be help Thanks in Advance Regards Mahmud Abdulla Tag: Events at Run time Tag: 211087
  - 10
    - dbf to excell Can I export a large dbf to excell to use multiple worksheets in excell. The file is to large for only 1 worksheet. thanks sherry Tag: Events at Run time Tag: 211085
  - 11
    - Consuming a dataset in a web service I have successfully consumed an XML from a web service from VFP8. Now I need to consume a dataset in a web service. Can someone point me in the right direction? I've been searching Microsoft site but nothing pops up. Thanks, Tag: Events at Run time Tag: 211079
  - 12
    - accessing VFP data for ASP.net pages We had (gone now) a developer who wanted to have access to our VFP tables (several hundred mb worth) for "live" queries on a low-traffic web site. His solution, doing all his development in ASP.net, was to create duplicate tables on an SQL server and import the VFP data on a schedule which allowed as up-to-date data for the queries as was possible (perhaps every 15 minutes, but no less than once an hour). I objected to this scheme as being inefficient in that it moved many thousands of times the amount of needed data across our various links (a shared 10 mb pipe to the web server was the bottleneck), when he could have accessed the data directly from ASP.net using OLEDB. His only point was that this allowed him to use SQL stored procedures. Can anyone give opinions on the pros and cons of these 2 approaches? Thanks. Tag: Events at Run time Tag: 211077
  - 13
    - How to dial a phone number from VFP? Hi All, Does anybody have a sample code for using a telephiony API from VFP? Where can I find the examples on how to implement auto-dialing from VFP application? Thanks, Andy Tag: Events at Run time Tag: 211073
  - 14
    - using controls in grid causes problem i am using combo1 that contain faculty,student,staff as combo1 items.... according to i choose the item in combo1 the grid is displayed..... i have insert checkbox1 and combo2 in the grid also...... the combo1 and the grid is in the same form.......initials the grid is set as visible false.... now when i run the form it shows the controls (checkbox1 and combo2) in the grid for frist selection but when i switch the selection in combo1 it does not shows the controls in the grid.......... i have tried thisform.grid.refresh thisform.grid.column1.refresh thisfrom.grid.column2.refresh thisform.grid.column1.checkbox1.refresh thisform.grid.column2.combo2.refresh can anybody help me...... -- Message posted via http://www.dbmonster.com Tag: Events at Run time Tag: 211069
  - 15
    - more on DIBAPI32 and Window Printing Hello and thanks for the response. I copied both the DLL and the LIB file into my development folder. It is now starting to work but... When I execute the code provided earlier the following happens: I am prompted for a printer. I then get a window which says "Printing..." and the window title "to" and the printer name "Sending bitmap to printer..." And there it sits with nothing actually getting sent to the printer The printer works fine. I printed a test page and a document but the bitmap never prints. The code I used is: !/N REGSVR32 /S DibApi32.Dll #DEFINE PW_WINDOW 1 #DEFINE PW_CLIENT 2 #DEFINE PW_BESTFIT 1 #DEFINE PW_STRETCHTOPAGE 2 #DEFINE PW_SCALE 3 DECLARE INTEGER PrintWindow IN DibApi32 AS PrintWin ; INTEGER HWnd, ; INTEGER fPrintArea, ; INTEGER fPrintOpt, ; INTEGER wxScale, ; INTEGER wyScale, ; STRING @ szJobName PrintWin(thisform.hwnd,1,1,0,0,ALLTRIM(thisform.caption)) Does anyone know what the problem is? Thanks, Jeff Tag: Events at Run time Tag: 211068
  - 16
    - gendbc, views and rounding problems... My question is really two part: First why when running gendbc against SQL data are the views created with data type of B(2) when the data structure in SQL is Numeric 12.2? In VFP data this would have been N(12,2) - correct? What is the type of "B"? Then, the second equally as confusing part of this problem is that we have a field which in the debugger, the tables and the views shows a value of 37.63 and we subtract a payment of 37.63 yet the result is not 0.00 as you would expect it is -0.01 unless we include the round function on the first part of the equation [round(finalcost,2)]. We do not see the rounding problem so where is it or is this just an anomaly that has always been part of the views that we have been unaware of. Thank you! Tag: Events at Run time Tag: 211066
  - 17
    - Error reading file... This is a question that I'm sure has an answer of "no". If you have a table open, and the network connection is severed, you get "Error reading file....". OK and Help are your only options. Pressing OK brings back the message, and it's a never ending cycle. Even if the network connection is restored, you will probably not be able to escape. Alt-Ctl-Del is your only way out. Is there any other way to get out of this loop short of hard terminating the app? To duplicate this, I plugged in my USB drive, copied some tables to it, opened the table, and pulled the stick out of the USB slot. Wham, "Error reading file...". Bye bye VFP and any unsaved work. Fortunately, this doesn't happen much in production, and when it does it's usually a network glitch (or in our case Windows server 2003 flakiness that we have not yet resolved). I am tempted to classify this as a bug because it's been around for so long. I would think that Micorosoft would change this to allow you escape from this condition without having to hard terminate the app. Tag: Events at Run time Tag: 211054
  - 18
    - SET CLASSLIB when using SET CLASSLIB, if a library has already been added, will using this call create another instance of that class? Is it necessary to use the RELEASE CLASS statement? I know it is good practice to use it but is it necessary? Thank you Tag: Events at Run time Tag: 211049
  - 19
    - foxpro security question I have 1 FoxPro client that I service once a year for a few weeks. I'm not remotely a FoxPro expert. The app is still in VFP6 and that's fine for now. I may end up converting the whole thing to Access since it's pretty small and low usage. It'd be easier for me to maintain that way. Anyway, I'm trying to find out about the security available in Fox. Their company has come up with a new policy that's going to require that the database be secured to some degree. Right now it's not in a container. It was originally a Fox 2.6 for DOS app that we just grungily moved over to VFP a few year ago. So the tables are all free. Other than doing things like securing folders on the network and such, is there any way within VFP6 (or even later versions maybe) of securing the tables so they cannot be tampered with? Obviously right now anyone can get into them even if they just have odbc on their system and they have access to the folder the files are in. Anyone with MS Access can get at them. We'd like to tighten it up a bit if possible. Thanks in advance, Keith Tag: Events at Run time Tag: 211048
  - 20
    - trouble with converting a string. i know this is a real basic question, please bear with me, i am still learning. i am placing a Name from a file onto a Word Doc. in some cases its a normal name. Jane Doe, other times it could be Jane Doe-Deer. thats the one i am having trouble with. i am using proper(from) to make it look nice. but the Hypen is giving me fits. it will print like this Jane Doe-deer not very nice. any ideas? Please. thank you in advance. Tag: Events at Run time Tag: 211043
  - 21
    - Outlook is killing my Excel workbook Hello, i am using Excel and Outlook Automation to respectivley create a Workbook and email it. all that is going well. once the workbook is attached to the mail and sent, the user then will open the workbook up, add to or make changes and send it back to the sender. prior to sending it gets the workbook is printed out. and it fine. however after recieving the edited workbook back, it adds a column to the book with the same data in the previous column. EX Date Cost Total cost 2/1/05 5.00 2/2/05 5.44 10.44 this in the Send email attachment i get back date cost totalcost 2/1/05 5.00 5. 2/2/05 5.44 5.44 10.44 it adds a row of the same as Cost but removes the .oo's so 10.01 is fine but 10.10 looks like 10.1 and i dont even know why it adds that row in the first place. its wrong. Tag: Events at Run time Tag: 211036
  - 22
    - DIBAPI32.DLL Hello all and thanks for the help. There was an earlier thread that talked about how to write a "Print Screen" for a form and referred to DIBAPI32.DLL which is available here: DIBAPI32.dll comes with Palfade.exe which is on the September 1999 Technet Library Archive It's also available at http://download.microsoft.com/download/platformsdk/sample42/1/W97/EN-US/PALFADE.EXE The problem I'm having is that this DLL seems to be quite old and doesn't work with (my) Win XP. Does anyone know of a modern replacement? Thanks, Jeff Tag: Events at Run time Tag: 211034
  - 23
    - VFP8 getnextid using cursoradapter views We are having some multi-user issues having changed our system over to use cursoradapters (native and SQL). The file which controls the next id for each table is accessed via a cursoradapter. Unfortunately requery on this file fails if someone else has updated that file and hasn't yet committed their change i.e. they are in the middle of a BEGIN/END TRANSACTION. Other than avoiding getting the next id inside a transaction and requerying inside an endless loop until successful, I can't think of a way round this. I toyed with autoincrement fields but we have a lot of parent/child tables where we need to know the parent id for the child records, so I've abandoned that idea. We also access the data via ODBC in Crystal so again I think there is a problem with autoincrement fields. Has anyone got any other suggestions? Thanks, Bernie Tag: Events at Run time Tag: 211031
  - 24
    - [SingFox] VFP UserGroup Meeting Time : 6 - 9 PM Date: 4 May 2005 Place: MS Office @ Marina Bay . For More info and directions - please see http://groups.yahoo.com/group/SingFox . If You wish to attend please SMS your name to me at 9004 1089 - I have to put your name on the Roster List for MS Security Desk. warmest regards / xie xie [Bill] Tag: Events at Run time Tag: 211026
  - 25
    - How to prevent DBC trigger from firing I have to write a utility that will update production tables. The tables have triggers to update a datetime changed field when the record is updated. The nature of the change I'm making is such that this trigger absolutely cannnot fire. Is there any quick and easy way to prevent record validation rules from firing? This is a production system and I can't change the DBC just for this update. The update is an automatic process, no human intervention. Tag: Events at Run time Tag: 211020
- Next
  - 1
    - May letter on Visual FoxPro web site This month's letter contains a summary of some recent Visual FoxPro news as the Visual FoxPro team is busy working on future plans for Visual FoxPro to be announced next month. http://msdn.microsoft.com/vfoxpro/letters/ Ken Levy VS Data Product Manager Microsoft http://blogs.msdn.com/klevy http://msdn.microsoft.com/vfoxpro -- Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: Events at Run time Tag: 211019
  - 2
    - create a help file i will appreciate if can help me, i develop visualfox 7.0 application, but i need to create a help file i dont know how. Tanks Tag: Events at Run time Tag: 211018
  - 3
    - Method code swapping in VFP8 SP1 VFP8 SP1 on XP Pro SP1 I've seen this reported in other versions of VFP, but not in VFP8. After editing a form and running it, I got some odd errors. I went back into the form and found that several methods had their code swapped. The code from the Load and Init methods had been swapped, the code from the Show and Unload methods had been swapped. How's that for scary? This form has about 40 custom methods added to it and only the native methods that had code in them got swapped. The custom methods were all fine. In VFP's defense, at the time this happened, (but after the form had been saved, compiled, and run) VFP crashed due to another issue. I suspect these events are related since I've never seen this code swap problem before this. -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: Events at Run time Tag: 211014
  - 4
    - RDP, Memory and VFP Hello, At a customers place, I have to develop foxpro (8.0) in a Remote Desktop session on a heavy machine, lots of memory, 2 cpu's etc.. When I' m running large queries I frequently get an error: "Not enough memory for map file", or when I look at the rushmore optimization it says; "Not enough memory to rushmore optimize table x". I tried SYS(1104) or/and sys(3050,1,large) / SYS(3050,1,small). But nothing seems to help. Sometimes it helps to log off the rdp session and start a new session. Because off security reasons it's not easy to try the query on a local machine (without RDP)... Is there anyone who knows how to solve this? TIA Gerben Kessen Tag: Events at Run time Tag: 211012
  - 5
    - Multiple Detail bands in Report Writer? Not sure if that's what I need to do or not, but here's the gist... We do testing services here, using vehicles. The data is compiled at certain mileage intervals. The report goes like this... Header Detail lines showing data at each mileage interval More lines showing data another way at each mileage interval. Same as above, data another way. Same as above, data still another way. Same again, data still another way. Each of these "bands" show the mileage intervals and dates that the data was compiled. But each of these show the data in a different manner. Initially, raw data, next band a sort of summary type data, the next band a projection data, but still based at the individual mileage increments when the data was compiled, next band is a series of comments compiled at each measurement interval and finally a set of physical properties taken at each mileage interval. Right now this is done as a "manual" report in FPD2.6. I have no idea how to get this into the report writer. Can someone please help? Point me in the right direction? Thanks! Shawn Tag: Events at Run time Tag: 211002
  - 6
    - shellexecute I need to display .pdf' files from within a Foxpro program. I thought that a shellexecute command was the way to go, but I can't seem to get it to work. Any help and/or sample code will be great. -- Lost in Tampa Tag: Events at Run time Tag: 211000
  - 7
    - User-Defined string Functions Transact-SQL - built-in functions Fo Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL, the name and functionality of which correspond to the same built-in functions of Visual FoxPro GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string AT() Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost character RAT() Returns the numeric position of the last (rightmost) occurrence of a character string within another character string OCCURS() Returns the number of times a character expression occurs within another character expression PADL() Returns a string from an expression, padded with spaces or characters to a specified length on the left side PADR() Returns a string from an expression, padded with spaces or characters to a specified length on the right side PADC() Returns a string from an expression, padded with spaces or characters to a specified length on the both sides PROPER() Returns from a character expression a string capitalized as appropriate for proper names RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the right ARABTOROMAN() Returns the character Roman number equivalent of a specified numeric expression ROMANTOARAB() Returns the number equivalent of a specified character Roman number expression ... For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards Tag: Events at Run time Tag: 210997
  - 8
    - VFP8 & Linux I am new in this subject... Is it possible to run a VFP8/application,exe/ on a workstation where the server's operating systeem is Linux? Could anyone help me? Many thanks. -- Sandor Tag: Events at Run time Tag: 210987
  - 9
    - VFP8 & Linux I am new in this subject... Is it possible to run a VFP8 /application, exe/ on a Win98 workstation, where the server's operating system is Linux? Could anyone help me? Many thanks. -- Sandor Tag: Events at Run time Tag: 210986
  - 10
    - Tableupdate fails - VFP8/SP1 Hi all! * Write from a local paramerized view to its basetable´s memofield IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias) llUpdated = tableupdate(1,.F.,lcAlias) * respons to user IF llUpdated = .T. wait 'Saved' nowait window ELSE TABLEREVERT(.F.,lcAlias) wait 'Not saved' nowait window ENDIF ENDIF Is the VFP-multiuser-stuff stable? User A saves to a memofield as above and receives the Saved-message. After that user B opens the same view and saves unother value to the same field and she receives the Not saved message. What can be wrong? The view is is opend shared of course. I have tried to reindex the table and recover the database as well. Best regards Christina Tag: Events at Run time Tag: 210984
  - 11
    - PrintScreen direct output to printer ? Hi I am using VFP6 SP4 I want to make a command button to dump the screen or active window and direct output to printer (not copy to clipboard). when the user clicks this command button, it is the same as press key PrtSc How can I do that ? pls give me a hand thanks all Tag: Events at Run time Tag: 210982
  - 12
    - Copying a Graphic to the Clipboard Anyone have a routine that will take a graphic (e.g. a .JPG file on disk) and copy it to the Windows clipboard so the user can then just paste it in a graphics program like Paint Shop or Photo Shop? Thanks. Charlie Parker Tag: Events at Run time Tag: 210977
  - 13
    - RUN will not work - requires working dir? I have an application on my machine that is basically an icon on the desktop with the following for the target P:\psw.exe. If I take properties on the icon, under "start in" it has p:\. If I double click the icon on the desktop, it works as expected. On one of my VFP forms, I have a command button with the following code and the program will not run (it generates an error specific to the program) RUN /N "P:\psw.exe" Any ideas how I can trouble shoot this, or modify the run command so it has a "start in" that emulates what it is expecting? Thanks, Dan Tag: Events at Run time Tag: 210968
  - 14
    - C0000005 upon vfp exe exit after responding to .net events I am getting a dreaded C000005 at address 79221bd8 after running a simple vfp exe that opens a simple .net form and responds to an simple event. The event is being handled fine by VFP, but upon exit the windows error is displayed. What is strange is that when this simple app runs in the VFP IDE it works just fine. No errors. Running it standalone produces the error. Does anyone here have some experience/sample code in responding to a vb.net dll's events in a VFP executable? I would sure appreciate some help here. Again the code is working just fine; .net dll is being created and .net form is running in new thread, I am implementing an eventhandler in VFP correctly since the event fired by the .net form is being responded to by VFP. It just blows when exiting back to Win XP. Thanks. SJT Tag: Events at Run time Tag: 210960
  - 15
    - Report. Page X Out of Y by Groups.VFP9.0 Hi, I want to be able to print "Page 1 out of 4" for every group on the report so that every group will start from page 1. Another word, I need page totals for every group. Note: VFP9.0 Thanks, Eugene. Tag: Events at Run time Tag: 210959
  - 16
    - Hiding the top level form Hello and thanks in advance for the help. If you have an app with a top level form where the other forms are "In top level form" and Desktop = .t., How do you hide the top level form when the user goes into a subform? Does the parent object of the lower level form point to the top level form? Thanks, Jeff Tag: Events at Run time Tag: 210956
  - 17
    - SQL: Group By error Hi, I'm new to FoxPro and am converting from version 5 to version 8. I'm getting this error: SQL: Group By clause is missing or invalid. The offending code is: SELECT statepmt.state_code, strecon.total ; FROM statepmt, strecon ; WHERE statepmt.yyyy_mm = w_yyyy_mm AND ; statepmt.state_code = strecon.name ; GROUP BY statepmt.state_code ; INTO CURSOR statots It works fine in version 5. I'd appreciate any comments. Thanks, Jim. Tag: Events at Run time Tag: 210948
  - 18
    - DOUBLE-BYTE PROBLEM HI ALL I TRY TO USE WEB SERVICE FOLLOW THE SAMPLE CODE IN VFP 9 HELP. BUT I WERE CONFUSED WTIH HOW TO TRANSFER CHINESE BIG5 FIELD AND CONTENTS PROPERLY. I FOLLOWED THE CODE BELOW Walkthrough: Creating XML Web Services with Visual FoxPro and made northwind!customer's filed into chinese include content but failed Can somebody help me ? Tag: Events at Run time Tag: 210939
  - 19
    - vb.net usercontrol used in a foxpro 9 app Hi, In VS6.0 it was simple to create an active-x control in VB and then use it as a ole object in Visual Foxpro. I'm trying to figure out how i can pass values from visual foxpro to a vb control and then return completed values. Can anyone shed some light on this, and/or provide examples. Thanks GG Tag: Events at Run time Tag: 210936
  - 20
    - data migration Hi friends am exporting vfp data to sql server and am using DTS to export. my question is is there any option to export all tables at once rather than doing one at a time? Thanks -- cheers Tag: Events at Run time Tag: 210931
  - 21
    - indexing problem How do you index a table which has a field which may be positive, negative or zero? The problem is a secondary field is also required which is a character field. Let's say field1 is the numeric field and field2 is the character field. Using the following command to create the index, does not produce the desired results: INDEX ON STR(field1,FSIZE("field1")+field2 TAG myindex For example, I would see the following numbers in a browse form when looking at the field1 column : 0 1 2 3 4 -1 -2 -3 -4 But, the desired response is: -4 -3 -2 -1 0 1 2 3 4 I'm sure other people must have come across this problem -- any ideas? Thanks, -- E. Myron I have a table containing two field called myvals which can contain numbers from -99 to +100. When I index the table using the following command, everything is fine: INDEX ON myvals TAG numindex If I index using the following command, the result is incorrect: INDEX ON STR(myvals) TAG strindex The problem is that I have to use a string because I am combining two fields in order to get a secondary -- To reply, change "invalid" to "net" Tag: Events at Run time Tag: 210928
  - 22
    - SQL Problem I have a problem (VFP6) in getting a summed amount which I need for a report. In simplified form, because there are other related tables, the code reads:- Select tenants.lastname,tenants.tenantref,more fields, tenacc.item,tenacc.debit,tenacc.credit,sum(tenacc.debit) as sumdebit,sum(tenacc.credit) as sumcredit; From tenants inner join tenacc; On tenants.tenantref=tenacc.tenantref; order by tenants.tenantref; Where (tenacc.item='Due' OR tenacc.item='Received'; INTO cursor rentsa The problem is that the summed fields include all debits and credits for tenantref, ignoring the Where line which is intended to restrict them. I would like to define the summed fields as sum(tenacc.debit) for (tenacc.item='Due' OR tenacc.item='Received') but SQL does not accept a FOR clause. I have also tried using the summing ability of a report format, but cannot seem to get it to work Help would be much appreciated. -- Tim Hobson Tag: Events at Run time Tag: 210917
  - 23
    - Timer events... when? ...in Fri pm duh mode. Timer events fire between lines of code or between procs? Also there are some issues with users setting focus on other non-VFP processes while timers are enabled, I seem to remember. Some refresher remarks about that'd be good, too. TIA. -Lew Tag: Events at Run time Tag: 210904
  - 24
    - - How to Save Target As.. ? I am trying to automate IE6 to downolad a bunch of documets (.tif, .fax files). Is there a way to execute "Save Target as" within IE object? For instance, I have a link that looks like this: https://www.whatever.com/viewfiles.jsp?fileid=999&name=FILE+NAME+.TIF and I need to download this file to a specific folder with a new file name: c:\TifFiles\_999FileName.tif If I use URLDownloadToFile, I get a blank page since viewfiles.jsp is preventing me from getting the file directly. However, if I use Navigate and then ExecWB(saveas), I am prompted with a dialog to Open/Save/Cancel from Navigate followed by Save As (filename)dialog from ExecWB. With this, I get the ability to download the file but how do I stop the prompts? Ideally, what I am looking for is something like URLDownloadToFile(with ability to provide source url and destination file name) that would work like Navigate->ExecWB(saveas) without the prompts... Is this the right group to post this on? Tag: Events at Run time Tag: 210902
  - 25
    - VFP 9: report not displaying 4-digit century This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C54CB6.42EE9CE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable All, I've been pulling my hair out over this! I have one report that = displays 4-digit year while another only displays two. I've fiddled = with VFP default date settings and still won't display 4-digit century. Suggestions please. Thanks ------=_NextPart_000_0006_01C54CB6.42EE9CE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DVerdana size=3D2>All,</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>I've been pulling my hair out over = this!  I=20 have one report that displays 4-digit year while another only displays=20 two.  I've fiddled with VFP default date settings and still won't = display=20 4-digit century.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Suggestions please.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Thanks</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C54CB6.42EE9CE0-- Tag: Events at Run time Tag: 210895

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

Top

Re: Events at Run time by Christian

Christian
Sat May 07 07:17:48 CDT 2005

Hello,

the standard way to do this is making a subclass of the standard
Commandbutton that comes with VFP, and writing the code that should run in
the different events directly into this subclass, you'll also have to save
the subclass into a classlibrary

then at the initialization phase of your program you issue a
SET CLASSLIB TO yourClasslib && to make the classes contained in the
classlibrary visible to VFP

then AddObject() the subclass instead of the standard button.

if you have VFP8 or beyond you can also bind to Events at runtime ..
e.g.
add a HandleClicks Method to your form
AddObject() the button's ..
then use BINDEVENTS function to bind the click events of the buttons to the
HandleClicks method of the form ..

Regards
Christian

"Mohammed Abdel-Razzak" <MohammedAbdelRazzak@discussions.microsoft.com>
schrieb im Newsbeitrag
news:58B8F32B-EC60-4F84-8700-B37375ED8B34@microsoft.com...
> 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

Top