DBSETPROP - IdleTimeout documentation error?

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
    - strange behaviour - MODIFY FILE VFP8 SP1 I have an error handling routine I would like to popup a box that the user can type into to say what they were doing at the time of the error. The file is then emailed to us. When the MODIFY FILE command finishes I get this message "Session number is invalid" repeated many times CANCEL IGNORE & HELP buttons are available, cancel fixes the problem and the email is generated. cReasonFile = TRANSFORM( INT(rand()*10^8) ) + ".txt" STRTOFILE(CRLF + CRLF + CRLF + "[Please include a brief description of how the error occurred]", cReasonFile) MODIFY FILE (cReasonFile) *** Seems to occur here after the Modify completes but before the fileToStr() executes. cReason = FILETOSTR(cReasonFile) ERASE (cReasonFile) If I use the debugger to step through the code the problem doesn't occur. The only way I have been able to determine where the error occurs is through "wait window ..." Any ideas - I am stumped, it could be the error being reported is wrong. Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225867
  - 2
    - SQL result difference between VFP8 and VFP9 CREATE CURSOR cur1 (field1 c(1) NULL) INSERT into cur1 VALUES (.Null.) SELECT field1 as field2, field1 from cur1 INTO CURSOR cur2 VFP 8 shows field2 - blank field1 - .Null. VFP9 shows field2 - .Null. field1 - .Null. Any setting can fix it? Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225865
  - 3
    - Using Setup Wizard 6.0 Using Setup Wizard (VFp 6.0) how do i create a Desktop icon to run my application and also to place it on the Start Menu (i.e Start...>Programs...> MyApp). plz help. Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225863
  - 4
    - problem with Fsize Fsize() returns an error "File does not exist" for hidden files Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225861
  - 5
    - Add money to your Paypal account with OPRAH Hlt8* Read this message until the end, and you will find out how the money flows in easy !!!!. Follow the steps and it WILL work. Trust me !!!!!. It's NOT illegal and it is NOT a scam !!!!!. PROVEN ON OPRAH! Reported in the Wall Street Journal!!!! The only thing you need is : - E-MAIL ACCOUNT - PREMIER (FREE) or BUSINESS PAYPAL ACCOUNT - $6 on this account (The only investment) - 30 minutes of your time There is no limit on how much money you can recieve, and you haven't got anything to lose with this Business program. I will explain how it works !!!!!. Follow these 4 easy steps and it WILL work !!!!!. STEP 1 : SIGN UP FOR A FREE PAYPAL ACCOUNT !!!!!. Paypal is a free and safe way to pay and receive money on the Internet. Creating a account is as easy as creating a MSN account. Copy and paste the next line in your Internet browser and sign up. HTTP://WWW.PAYPAL.COM Be sure to sign up for a FREE Premier or Business account and not for a Personal account. You cannot receive CREDITCARD payments with a Personal account and we can't have that. Do we !!!!!. STEP 2 : SENT $6 TO YOUR PAYPAL ACCOUNT This is your only investment to receive the money with ease. With your Paypal account, send $1 to each e-mailadres listed below. !!!!! IMPORTANT !!!!! Be sure to use this SUBJECT : *PLEASE PUT ME ON YOUR EMAIL LIST* when you send the money. 1) martine@pilote.net 2) dexxatol@netcourrier.com 3) armygirl8568@hotmail.com 4) comjii@starband.net 5) sinnek@bellsouth.net 6) nsi@nelasat.com STEP 3 : PUT YOUR E-MAIL ADDRESS ON THE BOTTOM OF THE LIST After you have send $1 to each e-mail address, put your e-mail address on the 6th place. Remove e-mail address number 1, and move each e-mail address 1 step up the ladder. !!!!! IMPORTANT !!!!! BE SURE THAT THE E-MAIL ADDRESS YOU USE IS THE SAME AS YOU USED TO SIGN UP AT PAYPAL. Remember that this is LEGAL. You are creating a service : an e-mail servicelist. STEP 4 : UPLOAD OR COPY THIS MESSAGE TO NEWSGROUPS, FORUMS ETC AND EMAIL IT TO ALL YOUR FRIENDS! There are 32,000 newsgroups. Upload or copy this message to at least 200 newsgroups or forums etc, but ........ remember that the more your upload the more people will see your message and the MORE MONEY WILL FLOW IN. How to upload to newsgroups and forums? : After you have followed step 1,2,3 and 4, save this message (and copy so you can use it again). Use your Internet browser and Outlook Express or another newsreader and try to find FORUMS, NEWSGROUPS, BULLETIN BOARDS, DISCUSSION GROUPS, CHAT SITES and ONLINE COMMUNITIES. Use GOOGLE or use a NEWSERVER. Use every option to post this message. Download PostXpert to send 1 message to more NEWSGROUPS at the same time. !!!!! REMEMBER !!!!! The more you post this message the more MONEY WILL FLOW IN. Why does this Business program work so well !!!!!. Lets asume that from the 200 (or more) messages that you have posted, only 5 people respond, you will have your $6 back that you have invested. Those 5 people will each send at least 200 messages with your e-mailadres on number 4. That's 6 x 6 x $1 = $36. The next 25 people will also send 200 messages with your adres on number 3. That's 36 x 6 x $1 = $216. The next 216 people also send 200 messages with your name on number 2. That's 216 x 6 x $1 = $1296!. Those 1296 people again also send 200 messages with your name on number 1. That will give us a total of 1296 x 6 x $1 = $7,776. Now the last tier! 7776 x 6 x $1 = $46,656!!!!!! This is only a EXAMPLE with 6 reactions. You WILL get MORE responses than that. Remember that most newsservers will leave the posted messages on there servers for about 2 weeks. If you will post your message again, it WILL again start from the beginning. So you can repeat this over and over again. Everyday MILLIONS of people are ONLINE and reading these messages, JUST LIKE YOU RIGHT NOW. I also was sceptical in the beginning and have read a lot of these messages. I also thought that it was bullshit. Until I thought : What the hell!, only $6. What's $6 and a couple of minutes of my time to solve my money problems. !!!!! REMEMBER !!!!! Follow every step, and IT WILL WORK, TRUST ME. !!!!! !!!!! BEST WISHES AND GOOD LUCK !!!!! w)O>+;)<9UVS;F>qaGL<Uq#v`V6(F]- rM;$g+!4IIQ*827?H4 Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225860
  - 6
    - Who has file open in Netware Hi, I need to know who as a particular file open. The file is on a Netware server and it's possible that several users have the file open at the same time (not exclusively of course). Gplib used to be great for this but AFAICS there is no version of gplib for VFP. Any ideas how to do this? Thanks, Frank Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225855
  - 7
    - Usability question? Hi, I'm developing multiple projects in VFP 9.0 and I'm wondering if it is possible to have a shortcut on my desktop that launches a specific project in the development environment? That way I could have a shortcut to each project that would have the correct startup folder and all. Does that make sense? Is it possible? How do you handle developing multiple projects on the same system? Thanks in advanced, Linn Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225851
  - 8
    - print with word97 I have an exe I think was originally created in vfp 5 , has been upgraded to 8 and then to 9. It creates a word document and populates it with variables created in same exe. The problem is it will only print correctly if word 97 is the only version of word on the computer running it. The part that doesn't print properly is a variable that uses chr(13)+chr(10). The newer versions of word do not have the carriage return . Only a space. I don't know what to look for ? thanks sherry Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225843
  - 9
    - Connection Handle Disconnect? This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6BFE4.B675A5D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I am creating a connection to MySQL with the code below and using it in = my CursorAdapter classes. lnConnectionHandle =3D SQLSTRINGCONNECT(lcConnectionString,.T.) Testing the application, I noticed that if I left one of my forms open = without any user activity for some period of time the connection gets = lost. What am I missing here? --=20 Edhy ------=_NextPart_000_0006_01C6BFE4.B675A5D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am creating a connection to MySQL = with the code=20 below and using it in my CursorAdapter classes.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2> <P>lnConnectionHandle =3D </FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20 size=3D2>(lcConnectionString,.T.)</P></FONT></DIV><FONT face=3DArial = size=3D2> <DIV>Testing the application, I noticed that if I left one of my forms = open=20 without any user activity for some period of time the connection gets=20 lost.</DIV> <DIV> </DIV> <DIV>What am I missing here?</DIV> <DIV><BR>-- <BR>Edhy</DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C6BFE4.B675A5D0-- Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225825
  - 10
    - How to import data from text file created from List Memory or Obje I want to import data from text files created from List Memory or List Object in VFP SP1. Is there any tools available for such import? Thanks Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225821
  - 11
    - VFP How do I determine table buffering setting. I want to be able to determine if cursorsetprop has been used to set buffering to something besides 1 for a free table. How do I do that? Help says you can find out by using cursorsetprop but doesn't tell how. Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225812
  - 12
    - Case studies in VFP Trying to submit a case study to MS, The Case study is for a 80GB 100% pure VFP 9 application. The site is not very helpful. Anybody know the procedure? Thanks Mohammed Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225799
  - 13
    - Clipper to VFP Anybody done this? What should I be aware of? Is it easy? Used to use Clipper as a compiler for dBase, did some programming in it when they broke away, Lost track of it over the years. Any and all information, Tips etc would be greatly appreciated. Thanks Mohammed Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225798
  - 14
    - The buffer overrun problem I encounted. It's the projecthook class. If I unhooked it, nothing would go wrong. If I ever tried to hook it up again, it would keep crashing even if you unhooked it after a failed compile. It seemed that the project builder would remember something that could bring about the crash. I believe my codes in projecthook.beforebuild and projecthook.afterbuild are clean and simple (mainly about hacking the report forms). Even if I just added some comments into these 2 events, the compile would still crash. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 12:22:01 up 5 days 17:18 0 users load average: 1.11 1.10 1.07 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225794
  - 15
    - Indexing a table on multiple fields with a date field in descending order I have a table with the following fields: id, date, testrecord. What I want to do is to order the table so that the records are ordered as follows: id by date by testrecord. I want id to be in ascending order, but date and testrecord in descending order. I created an index file called testdata with the expression: id+dtoc(date,1)+testrecord. Id and testrecord are character fields.This index file will sort in ascending order. My question is: what do I need to do to get the table sorted as I want it - that is id in ascending order, but date and testrecord in descending order? Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225790
  - 16
    - If I was to submit the test case Could I request M$ to sign an Non-Disclosure Agreemnt? :) Ok, I knew our stuffs aren't that mission-critical, but ....it's still my company's property. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 22:12:01 up 5 days 3:08 0 users load average: 1.02 1.03 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225786
  - 17
    - Winsock Control Help Thanks in advance for the help. I'm trying to build messaging into my app using the Winsock control and there is something that I don't quite understand. I need each instance of the app to act as both a client and a server so that it can receive messages from anywhere and so that it can send messages to anywhere. Do I need two controls? Do I listen and send on different ports? Has anyone ever built this type of app using this control? Thanks, Jeff Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225769
  - 18
    - Confused by sample code Hello and thanks for the help. I am looking at some sample code which works but there is an element of the syntax which is confusing. The code is: ThisForm.tcpServer.Object.LocalPort = 1001 ThisForm.tcpServer.Object.Listen where tcpServer refers to an instance of the Winsock control. Why is the .Object in this code? What is the difference between Thisform.tcpServer.Object.LocalPort and Thisform.TcpServer.LocalPort? Thanks again, Jeff Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225764
  - 19
    - Append general error Just trying to append a .jpg file and get an error I haven't had before. When using Append general photofield from temp.jpg I get "OLE error code 0x80070002. The system cannot find the file specified" Is there something wrong with my VFP9 installation? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225758
  - 20
    - Sending Control G to serial port In the code below I want to send CTRL G as the output. How do I do it or what is the code I need to enter. ***Program code*** PUBLIC ComForm ComForm = CREATEOBJECT('Form') ComForm.AddObject("Testcom","Olecontrol","MSCOMMLib.MSComm") ComForm.Testcom.CommPort = 2 && Use Comm2, The second Serial Port. ComForm.Testcom.Settings = "14400,N,8,1" && 14.4 Kbaud, No Parity, && 8 data Bits, 1 Stop Bit ComForm.Testcom.PortOpen = .T. ComForm.Testcom.Output = "ATDT555-1234" + chr(13) && Dialing the number * The chr(13) is needed to complete the modem command sequence ComForm.Testcom.PortOpen = .F. ***** End Code ***** Rusty Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225751
  - 21
    - TIF Files I have been using the kodak image viewer to open TIF files from my foxpro applications and it has been giving me memory errors since the last patch to Windows XP. Kodak image viewer is no longer supported. I was wondering if anyone else had another view they were working with. I have Adobe 7 but have not figured out how to initiate the program from within Foxpro. Any ideas? Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225745
  - 22
    - Converting Tabs to Spaces Does anyone know of command to convert Tabs into Spaces? of course a STRT will do the trick, except for the tabs that are less than the characters specified in the STRT. There is a VB command which I've seen referenced although I don't know if it will address the problem above. Edit.ConvertTabsToSpaces -- Thank You, Louis Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225744
  - 23
    - Need URGENT help with interactivechange with 2 combo boxes I am unable to change selection in 1st combo box when I try to clear the value of the 2nd combo box in the interactivechange area. Here is a little better explanation: I have 2 combo boxes on my form. Both combo boxes get populated using a select statement. Everything worked fine until I decided that I want to clear the value of the second combo box if the first one changes to force the user to make a new selection so I put this in the first combo box in the interactivechange event: thisform.cmbBox2.value = "" Now when you try to change the selection in the 1st combo box, the 2nd combo box does get cleared, but the first combo box doesn't change like it is supposed to. When I remove this line from the interactivechange event you can change the 1st combo box and the new selection appears. What am I missing? Is there another way to force them to make new selections in corresponding comboboxes when one changes the primary one? Thanks in advance for any help you can give me. Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225741
  - 24
    - Damaged/Corrupted DBF I have a corrupted .dbf file that can not be opened. What are my best options for getting this file repaired? The file does not have a .fpt associated with it. I know there are many utilities that can be purchased, but which one. I can't believe Microsoft hasn't included a utility to repair damaged files within VFP. I don't like the thought of paying $199 for a utility that I almost never need. I have this one client that seems to come up with a damaged file every six months or so. Any clues of why this is happening? They are running the application off of a Citrix server, meaning it is accessed via Citrix and actually loaded on the Citrix server. I have many apps that have been running for years and years without any corruption? All my apps are running on file servers? VFP9 / Windows XP Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225738
  - 25
    - Speaking of code generator using Foxpro... Mr. Ed Leafe didn't use Foxpro to generate python codes for his Dabo Framwork as well.. :) I wondered whether Dabo could generate PHP code.... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 21:18:01 up 3 days 2:14 0 users load average: 1.01 1.02 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225734
