Treeview Control

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
    - how to get all remote cursors connection in current data session? Hello all, Continuing my problem regarding connection to MSSQL, here is the latest progress (and question) about my effort to find the solution. Because my thread 'A lot of lockings and connections to SQL Server. Is it normal or bad?' in this ng didn't get any reply, I decided to cross post in microsoft.public.sqlserver.programming (I put the discussion in this post for your convenience in case you're willing to read). Anyway after giving more thought about the problem, here is what I found: I found out that each time I run any form in my apps (the form is child window, in-top-level, private-data-session), after I close the form, there were two or three external connections still intact. I can easily 'kill' those external connections by running following break.prg. *!* Break.PRG ON ERROR * FOR i = 1 TO 200 SQLDISCONNECT(i) ENDFOR ON ERROR *!* end of break.prg Regardless whether I kill those connections or not, after I run another form, there would be other two or three external connections added (and other locking as well - although I don't understand what kind of locking MSSQL do). All connections belong to one apps would be immediatelly close if I closed the apps. Yes, I know that this would be my own fault and I should learn more. That's why i already purchase a copy of Client Server with VFP6, and will certainly read the book cover-to-cover. Anyway, what I need now is a quick-and-dirty fix to my problem. What I have in mind is to explicitly close the connection with SQLDISCONNECT( ) on the Destroy event of each form. I can easily put that in my baseclass form and it will affect all forms in my apps. Problem: Anybody knows how to get (and to traverse) all cursors (remote views and cursor from SPT) in current (active) data session? I cannot run break.prg on Destroy event, because that would kill other connections needed by other window. I'm looking forward to hearing from you! TIA, Willianto Following is the discussion I mentioned above: My original post: --------------------------------------------------------- Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (created with Microsoft Visual FoxPro 8.0 SP1, connect with SQL Server thru ODBC) interact with SQL Server. I found out that on some parts of my apps (where there are lots of traverse and calculation), the number of locks on the SQL Server could go up to 700 and the external connection could go up to 15 or 20. And I tested that on my box (that means; I run my apps on the server and no workstation connect to the server). Whilst the apps so far running fine, it's never been really tested to the max. The traffic are quite low and the concurrent user has never exceed eight users. Yet, looking at the numbers, I'm afraid that there something that I don't do effectively. My Questions: 1. Is the number normal? 2. Anybody here can give me advices on C/S programming, I mean just a quick thumb rules what should and what, like should I make a connection, get the data, and disconnect immediately. Or should I share all SPT in one connection?, or any other rule what should and shouldn't? Thanks in advance Willianto ====================================== Following is the reply from Louis --------------------------------------------------------- This is the open question of all times. Without looking at the code, the best that can be said is that you might be fine, or you might have written a terrible app (something we all have done at one time or another :) Lots of locks are fine, as long as you don't have lots of users contending for those locks. You say you have 8 users, is that all you are planning for? If everyone is happy, it might be fine. Bottom line is that you need to get some literature and read up on design, internals, optimization, etc before you can decide if your application is well written, and experience is a must. Without being able to magically aquire this (and it takes a while and sadly we learn from failure!) I would suggest that you take this statement: > Whilst the apps so far running fine, it's never been really tested to > the max. Define what max means and test for it. If it works fine under max conditions, then your application is fine. ====================================== And my reply again: --------------------------------------------------------- Hi Louis: Thanks for your reply. > best that can be said is that you might be fine, or you might have > written a terrible app (something we all have done at one time or > another :) Lots of .. [skipped] Looks like my case is the second one :( As I stated in my post, the application runs fine, but it runs with a very minimum load. That's because the company using my apps is a machinery trading company. The activity is very low. To give you a clue how 'low' is that; they only have to create less than 10 invoices a day. Actually, that's the best numbers they got for years (that means less than ten sales a day - but, hey, the profit of selling one machine could cover three months expenditure!). Anyway, what I did is I backup the database, call up some of my fellow, line up eight computers, and massively attack the system with all the apps feature (purchasing, receive goods, stock preview, stock opname, delivery order, customer order, etc...). After an hour we manage to hang the server which by then, got about 350,000 locking and 80,000 external connections :( So, using SQL Server as a backend is not _that_ easy... Oh well, at least I know for sure that the problem won't appear in my client for a near future. Regards, Willianto Tag: Treeview Control Tag: 205492
  - 2
    - how to post a message in my application to the users i want to display a message to the users of my application a message when certain administrative tasks are to be done (esp indexing of the files, or forcing the clients to log out). How can i display these messages to the users of my application? Tag: Treeview Control Tag: 205490
  - 3
    - how to bring my vfp screen to the front if my vfp application has lost focux (ie the user is now using another application), then how can i forcefully bring up my application (to the front). i remember seeing some API functions for this. Tag: Treeview Control Tag: 205489
  - 4
    - Combo and Exit Routine I thought that if I wanted to exit the ComboBox (VFP7) I could press ESC and in the KeyPress Event I would RETURN 0. This seems to fire the Valid event, where I am checking for LASTKEY() = 27 and once again returning 0. Does not seem to work. What important steps am I missing here? Thanks for your help Tag: Treeview Control Tag: 205480
  - 5
    - ReadOnly property hi friends I am created a custom class programatically and want create a readonly proerty. e.g. DEFINE CLASS myclass AS Custom cVersion ='1.0' && i want this to be readonly ----other code here ---- enddefine Thanks -- cheers Tag: Treeview Control Tag: 205478
  - 6
    - Form not coming up in exe New to Foxpro and have an application using a form. When I run the program from within foxpro the form comes up and works fine but when I create an .exe file the program excutes but the form doesn't come up for any user input. Don't know where to go from here. Tag: Treeview Control Tag: 205477
  - 7
    - creating DLLs Hi Friends Can someone suggest a good document on how to create DLL and related issues. I am using vfp8 Thanks -- cheers Tag: Treeview Control Tag: 205474
  - 8
    - Report data environment affecting form data environment Hello, I've embedded a report within a form. Running the report moves the record pointer of the forms data environment. Setting AutoOpen and AutoClose of the report data environment had no effect. How can I prevent the report data environment from affecting the forms data environment? BTW: Both report and form data environments are the same, even table relations. Tag: Treeview Control Tag: 205465
  - 9
    - After closing a form, a connection doesn't disconnect thoroughly I just found out that whenever I closed any forms (in which I use remote views), than the connection doesn't disconnect automatically. Is this a normal behavior or do I miss something? I could not literally put SQLDISCONNECT because there might be other forms use the connections. I checked the connection using SQL Spy as I stated in my previous post. On my forms, I use Private Data Session, connect to the SQL Server via ODBC. Please advice. TIA, Willianto Tag: Treeview Control Tag: 205459
  - 10
    - Color Change of 'WAIT WINDOW' Does somebody have an idea on how to change the default grey color of the WAIT WINDOW to any other color ? I am working on VFP 8.0 Thanks, Ted Tag: Treeview Control Tag: 205444
  - 11
    - Help with FoxPro and DirectX 9 Hi, every time i try to use the video control from MS TV Video Control (MSVidCtl.dll - DirectX 9), FoxPro always Crash. Does anyone knows what is hapening? Any work arround? Thx -- Livrinho Tag: Treeview Control Tag: 205436
  - 12
    - Report Page Number Hi, Is this possible in a single report? I want to be able to group my invoice report and somehow reset page numbering. I tried counting the lines and using variables but had problem when data overflows. Page 1 of 1 Page 1 of 2 Page 2 of 2 Page 1 of 3 Etc. -- Thanks, Karma Tag: Treeview Control Tag: 205430
  - 13
    - World Country & Cities Codes Is there anywhere I can download a complete list of world's country code and it's respective cities code ? Thanks in advance! Tag: Treeview Control Tag: 205427
  - 14
    - Link VFP char/varchar data in ESRI ArcView 8+ Does anyone in this group have experience with ArcView 8 or 9? I am having no luck getting ArcView 8 or 9 to link spatial attribute data to my foxpro table. The field type I am trying to link with is a VFP char or varchar. The resulting link returns NULL in ArcView. This problem did not occur in ArcView 3. Hope someone out there can help... Thanks! Tag: Treeview Control Tag: 205415
  - 15
    - Messagebox-like .bmp's I've written my own messagebox-like dialog class and I'd like to display the standard messagebox graphics. The only complete set I can find is a bunch of icons which display with white backgrounds in the image control. Is there any (easy) way to make the backgrounds transparent so I can have a more professional look? -Lew Tag: Treeview Control Tag: 205407
  - 16
    - Conversion of Foxpro 2 Source to Latest Version of Foxpro or VB.Ne I have a client that wants a Foxpro 2 application updated to the latest version of the language or VB.Net. They have the source code. Any suggestions on how best to proceed? Tag: Treeview Control Tag: 205406
  - 17
    - Empty Objects This function can be useful for handling lightweight objects: *--------------------------------------------------------------------- * EmptyObject(fieldsList) * Receives a list of fields separated by comma * Returns an empty object with empty properties *--------------------------------------------------------------------- * Test: Customer = EmptyObject("Name,Address,Phone,Contacts[5]") Customer.Address = EmptyObject("Street,City,State,Zip,Country") Customer.Name = "John Doe" Customer.Phone = "555-1234" Customer.Address.City = "Sunny Beach" Customer.Address.State = "FL" Customer.Address.Zip = "12345" Customer.Contacts[1] = "Jane Doe" Customer.Contacts[2] = "Jim Doe" Set Step On && Check out Customer object Return Customer *--------------------------------------------------------------------- Function EmptyObject LParameters fieldsList As String If Empty(fieldsList) Then Return Null Endif Local Array fieldsArray[1] Alines(fieldsArray,fieldsList,.T.,",") Local oEmpty oEmpty = NewObject("Empty") Try For Each item In fieldsArray AddProperty(oEmpty,item,"") Endfor Catch oEmpty = Null Endtry Return oEmpty EndFunc *--------------------------------------------------------------------- Tag: Treeview Control Tag: 205402
  - 18
    - How to allow the user only to select a drives? Hi everyone, I need to allow the user only to select a drive from the machine. I need to create a predefind path in a drive. For this I need the user to select the drive where to create it. Is there a way where I can prompt the user to select the drive like in GETDIR()? Thanking in advance. Nadee. Tag: Treeview Control Tag: 205389
  - 19
    - Urgent! Can you help? I need someone to help me to work out the VFP solutions for the following within the next 4 hours. Who can help? Many thanks!!! 1) N!*M!(N-M)! 2) the square measure of a triangle 3) the summation of the even numbers from 1 to 200 Tag: Treeview Control Tag: 205387
  - 20
    - How Do I Ask VFP8 if a Folder Exists? In VFP6, ? FILE('MyFolder\NUL') returned .T. if MyFolder existed. VFP8 returns .F. even if MyFolder exists. I used MD with an error trap as a kludgy workaround. Is there an easier way (or function) in VFP8 to determine if a folder exists? TIA Steve Meyerson Tag: Treeview Control Tag: 205382
  - 21
    - Corrupted method code It's time for my semi-annual rant on this subject. I had hoped that Microsoft had fixed this, but it appears to still be there. Today I'm working on a form, and out of the blue, I open the form and find this in a dozen different methods: http://zootal.no-ip.info/stuff/evilvfp.jpg At this point the code that was there is irretreivably lost. Gone. Permanantly corrupted. This represents the loss of two days work, since that is how long since my last backup. This is something I have observed since VFP6. It happens with VFP6,7, and 8, Win98/2000/XP, fat32 and ntfs, and doesn't matter what machine I work on or where <sigh>.......and now I get to redo what I've spent the last two days doing....<sob>... Tag: Treeview Control Tag: 205379
  - 22
    - return value Dear sirs In my program I've a form which should return more than one value I use DO Form frm TO var but this method only returns one value which is (var) How can I return more than one value or an array of elements??? thanks Mohammed Tag: Treeview Control Tag: 205375
  - 23
    - How to Put a Array in a Report ? Dear Foxer There is a Array in a Report. After Build a .Exe file, has the following errors: Unknown xxxxx - Undefined How to do ? Thanks. - Tuberose Tag: Treeview Control Tag: 205366
  - 24
    - can save report as image file hello sir, can i save the spool of print report to printer as physical file print it any time later or can i save the report as image physical file attache in mail the problem i want to attache the receipt (payroll system) of every employee to him email and send it to see as image file or print it thanks mohamed nour Tag: Treeview Control Tag: 205359
  - 25
    - Intellisense - Webservice I have a web service and I am trying to register it in the intellisense manager. Based on the documentation and other readings I have found, it indicates that after I click on Tools-Intellisense Manager-Type-Webservices, I should be prompted to enter a name for the service and the WSDL url location. I am using VFP8 and I am only prompted to enter the WSDL location. Where do I enter a name for the service so that I can use the methods and properties in my code using intellisense? Many thanks and happy new year to all. Regards Shahriar Tag: Treeview Control Tag: 205358
