Get color pair

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
    - Catch child control mouse events Hi, How to catch a child control mouse events in the parent object. For example if I have a container and a text box placed on it, How I can catch the mouse right click event in the container before it goes to the edit box. Thanks Tag: Get color pair Tag: 187748
  - 2
    - How to measure an image width/height Hi All, Please advice how to measure the 'Width' and 'Height' of an image, so that I can display always in the midle of the screen whatever setting of the screen ( by getting WROW() and WCOL() function. ) Thanks for your advices Hidayat Tag: Get color pair Tag: 187743
  - 3
    - Maximized window size will cover up the taskbar The window size of my application is set to maximized so that the application is enlarged to fill up the screen. But my clients reported to me that the window size of my application is too large so that it cover up the Window's taskbar. I suggested them to check the box, "Always on top" in Windows taskbar's property. Some can solve this problem but some cannot solve it. Is there any suggestion to solve this? Thanks! Tag: Get color pair Tag: 187742
  - 4
    - I Want To Create a Newgroup-like forum and poll the membership. Hi FoxFans, I know this question is not directly related to Foxpro, but I figured this is the most likely place to get ideas. I am a board of director for a very large Homeowners association (8,000 members). I want to set up a newsgroup-like forum where the membership can constantly communicate and exchange ideas the same way we do here on the fox newsgroup. I want to allow access to members only so I can shut off anyone who is rude. I don't want to code this myself unless it's a last resort due to time constraints. Does anyone know of an off-the-shelf software that would acommplish this? The whole goal here is to create an atmosphere where members can voice their opinions about anything from the comfort of their own computer. I would also like to have a feature where I can routinely poll the membership to see how they feel on a variety of issues. This is a very high priority for me, so I greatly appreciate any feedback. Thanks in Advance! -- Brett_Slattery Tag: Get color pair Tag: 187734
  - 5
    - Re: Install Problem with FPW26a Application Thank you Lee!!! After I read your response and answered it, I took a look at the Start Menu\Programs folder and sure enough, I had one entry that was 56 characters long. This entry was not too old but I can't say when it was installed. I truncated that one and tried my program setup again - It WORKED!! I also tried setup via the Start Menu Run command and it worked too! I sure don't understand what the Start Menu has to do with it if I don't use that folder but it makes a difference. This also explains why only one other (and myself) have reported this problem after years and installation by hundreds. Do you know the reason for this strange behavior? I sure would be interested in knowing. Many thanks again - it could have taken me years to stumble on that one - if ever. Ray Lee Mitchell <Leemi@online.microsoft.com> wrote: > Hi Ray: > > I have heard of this error when any menu option in the Start Menu > folder has a name greater than 49 characters in length. Do you have > any folders > in the Start menu that might meet this criteria? If so, the only > option is to decrease the length of the name. > > I hope this helps and have a Happy New Year! > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > Sincerely, > Microsoft FoxPro Technical Support > Lee Mitchell > > *-- VFP8 HAS ARRIVED!! --* > Read about all the new features of VFP8 here: > http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp > Purchase VFP8 here: > http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518 > > Keep an eye on the product lifecycle for Visual FoxPro here: > http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv > - VFP5 Mainstream Support retired June 30th, 2003 > - VFP6 Mainstream Support retires Sept. 30th, 2003 > >> I've got a real problem with a FPW2.6a program and I could use >> some big help on it! This is long but I don't know how to shorten >> it, sorry. > >> Here's the problem: >> I have a program that has existed for many years and is downloaded >> over the internet. There have been a number of upgrades made and >> is currently on version 4.1. The program has been installed by >> hundreds of different people and more times than that by me >> personally with no problems. Yesterday I got a message from a new >> user using WinXP. He said he could not install the program and >> got the following error message during install: "An error has >> occurred in your application / If you choose Ignore you should >> save your work in a new file / If you choose close, your >> application will terminate." The error window within the FPW >> install window is titled "DSHELL". > >> What I've done: >> I tried to install the program and I too got an error. On a >> Win98SE machine the error read similar indicating a problem with >> DSHELL. The "ignore" button does nothing. After using the >> "Close" button, the machine exhibits a "not enough memory" error >> if I try installing again without resetting the computer. I tried >> to install an older version of the same program and now get the >> same error (when I had installed from the same install files many >> times before). I re-setup the program within FPW26a and then >> tried another install. Got the same failure. > >> As of now, I can not install any version of the program. > >> I did a complete virus check on the machine and there is no virus. > >> I know that the install program's setup.lst file shows, under >> [Params] section, that DrvModName = DSHELL but I do not know the >> significance of it. > >> It seems to me that maybe one of the dlls that get installed by >> the FPW26a installer is bad and for some reason (?) replaced the >> one I had on my machine. This would have to be one of the old FPW >> era dlls since common ones would be dated much later and should >> not get replaced. I tried removing some some of these old dlls >> and replaced them with ones that came with FPW26a. Now I get a >> different error that "Bind time error. 'SPAWN' not found in >> specified library" before I can get to the original error. > >> Any help would be greatly appreciated! > >> Ray Tag: Get color pair Tag: 187730
  - 6
    - Optional Parameter Hi, Can anyone tell me how to setup optional parameters in a method? Tag: Get color pair Tag: 187724
  - 7
    - string to integer? Is there anyway to convert a field saved in a db as a text field into an integer? i have a field thats padded by 0's on the left so you have numbers like 0000345, but the way they are stored in our db is just by the number 3-45 (with a dash) i have the dash removed in the select statement, but i need to remove the padding zeros from the other one to compare them... normally you can do that with integer conversion... but foxpro doesn't seem to like converting string numbers to integers? any help would be nice.. thanks! Tag: Get color pair Tag: 187702
  - 8
    - removeing char from string If i had a string like "3465-564576-3456-6" and i wanted all the dashes removed, how would you do that in foxpro? Tag: Get color pair Tag: 187700
  - 9
    - VFPOLEDB returning "Cannot update the cursor" Hi all, (And sorry for the double post for any .NET group readers) I'm trying to write to a VFP table from a .NET program using OLE DB. It returns 'Cannot update the cursor "cursor", since it is read-only.' The table is not open by any other source at the time and it wasn't flagged as read-only in the OS. I'm pretty ignorant when getting into OLE DB. Is there a setting in the driver that could be causing it? If so, direction as to where to address it would be great! TIA, John Tag: Get color pair Tag: 187694
  - 10
    - Tab Delim files with header import? If a file you are trying to import into a cursor is tab delimited and has a header column... how would you ignore the header column? im C++ we'd just read the next record, but since this is foxpro and things are diffrent, and im using APPEND FROM (fileName) DELIMITED WITH TAB as my statement... any suggestions? thanks Tag: Get color pair Tag: 187689
  - 11
    - Is it possible to change HeaderHeight property in a grid if View property is 1? If View property is 1 (Change), the header is viewed vertically. I want to change the width of the header. Is it possible? TIA. Tag: Get color pair Tag: 187687
  - 12
    - Visual foxpro executed file (.exe) if the executed file (.exe) was created in visual foxpro 7.0, is it possible to run it in visual foxpro 8.0? Tag: Get color pair Tag: 187684
  - 13
    - compare two fox tables Dear All, I wanted to findout whether user made any changes in a fox table. Is there any function to do this ? Thanks in advance Jijo David Tag: Get color pair Tag: 187680
  - 14
    - Install Problem with FPW26a Application I've got a real problem with a FPW2.6a program and I could use some big help on it! This is long but I don't know how to shorten it, sorry. Here's the problem: I have a program that has existed for many years and is downloaded over the internet. There have been a number of upgrades made and is currently on version 4.1. The program has been installed by hundreds of different people and more times than that by me personally with no problems. Yesterday I got a message from a new user using WinXP. He said he could not install the program and got the following error message during install: "An error has occurred in your application / If you choose Ignore you should save your work in a new file / If you choose close, your application will terminate." The error window within the FPW install window is titled "DSHELL". What I've done: I tried to install the program and I too got an error. On a Win98SE machine the error read similar indicating a problem with DSHELL. The "ignore" button does nothing. After using the "Close" button, the machine exhibits a "not enough memory" error if I try installing again without resetting the computer. I tried to install an older version of the same program and now get the same error (when I had installed from the same install files many times before). I re-setup the program within FPW26a and then tried another install. Got the same failure. As of now, I can not install any version of the program. I did a complete virus check on the machine and there is no virus. I know that the install program's setup.lst file shows, under [Params] section, that DrvModName = DSHELL but I do not know the significance of it. It seems to me that maybe one of the dlls that get installed by the FPW26a installer is bad and for some reason (?) replaced the one I had on my machine. This would have to be one of the old FPW era dlls since common ones would be dated much later and should not get replaced. I tried removing some some of these old dlls and replaced them with ones that came with FPW26a. Now I get a different error that "Bind time error. 'SPAWN' not found in specified library" before I can get to the original error. Any help would be greatly appreciated! Ray Tag: Get color pair Tag: 187679
  - 15
    - how can I get the loginname of user? Dear All, I want to ask that how can I get the login name on the viusal foxpro? since I need to use GETOBJECT() function get the user's detail information from the domain. Thank you!! Happy new year! Nic Tag: Get color pair Tag: 187665
  - 16
    - Newbie - Report Hi all, I would like to print this in report:- item Description of Goods Quantity 1 Apple 10 2 Banana 20 3 Orange 30 I just don't know how to print out the ITEM column, by writing up SQL statement properly. Many thanks. Regards, Wandy Tag: Get color pair Tag: 187661
  - 17
    - CDX structure Hi All! I am looking for CDX structure with terms explanation. There are many CDX and IDX docs but I dont understand their terms like "exterior node" etc. They say CDX is "similar" to IDC but I cant find this similarity ! Tag: Get color pair Tag: 187660
  - 18
    - Screen Font Easiest question of the day (I hope). When I do a "dir" or "list stru" from my VFP 8 command box, the font is too large. I have looked high and low and cannot find where to change it. Can someone tell me how to fix this nuisance? Thanks, Scott Tag: Get color pair Tag: 187657
  - 19
    - creating check boxes programmatically Hi all, I've recently started working on a project using microsoft visual foxpro 8.0. Unfortunately i met with some problems creating checkboxes wif values retrieved from a database table. Any help is appreciated. Thanks Tag: Get color pair Tag: 187656
  - 20
    - FoxPro Interop Okay, A foxpro programmer I am not, however...I wrote a class in vfp6. In this class I wrote a procedure that accepts three parameters. I compiled the dll. I wrote another app in VB6 that uses this class. Almost everything works. My only problem is with my parameters. I am trying to pass them by reference but I can't get it to work (and not sure that it will at all), does anyone have any thoughts on this? Could someone give me a template of how I would pass parameters by ref? I have seen the @ sign used, but I can't seem to get that to work...may be it's because I'm using vfp6... Thanks in advance. Tag: Get color pair Tag: 187655
  - 21
    - Fox 5&6 page frame instabilities I am writing a program for a company that has a truly computer phobic CEO. Because of that, I used a page framew with 9 pages to make it appear as simple as possible. The menu bar was to be accessed only by a computer literate staffer. When most of the program was done, it started exhibiting instablities that I couldn't get rid of. I tried manually controlling data and control issues. When that didn't work, I tried using as many automatic program building wizards as possible. That didn't work either. I tried using a floating window above the page frame with a menu bar inside it, and that had limited sucess. I can find nothing on the limitations of the number of pages and controls allowed in a page frame. I don't know if Fox 8 will work, and I'm reluctant to buy it and go to all the work involved in upgrading the program and then not have it work. If anyone has knowledge of a possible work-around, or knows whether version 8 would allow that many pages and controls, please let me know. Jack Hunt Creative Systems Tag: Get color pair Tag: 187654
  - 22
    - ADO and performance I'm working with an ADO connection via ODBC into a 1.3GB VFP table, and I'm finding it to be excruciatingly slow (don't ask why I'm doing it this way...). The recordset has about 5000 records in it. Doing a MoveFirst takes over 2 minutes. A query that retreives about 4700 records takes about 2 1/2 minutes. I'm wondering at this point if working via ADO is normally slow, and this is "normal" performance? Tag: Get color pair Tag: 187645
  - 23
    - Create a report file for email Happy Holiday To You All, I need to be able to print my report in a format (may be .PDF format?)so I'll be able to email them to my customers. Can you please help me. Thanks a million in advance, Nancy Tag: Get color pair Tag: 187634
  - 24
    - strange behavior in IDE for foxpro... Does anyone know what might be causeing this? Every time I go into a project and try to use the builder it says it cant be found... so i have to go reset the path to the builder each time the project loads... but it's not just the builder it doesn't remember the path to... there are a few others that get lost also... but when i make a brand new project, it knows where the builder is! only older projects from foxpro 6 are doing this.. (this is foxpro 7 right now) also, every time i run a form to test it, the controls toolbar (which i docked onto the toolbar spot on the top) gets undocked and moved back to a certin location (same place every time)... and the form window gets resized to smaller then maximized like i had it (the form designer window) it's getting kind of annoying and set as default in properties isn't helping much either... it just forgets the settings every time... any idea how to fix this? thanks -- ================================ Brian Henry The Reschini Group HTTP://www.reschini.com Tag: Get color pair Tag: 187632
  - 25
    - Error 1705 File Acces Denied I have a problem that someone out there may be able to help me with. We have a network with a server running Windows 2000 Server. There are several workstations on the network running different operating systems namely Windows 98 and Windows XP. The server primarily stays on continuously. Workstations are generally shut down each evening. On each of these systems there are two distinct programs accessing the same database's tables and indexes. One program is complied with Visual FoxPro 6.0 and the other is compiled with Visual FoxPro 7.0. For the most part this seems okay but we occasionally get an error message "1705 File access denied". We get this message at time when only one user is on the system with only one of the programs open after other users have been into and out of these programs. We suspect having the programs compiled under two different versions of FoxPro may be at the root of this. To get both programs compiled under the same version of FoxPro in this instance sounds easier than it will actually be. We're willing to do this if we had some good indication that this would solve the problem and it isn't something else say operation system related or say accessing the files with other programs namely Excel. Thank you in advance Tag: Get color pair Tag: 187631
