Answer Questions

• sql_jr how to shutdown the OS without error

  good day to all. i use my Net monitoring system developed in VFP at my net cafe for almost a year now, and so far it works fine. But there is a little problem that although it don't bothered the user and me but it much better if it does not shows-up. When i shutdown the workstation or restart it from the server, before it will totally close there is sometimes that a VFP error message will pops-up, which will prompt to send the error to MS. How could i prevent such error as if there is still missing in my shutdown code, clear events, clear dll's, etc and etc they've all there already. it seems that the PC can't wait any longer to shutdown. Thanks for any help regarding this matter Thank you very much Alex & MarciaAkins for yo ...Show All

• FassaBortolo How can I check whether a cursor exists or not?

  That's the question. Thanks I'm not sure what do you mean, but I think a simple if used command should help. if used("curSomeCursor") wait "Cursor exists" wind endif Mmmh, it worked, that's weird because the first time I used "used" didn't work. ...Show All

• GDigrego SQL Server Express & Foxpro-populating SS from Foxpro

  I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastname) values ("Kareen","Abdul-Jabar")'. If I use: lcStr = ['INSERT INTO SAUTHORS (firstname,lastname) values ("] + m.firstname + [","] + m.lastname + [")'] lnResult= SQLEXEC (m.lnConn, m.lcStr) I get an error that says Invalid Syntax. Can someone steer me in the right direction I want ...Show All

• eginde Slow Report Peviews and Printing

  I have an application on VFP 8.0 After previewing the report (35 pages), when I send it to printing in takes 10-15 second pause between each page. It also takes a lot of time (about 8 seconds) to skip each page during preview mode. Had anybody experienced this problem I am running win XP Pro, VFP 8.0 and a P4 + HP Laserjet 1020 Thanks. I am using external report files, I mean the report files are not compiled into thje EXE, does it matters for speed If your printing is done through a network printer off of a server, make sure the server's print spool folder and the drive where that folder resides has plenty of free disk space.  I have found a couple of sites in the past where their print jobs were very slow and so ...Show All

• Kaltenberg VFP 9 Form wizard - grid problems...

  Hello, I'm attempting to be lazy and whip up a form for data enty. It's a one-to-many form with a parent and child table. I use the Wizard to set it up and when I run it and click on the grid (child table) the data in it disappears. Sometimes, if I tab into the grid from a text box it will work okay...but as soon as I try outside of VFP it disappears regardless of how I get to the grid. I have just recently installed VFP 9, along with SP 1 and am new to this version. Could I be missing some components or something else Help is much appreciated! Thanks pmitter wrote: Sometimes, if I tab into the grid from a text box it will work okay...but as soon as I try outside of VFP ...Show All

• h3mp Upgrade MfoxPlus program to Visual FoxPro

  I had an early verson of FoxPro and I remember that it would convert mfoxplus programs to foxpro. Now years later an old customer is tired of running the program on Windows 98 and has upgraded to XP and would like to upgrade to a program that will run networked on XP without lots of problems. Will the new Visual FoxPro convert old foxplus code If not was there a version of Visual FoxPro that had this ability. Any help will be appreciated................ Convert In a way, yes. Most of the code may run but it won't be pretty. This is the time for a rewrite. VFP is an object oriented, visual language. Very different paradigm from a very old DOS system. You should co ...Show All

• Mark Guenault Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. AndyKr thank you for your reply. I passed your suggestion plus another received in answer to my question to our systems administrator to test but without any luck. It very much looks as though an upgrade to version 9 is the only solution. dni thank you for your reply. I passed your suggestion plus another received i ...Show All

• JoseBarrientos How do i use the WHERE clause in remote database connection?

  After connecting to and oracle database i want to select specific records using the where clause as below gctype = 'A' gquery = '1' = SQLPREPARE(gnConnHandle, 'SELECT fssno,floc,fcurrent_address1,fcurrent_address2,; fhome_address,ferno,fquery_code,fdate_approved,fcap30,fbenefit_paid FROM cif_hist; WHERE ftran_type = gctype and fquery_code = gquery','MyCursor') = SQLEXEC(gnConnHandle) It gives me an error message "SQL statement parameter is required for non-prepared SQLEXEC() calls. Can someone help me Thank you very much. Everything is okay now. i'm really grateful. VFP6 :( Then you would need to do some other way (text, textmerge doesn't work well with memvars under VFP6). lcSQL = ; "S ...Show All