- Next
  - 1
    - A lot of lockings and connections to SQL Server. Is it normal or bad? Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (created with VFP8SP1, ODBC, RVs and SPTs) interact with SQL Server. I found out that on some parts of my apps (where there are lots of traverse and calculation), the number of locks on the SQL Server could go up to 700 and the external connection could go up to 15 or 20. And I tested that on my box (that means; I run my apps on the server and no workstation connect to the server). Whilst the apps so far running fine, it's never been really tested to the max. The traffic are quite low and the concurrent user has never exceed eight users. Yet, looking at the numbers, I'm afraid that there something that I don't do effectively. Anybody here can give me advices on C/S programming, I mean just a quick thumb rules what should and what shouldn't. Thanks in advance Willianto Tag: Treeview Control Tag: 205357
  - 2
    - MSMQ in VFP I am wanting to implement MSMQ in my VFP app. I found Randy Brown article on MSMQ from VFP 6.0. There is so much to read and I know so little. I do not want to reinvent the wheel and Mr. Brown's article is dated 1999 so some of it may be out of date. Where should I start? I do not mind reading or even purchasing 3rd party products to aid im implementation but I really do not know where to start. I found a link to documentation for version 2.0 but nothing to 3.0. Do I need the SDK? Thanks for any guidance. John Tag: Treeview Control Tag: 205353
  - 3
    - WTB DBFtrieve or other Btrieve access Anyone have a copy of DBFtrieve they want to sell? Or some other access to Btrieve data that's programmable and preferably has a small footprint? Please contact me at the address below or in the ng. -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - n g at y a h 00 Tag: Treeview Control Tag: 205352
  - 4
    - store tables to server while installing app, how Hi, This is probably easy to most of you but is my first trial. I have an app that utilitize free tables stored in the server under a directroy "app_data" To access the data I have this set path command hard coded in my main.prg: SET PATH TO "F:\APP_DATA" This is working fine except now I would like my program to be installable on any workstation on which the server is mapped to some other drive letters instead of F:. What changes would my program need in order to allow the user to store the tables in any directory he desires while running setup of the app, and the app still knows where to find these tables? How exactly is it done? Thanks for all help. -- jw Tag: Treeview Control Tag: 205343
  - 5
    - Runtime reports I have generated an insurance claim form using the GDI+ and the render method of the report listener. The form prints and previews perfectly when I run it as an .APP from within VFP9, but will not generate any print or preview output when I run it as an .EXE outside VFP9. The report is rendering, there is just no output. What am I forgetting to compile into my .EXE to get the output? -- Marina Nelson Tag: Treeview Control Tag: 205337
  - 6
    - calling a Webservice from VFP I am trying to test calling a webservice created in VS.net. I can access the webservice from ASP itself. When I try to access it via VFP, i get the following error message. OLE error code 0x8002801d: library not registered. My vfp code is o=CREATEOBJECT("MsSoap.SoapClient30") ?o.MSSoapInit("http://localhost/WebService4/Service1.asmx?wsdl") Is there something else that need to be registered? I am using VFP8. Many thanks Shahriar Tag: Treeview Control Tag: 205331
  - 7
    - Shortcut menu on a toolbar I want a menu to show up on a toolbar that I have when the user right clicks. The problem I am having is that the menu shows up on the currently active form and not right under the mouse pointer. All I am doing is on the right click calling "DO toolbarmain.mpr." How can I get this to function right? -- Altman VFP8 SP1 Tag: Treeview Control Tag: 205329
  - 8
    - ALTER question I have found when a table column width is enlarged using the ALTER command, the index file (CDX) may grow greatly in size. If I reindex the file and then issue a USE statement again, the index file returns to the original size. Does anyone have an explanation for this anomoly (I'm looking for a knowlegeable answer, not a guess.) TIA. --E. Myron -- To reply, change "invalid" to "net" Tag: Treeview Control Tag: 205324
  - 9
    - Codepage problem with DLL on vfp6 We have a Visual Fox Pro dll that is inserting information into a Visual Fox Pro database This dll is called via a Visual Basic COM object or an ASP page. VFP6 When we pass greek characters strings to the dll then the majority of times garbage data are insterted in the Visual Fox Pro database We tried several tests 1) While in the Visual Fox Pro dll we write the greek strings out to a text file. The greek data are written out correctly to the text file 2) Calling CPCURRENT() from the dll and writing it out to a file returns 1252 (This is the codpage for Windows ANSI) 3) Calling CPCURRENT(1) from the dll and writing it out to a file returns 1253 (This is the codepage for Greek Windows) 4) Calling cpdbf() from the dll and writing it out to a file returns 1253 5) We tried setting CODEPAGE = 1253 in a function that is called first whenever the dll is called but the CPCURRENT() value remains the same 6) We tried cpconvert(1252,1253,alltrim(cCustomerName)) but it does not work Thanks in advance George Malekkos Tag: Treeview Control Tag: 205320
  - 10
    - Check if process is running Is there a way to find out if a process is already running in windows. I would like to get a list of processes running, like that of what is in the task manager. (note: I want processes, not applications) Tag: Treeview Control Tag: 205319
  - 11
    - Help, how to download VFP5 SP? last version thanks -- Thanks ! Tag: Treeview Control Tag: 205313
  - 12
    - Problems wih compiled application I select main program, Buil and win32 executable. When i run the program, it opens first form and closes it right away. If i build application everything is ok but i'd rather have win32 app. Thx. Tag: Treeview Control Tag: 205312
  - 13
    - [trouble of fox9 ]Can quit app Hello My old exe work well with fox 6,7,8 and fox9 beta. But they now got trouble with fox 9. Command QUIT and the close box can not quit the exe . Any idea ? Max. Tag: Treeview Control Tag: 205309
  - 14
    - Buffering - Update conflict VFP8-SP1 Happy new year to all! I´m new to build a shared environment. I want to make adjustments for an VFP-app based on views for the shared data and some tables as well for mostly nonshared data. Purpose to obtain a wellworking multiuser environment. An example, code in a forms destroy; CURSORGETPROP('Buffering','vwComp1') && returns 3 for the view vwComp1 SET MULTILOCKS ON CURSORSETPROP('Buffering',3,'tblLastUsr') Replace tblLastUsr.lastc1to234 with pcvwcomp1c1to234 && works just fine Requery('vwComp1') && my errorroutine traps "Update conflict - error 1585" As far as I know the view vwComp1 is not locked from another computer in the LAN. The parameterized view vwComp1 is based on one table only. It works just fine in a singeluser environment. Is there somebody who can give me a hint? Best regards Christina Tag: Treeview Control Tag: 205303
  - 15
    - VFP 9 dll's needed for redistributed app All: I am trying to test one of my applications in VFP 9 and I am getting this error "Visual FoxPro cannot start. Could not load resources." I have VFP9r.dll, msvcr71.dll, gdiplus.dll in the application root. I know from VFP8 and earlier you needed to have VFP8/7/RENU.DLL in the application root. Does VFP 9 have this and if so where is the file located? I checked Common Files\MS Shared\VFP and I cannot find it as well as checking the VFP install folder. Are their any other new dll's you have to use that I might not know of? Any help is appreciated. Thanks - Art Tag: Treeview Control Tag: 205298
  - 16
    - Using legacy forms in FOxPro 8 We are upgrading from Fox 5 to Fox 8. In the Fox 5 application there are about 40 legacy forms left over from an earlier DOS FoxPro version of the app. These forms use a "READ MODAL" command. The help files don't explain anything more than to say that it is included for compatibility with older versions. But it worked in Fox 5 but now it doesn't work in Fox 8. Can these old forms be made to work without re-writing them? The app is being upgraded to 8 so that we have the ability to re-write in VB.NET in a piece by piece methodology where old fundtionality and new co-exist. So I would prefer to not re-write them at this time. -- T Ralya, FoxPro & .NET developer, HMSA Tag: Treeview Control Tag: 205291
  - 17
    - DEALING_WITH_OBJECT Hi all i want to send object containing controls as (form & container) to methode to chang in the controls and determine there kind as sending form to program to chang bach color of the buttons to red and labels to yellow [changecolor(this)] in the methode or program dealing with intire controls determin kind . how can i know the kind and deal with intire controls of form or container controls?? Tag: Treeview Control Tag: 205282
  - 18
    - swapping columns in a grid Hello all, Happy New Year and thanks in advance for the help. Is there a simple way to move or swap columns in a grid control? Currently I have a grid with 8 columns each of which has is own distinct properties and methods. The user has asked me to swap column 2 and 3. Is there an easy way to do this? Thanks, Jeff Tag: Treeview Control Tag: 205271
  - 19
    - vfp9 VS VFP6 does it worth it to move from 6.0 to 9.0 and if yes what are the problems i will face do you think is better to move to 8.0 first? Thanks George Malekkos Tag: Treeview Control Tag: 205269
  - 20
    - Managing period accounts I'm designing a simple accounting system for our company, an Advertising company. We have nearly 500 clients and about 200 suppliers. I'v designed all the tables needed for A/c payable(Purchase orders, Supplier invoices, Payment vouchers), A/c Receivable (Sales invoices, sales receipts) and GL(petty-cash vouchers, bank payments, journal vouchers). Now I'v come to the most difficult stage where I'v to redesign my tables, so that 'period accounts' can be maintained (eg. monthly & yearly accounts). I'v a native VFP Database on a WIN2K server(with 20 users). Basically I want to know what are the typical tables that will be used in a simple accounting system like ours and their links and structures. And the typical method of maintaining period accounts. Your help is highly appreciated. Thanks, Don Tag: Treeview Control Tag: 205264
  - 21
    - hard to track update error This problem has bedeviled me for weeks. I hope someone can shed some light on it. At issue is an inventory tracking system. Changes are made to current inventory, and entered into a log. In the code synopsis below, parts contains part numbers and onhand quantities (among other stuff) and invlog contains a log of inventory changes. Both tables are contained in the same database. Additions to inventory involve subtractions of certain quantities of component parts; as a result, increasing inventory of any part involves from one to as many as ten changes and log entries. This is a file server system. Up to three workstations may be adjusting inventory at once. For historic reasons, it is desired to keep all related inventory transactions together (physical order) in the log. I know that's not ideal, but there's no changing it at this point, and in any case, that's not part of the problem. But to implement this, I accumulate related log entries in the cursor invlcur, then enter them into the log all at once. The parts table is table buffered optimistic. I make the necessary changes (it goes pretty quickly), then call TABLEUPDATE. Invlog is not buffered. Here's the code: LOCAL errMsg, oExc BEGIN TRANSACTION TRY INSERT INTO invlog SELECT * FROM invlcur CATCH TO oExc errMsg = m.oExc.MESSAGE ENDTRY DO CASE CASE NOT EMPTY(m.errMsg) && not likely, since invlog is never locked ROLLBACK CASE NOT TABLEUPDATE(1, .F., "parts") LOCAL ARRAY earr(1) AERROR(earr) ROLLBACK TABLEREVERT(.T., "parts") * error handling and notification in here OTHERWISE END TRANSACTION ENDCASE The problem is, occasionally - maybe one time out of a thousand - log entries will get made, but the inventory changes do not get entered. The users report no error messages. It's as if TABLEUPDATE() failed, but returned .T. anyway. Either that or ROLLBACK failed. I could try putting the log update after the part update, but even if that seemed to work, I wouldn't have confidence in it because I don't know what's wrong. And if it doesn't work, the error occurs so rarely that it would be a while before it was discovered. I see now that I should have a TABLEREVERT(.T., "parts") after that first ROLLBACK. Yet I do not see how that could cause this problem. Can anyone help? Tag: Treeview Control Tag: 205262
  - 22
    - Import text to DBF in SDF format - Decimal alignment I have used 'append from' to import an SDF file into a DBF. There are 125 fields containing char, date and numeric data. Everything appears to import correctly except in 5 numeric fields defined at numeric (7,2). The decimals are either missing, 1 position or 2 positions. An example of the imported data is 0001230. The decimal should appear between the 2 and 3. The decimal appears between the 2 and 3 or the 3 and 0 or not at all. Why would the decimal alignment not work? -- Robert Neal West Palm Beach, FL USA Tag: Treeview Control Tag: 205260
  - 23
    - getfile() problem, please help I have these line in my application. w=GETFILE("dbf","Input file name","Sure") copy stru to w however the command "copy stru to w" not work. it did not copy the file to the specify path,the file will be copy to the foxpro directory. there is a example below w=GETFILE("dbf","Input file name","Sure") now "w" contain "c:/copy.dbf" when I add this "copy stru to w" in the program, the "copy stru to" command did not copy the specify file to "c:/". but the "copy stru to" command copy the specify file to e:/foxpro -- foxpro directory. how can I use the "copy stru to" command to copy to the file to the specify dirve and path I want . thank you for you help Ming Tag: Treeview Control Tag: 205253
  - 24
    - adding properties to com object at run-time I seem to having a problem adding properties to COM objects at runtime. I have a OLEPUBLIC Class (TClass1) that instantiates another class (TClass2). It then adds a new property to this object. However this new property is not visible to the calling program. I have enclosed some sample code below. Could you enlighten me please? To run the samples code you will have to add the COM Object code to a project names proj1 and build it into a COM DLL. Calling program code: loClass1 = CreateObject("proj1.TClass1") loClass2 = loClass1.Function1() If PemStatus(loClass2,"Prop1",5) ? "Property 1 exists" Else ? "Property 1 does NOT exist" EndIf Release loClass2, loClass1 COM Object Code: Define Class TClass1 As Session OLEPublic oCallback = .Null. Function Error(tnError, tcMethod, tnLine) Local lcMessage As String, lnObjectName As String lcObjectName = This.Name lcMessage = "ERROR: "+lcObjectName+"."+tcMethod+" "+"Line: "+AllTrim(Str(tnLine))+" "+Message() This.WriteLog(lcMessage) EndFunc Function Function1 *-- Do some pre callback code... *-- Issue the callback *!* This.oCallback.Event1() *-- Do some post callback code... *-- Add a property at run-time loObject = CreateObject("TClass2") If AddProperty(loObject,"Prop1","Test") This.WriteLog("Prop1 added to loObject") Else This.WriteLog("Prop1 could NOT be added to loObject") EndIf Return loObject EndFunc Function Init This.WriteLog("Starting...") *-- Initialise Callback Object This.WriteLog("Initialise callback object") This.SetCallback(.Null.) This.WriteLog("Callback object has been initialised") EndFunc Function SetCallback(toCallback As Object) Local lcType As Character If IsNull(toCallback) *-- dummy instance that does nothing This.oCallback = NewObject("ApplicationEvents") Else *-- Check callback variable is an object lcType = Vartype(toCallBack) If lcType != 'O' This.WriteLog(PROGRAM()+": callback must be object. Parameter passed is "+lcType) EndIf This.oCallback = GetInterface(toCallback, "IApplicationEvents", "proj1.class1") EndIf EndFunc Function WriteLog(tcString) *-- Write expression to default log file *-- Prefix with date and time *-- Suffix with file name *-- Always append to file StrToFile(Dtoc(Date())+" "+Time()+" - "+tcString+Chr(13)+Chr(10),"c:\app.log",1) EndFunc EndDefine Define Class TClass2 AS Custom OLEPUBLIC EndDefine Define Class ApplicationEvents As Session OLEPublic *-- Template for Callback Interface --* Function Event1() EndDefine Tag: Treeview Control Tag: 205249
  - 25
    - B-Trieve I need to access B-Trieve data. I've been told that ODBC works but is painfully slow. There's a product called DBFtrieve (Hallogram), but that is out of stock and will be for an unknown period of time. Does anyone have a DBFTrieve they'd like to sell? Or any other suggestions? Tag: Treeview Control Tag: 205247