- Next
  - 1
    - 3rd party VFP grid replacement Hello, I wonder if anybody uses 3rd party replacements for the VFP grid? I'm looking for a commercial OCX or native VFP Grid class that is able to do sorting, filtering, grouping, incremental searching, editing local and remote (MS SQL) data, printing/exporting grid content. Do you have any experience with the products below and VFP ?: ComponentOne True DBGrid (http://www.componentone.com/products.aspx?ProductCode=1&ProductID=67) DBI-Tech Grid Tools 2.0 (http://www.dbi-tech.com/show_products.asp?id_prod=8) or maybe you could recommend any other Grid classes or VFP frameworks with advanced Grid capabilities?. Regards, Marek Hryceniak Tag: Get color pair Tag: 187626
  - 2
    - Newbie - Report Hi all, I would like to do this, a statement SELECT ... INTO ARRAY aryRecord will load in the sales record in my report, I would like to do this 1) check if aryRecord is created (length of array > 0) 2) if is created, print the content of the array can I all do that in programming in report? Regards, Wandy Tag: Get color pair Tag: 187623
  - 3
    - C0000094 on Terminal Server I run vfp app on Terminal Server and change the registy on 2k sbs server ref. by article 299603: http://support.microsoft.com/default.aspx?scid=kb;en- us;299603 HKEY_LOCAL_MACHINE\System\CCS\Services\Mrxsmb\Parameters OpLocksDisabled : 0x1 HKEY_LOCAL_MACHINE\System\CCS\Services\LanmanServer\Paramet ers CachedOpenLimit : 0x0 HKEY_LOCAL_MACHINE\System\CCS\Services\LanmanWorkstation\Pa rameters UtilizeNTCaching : 0x0 It occur the following error message while running app : Fatal error : Expection Code=C0000094 and then close the app. client connect to Terminal Server O/S : Windows 2000 sbs server (Service Pack 4) app store on Data Server O/S : Windows 2000 Server (Service Pack 4) foxpro version of app : vfp8.0 sp1 What steps of configuration is missing? Thanks Ray Tag: Get color pair Tag: 187622
  - 4
    - Object Excel Properties Hi Expert, I look at the VFP 7 ...\SAMPLES\SOLUTION\OLE\OLEXL.SCX, inside the 'Examples 1' button event stated the following line: tmpsheet = GetObject('','excel.sheet') XLApp = tmpsheet.application XLApp.Visible = .t. XLApp.WorkBooks.Add() XLSheet = XLApp.ActiveSheet XLSheet.Cells(1,1).Value = PRODUCT_LOC XLSheet.Cells(1,2).Value = SALESJAN_LOC XLSheet.Cells(1,3).Value = SALESFEB_LOC XLSheet.Cells(1,4).Value = SALESMAR_LOC XLSheet.Cells(1,5).Value = TREND_LOC I want to know all property/method related to EXCEL object like 'Cells()', 'ActiveSheet', 'Add()','Save()','Copy ()', 'Move()' etc. Do you know from where I can get the those information. Thansk for advices Hidayat Tag: Get color pair Tag: 187621
  - 5
    - Newbie - Report Hi all, Is it true that you cannot edit a label field again? A real headache that everytime you want to edit a label field you need to remove that label field and recreate and refill the label again. Many thanks. Regards, Wandy Tag: Get color pair Tag: 187618
  - 6
    - wrong report page footer printing O/S 2000 sp4 vfp7 sp1 SYMPTOMS 1.data group is set, new page when group change 2.when fields on group footer band is overflow to next page, fields of page footer band is incorrect. WORKAROUND create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('1','') insert into table1 (f1,f2) value ('2',repl('X'+ chr (13),200) && overflow to next page insert into table1 (f1,f2) value ('3','') create new report named 'report1' add data grouping "f1" : set "Reset page number to 1 for each group" add report variables "vf1" : value to store : f1 on page header band : add a field "f1" on detail band : add a field "f1" on "group footer : f1" band : add a field "f2" ,set "Stretch with overflow". on page footer band : add two field ,"f1" and "vf1" do a command : report form report1 preview result : on page footer band when f1 group is 2 : field "f1" : 3 && wrong field "vf1" : 2 && correct on page footer band when f1 group is 3 : field "f1" : 3 && correct field "vf1" : 2 && wrong Tag: Get color pair Tag: 187610
  - 7
    - VFP8: running SQL scripts Hello. What is the best way to run a series of SQL scripts from *.sql files (for MS SQL Server) - for example for creating a database on client machine. Our application runs on CA classes, ADO. And 2nd question - any thoughts on integrating MSDE installation into InstallShield project - so far no success. M.Kujawa Tag: Get color pair Tag: 187607
  - 8
    - Running VFoxPro application on network I have an application developed in VFoxPro. Recently, I should run this application on network where 30 different users are working and manipulating data simultaneously. I wonder if it's possible to do it in Visual FoxPro as in other technologies like MS-SQL. Thank in advance. Tag: Get color pair Tag: 187602
  - 9
    - Walkthrough files in a project Hi all, I need to 'walkthrough' scxs, vcxs, prgs, and fxps contained in a specific project (say, test.pjx). Can anybody show me how to do that? TIA, Willianto Tag: Get color pair Tag: 187591
  - 10
    - OT: Looking for Help in Central New Jersey If anyone lives or is going to be around the North Branch, New Jersey area, please send me an e-mail directly if you can and are willing to help. As a favor to my wife, I would like to ask if someone can go to the Girl Scout store in North Branch and get some patches and mail them to me. I have the store address and phone number that I will reply back to you with. We will pay you for the patches and mailing. Thanks! Mark McCasland mmccasla AT airmail DOT net Tag: Get color pair Tag: 187588
  - 11
    - Foxpro nubie: Migrate 2.6 Unix to Windows? Hello all, I have a client that has been running an SCO Unix FoxPro 2.6 database and I would like to migrate it to Windows. Is it as easy as buying a Windows version of FoxPro and moving the actual database tables and forms? I'm prepared to do some work as necessary, but would like to understand the "got-ya's" before I quote the conversion. What would be the best version of FoxPro to convert into: Visual, etc.?? I have a good database background, but am unfamiliar with FoxPro. Any guidance or links to an FAQ would be much appreciated Thanks in Advance Ed O'Reilly oreilly@nospambasici.com (remove the nospam) Tag: Get color pair Tag: 187579
  - 12
    - OCR IN VFOX PRO Hi! M.XMAS! Please help me with this... i need to use some OCR library in order to recognize some images text, where can i find libraryes to add the ocr funtionality ot my programs? does anyone has some idea or advice about how can i recognize text images into text? (the images are not files, area areas in my monitor... i need to recognize some images shown in my browser) thankz beforehand JOSE Tag: Get color pair Tag: 187574
  - 13
    - Network printing We are changing our network environment from Novell to Windows Server 2003 and we have several FPD2.6 legacy programs that utilize network printing. With Novell I was able to capture the port and print directly to the printer. However, I have not been able to print to the network printers under our new Windows Server network. I have used the the following command with no success: SET PRINTER TO \\<Network Name>\<Printer Name> = LPT1: What am I doing wrong? The printer is connected to the network via a HP Jet Direct print server with TCP\IP addressing and it is identified through the server as a shared printer. How can I reach this printer from my FPD2.6 programs? Any and all help would be greatly appreciated. Thanks, Ted Tag: Get color pair Tag: 187573
  - 14
    - How to print in basic codes ? Hello all ! What's epson printer's code if I want to make my output font in 8 point size ? I use basic printing codes like : set alternate to myname.txt set alternate on ? ?? chr(27)+(m)+chr(18) && if i want to make font size in 10pci ? 'body text' set alternate off set alternate to *====================== Thank's alot for your kind information and help... Tag: Get color pair Tag: 187561
  - 15
    - Any idea how to implement internet billing software Hi everyone, A client of mine just opened an internet cafe in our town. He asked me whether I can embed automatic billing application into my-already-run-POS apps. He got 25 computers in his cafe. All connected with 100 Mbps Ethernet connections. He got a wireless connection to the internet, and most of his customers are using the computer to play ragnarok (online games). He charge his customer on time basis, and he wanted the system to automatically record computer usage time (and bill) whenever the customer login on one of the computer and stop the timer (and print the bill) when the customer logout. A friend of mine suggested that this will involve winsock programming. Honestly, I never touch winsock, so I think I just asked here first. Anybody here got any idea how to implement such application? Is VFP capable of doing real-time transaction (I mean, transaction that heavily depends on time). TIA, Willianto Tag: Get color pair Tag: 187559
  - 16
    - Problem with printing on continuos form paper Hi there, merry X’mast!!! , Why when I printing my report using continuous form formated paper (4 pages or mores..) the position of contents different, start from page 3 if I compared it with page 1 ? (My codes: REPORT FORM myreport to printer noconsole nopageeject ) My printer is : LQ 1170 (custom size: W=22 x H=14 cm) Thank’s a lot for your help….. Tag: Get color pair Tag: 187557
  - 17
    - Any idea how to access task in outlook? I would like to update tasks in outlook, any tips? Tag: Get color pair Tag: 187555
  - 18
    - [OT]: Merry Christmas to all Foxers in the world! Hello everybody, It's 11:00 pm here in Indonesia. I just came home from my parents' home and had a wonderful Christmas day with all of my family. I wish you all the happiest Christmas ever. Merry Christmas to you! Merry Christmas to our Fox! Regards, Willianto P.S: I hope that I can have my next Christmas (2004) in New York! Tag: Get color pair Tag: 187551
  - 19
    - Visual Fox with SQL Server 2000 I want to Know as to save and to select in Visual Fox images(*.BMP) from SQL Server??? Which is the code or tool to save from Visual Fox to SQL server??? If I can save image in SQL server 2000??? Thanks.... Tag: Get color pair Tag: 187544
  - 20
    - OLE DB Support on remote server Hi all, We'll be deploying on a web server that we don't directly control but the owner is usually open to configuring as we wish. We've starting doing some new ASP.NET development using VFP's OLE DB Provider. My question is how does one install the OLE DB Provider? The help file indicates registry entries that result from an installation, but I can't seem to find the steps to set up in the first place. TIA, John Tag: Get color pair Tag: 187542
  - 21
    - Foxpro 2.6 I have an old version of foxpro 2.6 on 7 floppy discs. Disc 7 does not work, and burning a copy from the computer that has foxpro on it doesnt work either. Can anyone help. I will pay for disc 7 if necessary. Thank you. Dave Tag: Get color pair Tag: 187535
  - 22
    - corrupted data VFP6.0 i have a table that it says <<not a table>> any GOOD utilities that fix data? or any ways to fix this ? Thanks -- George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/6/2003 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Get color pair Tag: 187532
  - 23
    - set NULL values! Hi All, This time I have an easy question that may drive to your attention. I have a database table like this: Table Name: products col1 col2 col3 col4 AAA 432 57 BBB 10 CCC 493 20 29 DDD 293 28 I want to printout 3 records only as col2 and col3 are not NULL. What the command should be? I had tried the following commands, but it doesn't work. repo form products for isNull(col2)=.F. and isNull (col3)=.F. prev Please correct the mistakes as I mentioned above, many thanks. Sam. Tag: Get color pair Tag: 187517
  - 24
    - Create Image Hello: I have Visual FoxPro 8.0 clients that connect to SQL Server 2000. I need to display a *.bmp image in Visual Fox that stays on the Server end. What is the code or tool that I can use in FoxPro to create this? It is important that the image is recorded on the server end. Thank you. Tag: Get color pair Tag: 187514
  - 25
    - Project building VFP8/XPP When I build a project, I do not want the image files to be included in the final executable file. Even if I modify the project to specifically remove those image files in the project, after building the executable, I found the images are back inside the project and inside the executable file as well, resulting in a jumbo size executable file. What do I have to do to prevent the images being built inside the executable file? sp Tag: Get color pair Tag: 187509

? RGB(255,255,255) &&display 16777215

What is the function to convert 16777215 into pair of 255,255,255 ?

Thank to all

Top

Re: Get color pair by Roger

Roger
Wed Dec 31 08:14:20 CST 2003

budieko <eko_dja@myrealboxJUSTREMOVE.com> wrote:
> ? RGB(255,255,255) &&display 16777215
>
> What is the function to convert 16777215 into pair of 255,255,255 ?
>
> Thank to all

Try ...

?ColorNumToRGB(16777215)

Function ColorNumToRGB
LPARAMETERS nColor
LOCAL lnR,lnG,lnB
lnR=BITRSHIFT(BITLSHIFT(nColor,24),24)
lnG=BITRSHIFT(BITLSHIFT(nColor,16),24)
lnB=BITRSHIFT(nColor,16)
RETURN "RGB("+TRAN(lnR)+","+TRAN(lnG)+","+TRAN(lnB)+")"
EndFunc

-Roger
--
Roger Ansell
Australian President
FE AVP et Cie
Adelaide, Australia

My real email address is ransell at senet dot com dot au

Top

Re: Get color pair by budieko

budieko
Thu Jan 01 16:32:32 CST 2004

Many thanks Roger, this's very helpfull :)

Top