• Vipul211890 File is in use by another.

  When getting an error "File is in use by another" - Is there a way to trap what file is this I am using the sys(2018) but I don't get any info in there. Thx. Aleniko wrote: When getting an error "File is in use by another" - Is there a way to trap what file is this I am using the sys(2018) but I don't get any info in there. In what context are you seeing this error Question : in a application who opens all files in shared form , how can i manage a "clean up" of my tables , i mean i want to be able to use "pack" some how. How i can do that I get the error : "File access denied ...". What is the meaning of the following comman ...Show All

• mariogib Sys(2600) and Apps

  Sys(2600) is the way to send or retrieve a String from a memory Address. Passing the memory address to another application as a parameter, can we retrieve the string in memory sended by the first application I try it, but it doesn't work, I think the GlobalAlloc() doesn't work any more as Global but as Local - according to MS info) Does anyone know how to do it DaCosta11 Lets assume this: Open VFP9 and write this code: Declare Integer GlobalAlloc In Win32API Integer, Integer lcString ="VFP9 Rocks" + Chr(0) lnSize =Len(lcString) hMem =GlobalAlloc(0, lnSize) Sys(2600, hMem, lnSize, lcString) _ClipText =Str(hMem) the result in _Screen should be the lcString content including the Chr(0) Now, open a new VFP9 (dont close the ...Show All

• BonnieB Win 2K vs Win XP Pro SP2

  Hi, Just wondering if anyone has changed the development platform from Win 2K to Win XP SP2 Any problems encountered I've been working exclusively in XP Pro (SP2 now) since its inception. No problems. >>changed the development platform from Win 2K to Win XP SP2 Yes, I did this some time ago now, (when XP SP1 was released) and have not had any specific problems with VFP and XP. Everything seems to work just as expected. Changed from w2k to xp sp1, sp2 no problems with vfp7, vfp8, vfp 9. Yes I've changed from w2k to XP Pro, then SP1 and SP2. No problems. ...Show All

• MRDPrince Search in program

  I want to ask, if i have 2 tables, and if i need to find information that not exist, i need to grab one line data from first table, and other from other table, multiplicat them and after that i need to find value. ex. User want to find information of client wich both products off 200$, so i need to multiplicate records from table.products(price) and table.order(deal) . and compare them with user application. so how do i need to do it :) thnx im not really sure what your trying to do... i know what your trying to do is very simple because your just comparing fields but the way you are asking the problem is hard for me to understand. try explaining it better and i will be able to help you. ...Show All

• Jason Bolstad Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! I don't know why but this is all very confusing to me. This code: MCONNSTR="Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\FOX\TEST.xls;DefaultDir=c:\FOX;" nConn = sqlstringconnect(MCONNSTR) sqlexec(nconn, "select * from [sheet1$]", "CRSXLS") SELECT CRSXLS As supplied by Dave M. is fine, ...Show All

• Adam23 System time - synchronizing, displaying

  Hi experts. Does anybody know how to get the real time from internet. I want to have the real updated time in my application. Second task is to changing the system time. How can I do that Third task is how to display time in form for example in textbox. I know the way with timer but if there is any other way I will be glad to know it. But the consequence is in the order I have written. Mainly the getting real time from internet. Thanks And how can I change the time zone of the source(currentTime.getCurrentTime) I am from Slovakia and the time zone here is GMT +01:00 and the Daylight saving is on... Thanks a lot... And how can I cange the time zone of the source, I ...Show All

• alex china Interface in Polish

  Hi everyone: I'm developing an multilanguage application. Till now, we were working with: English, German, French, Italian, Spanish, Portuguese (both, also Brasilian Portuguese) and Romanian. Everything runs well, but I can't manage with some Polish characters. The captions are stored in tables DBF, which were populated from Excel files. As soon as information is imported from Excel to VFP DBF file, the Polish character (something between e and c) is substituted by e. What should I do Do you have any advice for me Thank you !! -- Regards, Ana Madrid, Spain www.amby.net Hi David: The characters are I was trying with several font types including "Polish". I'm using ...Show All