Does anyone know how to change font/color of nodes in the treeview control?
Is that even possible? If not, is there a better control to use instead?

Many Thanks
Shahriar

Re: Treeview Control by Shahriar

Shahriar
Wed Jan 05 06:12:03 CST 2005

I figured it out. Please ignore message.
Thanks
Shahriar
"Shahriar" <HelloShahriar@hotmail.com> wrote in message
news:frQCd.16650$Y57.12980@trnddc08...
> Does anyone know how to change font/color of nodes in the treeview
> control? Is that even possible? If not, is there a better control to use
> instead?
>
> Many Thanks
> Shahriar
>

Re: Treeview Control by Fred

Fred
Wed Jan 05 09:23:13 CST 2005

When you solve your own problem like that, it's better if you post what you
did so that others may benefit from your experience.

--
Fred
Microsoft Visual FoxPro MVP

"Shahriar" <HelloShahriar@hotmail.com> wrote in message
news:nQQCd.16651$Y57.2097@trnddc08...
>I figured it out. Please ignore message.
> Thanks
> Shahriar
> "Shahriar" <HelloShahriar@hotmail.com> wrote in message
> news:frQCd.16650$Y57.12980@trnddc08...
>> Does anyone know how to change font/color of nodes in the treeview
>> control? Is that even possible? If not, is there a better control to use
>> instead?
>>
>> Many Thanks
>> Shahriar
>>
>
>

Re: Treeview Control by Shahriar

Shahriar
Wed Jan 05 12:08:02 CST 2005

To set an individual node of a tree to color red here is the code
thisform.treeView1.Nodes(i).ForeColor = RGB(255,0,0)

Shahriar

"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:OhVyypz8EHA.1400@TK2MSFTNGP11.phx.gbl...
> When you solve your own problem like that, it's better if you post what
> you did so that others may benefit from your experience.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Shahriar" <HelloShahriar@hotmail.com> wrote in message
> news:nQQCd.16651$Y57.2097@trnddc08...
>>I figured it out. Please ignore message.
>> Thanks
>> Shahriar
>> "Shahriar" <HelloShahriar@hotmail.com> wrote in message
>> news:frQCd.16650$Y57.12980@trnddc08...
>>> Does anyone know how to change font/color of nodes in the treeview
>>> control? Is that even possible? If not, is there a better control to use
>>> instead?
>>>
>>> Many Thanks
>>> Shahriar
>>>
>>
>>
>
>