Visual Foxpro and MS Sql Server

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
    - Report to file - suppressing blank lines? On one machine in our office when we run a report to a file, blank lines seem to be getting suppressed so that the page footer appears up beside the detail line with no gap. All the other machines are fine so I presume it must be a windows/printer setting. Can anyone give us a clue what we should look at?:) Thanks Bernie Tag: Visual Foxpro and MS Sql Server Tag: 187853
  - 2
    - Conversion of *.Text file to *.dbf File Dear adviser I want to Convert Content of *.Txt File to *.dbf file can u help me in this regards, Thanks & Regd, Pandey G.D. my mail id is : gdpandey@hngil.com Tag: Visual Foxpro and MS Sql Server Tag: 187851
  - 3
    - api vfp6.0 how do we create api ? i need lets say to give access to another software to create a customer to my software thanks George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/6/2003 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Visual Foxpro and MS Sql Server Tag: 187850
  - 4
    - How to get and use large file sizes in VFP8 and GetFileSizeEx() I am writing a program that must list and manipulate a large file filesise. In the past I have used the Adir() or api calls of FindFirst and FindNext to retrieve the information. Now, I have run into a problem for the first time. Since I need to list in a table field, large numbers that exceed the capacity of a 4 byte integer. When I test using large > 4 gig, ".avi" file, the values obtained by all the functions I have tried are incorrect, showing - 2 gig or some other incorrect value. I know this is because the number exceeds the storage type capacity. I have used 8 byte doubles but the routine I have still will not work. I have tried using the following API call in Kernel32 GetFileSizeEx BOOL GetFileSizeEx( HANDLE hFile, PLARGE_INTEGER lpFileSize ); Parameters hFile [in] Handle to the file whose size is to be returned. The handle must have been created with either the GENERIC_READ or GENERIC_WRITE access right. For more information, see File Security and Access Rights. lpFileSize [out] Pointer to a LARGE_INTEGER structure that receives the file size. Return Values If the function succeeds, the return value is nonzero. But I cannot get it to work in either VFP8 or in a C DLL I wrote. Can anyone help with a routine to get these large files sizes into a program. There must be a way since many commercial programs do this. Any and all help appreciated. Tag: Visual Foxpro and MS Sql Server Tag: 187847
  - 5
    - How to combine two tables with same fields together Hi, I would like to ask how to combine two tables with same fields together. Thanks a lot, Ray Tag: Visual Foxpro and MS Sql Server Tag: 187843
  - 6
    - 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: Visual Foxpro and MS Sql Server Tag: 187837
  - 7
    - 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: Visual Foxpro and MS Sql Server Tag: 187836
  - 8
    - 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: Visual Foxpro and MS Sql Server Tag: 187835
  - 9
    - 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: Visual Foxpro and MS Sql Server Tag: 187832
  - 10
    - .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: Visual Foxpro and MS Sql Server Tag: 187829
  - 11
    - 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: Visual Foxpro and MS Sql Server Tag: 187825
  - 12
    - 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: Visual Foxpro and MS Sql Server Tag: 187823
  - 13
    - 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: Visual Foxpro and MS Sql Server Tag: 187820
  - 14
    - 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: Visual Foxpro and MS Sql Server Tag: 187814
  - 15
    - 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: Visual Foxpro and MS Sql Server Tag: 187810
  - 16
    - 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: Visual Foxpro and MS Sql Server Tag: 187806
  - 17
    - 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: Visual Foxpro and MS Sql Server Tag: 187805
  - 18
    - 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: Visual Foxpro and MS Sql Server Tag: 187801
  - 19
    - 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: Visual Foxpro and MS Sql Server Tag: 187796
  - 20
    - 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: Visual Foxpro and MS Sql Server Tag: 187795
  - 21
    - 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: Visual Foxpro and MS Sql Server Tag: 187793
  - 22
    - 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: Visual Foxpro and MS Sql Server Tag: 187787
  - 23
    - 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: Visual Foxpro and MS Sql Server Tag: 187782
  - 24
    - 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: Visual Foxpro and MS Sql Server Tag: 187781
  - 25
    - 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: Visual Foxpro and MS Sql Server Tag: 187778
- Next
  - 1
    - 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: Visual Foxpro and MS Sql Server Tag: 187777
  - 2
    - 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: Visual Foxpro and MS Sql Server Tag: 187776
  - 3
    - 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: Visual Foxpro and MS Sql Server Tag: 187760
  - 4
    - 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: Visual Foxpro and MS Sql Server Tag: 187757
  - 5
    - 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: Visual Foxpro and MS Sql Server Tag: 187753
  - 6
    - 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: Visual Foxpro and MS Sql Server Tag: 187749
  - 7
    - 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: Visual Foxpro and MS Sql Server Tag: 187748
  - 8
    - 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: Visual Foxpro and MS Sql Server Tag: 187743
  - 9
    - 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: Visual Foxpro and MS Sql Server Tag: 187742
  - 10
    - 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: Visual Foxpro and MS Sql Server Tag: 187734
  - 11
    - 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: Visual Foxpro and MS Sql Server Tag: 187730
  - 12
    - Optional Parameter Hi, Can anyone tell me how to setup optional parameters in a method? Tag: Visual Foxpro and MS Sql Server Tag: 187724
  - 13
    - 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: Visual Foxpro and MS Sql Server Tag: 187702
  - 14
    - 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: Visual Foxpro and MS Sql Server Tag: 187700
  - 15
    - 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: Visual Foxpro and MS Sql Server Tag: 187694
  - 16
    - 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: Visual Foxpro and MS Sql Server Tag: 187689
  - 17
    - 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: Visual Foxpro and MS Sql Server Tag: 187687
  - 18
    - 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: Visual Foxpro and MS Sql Server Tag: 187684
  - 19
    - 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: Visual Foxpro and MS Sql Server Tag: 187680
  - 20
    - 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: Visual Foxpro and MS Sql Server Tag: 187679
  - 21
    - 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: Visual Foxpro and MS Sql Server Tag: 187665
  - 22
    - 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: Visual Foxpro and MS Sql Server Tag: 187661
  - 23
    - 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: Visual Foxpro and MS Sql Server Tag: 187660
  - 24
    - 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: Visual Foxpro and MS Sql Server Tag: 187657
  - 25
    - 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: Visual Foxpro and MS Sql Server Tag: 187656

Can Visual Foxpro and MS Sql Server exist on the same
server without problems?

Re: Visual Foxpro and MS Sql Server by Eric

Eric
Mon Jan 05 09:26:44 CST 2004

Hello, Pat!
You wrote on Mon, 5 Jan 2004 07:03:23 -0800:

PL> Can Visual Foxpro and MS Sql Server exist on the same
PL> server without problems?

Yes.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Top

Re: Visual Foxpro and MS Sql Server by Fred

Fred
Mon Jan 05 09:32:58 CST 2004

Absolutely. As VFP is a file based system, and SQL Server is client/server,
there's no conflict.

Fred
Microsoft Visual FoxPro MVP

"Pat L" <pat.lyons@huntington.com> wrote in message
news:048401c3d39d$10a65bd0$a001280a@phx.gbl...
> Can Visual Foxpro and MS Sql Server exist on the same
> server without problems?

Top