Dynamic Back/Fore colors

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
    - Fox Report Writer - Sideways Text? Can you rotate text in Visual FoxPro Report Writer (VFP v.6.0 SP3)? Tag: Dynamic Back/Fore colors Tag: 197842
  - 2
    - Store Japanese characters from FoxPro into SQL Server? Greetings! I have an application that can happily store and retrieve Japanese characters into a stand-alone FoxPro database. Now I need to write them into nvarchar fields in SQL Server tables. SQL Server is expecting them in Unicode. I have an edit box into which I can enter Japanese characters through an input method editor. I haven't been able to figure out how to massage those characters to get them into Unicode and then into the SQL Server table. What hoops do I have to jump through? Thanks! RobR Tag: Dynamic Back/Fore colors Tag: 197836
  - 3
    - Pack causing intermittant fatal error VFP7 SP1 I originally posted a message about this problem on 12th May. I am beginning to think it may be a problem with the user's PC. As the crash happens during a pack and the file has actually disappeared from it's original place, the fatal error must be happening at the point where VFP deletes the original table from disk and renames the temporary table with the original table name. Where on the user's machine would this temporary table be located? We do not use any Config file. Is it the Windows temporary directory? Could there be a problem with that user's windows temporary directory or permissions to that directory? Note - the file that is being packed is not particularly big. Any help would be appreciated. Bernie. Tag: Dynamic Back/Fore colors Tag: 197810
  - 4
    - Visual SourceSafe with VFP8 I stopped using VSS a long time ago (found it presented many errors) when I was using VFP6. I didn't have time to sort all of the issues out back then. Now I am up to VFP8 and would like to get back to using some sort of CVS system. Will the version of VSS (6?) that I got with Visual Studio 6 work with VFP8 or should I be looking at an alternative CVS system? Perhaps a newer version of VSS. Ideally if an alternative one I would like it to be freeware. But then who wouldn't. -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Dynamic Back/Fore colors Tag: 197808
  - 5
    - FPW2.6a SCAN FOR missing records Hello, this is driving me crazy :( I have a screen that lets the user add/remove multiple items to an assembly. The items are stored in an array whilst they edit and then stored in the main table if they save. The save routine looks like this: SELECT pri_det m.arrayref=1 m.arraylen=ALEN(priceinf,1) SCAN FOR wk_ref = m.ref IF m.arrayref<=m.arraylen * already existing record - replace contents REPLACE pri_det.saparticle WITH RIGHT(priceinf[m.arrayref],6) m.arrayref=m.arrayref+1 ELSE * array has fewer records than table - delete record DELETE ENDIF ENDSCAN * add any remaining records from array to table DO WHILE m.arraylen>=m.arrayref INSERT INTO pri_det VALUES (m.ref,RIGHT(priceinf[m.arrayref],6)) m.arrayref=m.arrayref+1 ENDDO Sometimes when they remove items, this doesn't work correctly and the SCAN..ENDSCAN doesn't loop all the records in its FOR clause. Does anyone know WHY!?!! 1) There is no filter set. 2) I've recreated the indexes with INDEX ON. (although I haven't tried a SCAN.. NOOPTIMIZE yet) 3) I've pulled that routine out into a separate program (working on the same table) to try to reproduce and it seems to work fine. 4) I wrote a little program that SCANS the same clause just doing an incremental count to a vraible and then display the result in a wait window. I used my screen to remove some items and broke the save routine just before the SCAN. At this point I ran my counting program - it showed a SCAN FOR wk_ref=m.ref count of 5 records. When then went on to single step the save routine it only SCANned 3. What on earth could possibly be wrong here? -- TIA Andrew Howell Tag: Dynamic Back/Fore colors Tag: 197805
  - 6
    - How to print image file from VFP report? Hi all, I have some problem about VFP7 report. I want to use report to print the image that I have scan from the document in tif type but the report ole image can use only bmp and jpg.Is the vfp7 report can use only this two type? And when I use BMP file which greater than 1 meg the report can not run, it is error. How can I do? Thank you for your advise. Kitty Tag: Dynamic Back/Fore colors Tag: 197804
  - 7
    - Saving Picture in SQL Server Hi there, I need to know how can i save picutre in SQL Server table. I am using VFP 6.0 as front end and SQL Server at back end. I have already tried FILETOSTR() AND STRTOFILE() Function which performs well with Foxpro table but it does not work with SQL Statement as follow; tmpString=FILETOSTR("Picture.Bmp") =SQLExec(connHandler,"Insert Into temp (EmpPhoto) Values ('"+tmpString+"')") It looks String already contains some single quotes which creats ambiguity. Would be very thankful for any help in this regard. NR Tag: Dynamic Back/Fore colors Tag: 197803
  - 8
    - Coordinated grids and a lookup textbox I have 3 grids on a form, a parent(name) & 2 children (phones & emails). I have the grids set up so that as the user scrolls through the parent grid, the other 2 grids update themselves appropriately. Now I'm adding a textbox to serve as a quick look up for names in the parent grid. I do a locate for .../ if found(), etc... in the interactive change of the textbox and the parent grid updates itself correctly. Unfortunately, not only do the child grids NOT update correctly, they no longer track the parent grid if the user goes back to the parent & begins scrolling again. Calling the respective refresh methods doesn't seem to work. What to do? Any ideas? -Lew Tag: Dynamic Back/Fore colors Tag: 197802
  - 9
    - Check Box in VFOXPRO Always shows that it is ReadOnly Hello, I am still new to VFoxpro and in need of some advice. I have a new form that I created and I have included some Check boxes. Whenever I RUN the form and try to click on the Checkbox, the message that I see at the bottom left hand side is "The control is Read-Only". How do I get my application/form to not display this message and allow me to click/unclick the checkbox? Thanks alot, Eddy. Tag: Dynamic Back/Fore colors Tag: 197799
  - 10
    - Making CTRL+A Work in a Listbox Hi all. I would like to make CTRL+A work to select all items in a multi-select listbox. I've run into the problem that the CTRL+A combination won't register in a KeyPress() event of either a form or a control. I've come up with the following code that encapsulates a working solution within a listbox subclass as well as I can figure out. Of course, I'm aware of problems with using ON KEY LABEL and PUBLIC variables. If anyone can suggest a better way to do this, that would be very much appreciated. TIA, Ken Dibble Southern Tier Independence Center *** CTRL+A LISTBOX DEMO *** RELEASE ALL CLEAR ALL CLEAR LOCAL oldsafety oldsafety = SET("SAFETY") SET SAFETY OFF PUBLIC oForm oForm = CREATEOBJECT("Form") oForm.AddObject("Text1","Textbox") WITH oForm.Text1 .Top = 5 .Left = 5 .Height = 22 .Width = 100 .Visible = .T. ENDWITH oForm.AddObject("List1","MyListbox") WITH oForm.List1 .Top = 5 .Left = 120 .Visible = .T. ENDWITH oForm.Show(1) IF NOT EMPTY(oldsafety) SET SAFETY &oldsafety ENDIF RELEASE oForm DEFINE CLASS MyListbox AS ListBox RowSourceType = 1 RowSource = "ONE,TWO,THREE,FOUR,FIVE" ColumnCount = 1 ColumnWidths = "80" MultiSelect = .T. Height = 150 Width = 100 PROCEDURE Init ERASE handlectrla.prg ENDPROC PROCEDURE GotFocus THIS.Selected(1) = .T. THIS.SetupKeyHandler() ENDPROC PROCEDURE LostFocus THIS.ClearKeyHandler() ENDPROC PROCEDURE SetupKeyHandler LOCAL progstr TEXT TO progstr NOSHOW FUNCTION HandleCTRLA(oForm) IF UPPER(oForm.ActiveControl.BaseClass) == "LISTBOX" oForm.ActiveControl.SelectAllItems() ENDIF ENDFUNC ENDTEXT STRTOFILE(progstr,"handlectrla.prg",0) SET PROCEDURE TO handlectrla ADDITIVE PUBLIC oFormRef STORE THISFORM TO oFormRef ON KEY LABEL CTRL+A handlectrla(oFormRef) ENDPROC PROCEDURE ClearKeyHandler oFormRef = .NULL. RELEASE oFormRef ON KEY LABEL CTRL+A ERASE handlectrla.prg ENDPROC PROCEDURE SelectAllItems FOR x = 1 TO THIS.ListCount THIS.Selected(x) = .T. ENDFOR ENDPROC PROCEDURE Destroy THIS.ClearKeyHandler() ENDPROC ENDDEFINE *** END CODE *** Tag: Dynamic Back/Fore colors Tag: 197797
  - 11
    - error VFP 8 0: Class definition MSXML2.DOMDOCUMENT.4.0 is not found Hi, I had to uninstall VFP8 in order to reinstall VFP6 and then VFP8 again... however when I finished the Task pane Manager is showing this error message: 0: Class definition MSXML2.DOMDOCUMENT.4.0 is not found this was not happening the first time I installed VFP8 I already have tried to uninstall both VFP6 and VFP8, and installeng thean both agaon, but it did not fixed the problem, I also tried unsuccesfully "Repairing " VFP8 I would appreciate any suggestion thanks Oscar Taboada Tag: Dynamic Back/Fore colors Tag: 197783
  - 12
    - vfp 6.0 book Hi, I'm from the Philippines, the VFP6.0 Programmer's Reference book is no longer available in any book store here, is there anybody who could help me get a book of such? i've tried ordering throught the internet but all prospective agencies/couriers does not deliver in this country. from the last query that i made, they only deliver in Singapore. Pls help, i'm new in vfp OOP, i desperately need this book as reference. Thank you very much and more power. Tag: Dynamic Back/Fore colors Tag: 197779
  - 13
    - Pocket PC and VFP Hi All, I have a new project, I want to control inventory using a Pocket PC. I don't have the time to learn a new programming language. Is there a way to program an application in Visual FoxPro and run it on a Pocket PC with Windows CE ?? If not is there another logical solution. Thanks in advance. Tanya Tag: Dynamic Back/Fore colors Tag: 197775
  - 14
    - keybd_event(, , , ) What would be the numbers for alt+ctrl+P? Tag: Dynamic Back/Fore colors Tag: 197773
  - 15
    - toolbar Using VFP 6, I use toolbar which is currently docked horizontally at the top LHS of the screen when forms are opened. I have two questions. 1. Because some buttons are inappropriate for some forms, the init for those forms calls a method in a class which makes those buttons visible property = .F.. In some cases, while this works OK otherwise, the toolbar is no longer horizontal but some buttons appear on a second line under others and I have to drag the toolbar manually to correct it. What causes this and how do I fix it ? 2. What I would really like is to have the toolbar docked centrally under each form which calls it. But as the forms are all different sizes this means that it needs to be in different places for different forms. Is there any way to achieve this ? Thanks -- Tim Hobson Tag: Dynamic Back/Fore colors Tag: 197764
  - 16
    - "Hidden" files attached to a form? Hi, I created an exe w/VFP8(SP1) and sent it to a friend. When he ran it, he got several messages re. missing files. The exe ran OK after choosing "Ignore" for each file. There was no problem in my testing because I have those files. Most of the "missing" files were temporary files (012345678.dbf, etc) but some were dbf's on my system that he doesn't have or need. From what I can tell, the error messages come up when DO FORM is encountered and before any of my code in the form executes. The trace shows that the program stops at DO FORM and before READ EVENTS. I suspect the files may have been open when I created the exe and somehow, VFP assumed they were needed. They are not needed and are not in the project. My exe uses only free tables and the default database (i.e. I never specified a database). I was able to fix this by deleting all the files that were being called. I also made a slight change to the form so that it would get re-generated when I re-built the exe. But that's only a stop-gap solution since it seems it could happen every time I build an exe and I have no way to know what files might be needed until I distribute the exe and get feedback from others. That's not a good thing. I've only been using VFP8 for a short time but I don't think I've ever seen this in VFP6. What can I do to prevent this from happening in the future? Thanks, Frank Tag: Dynamic Back/Fore colors Tag: 197759
  - 17
    - Alternative to upsizing wizard I have a VFP database that has some "unusual" features in indexes and views, like some IIF's, PADR's, UPPER's, etc., that the upsizing wizard doesn't know what to do with. Since I'm new to SQL Server, I don't know what to do with them either. Anyone have suggestions? Should I just simplify the VFP database? That would require some modifications to the application. -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - 2 0 0 4 at y a h 00 Tag: Dynamic Back/Fore colors Tag: 197756
  - 18
    - Automatically E-mail Reports I'm new to this group and need some help. I consider myself a novice when it comes to VFP. I'm looking for an easy way to modify our database to automatically E-mail packing lists to a static E-mail address at one of our sister companies. I'm finding this a challenge because there are no comments in the code and I was given no programmers documentation. I found a plugin called eReports that will do this, but I can't for the life of me follow their examples. I'd like to convert the report to .htm format then I'd like to send it out as an attachment without the user noticing. Before everyone starts yelling "post on eReports forum for help" I've already posted a message on their forum and haven't received response yet. I'm running Visual FoxPro 6.0 with Service Pack 3. Any help would be appreciated. ***** Here is the eReports snippet for converting to htm format ****** LOCAL lnResult, oHTML oHTML = NEWOBJECT("eReportsHTML", "eReports.dll", "eReports.dll") oHTML.ReportFile = "myReport.frx" lnResult = oHTML.ReportConvert() RELEASE oHTML ***** Here is the eReports snippet for SMTP ***** LOCAL loSMTP, lcRecipient, lcName, lnResult loSMTP = NEWOBJECT("eReportsSMTP","eReports.dll","eReports.dll") loSMTP.Unlock("Organization - E8FTY 4JR8S 2JX4R 49FJR") loSMTP.SMTPServer = "mail.johndoe.com" *-While not required, some SMTP servers need this. If you get -505 *-error, this is the likely solution. loSMTP.SMTPDomain = "johndoe.com" *-Optional loSMTP.SMTPLogFile = "c:\SMTPLog.txt" loSMTP.FromAddress = "support@johndoe.com" loSMTP.FromName = "Support" loSMTP.Subject = "Test" loSMTP.MessageBody = "This is a test" *-Alternatively Insert a message file between the quotes below *-The message file can be an exisiting boilerplate text/rtf file or an *-html file generated by eReports. *-If the message file is HTML, set the MessageFormat property to 1 or 2 (see help) *loSMTP.MessageFormat = && valid parameters are 0,1,2,3 (see help) *loSMTP.MessageFile = "" && "C:\eReports\Output\myreport.htm" *-The first parameter is the friendly name like "John Doe" or "" for empty *-The second parameter must be a valid email address *-The third parameter is the recipient type - 1=Normal, 2=CC, 3=BCC lcRecipient = "jdoe@johndoe.com" lcName = "John Doe" loSMTP.AddRecipient(lcName,lcRecipient,1) *-Include an optional attachment file by adding the file name between the quotes *-below or using a variable that points to an existing file. lnResult = loSMTP.AddAttachment((lcPDFFile)) lnResult = loSMTP.SendMail() IF lnResult = 0 MESSAGEBOX("Message Sent",0,"System Message") ELSE MESSAGEBOX("An Error occured:"+CHR(13)+loSMTP.ErrorLog,0,"System Message") ENDIF RELEASE oSMTP ***** This is the Exit command button code where the packing lists are printed in our database ***** if times=0 thisform.mybutton1.cmdnext.click endif private is_tally is_tally=0 thisform.label1.visible=.t. thisform.edton_hold.enabled=.f. thisform.command1.enabled=.f. thisform.refresh select exe_packinglist_0 replace on_hold_a with thisformset.form3.edton_hold.value if tableupdate(.t.)=.f. messagebox("Error in saving exe_packinglist_0.",0+16,"Error") tablerevert(.t.) else thisform.lockscreen=.t. scan thisformset.qtyorder_num=exe_packinglist_0.order_num_a thisformset.qtyseq=exe_packinglist_0.packing_seq =requery("exe_packinglist") select exe_packinglist replace on_hold with exe_packinglist_0.on_hold_a all if tableupdate(.t.)=.f. messagebox("Error saving exe_packinglist "+alltrim(Exe_packinglist.model_a)+".",0+16,"Error") tablerevert(.t.) endif select exe_packinglist_0 endscan thisform.lockscreen=.f. endif thisform.label1.visible=.f. thisform.edton_hold.enabled=.t. thisform.command1.enabled=.t. thisform.refresh select approval_pl scan thisformset.qtyorder_num=approval_pl.order_num thisformset.qtyseq=approval_pl.seq =requery("doc_pl") if _tally!=0 is_tally=1 report form doc_pl to printer noconsole endif endscan if _tally<>0 thisformset.form4.visible=.t. thisformset.form4.show thisform.enabled=.f. endif **************************************** Again, if anyone can point me in the right direction (or at least help me get started), I would appreciate it. Best regards, Tom Tag: Dynamic Back/Fore colors Tag: 197744
  - 19
    - global datasession It appears that even though Datasession 1 is called the "global data session" it is not actually global because when you are in another datasession you apparently can't access tables in datasession 1. Is that correct? Assuming it is correct, what would be the best way of having certain tables that you want to make available to all the forms in an application, even though these forms have private datasessions? The application I have is a school application that needs read access to student records from many different forms. I have standard procedures that have been opening up the student data files and reading from them when I need information, but the coverage profiler shows that this is a real performance killer. It would be much faster to have the tables open all the time for read access. I could simply open the tables when I start each form that needs access, but having a global instance of the tables would be quicker and more helpful. Kevin Clark Seton Home Study School Tag: Dynamic Back/Fore colors Tag: 197739
  - 20
    - Grids on form with Private Datasession and 3 tier application Please could someone give me a pointer in the right direction on this please. I am developing a small application but I would like to stick with the 3 tier architecture if possible. My forms are modeless with private datasessions. The problem is, I would like to display a recordset in a grid on my form. The grid control will only allow a table/cursor as a record source so I need some way to get that recordset through the tiers. I have tried creating a cursoradapter but the cursor gets created in the default datasession instead of the private one. I am on the verge of just coding the data access straight into my grid control but that would break the 3 tier design. Is my best option ADO or another idea? If I use ADO is there a grid that will accept ADO as a recordset or do I have to convert it back to a cursor? Your thoughts please. -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Dynamic Back/Fore colors Tag: 197737
  - 21
    - Conditional Counter field .. Want to add a Counter field to a Table which should be incremented only if certain field in the table is NOT EMPTY() ? How can I achieve this ? Urgent Response is urged. TIA Tag: Dynamic Back/Fore colors Tag: 197734
  - 22
    - VFP6 and Excel Hi I have a program in VFP6 that has OLE excel worksheet in a form I am able to print what I want by calling oXObj.PrintOut() but I can't get .PrintPreview to work. I would also like to be able to bring up the standard Print Dialog window can anyone help me with this. Any help greatly appreciated. Warren warrenjw@austarnet.com.au Tag: Dynamic Back/Fore colors Tag: 197729
  - 23
    - VFP6 & VFP8 on the same computer Hi, I have upgraded my computer from VFP6 to VFP8 for what i had to uninstall VFP6, however I have a framework (Visual Promatrix 6.0) that is sending error when I try to execute under VFP8.... is it possible to have both VFP versions installed concurrently on the same computer? how? thanks Oscar Taboada Tag: Dynamic Back/Fore colors Tag: 197728
  - 24
    - FPW2.6a changing browse title In FPW2.6, can I change the title of a browse window without releasing / redisplaying the browse? * something like this, but working ;) ***************************************** CREATE CURSOR test (test L) m.ltitle="text1" ON KEY LABEL f12 DO chgtitle BROWSE TITLE m.ltitle **************************** PROCEDURE chgtitle **************************** PRIVATE m.loldtitle m.loldtitle=m.ltitle m.ltitle="text2" SHOW WINDOW (m.loldtitle) REFRESH * also tried MODIFY WINDOW (m.loldtitle) TITLE (m.ltitle) *eof At the moment I'm doing this: ************************************* CREATE CURSOR test (test L) m.test="text1" m.looping=.T. ON KEY LABEL f12 DO chgtitle ON KEY LABEL esc DO killit DO WHILE m.looping BROWSE ; TITLE m.test ENDDO ON KEY LABEL esc ON KEY LABEL f12 ******************* PROCEDURE chgtitle ******************* PUSH KEY CLEAR RELEASE WINDOW (m.test) m.test=IIF(m.test="text1","text2","text1") POP KEY ******************* PROCEDURE killit ******************* PUSH KEY CLEAR m.looping=.F. RELEASE WINDOW (m.test) POP KEY *eof -- TIA Andrew Howell Tag: Dynamic Back/Fore colors Tag: 197721
  - 25
    - Create Label generates C0000005 error I have a VFP8 SP1 application (compiled EXE) that generates a C00000005 error whenever I run "MODIFY LABEL XXX" or "CREATE LABEL XXX" (xxx does or does not exist - makes no difference). I have another VFP8 SP1 application in the same directory (Command prompt emulator) that does not give C00000005 error. In both cases, no tables are open so it has nothing to do with data file corruption, indexes or a corrupt label file. Any ideas? Cheers David Younger Tag: Dynamic Back/Fore colors Tag: 197719
