How to combine two tables with same fields together

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
    - OUTLOOK EXPRESS OBJECT NAME Hi Expert, Please advice me what the name of Outlook Express Object is, I will use it as automation program from VFP. And if you do not mind please supply me with the properties, event and method Thank's for your advices Hidayat Tag: How to combine two tables with same fields together Tag: 187837
  - 2
    - Report Hi all, Can someone 100% confirm me that I can print two+ reports on one a4-size paper, all reports printed on same side in vfp8? If that is true, I am considering upgrade from vfp7 to vfp8. Currently, I need to generate two invoices on an a4, both on same side, same direction, I hardly found that can be done in vfp7 (well, it does not allow two seperate sets of page header and group header on one paper). My solution will be generate a *.prg, and using command like "eject paper, @row, @col print ..." to print the invoice out. Any other good solutions advise? Many thanks. Regards, Wandy Tag: How to combine two tables with same fields together Tag: 187836
  - 3
    - OUTLOOK EXPRESS OBJECT Hi Expert, Please advice what the name of the Outlook Express object is, because I want to use it as automation program from VFP. And if you do not mind please supply me with it's property, event & method. Thank's for advices Hidayat Tag: How to combine two tables with same fields together Tag: 187835
  - 4
    - How to delete record in cursor Hi Expert, Please advice how to delete/remove a record from the CURSOR that I get from the following code: SELECT *FROM CUSDTA INTO CURSOR CURDTA so, I want to delete record or some record in CURDTA Thank's for advices Hidayat Tag: How to combine two tables with same fields together Tag: 187832
  - 5
    - .dbx files hi. can anyone help me with restoring .dbx files that I backed up according to MS knowledge base, but cannot restore. MS tells me this is a "bug", that the files are lost because either my previous version of OE was different, the .dbx files were corrupt or some third reason. I went to great pains to back up these email files when I had to do a windows reinstall and now it appeas that they are just gone. Thanks for any advice. kb Tag: How to combine two tables with same fields together Tag: 187829
  - 6
    - Vietnamese Characters in a VFP App Hi, I've installed vietnamese language pack on Windows XP Pro also put CODEPAGE=1258 in Config FPW I need to be able to have the following data in a VFP app ngày cu?i xu?t d? li?u Some of the chrs are not available when I printed all the chrs with ? chr(x) I've set Fonts to Tahoma and Courier New Word Supports the characters no problem with courier new Notepad complains that some chr's are unicode and obviously VFP doesn't support unicode! Is there a way to set the codepage to the unicode codepage????? Have also tried x=filetostr('viet.txt') && Viet.txt contains ngày cu?i xu?t d? li?u looking at x in the debugger it has some crap characters in the string getcp() doesn't have 1258 in the list either! Is there a way to get it into the VFP NLS list? IS anyone using VFP with Vietnamese data with all the diacritic characters? TIA Rob Tag: How to combine two tables with same fields together Tag: 187825
  - 7
    - Report Hi all, Is it possible that I can print two *.frx onto one a4-size paper? one on the top half and the other on the bottom half. Regards, Wandy Tang Tag: How to combine two tables with same fields together Tag: 187823
  - 8
    - Treeview How do I set a node not to have a parent? I know how to *create* one without a parent, but not how to reset it. Anyone? TIA Mark -If more of us acted more sensibly, d'you think Governments might join in? Tag: How to combine two tables with same fields together Tag: 187820
  - 9
    - How can I download a file from a internet address in vfp! Good luck in the new year, everyone! I want to update my program from a internet directory. Suppose, my updated announces is in ftp://xxxxx.com/update/announce.txt, how can I download the file in vfp? Of cource, I can do it a API function: ShellExecute with such code: DECLARE integer ShellExecute in shell32.dll As ShellA integer hwnd,; String lpOperation , string @lpFile , String lpParameters , String @lpDirectory ,integer nShowCmd Shella(0,'OPEN','ftp://xxxxx.com/update/announce.txt','','',5) But the problem is: executing it will come out a question window. I needn't it, and I want to download it in a folder I can control and no any question window automatically created by window. How can I do it? Tks a lot! Chuen Tag: How to combine two tables with same fields together Tag: 187814
  - 10
    - data no borrar w=0 clea set print on set printer to c:\ito.txt for w=999 to 999999999.99 *@1,1 say ' monto:' get w pict '999999999.99' *read *if lastkey()#27 ?w,CADENA0(W) *endif next set print off set printer to RETURN *************** FUNCTION CADENA0 PARA PCADENA WRET='' WVALOR=PCADENA IF VAL( left( trans( WVALOR,'999999999.99' ),3 ) ) >0 Wtexto='un' IF VAL( left( trans( WVALOR,'999999999.99' ),3 ) ) # 1 Wtexto=CADENA1( VAL(left( trans( WVALOR,'999999999.99' ),3 )) ) IF VAL( SUBSTR( trans( WVALOR,'999999999.99' ),3,1 ) )=1 Wtexto=LEFT(Wtexto,LEN(Wtexto)-1) ENDIF ENDIF WRET=WRET+Wtexto+' millon'+iif(VAL( substr( trans ( WVALOR,'999999999.99' ) ,3,1) )=1,'','es') ENDIF IF VAL( SUBSTR( trans( WVALOR,'999999999.99' ),4,3 ) ) > 0 Wtexto='' IF VAL( SUBSTR( trans( WVALOR,'999999999.99' ),4,3 ) ) # 1 Wtexto=CADENA1( VAL( SUBSTR( trans( WVALOR,'999999999.99' ),4,3 ) ) ) IF VAL( SUBSTR( trans( WVALOR,'999999999.99' ),6,1 ) )=1 Wtexto=LEFT(Wtexto,LEN(Wtexto)-1) ENDIF ENDIF WRET=WRET+Wtexto+' mil' ENDIF IF VAL( SUBSTR( trans( WVALOR,'999999999.99' ),7,3 ) ) > 0 WRET=WRET+CADENA1( VAL( SUBSTR( trans( WVALOR,'999999999.99' ),7,3 ) ) ) ENDIF WRET=WRET+' con '+padl(Allt(Str( ((WVALOR-int(WVALOR)) *100) )),2,'0')+'/100 ' RETURN WRET **************** FUNCTION CADENA1 PARA PCADE_1 PCADE1=PCADE_1 WRET1='' IF LEN(ALLT(STR(PCADE1)))=3 && centenas DO CASE CASE LEFT(ALLT(STR(PCADE1)),1)='9' WRET1=WRET1+' novecientos' CASE LEFT(ALLT(STR(PCADE1)),1)='8' WRET1=WRET1+' ochocientos' CASE LEFT(ALLT(STR(PCADE1)),1)='7' WRET1=WRET1+' setecientos' CASE LEFT(ALLT(STR(PCADE1)),1)='6' WRET1=WRET1+' seiscientos' CASE LEFT(ALLT(STR(PCADE1)),1)='5' WRET1=WRET1+' quinientos' CASE LEFT(ALLT(STR(PCADE1)),1)='4' WRET1=WRET1+' cuatrocientos' CASE LEFT(ALLT(STR(PCADE1)),1)='3' WRET1=WRET1+' trescientos' CASE LEFT(ALLT(STR(PCADE1)),1)='2' WRET1=WRET1+' doscientos' CASE LEFT(ALLT(STR(PCADE1)),1)='1' WRET1=WRET1+' cien'+iif(val( substr(ALLT(STR(PCADE1)),2) ) = 0,'','to') ENDCASE ENDIF if val( substr(trans( PCADE1,'999' ),2) ) >=1 and val( substr(trans( PCADE1,'999' ),2) ) <=9 WRET1=WRET1+' ' endif IF val( substr( trans( PCADE1,'999' ) ,2,1 ) ) > 0 && decenas DO CASE CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=9 WRET1=WRET1+' noventa'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=8 WRET1=WRET1+' ochenta'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=7 WRET1=WRET1+' setenta'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=6 WRET1=WRET1+' secenta'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=5 WRET1=WRET1+' cincuenta'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=4 WRET1=WRET1+' cuarenta'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=3 WRET1=WRET1+' treinta'+iif( val (right(ALLT(STR(PCADE1)),1))>0 , ' y ', '' ) CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=2 WRET1=WRET1+' '+iif( substr(ALLT (STR(PCADE1)),2,2) = '20','Veinte','Venti') CASE right(trans( PCADE1,'999' ),2)='11' WRET1=WRET1+' once' CASE right(trans( PCADE1,'999' ),2)='12' WRET1=WRET1+' doce' CASE right(trans( PCADE1,'999' ),2)='13' WRET1=WRET1+' trece' CASE right(trans( PCADE1,'999' ),2)='14' WRET1=WRET1+' catorce' CASE right(trans( PCADE1,'999' ),2)='15' WRET1=WRET1+' quince' CASE val( substr( trans( PCADE1,'999' ) ,2,1 ) )=1 WRET1=WRET1+' die'+iif(val( substr ( trans( PCADE1,'999' ) ,3) ) = 0,'z','ci') ENDCASE ENDIF IF val(right(trans( PCADE1,'999' ),1))>0 && unidades DO CASE CASE right(ALLT(STR(PCADE1)),1)='9' WRET1=WRET1+'nueve' CASE right(ALLT(STR(PCADE1)),1)='8' WRET1=WRET1+'ocho' CASE right(ALLT(STR(PCADE1)),1)='7' WRET1=WRET1+'siete' CASE right(ALLT(STR(PCADE1)),1)='6' WRET1=WRET1+'seis' CASE right(ALLT(STR(PCADE1)),1)='5' and right(ALLT(STR(PCADE1)),2)<>'15' WRET1=WRET1+'cinco' CASE right(ALLT(STR(PCADE1)),1)='4' and right(ALLT(STR(PCADE1)),2)<>'14' WRET1=WRET1+'cuatro' CASE right(ALLT(STR(PCADE1)),1)='3' and right(ALLT(STR(PCADE1)),2)<>'13' WRET1=WRET1+'tres' CASE right(ALLT(STR(PCADE1)),1)='2' and right(ALLT(STR(PCADE1)),2)<>'12' WRET1=WRET1+'dos' CASE right(ALLT(STR(PCADE1)),1)='1' and right(ALLT(STR(PCADE1)),2)<>'11' WRET1=WRET1+'uno' ENDCASE ENDIF RETURN WRET1 Tag: How to combine two tables with same fields together Tag: 187810
  - 11
    - Forms Registrations w/ Project Manager Q. Is there a way register all the forms in a specified directory (i.e. c:\myapp\forms) in the Project Manager? I know all I have to do is make a list and go through it but if such animal existed it would be a good tool in my toolbox. Kindest ~ Jonathan Morningstar ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: How to combine two tables with same fields together Tag: 187806
  - 12
    - RTFBOX Control I 'd like to know the arguments it 's possible to send to the method 'FIND' of a RTF control, speciallly to do back search in a text. Thanks Tag: How to combine two tables with same fields together Tag: 187805
  - 13
    - VFP7 C5 error accessing class instance Hello, I have a weird situation. I have a class based on a container, with about 20 methods and a dozen properties. Pretty simple stuff in there. I can get access the class method code by itself no problem. The problem comes when I drop an instance of the class onto a form. When I try to access the methods by double clicking the object on the form, I get kicked out with a C5 error. I've tried changing the instance object name, the class name, the form I'm dropping it onto, creating a new object and cut/pasting all the methods into it, all to no avail. Does anyone have any clue as to what might be going on and how I can fix it? TIA, Cathy Tag: How to combine two tables with same fields together Tag: 187801
  - 14
    - Help with opening FoxPro files without FoxPro? Greetings, all. I've been sent a load of FoxPro files by someone, but I don't have FoxPro. I was hoping to try to import it into Access but without much luck. I know this isn't a tech query, but any advice would be really appriciated. Many thanks, C. -- Christopher Lloyd London Offshore Consultants Ltd 20 St Dunstan's Hill London EC3R 8NP Tag: How to combine two tables with same fields together Tag: 187796
  - 15
    - Format I am new to this forum and liked it very much. I think it may be easier to show/highlight the questions which have been solved. This whould be done by the same person who posted the question and may optionally enter his/her satisfaction level (0-100)after he does not require any more answers to his question(s). Just a thought. Happy New Year to All. Tag: How to combine two tables with same fields together Tag: 187795
  - 16
    - Size of report Dear ALL, I want to ask that how can I set the width and height of the report before send the report form to printer? That mean before the command "report form abc to printer noconsole". Thank you for your help!! Best Regards, Nic Tag: How to combine two tables with same fields together Tag: 187793
  - 17
    - Printing problem Dear All, As I know that use 2003 remote desktop I can direct print the report or receipt in my office. no matter that remote pc is located at data center. So that i have run a foxpro application program on that pc. But I found a problem about the printing. I cant correctly print the receipt from my dot-matrix printer. but i can correctly print the report from my laser printer. would you suggest any code or method that I must print report or receipt to any printer as I like? In fact, I just use this command to print the receipt "report form invoice to printer noconsole" Best Regards, Nic Tag: How to combine two tables with same fields together Tag: 187787
  - 18
    - Mapping Software My name is Charlie Parker and I'm a Project Manager for Fowler Software Design LLC (www.fowlersoftware.com). We develop custom software for clients. I'm currently working on a project for a client named Dupree. Dupree runs a call center for non-profit organizations like Vietnam Veterans of America (V.V.A.). When anyone wants to make a donation of items like clothing, toys, etc. to V.V.A., they call an 800 number that directs them to Dupree. A person at Dupree enters the donor's information (name, address, phone number, items to be donated, pickup date, etc.) into the computer system. Then each night, the computer system at Dupree faxes a list of scheduled item pickups to the various outlets across the US so the outlet can then send out a truck to pick up the items. Currently, Dupree gets about 25,000 calls a week, but with the new system, they hope to expand. A feature we would like to add to the system is the ability to show the Thomas Street Guide page and section for each address on the pickup that gets faxed to the various outlets. Most of the outlets already use the Thomas Guide, so adding this info to the pickup list will save them the time of trying to find the page/section. Thus, what I need is a program that has an API or OCX interface that when given an address anywhere within the US will return the page number and section for that address if that address is on any of the Thomas Guides. Is such a program available? Thanks. Charlie Parker cparker@fowlersoftware.com Tag: How to combine two tables with same fields together Tag: 187782
  - 19
    - Printing .NULL --- This post is also appears in printing forum and is reposted here to ensure best exposure --- In my reports null values appear as .NULL. I would like to have them appear as something like --- or another N/A-style indicator. Some of these fields also have expressions already defined such as the one below: IIF(PartNumber = "V","---",ItemType) So the solution would have to be incorporated or work around existing expressions. ANYTHING other than .NULL would be great at this point! Thank you. Alan Tag: How to combine two tables with same fields together Tag: 187781
  - 20
    - Foxpro 2.6 Unix I have a client who has a very large app running in Unix using FP 2.6 development system which was installed over 5 years ago. They need to upgrade the hardware and make some changes to the code. They have the install disks but the serial number and activation key page is now illegible. Can anyone help. Tag: How to combine two tables with same fields together Tag: 187778
  - 21
    - Happy New Year Well almost time for me to go home. Just like to wish everyone a happy new year and thanks for all your help and thanks in advance for all the help that I'll need in the future. -- Altman "No matter how foolproof you make a system, 'fools' can be remarkably ingenious." Tag: How to combine two tables with same fields together Tag: 187777
  - 22
    - Printing to slip printer Hello all I am having to print to a validation slip printer EPSON TM- U375P. In order to switch from roll paper to sheet feed I need to echo the escape chr and the command to the printer. below is my code that uses the ! command to do this. This works but i get the black dos run box when I use it. My question is how can I get these commands to the printer other than the ! echo ? Glen _____________________________________________________ ccmd = [!echo ] + chr(27) + [c0] + chr(4) + [> lpt1 ] &ccmd ccmd = [!echo ] + chr(27) + [C] + chr(8) + [> lpt1 ] &ccmd ccmd = [!echo AAAAA > lpt1 ] &ccmd ccmd = [!echo bbbbbb > lpt1 ] &ccmd ccmd = [!echo ccccccc > lpt1 ] &ccmd ccmd = [!echo ddddddd > lpt1 ] &ccmd ccmd = [!echo eeeeeeee > lpt1 ] &ccmd ccmd = [!echo ] + chr(27) + [c0] + chr(1) + [ > lpt1 ] &ccmd _________________________________________________________ Tag: How to combine two tables with same fields together Tag: 187776
  - 23
    - VFP Code Page Question Hi All, Happy New Year hope it's a prosperous one for us all! :o) Anyway, onto business. Is there a way that VFP7 can utilise a Code page that isn't in it's default list ? Obviously it can't handle unicode data but I want to be able to get at and display CP 1258 or the Unicode CP 65000 & 65001 Is this at all possible. There is a SYS command to change code page but can you add one for use? Would it also be possible to set the collate order to that codepage? Have tried SYS but it threw up an error, not a valid codepage! Also have set windows CP to 1258 and everything works OK apart from Foxpro! :o( Any Help or Ideas please TIA Rob Tag: How to combine two tables with same fields together Tag: 187760
  - 24
    - Image Controls In VFP8, is there a way to control the image frame speed of a GIF? And is there a way to specify if the image is transparent or not? Happy New Year, Jonathan Morningstar ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: How to combine two tables with same fields together Tag: 187757
  - 25
    - Pause for 2 seconds... I need to pause my code for about 2 seconds in order for some commands to complete. What's the best way? I tried: wait "" timeout 3 but the cursor started blinking on my form I thought about adding a timer but will my code hault while the timer event runs? Thanks for any insight! VFP 6.0sp5 -Bruce Duncan Tag: How to combine two tables with same fields together Tag: 187753
- Next
  - 1
    - Get color pair ? RGB(255,255,255) &&display 16777215 What is the function to convert 16777215 into pair of 255,255,255 ? Thank to all Tag: How to combine two tables with same fields together Tag: 187749
  - 2
    - Catch child control mouse events Hi, How to catch a child control mouse events in the parent object. For example if I have a container and a text box placed on it, How I can catch the mouse right click event in the container before it goes to the edit box. Thanks Tag: How to combine two tables with same fields together Tag: 187748
  - 3
    - How to measure an image width/height Hi All, Please advice how to measure the 'Width' and 'Height' of an image, so that I can display always in the midle of the screen whatever setting of the screen ( by getting WROW() and WCOL() function. ) Thanks for your advices Hidayat Tag: How to combine two tables with same fields together Tag: 187743
  - 4
    - Maximized window size will cover up the taskbar The window size of my application is set to maximized so that the application is enlarged to fill up the screen. But my clients reported to me that the window size of my application is too large so that it cover up the Window's taskbar. I suggested them to check the box, "Always on top" in Windows taskbar's property. Some can solve this problem but some cannot solve it. Is there any suggestion to solve this? Thanks! Tag: How to combine two tables with same fields together Tag: 187742
  - 5
    - I Want To Create a Newgroup-like forum and poll the membership. Hi FoxFans, I know this question is not directly related to Foxpro, but I figured this is the most likely place to get ideas. I am a board of director for a very large Homeowners association (8,000 members). I want to set up a newsgroup-like forum where the membership can constantly communicate and exchange ideas the same way we do here on the fox newsgroup. I want to allow access to members only so I can shut off anyone who is rude. I don't want to code this myself unless it's a last resort due to time constraints. Does anyone know of an off-the-shelf software that would acommplish this? The whole goal here is to create an atmosphere where members can voice their opinions about anything from the comfort of their own computer. I would also like to have a feature where I can routinely poll the membership to see how they feel on a variety of issues. This is a very high priority for me, so I greatly appreciate any feedback. Thanks in Advance! -- Brett_Slattery Tag: How to combine two tables with same fields together Tag: 187734
  - 6
    - Re: Install Problem with FPW26a Application Thank you Lee!!! After I read your response and answered it, I took a look at the Start Menu\Programs folder and sure enough, I had one entry that was 56 characters long. This entry was not too old but I can't say when it was installed. I truncated that one and tried my program setup again - It WORKED!! I also tried setup via the Start Menu Run command and it worked too! I sure don't understand what the Start Menu has to do with it if I don't use that folder but it makes a difference. This also explains why only one other (and myself) have reported this problem after years and installation by hundreds. Do you know the reason for this strange behavior? I sure would be interested in knowing. Many thanks again - it could have taken me years to stumble on that one - if ever. Ray Lee Mitchell <Leemi@online.microsoft.com> wrote: > Hi Ray: > > I have heard of this error when any menu option in the Start Menu > folder has a name greater than 49 characters in length. Do you have > any folders > in the Start menu that might meet this criteria? If so, the only > option is to decrease the length of the name. > > I hope this helps and have a Happy New Year! > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > Sincerely, > Microsoft FoxPro Technical Support > Lee Mitchell > > *-- VFP8 HAS ARRIVED!! --* > Read about all the new features of VFP8 here: > http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp > Purchase VFP8 here: > http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518 > > Keep an eye on the product lifecycle for Visual FoxPro here: > http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv > - VFP5 Mainstream Support retired June 30th, 2003 > - VFP6 Mainstream Support retires Sept. 30th, 2003 > >> I've got a real problem with a FPW2.6a program and I could use >> some big help on it! This is long but I don't know how to shorten >> it, sorry. > >> Here's the problem: >> I have a program that has existed for many years and is downloaded >> over the internet. There have been a number of upgrades made and >> is currently on version 4.1. The program has been installed by >> hundreds of different people and more times than that by me >> personally with no problems. Yesterday I got a message from a new >> user using WinXP. He said he could not install the program and >> got the following error message during install: "An error has >> occurred in your application / If you choose Ignore you should >> save your work in a new file / If you choose close, your >> application will terminate." The error window within the FPW >> install window is titled "DSHELL". > >> What I've done: >> I tried to install the program and I too got an error. On a >> Win98SE machine the error read similar indicating a problem with >> DSHELL. The "ignore" button does nothing. After using the >> "Close" button, the machine exhibits a "not enough memory" error >> if I try installing again without resetting the computer. I tried >> to install an older version of the same program and now get the >> same error (when I had installed from the same install files many >> times before). I re-setup the program within FPW26a and then >> tried another install. Got the same failure. > >> As of now, I can not install any version of the program. > >> I did a complete virus check on the machine and there is no virus. > >> I know that the install program's setup.lst file shows, under >> [Params] section, that DrvModName = DSHELL but I do not know the >> significance of it. > >> It seems to me that maybe one of the dlls that get installed by >> the FPW26a installer is bad and for some reason (?) replaced the >> one I had on my machine. This would have to be one of the old FPW >> era dlls since common ones would be dated much later and should >> not get replaced. I tried removing some some of these old dlls >> and replaced them with ones that came with FPW26a. Now I get a >> different error that "Bind time error. 'SPAWN' not found in >> specified library" before I can get to the original error. > >> Any help would be greatly appreciated! > >> Ray Tag: How to combine two tables with same fields together Tag: 187730
  - 7
    - Optional Parameter Hi, Can anyone tell me how to setup optional parameters in a method? Tag: How to combine two tables with same fields together Tag: 187724
  - 8
    - string to integer? Is there anyway to convert a field saved in a db as a text field into an integer? i have a field thats padded by 0's on the left so you have numbers like 0000345, but the way they are stored in our db is just by the number 3-45 (with a dash) i have the dash removed in the select statement, but i need to remove the padding zeros from the other one to compare them... normally you can do that with integer conversion... but foxpro doesn't seem to like converting string numbers to integers? any help would be nice.. thanks! Tag: How to combine two tables with same fields together Tag: 187702
  - 9
    - removeing char from string If i had a string like "3465-564576-3456-6" and i wanted all the dashes removed, how would you do that in foxpro? Tag: How to combine two tables with same fields together Tag: 187700
  - 10
    - VFPOLEDB returning "Cannot update the cursor" Hi all, (And sorry for the double post for any .NET group readers) I'm trying to write to a VFP table from a .NET program using OLE DB. It returns 'Cannot update the cursor "cursor", since it is read-only.' The table is not open by any other source at the time and it wasn't flagged as read-only in the OS. I'm pretty ignorant when getting into OLE DB. Is there a setting in the driver that could be causing it? If so, direction as to where to address it would be great! TIA, John Tag: How to combine two tables with same fields together Tag: 187694
  - 11
    - Tab Delim files with header import? If a file you are trying to import into a cursor is tab delimited and has a header column... how would you ignore the header column? im C++ we'd just read the next record, but since this is foxpro and things are diffrent, and im using APPEND FROM (fileName) DELIMITED WITH TAB as my statement... any suggestions? thanks Tag: How to combine two tables with same fields together Tag: 187689
  - 12
    - Is it possible to change HeaderHeight property in a grid if View property is 1? If View property is 1 (Change), the header is viewed vertically. I want to change the width of the header. Is it possible? TIA. Tag: How to combine two tables with same fields together Tag: 187687
  - 13
    - Visual foxpro executed file (.exe) if the executed file (.exe) was created in visual foxpro 7.0, is it possible to run it in visual foxpro 8.0? Tag: How to combine two tables with same fields together Tag: 187684
  - 14
    - compare two fox tables Dear All, I wanted to findout whether user made any changes in a fox table. Is there any function to do this ? Thanks in advance Jijo David Tag: How to combine two tables with same fields together Tag: 187680
  - 15
    - Install Problem with FPW26a Application I've got a real problem with a FPW2.6a program and I could use some big help on it! This is long but I don't know how to shorten it, sorry. Here's the problem: I have a program that has existed for many years and is downloaded over the internet. There have been a number of upgrades made and is currently on version 4.1. The program has been installed by hundreds of different people and more times than that by me personally with no problems. Yesterday I got a message from a new user using WinXP. He said he could not install the program and got the following error message during install: "An error has occurred in your application / If you choose Ignore you should save your work in a new file / If you choose close, your application will terminate." The error window within the FPW install window is titled "DSHELL". What I've done: I tried to install the program and I too got an error. On a Win98SE machine the error read similar indicating a problem with DSHELL. The "ignore" button does nothing. After using the "Close" button, the machine exhibits a "not enough memory" error if I try installing again without resetting the computer. I tried to install an older version of the same program and now get the same error (when I had installed from the same install files many times before). I re-setup the program within FPW26a and then tried another install. Got the same failure. As of now, I can not install any version of the program. I did a complete virus check on the machine and there is no virus. I know that the install program's setup.lst file shows, under [Params] section, that DrvModName = DSHELL but I do not know the significance of it. It seems to me that maybe one of the dlls that get installed by the FPW26a installer is bad and for some reason (?) replaced the one I had on my machine. This would have to be one of the old FPW era dlls since common ones would be dated much later and should not get replaced. I tried removing some some of these old dlls and replaced them with ones that came with FPW26a. Now I get a different error that "Bind time error. 'SPAWN' not found in specified library" before I can get to the original error. Any help would be greatly appreciated! Ray Tag: How to combine two tables with same fields together Tag: 187679
  - 16
    - how can I get the loginname of user? Dear All, I want to ask that how can I get the login name on the viusal foxpro? since I need to use GETOBJECT() function get the user's detail information from the domain. Thank you!! Happy new year! Nic Tag: How to combine two tables with same fields together Tag: 187665
  - 17
    - Newbie - Report Hi all, I would like to print this in report:- item Description of Goods Quantity 1 Apple 10 2 Banana 20 3 Orange 30 I just don't know how to print out the ITEM column, by writing up SQL statement properly. Many thanks. Regards, Wandy Tag: How to combine two tables with same fields together Tag: 187661
  - 18
    - CDX structure Hi All! I am looking for CDX structure with terms explanation. There are many CDX and IDX docs but I dont understand their terms like "exterior node" etc. They say CDX is "similar" to IDC but I cant find this similarity ! Tag: How to combine two tables with same fields together Tag: 187660
  - 19
    - Screen Font Easiest question of the day (I hope). When I do a "dir" or "list stru" from my VFP 8 command box, the font is too large. I have looked high and low and cannot find where to change it. Can someone tell me how to fix this nuisance? Thanks, Scott Tag: How to combine two tables with same fields together Tag: 187657
  - 20
    - creating check boxes programmatically Hi all, I've recently started working on a project using microsoft visual foxpro 8.0. Unfortunately i met with some problems creating checkboxes wif values retrieved from a database table. Any help is appreciated. Thanks Tag: How to combine two tables with same fields together Tag: 187656
  - 21
    - FoxPro Interop Okay, A foxpro programmer I am not, however...I wrote a class in vfp6. In this class I wrote a procedure that accepts three parameters. I compiled the dll. I wrote another app in VB6 that uses this class. Almost everything works. My only problem is with my parameters. I am trying to pass them by reference but I can't get it to work (and not sure that it will at all), does anyone have any thoughts on this? Could someone give me a template of how I would pass parameters by ref? I have seen the @ sign used, but I can't seem to get that to work...may be it's because I'm using vfp6... Thanks in advance. Tag: How to combine two tables with same fields together Tag: 187655
  - 22
    - Fox 5&6 page frame instabilities I am writing a program for a company that has a truly computer phobic CEO. Because of that, I used a page framew with 9 pages to make it appear as simple as possible. The menu bar was to be accessed only by a computer literate staffer. When most of the program was done, it started exhibiting instablities that I couldn't get rid of. I tried manually controlling data and control issues. When that didn't work, I tried using as many automatic program building wizards as possible. That didn't work either. I tried using a floating window above the page frame with a menu bar inside it, and that had limited sucess. I can find nothing on the limitations of the number of pages and controls allowed in a page frame. I don't know if Fox 8 will work, and I'm reluctant to buy it and go to all the work involved in upgrading the program and then not have it work. If anyone has knowledge of a possible work-around, or knows whether version 8 would allow that many pages and controls, please let me know. Jack Hunt Creative Systems Tag: How to combine two tables with same fields together Tag: 187654
  - 23
    - ADO and performance I'm working with an ADO connection via ODBC into a 1.3GB VFP table, and I'm finding it to be excruciatingly slow (don't ask why I'm doing it this way...). The recordset has about 5000 records in it. Doing a MoveFirst takes over 2 minutes. A query that retreives about 4700 records takes about 2 1/2 minutes. I'm wondering at this point if working via ADO is normally slow, and this is "normal" performance? Tag: How to combine two tables with same fields together Tag: 187645
  - 24
    - Create a report file for email Happy Holiday To You All, I need to be able to print my report in a format (may be .PDF format?)so I'll be able to email them to my customers. Can you please help me. Thanks a million in advance, Nancy Tag: How to combine two tables with same fields together Tag: 187634
  - 25
    - strange behavior in IDE for foxpro... Does anyone know what might be causeing this? Every time I go into a project and try to use the builder it says it cant be found... so i have to go reset the path to the builder each time the project loads... but it's not just the builder it doesn't remember the path to... there are a few others that get lost also... but when i make a brand new project, it knows where the builder is! only older projects from foxpro 6 are doing this.. (this is foxpro 7 right now) also, every time i run a form to test it, the controls toolbar (which i docked onto the toolbar spot on the top) gets undocked and moved back to a certin location (same place every time)... and the form window gets resized to smaller then maximized like i had it (the form designer window) it's getting kind of annoying and set as default in properties isn't helping much either... it just forgets the settings every time... any idea how to fix this? thanks -- ================================ Brian Henry The Reschini Group HTTP://www.reschini.com Tag: How to combine two tables with same fields together Tag: 187632

Hi,
I would like to ask how to combine two tables with same fields together.
Thanks a lot,
Ray

Re: How to combine two tables with same fields together by Eric

Eric
Mon Jan 05 00:28:36 CST 2004

Hello, Ray!
You wrote on Mon, 5 Jan 2004 13:17:45 +0800:

R> Hi,
R> I would like to ask how to combine two tables with same fields
R> together. Thanks a lot,
R> Ray

The easiest way is using the APPEND FROM command. See VFP help for details.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Top

Re: How to combine two tables with same fields together by Ray

Ray
Mon Jan 05 03:05:40 CST 2004

Thanks,
Ray
"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> ¦b¶l¥ó
news:OvKxnU10DHA.2972@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...
> Hello, Ray!
> You wrote on Mon, 5 Jan 2004 13:17:45 +0800:
>
> R> Hi,
> R> I would like to ask how to combine two tables with same fields
> R> together. Thanks a lot,
> R> Ray
>
> The easiest way is using the APPEND FROM command. See VFP help for
details.
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>

Top