Answer Questions

• TonyTech06 Printing from com dll

  I'm trying to print a report from a Com dll file. I keep getting the OLE IDispatch exception code 2031: User-interface operation not allowed at this time. Is there any way to make this work without building to an .exe file I'm using VFP 9 thanks in advance -m If you are calling from a fox web mtdll(web app or web service), then you'd need to use a work around since you can not issue a REPORT FORM from an mtdll. The workaround is to createobject an .EXE COM server from your fox mtdll and call a method from it that has the REPORT FROM in it... Thanks for your reply, Andy. After your reply we made a getReport( @filefrx, @filefrt, @xml ) return nCounter It runs the query in the dll an ...Show All

• djbjmb Report Designer Beginner

  Hi everybody: I am new in vfp 9.0 and i am working with reports. I have created a simple report with the Report Designer, with the option blank report; I'm using a table with 4 records and 2 columns. When i choose report preview i get the message "No table is open in the current work area", and it selects work area 2, wich i don't know why. Also i have set reportbehavior to 90. Does anybody knows what i am not doing. thanks for your help grot Where is that "blank report" option I really don't know if such an option exists somewhere, I'm old fashioned and do it from command window: use myTable modify report myNewReport If you can tell the steps you take th ...Show All

• khaleel MySQL and VFP

  Hi experts. I have a MySQL database. I operate with them using syntax like SQL(sqlhandle, "select * from...") I copy them into cursor and than operate with a cursor. Is there a simplier way how to work with them Thanks in an advice. "Is this code useful for MySQL database " Yes, why not. Only change sql and connection string. "Which one is faster " Comparing what MSSQL and MySQL I don't know. Never used mySQL. "The code written above or everytime use SQLEXEC() " WHat do you mean Yes I wrote it there. No I don't use SQLExec() everytime. I choose depending on my needs between RV,SPT,ADO,CA... "I want it for my Chat, and I want to actuate ...Show All

• Csaba Vegso impersonateloggedonuser and Getfil()

  Iam running VFP 9 with SP1 under windows 2k. In order to protect my database/table files on a network I have created a single user who has access to the folder where the files are contained. This is the only user with access to the folder. When an individual on the network runs the application the application logs on as that user and has access to the database files...the code goes like this.... #define LOGON32_PROVIDER_DEFAULT 0 #define LOGON32_PROVIDER_WINNT50 3 #define LOGON32_PROVIDER_WINNT40 2 #define LOGON32_PROVIDER_WINNT35 1 #define LOGON32_LOGON_INTERACTIVE 2 #define LOGON32_LOGON_NETWORK 3 #define LOGON32_LOGON_BATCH 4 #define LOGON32_LOGON_SERVICE 5 #define LOGON32_LOGON_UNLOCK 7 DECLARE ...Show All

• bluebx32 First try at updatable views - Help!

  OK - So I'm trying updatable views now. I have a table with a few fields but there is no primary key. I've created an updatable view, and I'm getting some update conflict errors. I was wondering what's the proper way of doing this: Do I need to have a primary key in the table Should I create an autoincrementing field for that purpose Thx. >> Do I need to have a primary key in the table Absolutely! However it need not be a single column, nor does it have to be an autoincrementing integer. You can define your primary key as any combination of fields that uniquely identifies a record within a table. The easiest, and best (for lots of reasons) way it to use a "surrogate&q ...Show All

• MParkhouse Safe Select Doubt

  Hello I was trying to use Safe Select, and it doesn' t work, look at the following: * This is the working cursor SELECT code FROM product WHERE 0 = 1 INTO CURSOR tmpProduct * This is the real query SELECT * FROM product WHERE code=7 INTO CURSOR curdummy * Clear the working cursor and append the results of curdummy SELECT tmpProduct ZAP IN tmpProduct APPEND FROM DBF("curdummy") USE IN curdummy Anyone should expect a tmpProduct table filled only with products with a code of 7, but in fact the result is a tmpProduct table filled with all the records in the PRODUCT table. I inserted a BROWSE after I populated the curdummy cursor to see what was happening and it showed the desired results, only prod ...Show All

