Answer Questions

• brian_tsim Suggestion for VFP-MySQL Multiuser env.

  Hi all, I've just shifted from Foxpro tables to MySQL server based application. For a multiuser environment in VFP I used to have the temporary tables for the individual users in their own local machines. But in case of Mysql / oracle how to handle this situation The temporary table that I 'm speaking of are generated when I want to create some reports or perform some maintenance on tables. For example consider a scenario of producing a Sales analysis report. In VFP based application I created a local table say temp and put the data from invoice, invoice return and all related tables. then I manipulated the temp table to suit my reports. There was no problem in multiuser env. since each user created their own 'temp' table in thei ...Show All

• sanjeevm vpos value in frx files

  I'm trying to convert the vpos value (ex. 9479.833) in a report file to actual inches) so that I can give the actual label values for a check to a printer. When I look at the top value in design mode this value is denoted at .53 which I confirm. How is the vpos value converted to inches As I remember one report unit is 1/10000 inch. In the case of my sample value 9475.833 my inches value while I am in report design mode shows as .53in but if I divide the value shown by 10000, I get .9475 and thus my confusion. If I take the hpos value and divide by 10000, I match perfectly with the report design screen value but the vpos value must indicate something other than the v ...Show All

• Elad_23 Err 1957 "Error accessing printer spooler"

  Any thoughts on how to overcome this As far as I am aware the app (v9 SP1) is just trying to print to the standard windows printer. It's just at one site where its falling over. (They have an HP Deskjet of some sort which prints ok in their other (non-vfp) applications. Mike, I would try: -Uninstall printer -Install using the closest driver that ships with windows (not HP supplied) I also got this error in the following situation: Win98 machine with no local printers installed. set printer to getprinter() will cause this error. ...Show All

• mrleokarthik Wait Window "" timeout 0.01 and Sleep(10) in VFP-9

  At times my VFP processing requires *rest(s)* it seems. (report processing/printing, various functions, .BeforeRowColChange events, etc.) I've *discovered*: Wait Window "" timeout 0.01 && ... helps at times while the preferred: Windows API Sleep() routines && ...I've had NO success with API Sleep() declarations Any general or specific feedback concerning *rest(s)* in VFP-9 is appreciated. >> *Of course* the wait window itself *corrects* the problem: a red-light (.backcolor) *faithfully* appears before the yellow .backColor. As I said, the issue is one of timing. VFP attempts to optimize the screen updates (which are slow) by queuing events and handling them in 'idle' moments. The issue here is t ...Show All

• h3mp buffering, Rlock() and FLOCK()

  Hi; I think I don't understand the concept of buffering. Can someone explain the following behavior I have a form which uses opt. table buffering. While that form is open by a user, I manually rlock() one of the records. Then, I ask the user to change the same record. The change, including the =tableupdate() goes through fine. I try the same with FLOCK(), and the change still goes through fine. Shouldn't FLOCK prevent the user from comiting a change thanks. OK - let me explain again: User A opens up an application and goes into a form. The form has a table that is open in an optimistic table buffering. At the same time, user B (Which happens to be me) opens up VFP, and issues the following commands: us ...Show All

• devstuff reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle When you say: >DELETE FROM tabelle_1 WHERE nr IN(SELECT nr FROM this file in the directory) do you mean that nr is part of the filename or text inside the contents of the file first get the list of files from your directory into a dbf/cursor crea table xxx ; (tblnm c(8),delflag c(1)) && create a temp table to store table names and flag to store whether to b ...Show All

• Code-Master Grid sorting

  Hi; I have a grid which is populated with the results of a SQL query. I need to sort the grid depending on which column header the user clicks on. I have not done this ever and I was wondering which is the correct approach: - After I run the SQL query, run a series of 'index on' commands so I can use the indexes. - Run a secondary query on the results of the query to produce the proper order when user click a header. - Some other way - Which is probably the case :-) Thank you all. Does anyone here think that the query of a query solution is a good idea Hi Aleniko, Neither I've tried it... But I shall suggest you a approach. You can give it a ...Show All

• sgiannone Guidance Required for VFP - MSSQL upgradation...

  Hi all,         I've developed a VFP application in vers. 6.0. Now that the client wants the same with MS SQL / Oracle. Please someone tell me the list of atricles and other notes i've to go through..... I'm ok with SQL querries.... Please suggest me regarding the -Remote views, SPT's...... The application as a whole has about 2 GB of data in VFP..... It's a multi-user application....running on VFP 6.0 ./ WIn2000 Platform.  Thanks in advance... -Markish Markish, Even within VFP rlock() approach is not very good IMHO. Your application's needs would really shape it. Once I posted a sample code on universalthread demonstrating "rlock" for VFP/MSSQL table in asp.net ...Show All