- Next
  - 1
    - How to get the complextype data return from a web services? Hi I am actually testing how to use web services using VFP8. I have written a sample code (see below) to consume the web service on the link below: http://www.webservicex.net/WS/WSDetails.aspx?CATID=12&WSID=64 --------------------------------------------------------------------------------------------------------- LOCAL oWS AS "XML Web Service" LOCAL loGeoIP TRY oWS = CREATEOBJECT("MSSOAP.SoapClient") oWS.MSSoapInit("http://www.webservicex.net/geoipservice.asmx?WSDL") loGeoIP = oWS.GetGeoIPContext() CATCH TO oErr MESSAGEBOX(oErr.Message) ENDTRY IF VARTYPE(oWS) = "O" RELEASE oWS ENDIF --------------------------------------------------------------------------------------------------------- The method GetGeoIPContext() return a complextype GeoIP. Below is the GeoIP extract portion from the WSDL file. - <s:complexType name="GeoIP"> - <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="ReturnCode" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="IP" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="ReturnCodeDetails" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="CountryName" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="CountryCode" type="s:string" /> </s:sequence> </s:complexType> Does anyone know how to extract the complextype data in VFP8? Appreciate your help. Tham Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225720
  - 2
    - How to determine the input method for the textbox control? Hi I have a PC with a barcode scanner and keyboard attached to its PS/2 plug using the Y cable. In my VFP8 application, I want to control the type of input method for a textbox control in a form. That means that I want the data to be input to a textbox control ONLY from the barcode scanner, NOT from the keyboard. Is there a way to determine or control the input method for textbox control? Appreciate your help. Tham Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225718
  - 3
    - License If I bought Visual Foxpro via Amazon.com from Hong Kong, is the license valid? Not many shops in Hong Kong sell VFP... -- SoftMedia Technology Co., Ltd. Website: http://www.softmedia.hk Tel: (852)2743 4228 * TryEasy Accounting/POS/Trading/ERP solutions Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225717
  - 4
    - project file The project that I have been working on for some months loads fine in the vfp 9 ide. It looks like all the forms and code are present. When I try to build the project it says the memo file, name.pjt, is missing or invalid. I see that yes, the file is present where it should be. Is there some way that I can regenerate this file? Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225711
  - 5
    - Need help with combobox Hi everyone. I need some help with using a drop down combobox. I have a table (physicians) that contains physician's names and phone numbers. I want to be able to create a drop down menu where users can click on the drop down menu and select the physician. Once the usr selects the physician, I want a text box to display the physician's phone number automatically. How would I go about doing this? I am using VFP 8 with SP2. Thank you in advance. Arvin Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225710
  - 6
    - VFP 9 Local Drag and Drop Is there a way to drag the contents of a control on a form to another control? IE. drag contents of a textbox to another textbox. My specific need is to drag the contents of a cursor cell to a cell in another cursor. I have gotten it to work using a right click to copy and then paste but would like it to be a little more elegant. Jim Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225705
  - 7
    - SBT/Vision Point 10 with VFP 6.0 Anyone out there using SBT/Vision Point 10 in Windows XP, along with Visual FoxPro 6.0 (actually, any version of VFP)? My client has source, and I'm doing extensive revisions to non-Laser printing output, bypassing the Report Generator code and the .FRM/.FRX files, and getting FoxPro "C0000005" error. Researched that on Google, found only one guy who seemed to really know anything about it, and he suggested downloading the latest Service Pack (SP5) which I did. Still, no joy. Wondering if anyone else is doing something similar. Many thanks for your input. Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225702
  - 8
    - VFP build version Hi, Is there a way to find what version of VFP I used to build an executable? I'm sure I've seen an (MSDN?) article on it before, but can't seem to find it anywhere. Any help much appreciated. Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225700
  - 9
    - VFP 9: Help with sending/receiving XML via FTP Hello, Looking for resources which will help me understand XML via FTP. The same application is used by both the sender and recipient. Here is what I do (sender): Insurance claim is created (single record). The record is converted to XML. The XML file is uploaded to specific FTP directory for the specific insurance company. At the other end (recipient): Recipient checks FTP folder for contents. Recipient is prompted to download the claims. The claims are downloaded and exported to table. Confirmation is returned to sender. I have the concept of how it will work, but I need a good book or suggestions from you on how to actualy deploy the idea. Thanks for the input. JD Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225698
  - 10
    - Running BAT file via ShellExecute I kick off a BAT file from within my VFP7 app with something like this... lcPath = "C:\MyPath" lcFile = "MyFile.BAT" CD (lcPath) ShellExecute( 0, "open", lcFile, "", "", 2 ) All works OK. However, if lcPath has a value of [\\MyPC\c\MyPath] the ShellExecute doesn't seem to work. SYS(5) + SYS(2003) return the expected value of [\\MyPC\c\MyPath] at that point. FILE(lcPath + "\" + lcFile) returns .t. Any ideas? Brian Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225684
  - 11
    - Serial Cash register drawer I posed this issue before and was steered to the microsoft site for using mscomm32 to send output to a serial port. The cash register is on com1 and the drawer opens pressing CTRL G. Can I just save the code below as a program. Call the program at the time the receipt button is pressed and edit the following code to read as follows to work? ComForm.Testcom.CommPort = 1 ComForm.Testcom.Output = 7 ( the appropriate code to send the CTRL G to the serial port?) ComForm.Testcom.Settings = "9600,N,8,1" Do I have to run the setup tool and include the mscommlib for the application to work for my customer also? ***Program code*** PUBLIC ComForm ComForm = CREATEOBJECT('Form') ComForm.AddObject("Testcom","Olecontrol","MSCOMMLib.MSComm") ComForm.Testcom.CommPort = 2 && Use Comm2, The second Serial Port. ComForm.Testcom.Settings = "14400,N,8,1" && 14.4 Kbaud, No Parity, && 8 data Bits, 1 Stop Bit ComForm.Testcom.PortOpen = .T. ComForm.Testcom.Output = "ATDT555-1234" + chr(13) && Dialing the number * The chr(13) is needed to complete the modem command sequence ComForm.Testcom.PortOpen = .F. ***** End Code ***** Rusty Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225682
  - 12
    - vfp 2.6 Getting user name from machine Does anyone know if it is possible to get the user name from the machine in Visual FoxPro 2.6? I have a routine I use in versions 6.0 and up, but it won't compile in 2.6 : lpbuff = space(40) declare long GetUserNameA in advapi32.dll string @ str1, long @ lval kint = GetUserNameA(@lpbuff, 25) ? lpbuff clear dlls TIA, Marc Miller Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225675
  - 13
    - Detecting an Excel File Hello and thanks in advance for the help. This may be the wrong place for this question but if anyone has any ideas I'd be grateful. I am working with Excel spreadsheets and using the following code to open a spreadsheet: oExcel = CREATEOBJECT("Excel.Application") && Start Excel oExcel.Workbooks.Open(lcSpreadsheet) where lcSpreadsheet contains the name of the spreadsheet file. The problem is that these are uploaded files and sometimes they don't upload Excel files even though they are supposed to. Sometimes this code is executing on my web server which doesn't like Excel file open errors. My question is: 1. Is there a way to detect whether or not a file is an Excel spreadsheet before calling Workbooks.Open? Thank you very much. Jeff Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225662
  - 14
    - Update Views problem I use a view to fill a grid. To add an additional row in the grid I provide a button on the form which adds a row in the view, enters some predefiened data and send an update to the view with: =TABLEUPDATE(1,.t.,'view') and put the focus onto the grid. After entering data, closing the form, reopening it again the predefined data are there but the manually entered data are lost! In the grid in every text and combo box I put in the Valid Methods the code: =TABLEUPDATE(1,.t.,'view') The problem occurs only if a new row is added to the grid/view. Please could someone give me an advice how to avoid the data loss. Wolfgang Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225661
  - 15
    - PS file generation error after VFP8 upgrade to VFP9 Hi All, After i upgrade from VFP8 to VFP9(with SP1), the Adobe Distiller can not convert the ps file to pdf successfully. The problem is due to the ps files store the printer setting. I have fixed it by checking "Printer Environment" in every report forms, (since all report forms are checked it in VFP8), however, it is too time consuming. Any other methods to solve it? many thanks! Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225651
  - 16
    - Keeping Focus in a TextBox I have a textbox at the top of a form and a grid below. I want to stay in the textbox and enter data - hit return and update the grid - and then go right back to the textbox. Don't want to leave it until I click out of it. I use valid to test the data in the textbox and return(.t) just after updating the grid. If not valid I return .f. and tell the user and the focus stays in the textbox. I want it to stay there even if I return .t. Return .t causes focus to go to the next object. I don't want that. When the user is done entering data and updating the grid data then they can click out of the textbox. Using VFP 9. XP Pro. Any Ideas would be very appreciated. TIA Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225648
  - 17
    - Table Sorting / Indexing VFP9 I want to sort a table by the 'Group' C(20) and the 'Total' N(12,2) fields . How can I sort the table by group+total. There many duplicate groups and within the group I want it sorted by total. The totals range from .01 to 100.00. Thanks Tim Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225645
  - 18
    - Insertion point, active window highlight: not I've got a situation in which the vfp insertion point is not visible and the title bars of active windows are no longer highlighted. This has nothing to do with set cursor or sys(2002), but it *may* be related to the fact that I have a large number of tables open (aprox 110) and some of those tables have a large number of fields (eg 250) with an index tag on about every field. Has anyone else seen this? -Lew Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225639
  - 19
    - Using F2 to emulate a button click I have a button on a form with the two lines: DO FORM frmFindRef TO dlcRef dllReturn = thisform.FindPersonbyRef(dlcRef) I want to set up function key F2 so that it emulates the click of this button. I have tried ON KEY LABEL F2 but of course I can't put a reference to THISFORM.CMDBUTTON.CLICK() so I am not sure how to go about this. Many thanks Stephen Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225633
  - 20
    - Duplicate record dropped in SQL UNION query... Hi -- - I have 8 tables in a directory. One of the tables has a duplicate record. The number of records for all 8 tables, including the duplicate record, is 13,021 - I joined the 8 tables using SQL UNION. One of the instances of the duplicate record is NOT part of the resulting cursor. The total number of records in the cursor is 13,020. - How did this happen? - Thanks for any help. David Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225622
  - 21
    - export memo fields to excel COPY TO with XLS/XL5 seems to ignore memo fields. The only way I've been able to copy memo fields to Excel is to use CURSORTOXML, then import the xml file into Excel. Is there a simpler way? Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225618
  - 22
    - Code generator for HTML + PHP + MySQL + Javascript/AJAX Something like the old Foxpro/DOS screen generator.... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.6 ^ ^ 11:36:01 up 20 days 18:59 0 users load average: 1.00 1.04 1.05 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225614
  - 23
    - Line Drawing in Report. Hi, I want to print a triangle on vfp report, but the 3 points of the triangle will vary based on the values (x1,y1) of 3 points of the triangle.(I will specify 3 values at runtime). Can it be done in vfp ? Will the 2 diagonal lines of the triangle look as sharp as third horizontal line on preview mode or when printed on paper ? Please Suggest. Regards, Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225610
  - 24
    - Sturcutres in VFP for API declaration In addition to my earlier post i want another help. Some APIs require structure types in VFP what can we use for structures Fox Example.. in Visual Basic we write code like ''''''''''''''''''''' Private Type abc tmpName as String tmpId as Long End Type ''''''''''''''''''''''' This above declaration i need to do in VFP, in-case of adding this functionality in my VFP program rather than accessing through DLL. Thanks in advance for any help. -- NR Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225607
  - 25
    - Accessing DLL in VFP Hi, I want to use external DLL in VFP. Fox example i have created on DLL file in Visual Basic using ActiveX DLL. When i use it with VB application it works fine but in VFP 8.0 it gives an error message i.e. Cannot find entry point <FunctionName> in DLL. Below is the example code: Class Code in VB-ActiveX DLL '''''''''''''''''''''''' Public Function Multiply(int_x As Integer, int_y As Integer) As Integer Multiply = int_x * int_y End Function In VFP I am using it as: DECLARE Integer Multiply IN tstProject.Dll integer @x, integer @y x = 2 y = 3 ?Multiply(@x , @y) && Gives an error message mentioned above ?Multiply(x , y) && Same error message Please let me know if i am doing any mistake. -- NR Tag: DBSETPROP - IdleTimeout documentation error? Tag: 225606

Hi there,

I'm comparing the MSDN for DBSETPROP "IdleTimeOut" to the tooltip that
comes up in the IDE.

MSDN says that the value is in minutes, but the tooltip says the value
is in seconds.

Top

Re: DBSETPROP - IdleTimeout documentation error? by AA

AA
Thu Aug 17 03:54:05 CDT 2006

The Help doc has a reason for minutes:
<<
The idle timeout interval in minutes. Timeout is checked no more than once
per minute, therefore it is possible that active connections might
deactivate one or two minutes later after the specified time interval has
elapsed. The default value is 0 (wait indefinitely).

Read/write.

>>
-Anders

<drsystems@gmail.com> skrev i meddelandet
news:1155754372.231142.131320@75g2000cwc.googlegroups.com...
> Hi there,
>
> I'm comparing the MSDN for DBSETPROP "IdleTimeOut" to the tooltip that
> comes up in the IDE.
>
> MSDN says that the value is in minutes, but the tooltip says the value
> is in seconds.
>

Top