• DSent Multithreading in Vfp9

  Hi *.* How can i make real multrithreading application in vfp9 Thanks. Check out Calvin's blog :- http://blogs.msdn.com/calvin_hsia/archive/2006/05/23/605465.aspx HTH, Robbo. VFP doesn't really do real multithreading. It does Appartment Model Threading running under MTS or COM+ in Windows2000/2003.   See: http://fox.wikis.com/wc.dll Wiki~MultiThreadedVFP http://fox.wikis.com/wc.dll Wiki~MultiThreadedDLL   .NET Interop for Visual FoxPro Applications: http://www.west-wind.com//presentations/VfpDotNetInterop/vfpDotNetInterop.htm   ...Show All

• WeiY a newbie's question: how to mark columns in 2 databases with same values

  Guys, I'm a newbie of foxpro and I'm bad in English. I'm using Visual Foxpro6.0. Now I have two databases A and B with three same fields: id, lac, cell. I want to mark the the columns in these 2 databases with the same values of id, lac, cell. What's the command to do that Thanks a lot.   Alen Add a Field to the second table called "flag". UPDATE table1 SET MARK='Y' WHERE id+lac+cell IN (SELECT id+lac+cell FROM table2) I think this is what you are looking for… But I don’t see how this makes it easier for “Next time”. Why not Just Select what you need when you need it Dave M. what do you mean by " mark the the columns" ...Show All

• Lj47 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 Madix_t wrote: Good morning to all, i try t ...Show All

• A. Dachauer Visual FOXPRO ODBC Drivers for windows Vista

  Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos Just don't let any of your users run a 64-bit version of either WindowsXP or Vista. 32-bit ODBC and OLEDB drivers are not visible or usable by 64-bit applications. Thanks for the head's up! MD We are in same situation...I'm trying to view inside VFPODBC.MSI with ORCA to learn how can i install it "manually" but is hard for me ! Can anyone help us I ran into the same problem and figured out a workaround. I tried to install the current 6.0 version of the VFPODB ...Show All

• Chris Beiter - MSFT CursorAdapters and ConnectBusy

  Hey all. I was doing some work with CursorAdapters and SQL Server and ran into the dreaded ConnectBusy issue. This was caused by having an adapter open where I guess all the data hadn't yet been pulled down so while it did a SCAN ENDSCAN with some updates, it kept coming back saying ConnectBusy and it felt like an endless loop. I got around the problem by putting in some code to ensure I could go to the top of the file and the bottom of the file and then reran my scan loop. But I know there's an easier way. What are some of you doing to get around this I know about a few of the approaches but I know there must be some other better ones around there. Thanks Is it SQL2000 Then you could workaround by multiple connections or ADO (whic ...Show All

• Bart371 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 Some delays are normalwhen pre-view a reportdepending on computer hardware configuration, but printing should woow without delays between pages. You may check in report data environment to be sure you have only data you need for print. You may check to have the latest hp dr ...Show All

• dgolds naming a file with timestamp

  hi, i want to export to excel or export a text file including timestamp in the name. plz help. USE mytable * prepare or filter or create a cursor from a query or view with the records to export lcFilename = "MyFile_"+Strtran(Strtran(TTOC(DATETIME())," ","_"),":","") COPY TO (lcFilename) TYPE XL5 Another way: use myTable copy to (alias()+'_'+ttoc(datetime(),1)+'.csv') type csv ...Show All

• Russ Harding 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

• pkazaria VFP TIMER MEMORY PROBLEM

  Hi All, Our product is a 24/7 Hospital product and i face a critical issue in Timer control. The below code is a small example of my process, i created an exe of this code and this runs as a process in the task manager. The issue is this eats up memory consistently in time intervals. if this exe is ran for days the memory is used is like in MBs and slowing down the PC's performance. TimerCtrl() procedure TimerCtrl LOCAL poTim poTim = createobject ( "iTimer") poTim. interval = 1000 poTim. enabled = .t. read events endproc *========================================================================================================================= define class iTimer as timer fun ...Show All