• Becool Copy File Error in Visual FoxPro 7?

  When a COPY File Command is executed and a space is in either a folder name or a file name, the instruction is unable to handle it. I have tried a technique to put in " quote marks in the manner '"<path><filename>"' but then it gives me a syntax error. Is this a bug or am I entering the full path and filename wrongly If this is a known bug, is there a patch for it If not, how do later versions of VFP do with this "bug" Thanks Andy. I believe that I tried the solution you mentioned, but it failed to work. It may have been further impaired by the fact I was using macro variables for the path filename and I don 't believe the quotes got through to the final command The p ...Show All

• Xancholy Philadelphia VFP User Group--Wednesday, September 13

  The Philadelphia Visual FoxPro User Group will meet on Wednesday, September 13, 2006 at 7 PM. Location: Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025 Dinner at 6 PM at Rocky's in the shopping center across the street, for anyone interested. Speaker: Robert Pierce Robert Pierce is currently the Manager of Information Services and senior developer at Smooth-On Inc., a rubber and plastics manufacturing company located in Easton, PA. With 21 years of custom Fox programming experience; he has been a consultant, a contract programmer, and part of the TIW development team. Topic: Data Driven Interfaces This powerful technique gives the developer and end users many advantages ove ...Show All

• Gunnar Adler MSCHART AND VISUAL FOXPRO 9

  I am trying to use MSCHART with VFP9 and have some success until I want to set or change Legions, Titles, Colors etc. or to enter data into the second Y axis. Using any of the property / constant names only produces the message "Name Unknown". Any suggestions. collide wrote: i saw the samples which uses MSChart but is there a more easy way to create graphs in VFP i mean the simpliest way other than that :) because it looks difficult for me..thanks The white paper gives you 4 examples from which to choose. Pick one that you like No I didn't and that is why I said "try". I don't have VFP (nor any other thing including .Net framework) to test something (on this box). If you want to see working code, vis ...Show All

• Kris2006 Indispensable books for VFP-9 Users ?

  Having searched the web I've seen samples of excellent book and code-examples but am not sure which remains best for a mediocre (beginner-intermediate) VFP-9 programmer/enthusiast trapped in the boondocks of Albertville, AL. I am interested for artistic reasons … VFPX (which seems ahead of its time) seems promising in graphics for VFP-9, the rest of VFPx might be too advanced for me. I can't find but a very few VFP-9 books ( www.hentzenwerke.com ) that seem to apply to my level; Universal Thread and Fox-Advisor have been helpful but difficult to sift (for me) What monumental books do any of you conclude are inspiring / indispensable *favorites* (at my level) I've recently become spell-bound by samples of older bo ...Show All

• TheViewMaster No Connection Sting handle

  I cannot figure out why I cannot get a valid handle for a connection I am able to establish in Command Window as well as in a method. The question mark statement consistently returns -1 which means: no handle (error). OPEN DATABASE ("D:\vfp_Projects\Data\d_data\histdata.dbc") CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "Administrator" PASSWORD "" IF EMPTY (DBGETPROP ("Myconn","CONNECTION","ConnectString")) myUserID = 'Administrator' myPassword = "" STORE SQLSTRINGCONNECT ('dsn=MyFoxSQLNT;uid=myUserID;pwd=myPassword') TO gnConnHandle gnConnhandle ENDIF The connection is being established because otherwise I would have gotten an error at DB ...Show All

• tomohog Tables Relation

  Dear reader, I hope you can help me. I dont know how to relate two dbf free tables files. Table Sub (submenus Items belongs to) ID OWNERID USERNUMBER SHORTNAME LONGNAME EXCEPTIONS ITEM01 ITEM02 ITEM03 ITEM04 1000 0 1000 Entradas Entradas 0 1001 1002 1003 1004 1100 0 1100 Ensaladas Ensaladas 0 1101 1102 1103 1104 1200 0 1200 Sopas Sopas 0 1201 1202 1203 0 1300 0 1300 Cremas Cremas 0 1301 1302 1303 0 1400 0 1400 Ex tico Ex tico 0 1401 1402 1403 1404 1500 0 1500 Aviant\nCuisine Aviant Cuis ...Show All

• constm using amouseobj to determine current position.

  I'm trying to open up a form and position it right where the user clicked the mouse. I'm trying to use amouseobj to get the current position of the mouse but for some reason I'm having problems doing so. Can someone please give me an example of how to use amouseobj() Also, if there is a better way to do this, please let me know. Thanks. AMOUSEOBJ(ArrayName [, 1]) or you can use SYS(1270 [, nXCoord, nYCoord]) See: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/e3730f77-7138-4d79-8450-2f8cef726e63.asp   Tamar has a good article on Arrays that covers AMOUSEOBJ() http://www.tomorrowssolutionsllc.com/Materials/arrays.html ...Show All