- Next
  - 1
    - Any real speed advantage with dual Xeon processors? Hi, I'm looking for the fastest performance I can get on a networked VFP app. The server which holds the data is currently dual Xeon, lots of RAM, Win 2003 Server, 15K SCSI drives, 10/100BaseTX LAN. My current idea is to upgrade the server to 1000BaseTX, and buy a dual Xeon workstation, plenty of RAM, 1000BaseTX, 15K SCSI drives and XP Pro. The app only needs to work on the one workstation, and the server is simultaneously handling data for 50+ other workstations with lower performance requirements. The data is all free table - I can't use DBCs/stored procedures because of FPD apps sharing the data. Do the dual processors make a difference to workstation speed with VFP? Does anyone have any better ideas? VFP7, but going VFP9 as soon as it's available. Regards, Neil Tag: Dynamic Back/Fore colors Tag: 197713
  - 2
    - How to get images to be added automatically to project I am trying to setup my app so that if I create a new project and add the startup routine, all necessary routines will be automatically added to the project. I do this by having a dummy routine that never gets called, that references all forms, classes, and reports. I also have a bunch of images I want added to the project that are not directly referenced. Any ideas how these could be referenced in a dummy routine so that the project will automatically add them on rebuild? Tag: Dynamic Back/Fore colors Tag: 197711
  - 3
    - PowerTCP UDP Control Does anyone have any experience using PowerTCP's UDP Control. Tag: Dynamic Back/Fore colors Tag: 197699
  - 4
    - DBI-Tech ctTree Activex -- anyone know how to get node information Does anyone Know how to get node information such as text value when user clicks on a node from DBI-Tech ctTree activex control? ALso how do you know if the node you clicked on is a parent or child node? thanks Nick Tag: Dynamic Back/Fore colors Tag: 197687
  - 5
    - DBI-Tech ctTree activex -- how do I get node information? Does anyone Know how to get node information such as text value when user clicks on a node from DBI-Tech ctTree activex control? ALso how do you know if the node you clicked on is a parent or child node? thanks Nick Tag: Dynamic Back/Fore colors Tag: 197686
  - 6
    - Not enough memory message when joining source control project File -> Join source control project. This is a large project with several thousand files. VFP apparently does a get latest on the PJM file, builds a new PJX., and then does a get latest on everything in the PJX. When it finishes, I get "There is not enough memory to complete this operation". At the time this occurs, VFP is consuming 20MB physical memory, 10MB swap file, 209 GDI objects, and 2911 USER objects. This last entry concerns me, as 2911 USER objects is quite high and is probably why the error occurs. VFP will normally have less then 100. Historically, excessive USER or GDI usage is a result of poor programming, bugs, or memory leaks. I also think that this should work, even if it is using a lot of USER resources. Win2000/XP doesn't have the terminal USER or GDI limits that Win9x had, so I'm thinking that the problem here is internal to VFP. Also, it works for some of us, and not for others. It's not just my workstation, as I'm not the only one having this problem. Any ideas? Tag: Dynamic Back/Fore colors Tag: 197681
  - 7
    - VFP 9.0 beta help file I have downloaded and installed the beta of VFP 9.0. The help file does not function, and I wonder if this is the way the beta was released. Should I try downloading and installing again, or is this feaure just not working in the beta? -- seeker Tag: Dynamic Back/Fore colors Tag: 197678
  - 8
    - Watch for a fake bill Hi FP community, Make sure to watch out for a fake bill from Stonefield ... I guess they are desperate enough for business that they have resorted to sending a fake bill to try to get return customers. Very, very unethical business strategy in my opinion. Tag: Dynamic Back/Fore colors Tag: 197672
  - 9
    - dbf and php there is an example to open with mysql and php a foxpro database? Tag: Dynamic Back/Fore colors Tag: 197663
  - 10
    - Tables with buffering VFP 80 Sp1 XP My form allows the user to add a record. (In this case to the zip code table). I control my "Save" and "Undo" according to certain rules. If the user enters a zip code that is already in the table, I want to prevent the "Save" from enabling. However, on the LostFocus of the textbox for the zip code, I will automatically save the record when I seek that code. How do I determine if that zip code codes not already exist? I could open the table twice, but that seems a waste. TIA Tag: Dynamic Back/Fore colors Tag: 197651
  - 11
    - _Screen.Image When an Image object is added to the _screen to show some picture or graphic and a user later runs a report in Preview mode, periodically the image object on the _screen, continues to show the report preview image even after the report preview has been released. It is as if the graphic image from the report preview window, overlays, changes or corrupts the PICTURE of the IMAGE object on the _screen. Has anyone else seen this behavior/bug, and if so, any ideas what causes it or how to fix it short of destroying the _screen.image object and re-adding it to _screen? Thx Alec Tag: Dynamic Back/Fore colors Tag: 197648
  - 12
    - Sql Server Question Assuming I have a table stored in SQL server. What is the best technique advised as to searching for a particular record since the Seek command can not be used. The two options that comes to my mind is the Locate and the set filter command. If the particular field I am searching for has been defined in SQL server as being an index key, how can one perform a search that would not be considered sequestial and move the record pointer to the record desired as in the seek command. Many thanks in advance. Shahriar Tag: Dynamic Back/Fore colors Tag: 197647
  - 13
    - displaying records through a preview window Hi, what and how would be the easiest way to display records in a pre-formatted preview window in vfp6.0? before with 2.6, i redirect the formatted report to a text file, viewing the result through 'modi comm (text output file)' and terminating the preview report throught the ESC button. With 6.0, i've heard of so many ways to implement it, i dont know now what to use as my standard program procedure? I'm thinking of using a 'Microsoft Word Document Viewer'. will this simplify my class creation and maintenance? Thank you very much and more power! Long live Foxpro! Tag: Dynamic Back/Fore colors Tag: 197646
  - 14
    - Cryptor IV fll file I can't seem to get a response from Xitech on the issue but they advertise the Cryptor IV is compatible with VFP 8 but there is not an fll for VFP8 included in my copy. Is there an fll for VFP8? And if so does anybody have it and can I get a copy. This should not be a problem as I can't use the fll without a legit copy of he rest and I have that and all. But it makes it a little hard to use the product in VFP8 without the fll since you have to have the proper version of the dll for each version of VFP that is supported. I have tried emailing Xitech on the issue several times and have not gotten any response from them at all. Tag: Dynamic Back/Fore colors Tag: 197644
  - 15
    - dbf encrypting data Is there an easy and efficient way of encrypting data in dbf's? Looking for something simple.. thanks Tag: Dynamic Back/Fore colors Tag: 197636
  - 16
    - Adding events VFP80 SP1 on XP I have a basegrid in MyClass. I have added it to a form. When I run the form, I programmatically want to add a column and a Click() event to that column. I do not understand the Help screens on this issue. Anyone have a simple example. TIA Tag: Dynamic Back/Fore colors Tag: 197629
  - 17
    - set confirm and end of input ContainerA .textbox ContainerB 1. With SET CONFIRM OFF, how could I make a particular textbox on a form NOT to fire its valid()/lostfocus() event unless the user hit <enter>? 2. and when the user did hit <ENTER>, containerB will be made visible while containerA would be made invisible via containerA.textbox.lostfocus(). Any neat way to prevent containerA.textbox.valid() from being fired again when containerB was made visible? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:24am up 16:25 0 users 1.72 1.89 Tag: Dynamic Back/Fore colors Tag: 197628
  - 18
    - textbox focus (VFP6 unpatched) In one form, after going through a few events, a textbox.setfocus() was called, with textbox.format="K". Though the textbox got focus, the text inside was not selected (note the textbox.format) and sometimes, even the cursor is not inside the textbox, going somewhere. sometimes, the textbox, while in focus, didn't echo the text I inputted, though beneath the "surface", it's taking the input. The behaviour returned to normal after textbox.valid() fired once. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:16am up 16:17 0 users 2.11 2.06 Tag: Dynamic Back/Fore colors Tag: 197627
  - 19
    - simulate PRINT-SCREEN I use VFP 8.0 I would like to simulate the print-screen (stamp) button Any ideas ???? thanks KEYBOARD '{ xxx }' Tag: Dynamic Back/Fore colors Tag: 197626
  - 20
    - Datagrid control for VFP 8? Does anyone have a recommendation on a grid control for foxpro outside of the Datagrid control that is shipped with VFP 8. Many thanks Shahriar Tag: Dynamic Back/Fore colors Tag: 197625
  - 21
    - cannot using "GROUP BY" clause hi why i can't include GROUP BY clause in my SQL-string ? thank Tag: Dynamic Back/Fore colors Tag: 197616
  - 22
    - Menu Creation I have created menu using menu command Everthing works fine through command window i.e. do program name. But, when i generate the EXE it does not work, Programme exits directly. Tag: Dynamic Back/Fore colors Tag: 197610
  - 23
    - Complicated form with many search options Hello, I'm creating a form to manage serialized goods. The form shows data from 9 different tables. I also need to allow the user to search on a combination different parameters: Serial number Description GL Accounts Payment Due date Retail price Received Date AP Invoice # Categories They can search on as many or as few as they want. When faced with a form of this complexity, is it best to go with a CURSOR and update the records by hand, or is it best to use a view. The downside of the cursor is that it requires more work to commit the changes to the back end table. The advantage is that I have a lot more flexibility with my query statement. The downside of using a view is that I have to include all parameters in every search whether the user search on it or not. The advantage is that I can bind a view to the form itself and TABLEUPDATE() will handle the changes for me. Another problem is that a couple of my search fields are variable list matches that I make with a sub query against a temporary cursor and this might be difficult with a view (a variable table name parameter?) Does anybody have any tips on ways to go about this? Sincerely, Caleb Land Tag: Dynamic Back/Fore colors Tag: 197606
  - 24
    - NTFS system I need to know if our program is running on NTFS. I figure I could do this with OS(11). I am just checking if this is right. We only have NTFS stations so I can't see what a Win 98 will return with that function. I am guessing it will return a 0. Is this right? Tag: Dynamic Back/Fore colors Tag: 197592
  - 25
    - What am I missing in outer join query I am having problem with outer join in query. I am sure I am missing something and I am sure someone will point me the right direction. I have 2 tables AreaOffice Purchases I want all the records from Areaoffice and related purchases from Purchases table. AreaOffice: AOId AOName 1 AreaI 2 AreaII 3 AreaIII Purchases: AOId Date Amount 1 7/1/04 100 1 7/2/04 200 3 7/1/04 300 What I want is AOId AOName Date Amount 1 AreaI 7/1/04 100 1 AreaI 7/2/04 200 2 AreaII 3 AreaIII 7/1/04 300 But I dont get AreaII record on final result. Here is my query: SELECT AreaOffice.AoId, AreaOffice.AOName, Purchases.Date, Purchases.Amount ; from Areaoffice LEFT OUTER JOIN purchases on purchases.aoid = areaoffice.aoid ; order by ao_id Why am I not getting expected records? Thanks. Tag: Dynamic Back/Fore colors Tag: 197591

