Is rename always copy/erase?

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
    - MSCOMM in windows 2000 server does the control fox 'mscomm' work in windows 2000 server? Tag: Is rename always copy/erase? Tag: 236151
  - 2
    - How do I capture time input from a user in a 24 hour format How do I capture time input from a user in a 24 hour format without the date and seconds? I need to get the arrival time and departure time from a user and find the time in between. Thanks, Thorkell Tag: Is rename always copy/erase? Tag: 236139
  - 3
    - Lost dev environment Hi All, All of a sudden my VFP has lost it's memory. Before, yesterday, when I would launch VFP the Task Manager would pop up and have a list of recently used projects. When opening a project all the tabs, Data, Documents, Classes, Code and Other, would open with all of the trees left in how I had them when using them previously. The editor windows would open sized the way I liked them, even the command window would be as I had it setup. All of a sudden, just today, everything acts like it had never been opened before. The task manager doesn't remember my recent projects, the All tab is the default and all the windows open small so I have to resize them to use them. What gives? The only thing I remember doing is compiling the application and creating an install routine with Install Shield Express. Any one know how I can recover my environment, or at least get VFP to remember it from session to session? This is VFP 9.0 sp1, BTW. Thanks, Linn Tag: Is rename always copy/erase? Tag: 236136
  - 4
    - VFP to SQL via ODBC add records to table with key field Using VFP 9 remote view connecting to SQL 2005 via ODBC. On the SQL side I have a table with three fields, one is a primary key type BigInt, other two are text On the VFP side I have a remote view selected, append blank, browse, type in number to key, then text to other two. When I try and close the view it errors out saying the key field does not accept null values, but in the remote view it is not null and has a value. There is only one record added in the remote view. What am I missing? Tag: Is rename always copy/erase? Tag: 236135
  - 5
    - Dumb Grid Question I would like to use a method to modify a specific cell's value using a cell click/rightclick event. Not seeing anything obvious with respect to taking action on a single cell... i.e. if the cell is readonly, is there a way to run a method on the cell when it's clicked/rightclicked? Feeling dumb again... help! Thanks in advance, Beverly Howard Tag: Is rename always copy/erase? Tag: 236134
  - 6
    - Troubles in showing a web site which contains a flash animation I have developed a Visual FoxPro 6.0 application which has two forms. The first form has the following value "2 - As Top-Level Form" in "ShowWindow" property. The second one has the following value "1 - In Top-Level Form" in "ShowWindow" property; it also has the following value "0 - Off" in "TitleBar" property. So, the first form becomes the main window, and the second one is located inside the main window area. In the main window an ole control named "_webbrowser4" (based on "ShellExplorer2" class) is inserted for showing a website content. My aim is to show a set of banners, which are shown in a sequential way; these banners are animated gifs, jpgs and flash animations. In the second form I inserted a TextBox object for entering a string. The trouble is: when a flash animation is showed in the web site, the TextBox object loses the focus, which may cause an inconvenience to user who is entering data in a Textbox. I would like to know how I can avoid that "_webbrowser4" ole control (from the main window) gets the focus, when a banner with Flash is showed (this doesn't happen when a banner with an animated gif or with a jpg is showed). The ole control named "_webbrowser4" is located in the following class library: c:\Program Files\Microsoft Visual Studio\Vfp98\Gallery\_webview.vcx Thank you for your help. Tag: Is rename always copy/erase? Tag: 236127
  - 7
    - filetostr() /strtofile() capacities I have to make multiple copies of some files in the size range of 2000 to 7000 kb and it seems like it'd be more efficient to do a single filetostr() followed by multiple strtofile()'s --rather than multiple copy's - I'm using winapi CopyFile()-- but I have no clue as to how this would affect system performance. The pc in question has 2g ram. Can anyone share their experience with this sort of thing? -Lew Tag: Is rename always copy/erase? Tag: 236126
  - 8
    - table names from a query Hi I have 2 like querys. The only difference is one picks the .T. , the other picks the .F. Here is the code behind the query; SELECT Reservefile.pbfrsvcd1, SUM(Reservefile.wrvrsvamt),; Reservefile.pbfcd, COUNT(Reservefile.pbfrsvcd1),; SUM(Reservefile.pbfprm), SUM(Reservefile.pbfprmannl),; SUM(Reservefile.pbfamt), SUM(Reservefile.wrvprmdefg),; SUM(Reservefile.wrvprmdefn), SUM(Reservefile.wrvprmuneg),; Reservefile.wrvyr1flag, Reservefile.wrvprmcd, Reservefile.pmdtype,; SUM(Reservefile.wrvprmunen); FROM ; reservefile; WHERE Reservefile.wrvyr1flag = ( .T. ); GROUP BY Reservefile.wrvyr1flag, Reservefile.pbfrsvcd1; ORDER BY Reservefile.pbfcd, Reservefile.pbfrsvcd1; INTO TABLE 1styear.dbf This query names the table A or B or C Then expect to find that file later. The second query SELECT Reservefile.pbfrsvcd1, SUM(Reservefile.wrvrsvamt),; Reservefile.pbfcd, COUNT(Reservefile.pbfrsvcd1),; SUM(Reservefile.pbfprm), SUM(Reservefile.pbfprmannl),; SUM(Reservefile.pbfamt), SUM(Reservefile.wrvprmdefg),; SUM(Reservefile.wrvprmdefn), SUM(Reservefile.wrvprmuneg),; Reservefile.wrvyr1flag, Reservefile.wrvprmcd; FROM ; reservefile; WHERE Reservefile.wrvyr1flag = ( .F. ); GROUP BY Reservefile.wrvyr1flag, Reservefile.pbfrsvcd1; ORDER BY Reservefile.pbfcd, Reservefile.pbfrsvcd1; INTO TABLE renewal.dbf This one names the table renewal.dbf ---as I want. I do not want aliass thanks sherry Tag: Is rename always copy/erase? Tag: 236120
  - 9
    - File exists notification or dir update I'm writing a program that processes files arriving on our server via ftp. Is there a windows service that could notify me or my program when files arrive in the target directory? A work around is adir() plus a timer control, I know. -Lew Tag: Is rename always copy/erase? Tag: 236119
  - 10
    - MAPI program loop I am using the MAPI control to send email from my application but it seems that if I send an email to one email address then subsequently try to send another message to another email address I get a program loop (somewhere). My code is as follows (executed in the click method of a button) If !This.Parent.signon() && Use the custom method MESSAGEBOX("Email sign-on failed.",16,thisform.caption) Return ENDIF If This.Parent.LogSession && Check if the user was able to login This.Parent.OleMMess.sessionid = This.Parent.OleMSess.sessionid * Start a new mail message and build the text This.Parent.OleMMess.compose lcMessageText = '<No Text>' lcSubject = '[tbs]' lcRecipAddress = lcemail lcRecipDisplayName = lcRecipAddress This.Parent.OleMMess.RecipAddress = lcRecipAddress This.Parent.OleMMess.RecipDisplayName = lcRecipDisplayName This.Parent.OleMMess.msgnotetext = lcMessageText This.Parent.OleMMess.msgsubject = lcSubject This.Parent.OleMMess.Send(1) This.Parent.OleMSess.signoff MESSAGEBOX("Signed off") Endif Is there a method other than signoff that I need to call to discard the message? The button is on a form that has a list of potential contacts and the intent is to be able to go down that list and select individual contacts to send an email to. thanks pete Tag: Is rename always copy/erase? Tag: 236114
  - 11
    - Exact match using INLIST() Hi -- Using VFP9 + XPPro. I tried to use the INLIST() function in an SQL SELECT statement to get only certain information from a table. I used SET EXACT ON before running the statement. However, this did not result to "exact" matches. For example, I asked for 'African American', but I received 'African American', as well as 'African American Females', and 'African American Males'. I finally had to redo the statement without the INLIST() function and use the "==" convention. Thanks in advance for any clarification or advice. David Tag: Is rename always copy/erase? Tag: 236109
  - 12
    - Lookups in listbox? Hi, Using VFP 9.0 sp1, I have a listbox control setup where the bound column is 1 of 2 columns. I have the row source type set to 6 and have picked my two fields from the cursor. Column one is an ID and column two is a name. When I tab into or select the listbox I can type an ID and it finds it in the list, pretty cool. However, my users really think in names, not ID's. How can I allow the fast searching by the second column but still return the first column in the value? I tried simply changing the bound column to 2 but then it returned the name not the ID, which I need for a lookup. I'm sure this can be done I just haven't figured out how yet. Any suggestions? Thanks in advance, Linn Tag: Is rename always copy/erase? Tag: 236101
  - 13
    - frx not found Help! I compiled an vfp9 sp2 exe which includes frx, not error during build. Then I copy the exe to other directory and try to run it. It can not find the included frx! Did I missing anything? Please help! TIA Tag: Is rename always copy/erase? Tag: 236083
  - 14
    - Michael Hogan on XML at Chicago FUDG at 11 Sep 07 The topic at the September 11 meeting of Chicago FUDG will be "MetaTables Using XML: Tables Within Tables" presented by Chicago's own Michael Hogan. Data changes: fields required for different types of records may differ. When different records within the same table require one-to-one joins with different child tables or when a table gets bloated with mostly unused fields, it's time to consider a more efficient way of handling the supplemental data. XML to the rescue! Using VFPâ??s CursorToXML and on-the-fly cursor structures you can encapsulate that data in memo and varchar fields. You'll learn how to: * Avoid table bloat from rarely-used fields in tables * Save and extract phantom sub-tables from memo and varchar fields * Use different sub-table structures for different record types * Use Memo to Object and Memo to Cursor techniques and their corollaries * Choose When to use or not use this technique Michael Hogan is an independent VFP consultant, and runs Ideate, LLC to provide business solutions in the Chicago area. His primary tools are Visual FoxPro and Web Connection. Same time and place. Tues, Sept 11th. 5:30 pm. 53 W Jackson Blvd, Suite 826. Dues are due. And bring a fin for pizza. We'll have a report from the Fox Forward Conference in Atlanta. See ya then. More info and upcoming meetings at http://www.ChicagoFUDG.com Future speakers include Whil Hentzen, Toni Feltman, and a CFUDG members night. -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200709/1 Tag: Is rename always copy/erase? Tag: 236072
  - 15
    - Subst.exe internal table Is there a way to retrieve the drive letters & associated devices created by subst.exe? (Would need to distinguish bet these and those created via net use calls). Tag: Is rename always copy/erase? Tag: 236069
  - 16
    - ShowWindow situation I have a method called OpenDatabaseFiles. This method can be called from the LOAD method or a Database Maintenace procedure to switch processing to another database. The main form is a TLF. If there is an error loading the database, I want to show wizard like forms to help the users correct the condition. Problem is, from the Load method, you cannot show the forms in a TLF because it is not ready yet (ShowWindow = 1) while from the Database Maintenance procedure I want to show in the TLC. ShowWindow is a read-only property so it is not possible to set the setting before activating the form. The only solution I can see is the have two forms, one ShowWindow = 2 for the LOAD procedure and Show Window =1 for the Database Maintenance procedures. Then put all the logic in a container that is added in Initialization. I would appreciate your expertise and comments Lee Jefferies Tag: Is rename always copy/erase? Tag: 236057
  - 17
    - Creating an inline attachment for Outlook I am using FoxPro7 to create a mailer using Outlook 2000. I wish to add a . jpg as an inline attachment, which I have not been able to do. I am able to creat the message with the .jpg as normal attachment. Can someone give me the Foxpro statement to add a .jpg as an inline attachment? Mohan I got the following response from the Outlook forum: Reply to this Message Report Abuse Ken Slovak - [MVP - Outlook] - 09-06- 2007 23:24 You won't find many or any FoxPro programmers here but just use the olByReference argument when you add the attachment and not olByValue. Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm I then tried the VBA forum; from where I got the advice to use olByreference instead if p\olByValue But my problem is oooooooo olByValue (=1)attaches the normal attachment olByReference (=4) attaches a Shortcut OlEmdeddedItem (=5) attaches a shortcut olOLE (=6) attaches a shortcut. My statement is - lonewmsg.Attachments.Add("d:\prdpl\order\greetings2.jpg",5, 1) Can someone help? Mohan -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200709/1 Tag: Is rename always copy/erase? Tag: 236051
  - 18
    - programming question I would like to know why the data can't append to the output file from the script below: ** close databases set date to british set safety off set century on set cpdialog off set talk off set defa to c:\GP\utilities set path to c:\GP\utilities startday=ctod("01/09/2007") endday=ctod("03/09/2007") inpath = "D\Source\" USE ABC_Count ZAP in_date = startday DO WHILE in_date <= endday ?in_date wdate = DTOC(in_date,1) wdd = SUBSTR(wdate,7,2) wmm = SUBSTR(wdate,5,2) wyy = SUBSTR(wdate,1,4) filename = inpath + wyy + wmm + "\" + wyy + wmm + wdd + "-stock.dbf" use &filename in select(1) alias a select a.date,a.location,a.stock,ud.type, ; sum(iif(a=1)) as stockAcount, ; sum(iif(b=0)) as stockBcount, ; from a; group by a.location; into table a1 APPEND FROM a1 FOR (stock= 'A') REPLACE bdate WITH in_date FOR EMPTY(bdate) in_date=in_date+1 ENDDO copy to stock.csv type xls close database Tag: Is rename always copy/erase? Tag: 236047
  - 19
    - The Windows Help (WinHlp32.exe) program is no longer included with http://support.microsoft.com/kb/917607/en-us Windows Help (WinHlp32.exe) is a Help program that has been included with Microsoft Windows versions starting with the Microsoft Windows 3.1 operating system. WinHlp32.exe is required in order to display 32-bit help content files that have the ".hlp" file name extension. However, the Windows Help program has not had a major update for many releases and no longer meets Microsoft standards. Therefore, starting with the Windows Vista operating system release, the Windows Help program will not ship as a component of the Windows operating system. Also, third-party programs that include .hlp files are prohibited from redistributing the Windows Help program together with their products. Users who want to view 32-bit .hlp files must download the program from the Microsoft Download Center, and then install it on their computers. Users who have not installed this program on their computer will be directed to a help topic in the Windows Vista Help and Support application. To download WinHlp32.exe, visit the following Microsoft Web site: Tag: Is rename always copy/erase? Tag: 236041
  - 20
    - Printing labels? Hi All, I am trying to put together a simple label printing program but, of course, am having a small problem(s). I have my data setup following a previous post on relating views. I have a view with names and I use the selected name to then query another view for addresses. Each name may have more than one address. In the second view I select the address I am interested in and have defined a report with the layout that I want. Problem is that if I print someone with more than one address all their addresses are printed, not just the address I selected. Anyone know of any examples of how to do this? Or a better approach I should be taking? I thought about using scatter to an object but then I didn't know how to reference that object in the report designer. I'm thinking it is a scoping issue, I don't quite know how to make the scattered object global. To print the labels we have a fancy thermal label printer with 4" x 5" labels. I've only been using the print preview so I don't know if it will work for sure or not. With that in mind, is there anyway to hard code the printer so that the user doesn't have to select it each time? Also, we want to print only one label at a time, not a set of records, just the person and address combination the user selects. Hope all this makes sense and that someone can offer some suggestions. I'm using VFP 9.0sp1 btw. Thanks in advance, Linn Tag: Is rename always copy/erase? Tag: 236032
  - 21
    - odbc, foxplus and office desktops apps When I create a standalone table via copy to ... type foxplus/fox2x, do all other office apps still use odbc to view the table or do some of them use old style direct file io? I ask because I'm rewriting an older app & the previous developer believes that the foxplus/fox2x tables can always be opened by other office apps regardless of odbc version/install issues. I find this difficult to believe. Anyone know for sure? -Lew Tag: Is rename always copy/erase? Tag: 236026
  - 22
    - Collecting data in vfp vs fox2x I need to collect and sum data from related database, something I know how to do in fox2x based on the speed and efficiency limits of that platform, but would like to get input on (efficient) ways to do the same in vfp. Assuming a large related table with a handful of records meeting the relation scope, how would I best sum a (non indexed) numeric field field for the scope of the relation? here's what I assume would still be most efficient; select ordent &&parent onum = ordernum select orddet &&o2m child if seek(onum) CALCULATE sum(qtyord * price) while ordernum = onum TO otot *or sum (qtyord * price) TO otot while ordernum = onum endif select ordent goto recno() Thanks in advance, Beverly Howard Tag: Is rename always copy/erase? Tag: 236017
  - 23
    - Old spr bug occurs when changing from VFP8 to VFP9 This is an odd one that I doubt anyone has encountered but I'll throw it out in case I get lucky: We have a large application (hundreds of screens) that was developed in the FP2.6 days that has been working fine under VFP8. For our next release we'd thought it would be a good idea to move the development to the latest version of VFP9 (SP1). We thought we got through the transition clean but now a strange problem has popped up. On quite a few of the old SPRs that were created with 2.6 where we have a list that is populated from a field the list is not being refreshed when the user selects to add a record (via a button). The code behind the button just does: APPEND BLANK SHOW GETS If you put your cursor in the list then it refreshes correctly and shows you the new record. What's odd is there is also a button that deletes a record. It has code that deletes the record and then does a "SHOW GETS". This button works fine. If I run the code in VFP8 it works as intended. If I then run it with VFP9 I get the quirky behavior. Any insight would be greatly appreciated, - Lee Blue Tag: Is rename always copy/erase? Tag: 236014
  - 24
    - programing question Hello, I am sure I am asking a stupid one and maybe the answer is already out there, but when you don't know what keywords to search for that practically nulifies that. Ok so I have this filter that I want to make shorter: substr(Invlines.Product,1,3)='CAP' Or substr(Invlines.Product,1,3)='CCC' Or substr(Invlines.Product,1,3)='CCO' Or substr(Invlines.Product,1,3)='CDC' Or substr(Invlines.Product,1,3)='CDO' so I want to say in one line of code search the first three letters of this product and pull out all that have the CAP, CCC ... and so on. Thank you. Tag: Is rename always copy/erase? Tag: 236009
  - 25
    - Packing Code? Having just gone through a worst case scenario related to lost source code and noting another thread here concerning maintaining reference code, I'm wondering if there is any way to easily include a zip or other file containing an application's code within the application itself. Expanding on the thought, an option could be included in the utility menu to copy the file out to disk. At the moment, I'm uploading a zip containing the current code to the customer's site with each build but it would seem that an embedded solution would be preferable for a number of possible reasons. I've tinkered with simply including the zip in the project, but that does not seem to be workable. I note the "other" file category but havn't yet found how to directly manipulate that. The info on projects seems to show a lot of power, but nothing directly related to this type of need. Any thoughts and other solution approaches would be appreciated. Beverly Howard Tag: Is rename always copy/erase? Tag: 235998
- Next
  - 1
    - SQL Aggregation and .NULL. Mess On investigation of a bug in a report, it turns out that some work might not have any disbursements. Because I have been using inner joins to add columns to build up the report data, that work does not show up on the report. I have solved this, I think, but it is not nice. Where I join the various columns together and there is danger of .null., I have made the joins left outer, the resulting cursor readwrite, and follow by replaces like replace thing with 0 for isnull(thing) for each potentially-.null. column. You think this is a kludge, right? So do I. It is too easy to miss a case, and it is ugly. Is there a better way of handling these idiot .null.s? (I am quite aware that the sum of zero numbers is 0. A pity SQL does not understand.) (Yes, I could use set enginebehavior, but that is likely to bite if I have to have a VFP 9 SQL feature.) Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Is rename always copy/erase? Tag: 235982
  - 2
    - Tree View in Grid Hello, Can anyone help on Tree View in Grid Regards Tag: Is rename always copy/erase? Tag: 235981
  - 3
    - Tree View in Grid Hello, Can anyone help on Create a form by using Tree View in a grid ? - Reference , Particulars , Amount - Product Amount - Product Amount + Reference, Particulars , Amount + Reference, Particulars , Amount Regards, John Chu Tag: Is rename always copy/erase? Tag: 235980
  - 4
    - Command Buttons Dear "All" How can i add command buttons interactively on my forms.. example : if i type 5 on the textbox then it will display 5 command buttons on the form.. it that possible? thanks... gechelle Tag: Is rename always copy/erase? Tag: 235974
  - 5
    - Using writemethod() I'm trying to automate the adding of a method and code to a series of vcx class defs. Using .WriteMethod() generates the error "...must be in design mode." So how do I get into design mode from a prg? (I've actually posted the answer to this question on this list, but I lost the code & don't remember the answer.) -- -Lew The workers took the robot for Maria. Tag: Is rename always copy/erase? Tag: 235973
  - 6
    - Preparing to install VFP 9 Why to I get & how do I turn off the annoying message "Preparing to install VFP 9 ..." when I click on a .prg in Windows Explorer? VFP 9 has been installed for years & it's working fine. -- -Lew The workers took the robot for Maria. Tag: Is rename always copy/erase? Tag: 235972
  - 7
    - PDFSplitMerge - wierd ! Hi All I have been out of town, so I have started a new thread My previous post said: <<We just purchased PDFSplitMerge from Guangmingsoft It is a set of dll's that work fine in development Does not work in runtime (vfp9, sp1) Fails on createobject>> on further testing, this is not correct ! our framework has classes: cntSend, and Frmrpt that are used here Frmrpt class has cntSend as member, cntSend handles report, email, fpt, etc thru contained classes cntMapi etc situation 1: method cntSend.open tries to: This.oSplitMerge = createobjec("PDFSplitMerge.PDFSplitMerge.1") in development, this works once !! on 2nd attempt, fails (restarting vfp => once again) in runtime, always fails situation 2 Frmrpt button has code: oObj = createobjec("PDFSplitMerge.PDFSplitMerge.1") this works always in development and runtime !! anybody have any idea what is going on ? al ps. for anybody who is interested, when this works it is very fast, combines 50 reports into one pdf over 10 MB in about 1 second ! Tag: Is rename always copy/erase? Tag: 235969
  - 8
    - Vista Solutions Hi. When running a vfp app in vista "aero" you get the missing borders on child forms and dropdown box items all get highlighted when using the mouse. If you run an app as administrator, the problem magically goes away. Microsoft obviouslly has the code to fix these display issues. Can they not just parse out the code that fixes the display problem and make it as another "compatibility" option. Surely the code involved can't be "dangerous" enough to warrant being run as administrator. I,m sure millions of apps could benefit from this. Is there someone who can be emailed the suggestion that would actually take it a serious look at it? Thanks. Mike Tag: Is rename always copy/erase? Tag: 235960
  - 9
    - Any way to communicate to modem via VFP to detect dialtone? Hi, Is there any way to communicate to modem via VFP to detect if there is a dialtone or if the line is in use? Thanks Zoom Tag: Is rename always copy/erase? Tag: 235959
  - 10
    - Field called Year I have a field I've named year. First I tried it as a numeric type and got 2,007 ib the form that I was using to feed data into the table. Then tried character as the type and got 20,07 in the form. How can I get the field just simply to show the year and only the year? Thanks, Thomas Tag: Is rename always copy/erase? Tag: 235943
  - 11
    - Help with buffered table I have 2 tables: in one of them I have the parents of the childs of the 2nd table. This means, I have a 1 to n relationship. Let's say, for key 'A' I have 3 childs A1,A2,A3. Table 1: primary key A primary key B primary key C Table 2: candidate key A1 candidate key A2 candidate key A3 candidate key B1 The candidate key in table 2 is to ensure that there are no double A1 or A2 o A3 or B1. Now I delete in table 2 the record A2 , and append from another table another record A2. This works fine as long I have no table buffering. But when I turn buffering on (in order to make it work within a transaction), I get "uniqueness of index .... violated" when I issue the APPEND command. What can I do? I don't want to update the record A2, I want to delete it and to append it. Walter Tag: Is rename always copy/erase? Tag: 235940
  - 12
    - calling an external form from an executable I have a standard executable that I want to add a customised form to without compiling it into the executable.. This will be an external .SCX file. This works fine by adding in DO FORM MyForm.SCX as a menu option in the executable, ensuring that it does not get compiled into the executable. The problem occurs when MyForm.SCX calls another form in the Executable. It fails, complaining that it can not find the form in the directory. How can I get the external form to call a form inside the executable that is calling it? ie: My.EXE ---------> MyForm.SCX (external form in the directory) --------------------> My.SCX (inside My.EXE) Cheers David Younger Tag: Is rename always copy/erase? Tag: 235931
  - 13
    - Learn to develop internet applications I am not a "techi", but I need to learn how to put my VFP application on the internet for my customers to use. Can anyone point in the direction to learn this? -- TIA Cowboy Tag: Is rename always copy/erase? Tag: 235912
  - 14
    - UPDATE - SQL very slow Yesterday I had 2 tables: table 1 has 5 million records, table 2 has 2.5 million records, both in dbf format. Both tables are free tables,i.e. with no dbc belongign to. The tables have no memo fields. I want to update the first column of table 1 with the first column of table 2. So I did: UPDATE table1 SET column1=table2.column1 FROM table2 ON table1.id=table2.id The whole process vas very, very slow (more than half an hour on a Intel D915 with Pentium4 3.00 GhZ), Then I thought it would be better to index both tables on the field id which is an Integer. Performance was still the same. Then I did it the old way: a little program with SCANning table1 and SEEKing table2, and REPLACEing and it was fast. How come the UPDATE - SQL command is so slow? Walter Tag: Is rename always copy/erase? Tag: 235905
  - 15
    - Printing .prg etc files In Foxpro 2.0 there used to be a way to create a special report format that could be used to print .prg files. If I remember correctly we modified or created a new report file that could be used to print the file with a header (etc) page numbers and the like. It seems that 9.0 has the report format included in the build and it is not possible to do the substitution. Is there any way to enhanse the printout format in VFP 9. If not does anyone agree this would be a nice enhancement for an update. Tag: Is rename always copy/erase? Tag: 235904
  - 16
    - How to increase the size of the checkbox in VFP9? Hi, I am looking to have a "large" checkbox as a control. When I increase the font size of the checkbox control, only the checkbox caption text size is increased. The checkbox still remains small. I have even set the AUTOSIZE property to .T. but no change. I would appreciate any ideas anyone might have to increase the size of the checkbox itself. Thanks Zoom Tag: Is rename always copy/erase? Tag: 235899
  - 17
    - TS part XX Hi again..., now I have problems with foxuser.dbf. I create a config.fpw file when it doesn't exist : IF .not. FILE("config.fpw") TEXT TO cconfig noshow SCREEN = OFF SYSMENU = OFF MENU = OFF RESOURCE = OFF BITMAP = OFF ENDTEXT STRTOFILE(cconfig,ADDBS(lcpath)+"config.fpw") ENDIF When I start my exe under TS (adminstrator) the foxuser.dbf is still getting created in the C:\ ? then when a User start my exe a message is shown stating it is invalid overwrite yes/no ? just for testing purpose. I've deleted foxuser.dbf and I don't start my exe under TS (Administrator) only as a TS User everything works ok. no foxuser.dbf is being created ? So why is foxuser.dbf created under Administrator and not as a User. but as a User it is still looking for it when it is created as Adminstrator ! The reason why it asks to overwrite it, is probably because the User has no userrights on those files create as Adminstrator ? Does this mean when a dbf or any other file that will be created with my exe run by the Adminstrator Users won't have access to it ? regards christophe Tag: Is rename always copy/erase? Tag: 235898
  - 18
    - From VFP7 to 8 or 9? Now that the water is not so high, gonna try changing horses and upgrade from VFP7 as I have been oft prompted here to do... Question... should I go to VFP8 or 9, especially in view of my current vfp beginner status? Looking forward to the comments. Beverly Howard Tag: Is rename always copy/erase? Tag: 235891
  - 19
    - HAL-PC FoxPro September 11 Meeting - First Notice FIRST NOTICE For last minute changes and error corrections check the web site at http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html> <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html> > SIG Group News and Announcements: This is the September meeting. Fall is here, time to attend a meeting catch up with everyone and what is going on with VFP. It is also time to start preparing to move your apps to VFP 9 where it will work on all platforms SP2 is on the web in beta with a list of the contents. ISP2 should be released at any time. Look forward to seeing you there. Plus HAL-PC General Meeting with lots of interesting things on my birthday Sept. 22nd. Oh, joy, I will be 65. To get information go to: http://www.HAL-PC.org <http://www.hal-pc.org/> <http://www.hal-pc.org/ <http://www.hal-pc.org/> > HAL-PC GENERAL MEETING Saturday, September 22: 10:00 am Join us at HAL-PC Headquarters for our General Meeting. Featured speaker will be Dwight Silverman, interactive journalism editor, technology blogger and computer columnist at the Houston Chronicle and co-author with Larry Magid of "Microsoft Windows Vista: Peachpit Learning Series", from Peachpit Press. Mr. Silverman's will present 'Windows Vista - A midyear report card'. Windows Vista has been available to consumers for almost 9 months. It's been successful in terms of sales, but not necessarily in terms of acceptance. Mr. Silverman will look at some of the reasons why, and the challenges that face Microsoft as a result. VFP NEWS: The next VFP Boot Camp will be in Kansas City, Missouri, October 1-3, 2007 Registration ends on September 14, 2007 for the highly-acclaimed VFP Boot Camp. This event delivers three jam-packed days of solid, hands-on learning. From the fundamentals of VFP development through the very latest VFP 9.0 features, this boot camp is designed to quickly get your VFP skills up to speed. Attendees will receive a 500 page manual in both print and electronic format. For more information visit http://visionpace.com/developereducation.html <http://visionpace.com/developereducation.html> or email info@visionpace.com. To register call 888-904-7900. Please check the news page for details: http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html> <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html> > click News & tips in first drop down box Meeting information for Tuesday September 11th , 2007 at HAL-PC Headquarters: Next Meeting Tuesday September 11th, 20007 6:30 PM at HAL-PC 6:30 PM This Page last modified Thursday, August 30, 2007 by John P. Chambers, LCSW, LMFT, LPC, LCDC Email John <mailto:john@vfug.org <mailto:john@vfug.org> > Feature presentations: Rich Monroe: Tips & Tricks + Form Class Design Rich Monroe:Session Tracking Screen Ed Hardin: Creating Email Down and Dirty Part I Meeting Agenda <http://www.hal-pc.org/%7Ejpc/HAL-PC/HalFoxNextMeet.html#Meeting%20Agenda <http://www.hal-pc.org/~jpc/HAL-PC/HalFoxNextMeet.html> > For their incredible presentations, we would like to thank our August Speakers: Rich Monroe: Tips & Tricks Ed Hardin: Creating Email Down and Dirty Part II Meeting Agenda August 14th, 20007 6:30 PM Beginning John Chambers Jabberwocky 1. 6:00 - 6:30 PM: Mayhem reduction Question and Answer session 2. 6:30 - 6:45 PM:Rich Monroe: Tips & Tricks + Form Class Design: In addition to some new Tips & Tricks Rich will show proper designing of Form Class 3. 6:45 - 7:15 PM: Rich Monroe:Session Tracking Screen: Rich shows a screen that tracks the activity and screens when an application runs, keeping up with who, etc. BREAK 7:15 PM till 7:30 PM Announcements by John Chambers Advanced Rich Monroe Jabberwocky 4. 7:30- 8:00 PM: Ed Hardin: Creating Email Down and Dirty Part I :I'll be talking about using winsock to create an internet connection and then using POP3 commands to create a down and dirty email client thus bypassing having to use Outlook, Eudora, etc. to check email. In my case this is something that I had a need for. 5. 8:15 - 8:45 PM:Panel: Open Question and Answers of VFP Hope you can join us, Rich Monroe, Advanced SIG Leader John Chambers, Beginning SIG Leader John Chambers, SIG Secretary, Web Master, Flunky Ed Hardin, SIG File Librarian and SIG Ambassador to Russia Problems or to be added or removed from this list Add to List: mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> <mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> > FoxSigAdd Remove from list: mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> <mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> > FoxSigRemove Problem or Suggestion: mailto:jpc@hal-pc.org?subject=HalFoxSigProblem <mailto:jpc@hal-pc.org?subject=HalFoxSigProblem> or Suggestion Please add name and email address notices are going to To volunteer to make a presentation: mailto: richmonroe@pdq.net?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> > FoxSigVolunteerToPressent To suggest a topic: mailto: richmonroe@pdq.net?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> > FoxSigSuggestTopic Rich is in charge of the speaking schedule. Please help him out. If he has a lot of speakers and topics that he can pick and choose from it makes it easier to schedule things, take care of emergencies, and of course better meetings. Thanks for any help. ----------------------------------- Sender John P. Chambers Texas Licenses: LMSW-ACP, LPC, LMFT, and LCDC (Texas Licenses required by my day job) HAL-PC FoxPro SIG secretary and General Flunky Web: http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html> <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html <http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html> > Email: mailto:jpc@hal-pc.org <mailto:jpc@hal-pc.org> <mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> > VFUG Board and PR Person: http://www.vfug.org <http://www.vfug.org/> <http://www.vfug.org/ <http://www.vfug.org/> > mailto:john@vfug.org <mailto:john@vfug.org> <mailto:jpc@hal-pc.org?subject=Hal <mailto:jpc@hal-pc.org?subject=Hal> > Main Email address: John@DiscoveryOffice.com mailto:John@DiscoveryOffice.com <mailto:John@DiscoveryOffice.com> ------- Sender: John P. Chambers Business: Discovery Center, Inc. Hm. Ph. (713) 465-4209 Bus. Ph.: (713) 963-0043 Texas Licenses: Fax Ph.: 713-465- 6069 LMFT , CSW, 7505 Highmeadow LPC Houston, Texas 77063 http://www.DiscoveryOffice.com <http://www.discoveryoffice.com/> Email mailto:John@DiscoveryOffice.com <mailto:John@hDiscoveryOffice.com> Virtual FoxPro User Group (VFUG) Public Relations Mgr. http://www.vfug.org/ <http://www.vfug.org/> Email mailto:John@vfug.org <mailto:John@vfug.org> mailto:jpc@RedTile.com <mailto:jpc@RedTile.com> FoxPro Beginning SIG Leader http://www.hal-pc.org/~jpc <http://www.hal-pc.org/~jpc> Email mailto:jpc@hal-pc.org <mailto:jpc@hal-pc.org> -- Main Email address: John@DiscoveryOffice.com mailto:John@DiscoveryOffice.com ------- Sender: John P. Chambers Business: Discovery Center, Inc. Hm. Ph. (713) 465-4209 Bus. Ph.: (713) 963-0043 Texas Licenses: Fax Ph.: 713-465- 6069 LMFT , CSW, 7505 Highmeadow LPC Houston, Texas 77063 http://www.DiscoveryOffice.com Email mailto:John@DiscoveryOffice.com Virtual FoxPro User Group (VFUG) Public Relations Mgr. http://www.vfug.org/ Email mailto:John@vfug.org mailto:jpc@RedTile.com FoxPro Beginning SIG Leader http://www.hal-pc.org/~jpc Email mailto:jpc@hal-pc.org Tag: Is rename always copy/erase? Tag: 235876
  - 20
    - Exchange crash after promoting server to Domain Controller I did big mistake and i promoted Exchange server to DC. After that replication was not working - something wrong with "out of RID keys" and exchange services won't start. Than I did DCpromo and i uninstalled AC. Exchange still dead. My question is - can i reinstall entire server (OS + SP2 + Exchange + ExchSP1, setup other things like RPC over HTTP, OWA, etc.) and just restore edb files from backup ? Is it gonna work or it will crash ? I have MS instruction how to do it but it states "if Exchange was not on DC" - mine was on DC for a few hours(not operational anyway). Thanks in advance Tag: Is rename always copy/erase? Tag: 235868
  - 21
    - Grids and SET SKIP vfp7 ...yea... I know... but, the water's still pretty deep. As my forms are getting more complex, I need some guidance on how to handle a form with multiple related grids... the scenario; Form displays fields from the parent dbf (works fine) Bottom grid shows multiple rows from a related/setskip dbf (works fine) Top grid shows rows from the parent database and allows the user to browse the parent... ...works, but the top grid includes lines for each of the multiple "set skip" rows. I assume I can address this by using the parent "again" but wonder if there is a simpler approach to having the grid of the parent only show a single line per parent record? Thanks in advance, Beverly Howard Tag: Is rename always copy/erase? Tag: 235867
  - 22
    - Relating views? Hi, I'm running VFP 9.0 and writing a very small application that will simply print an address label. The backend is our SQL 2000 Server. I've written two remote views, one for the patient list and another for the addresses. Any patient my have more than one address and I want the users to be able to select the correct address. So I'm creating a form with two grids, one for the patient names and the other for the addresses. What I want is to select a patient name and have the associated addresses display in the second grid. I think I want to link the views in a parent-child configuration but I can't seem to remember or figure out how to do it. What is the best way to configure this setup? Thanks in advance, Linn Tag: Is rename always copy/erase? Tag: 235863
  - 23
    - File Type Execution When you double-click a file in Windows Explorer, explorer uses the extension to start a processor for the file. I would like to do that in VFP. I tried GETObject, but the results are mixed. Works fine for .doc, OK for .xls(file is hidden), not at all for .txt. Also, I will never have all the software users may want to use to process their file types. Can anyone describe the API calls that are required to use the file type to execute the processor associated with a file. Thanks for any responses. Tag: Is rename always copy/erase? Tag: 235855
  - 24
    - preparing to install and TS Hi, Each time when my exe is run under Terminal Server some forms contain the MsComCtl2.MonthView control when opening there is a messagebox saying "preparing to install" and it's closing right away. At least I think it has something to do with that control. Because others forms doesn't have this. I saw somewhere in this NG messages concerning this issue but I can't find them back. Kind regards christophe Tag: Is rename always copy/erase? Tag: 235854
  - 25
    - Fox-ODBC-sql2005 : does "schemas" work ??? hi i have a big trouble... i'm trying to access some stored proc at a Sql Server 2005 db, the is that stored proc are replicated for 2 different schemas : "dbo" y "schema_x" although i connect with a "login" under "schema_x" : it seems the driver always maps to "dbo" instead of try first to map "schema_x" and then, if it faults, try with "dbo" does somebody feel familiar this problem ?!! i'll aprecite your helppp PD: it works FINE thru OLEDB, from ASP and from sql server query console thanks atte, ks Tag: Is rename always copy/erase? Tag: 235850

I can't find an api call for a simple rename, leading to my question: Is
rename *always* a copy/erase function?
-Lew

Re: Is rename always copy/erase? by fpicanza

fpicanza
Thu Sep 13 07:12:06 PDT 2007

On Sep 13, 9:58 am, Lew <L...@discussions.microsoft.com> wrote:
> I can't find an api call for a simple rename, leading to my question: Is
> rename *always* a copy/erase function?
> -Lew

I think Rename is more like a MOVE than like a COPY/ERASE. A MOVE
simply modifies the File Allocation Table (fast) but doesn't shift
bytes around unlike a COPY (copies bytes... slow) followed by an Erase
(wipe the file in the File Allocation Table...fast). Move/Rename
should be faster than Copy.

But should anyone know better (I didn't necessarily stay current with
all version), feel encouraged to contradict me :)

-Francois

Top

Re: Is rename always copy/erase? by Michael

Michael
Thu Sep 13 11:32:11 PDT 2007

You may find the MoveFile Win32 API function handy. It works efficiently
and handles mixed case file names, as well as directories. See:

http://www.news2news.com/vfp/?group=27&function=20

Mike

"Lew" <Lew@discussions.microsoft.com> wrote in message
news:8AA42077-202A-4B47-80F6-06F9EEE351AA@microsoft.com...
>I can't find an api call for a simple rename, leading to my question: Is
> rename *always* a copy/erase function?
> -Lew

Top

Re: Is rename always copy/erase? by Gene

Gene
Thu Sep 13 10:56:49 PDT 2007

Lew <Lew@discussions.microsoft.com> wrote:

>I can't find an api call for a simple rename, leading to my question: Is
>rename *always* a copy/erase function?

Why not use the VFP command?
RENAME FileName1 TO FileName2

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Top

Re: Is rename always copy/erase? by Lew

Lew
Thu Sep 13 11:42:03 PDT 2007

I have a perverse sense of purpose.

"Gene Wirchenko" wrote:
> Why not use the VFP command?
> RENAME FileName1 TO FileName2
>
> Sincerely,
>
> Gene Wirchenko

Top