Is there a way to see what a grid has assigned as the dynamic back/fore
colors?

I have an application that loads three tables on separate showwindow=1
forms. The 1st one that loads never shows the dynamic colors but all of the
rest do. It would seem that I am not executing the "setall" to the first
grid, but I stepped through the code and it runs. I am baffled.

Thanks,

Scott

Top

Re: Dynamic Back/Fore colors by Stefan

Stefan
Thu Aug 05 01:32:51 CDT 2004

SetAll() assigns each property directly, so at runtime you can
see the result in the debugger for example
Thisform.Grid1.Column1.DynamicBackcolor

If your SetAll() runs quite late, e.g. after form.Init(), does an
additional ..GridX.Refresh() help to make the colours appear?

-Stefan

"Scott Cadreau" <scadreau@aros.net> schrieb im Newsbeitrag
news:NpKdnTjLKqPt9IzcRVn-uQ@aros.net...
> Is there a way to see what a grid has assigned as the dynamic back/fore
> colors?
>
> I have an application that loads three tables on separate showwindow=1
> forms. The 1st one that loads never shows the dynamic colors but all of the
> rest do. It would seem that I am not executing the "setall" to the first
> grid, but I stepped through the code and it runs. I am baffled.
>
>
> Thanks,
>
> Scott
>
>

Top