Checkbox in grid

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
    - Add Method Problem I am having something wierd going on in VFP 9. I have a formset and go to form -> new method to create a method. I type in the name "testMethod" and hit add. This then adds the method to the currently active form in my formset, and not to the formset. I can go into the form.testMethod and add code to it. When I save and close out of the formset and then go back in, the method does not show up under the form nor does it show up under the formset. My workaround is to go to edit property method in the menu and then do add method there. Then everything works fine. Is anybody else having this same issue? P.S. I know formsets are not the best way to do things but I am working with old code and it would be alot of work to get them out of formsets. -- TIA Altman VFP9 Tag: Checkbox in grid Tag: 215124
  - 2
    - Landscape reports Hi. In one of my applications I have a couple of Landscape reports. I send these reports to the windows spooler. Sending characters strings and using SET PRINT FONT. To do this, I test PRTINFO(1) = 0. If true,= SYS(1037) to allow the user to switch the landscape mode. Couple of problems with this technique. One, the user might not switch to landscape. Two, that print device stays in landscape mode until he switches back or exits FoxPro. Question. Is there a way my code could switch the print device back and forth from landscape mode? Without the need of SYS(1037). Any advice would be appreciated...Dennis Tag: Checkbox in grid Tag: 215119
  - 3
    - VFP7 view with uncommitted changes - weird behaviour I have a situation, reproducable very occasionally but not consistently, where a requery after tableupdate fails with uncommited changes. I've looked at the view cursor in Debug and it looks really strange. This is the scenario (code that creates the view is below). The view is of a child table and has a filter in place equal to the id of the parent table. The view is in item number order. Add 5 records (items 1 to 5) to the view, delete the 3rd one (causes item 4 and 5 to resequence to item 3 and 4) and then save. Save scans the file (with set deleted off) and issues a tableupdate on each record. The subsequent requery sometimes fails. Browsing the cursor shows why it has failed but I can't see a reason for the cursor being in the state it is in! Debug says these are 8 records. Browsing displays 5. 2 records belonging to the previous header even though there is a filter in place so I don't know why these are showing. The 2nd item of the added items does not display. After setting the filter off and setting deleted off, 6 records display, the same 5 as above plus the deleted one. I then set the order off and 8 records then appeared. The 8th record was full of zeroes and characters that look like a thick letter I in some of the fields. Where this came from I have no idea. I have no idea where to go from this point as it seems to be VFP7 doing something outwith my control. Has anyone had this kind of problem before? Thanks for any help. Bernie Beattie Here is the code that creates the view: CREATE SQL VIEW V_NLJDTL AS ; SELECT NLJDTL.nljdtl_id AS nljdtl_id,; NLJDTL.nljhead_id AS nljhead_id,; NLJDTL.item_no AS item_no,; NLJDTL.acctno AS acctno,; NLJDTL.db_or_cr AS db_or_cr,; NLJDTL.tran_amt AS tran_amt,; IIF(nljdtl.db_or_cr='D',tran_amt,0000000000000.00) AS Debit,; IIF(nljdtl.db_or_cr='C',tran_amt,0000000000000.00) AS Credit,; NLJDTL.property AS property,; NLJDTL.REFERENCE AS REFERENCE,; NLJDTL.reconc_id AS reconc_id,; NLJDTL.added_dt AS added_dt,; NLJDTL.changed_dt AS changed_dt,; NLJDTL.vatst_pr AS vatst_pr, ; nljdtl.rcveble_id as rcveble_id,; nljdtl.plinv_id as plinv_id,; NLACCD.COMPULSPRP AS COMPULSPRP,; NLACCD.ACCTYPE_ID AS ACCTYPE_ID ; FROM NLJDTL,NLACCD ; WHERE NLJDTL.acctno=NLACCD.acctno AND NLJDTL.acctno<>0 AND nljdtl.nljhead_id=?pnhead_id *make the view updatable DBSETPROP('v_nljdtl','View','Tables','nljdtl') DBSETPROP('v_nljdtl.nljdtl_id','Field','KeyField',.T.) DBSETPROP('v_nljdtl.nljdtl_id','Field','UpdateName','nljdtl.nljdtl_id') DBSETPROP('v_nljdtl.nljhead_id','Field','UpdateName','nljdtl.nljhead_id') DBSETPROP('v_nljdtl.item_no','Field','UpdateName','nljdtl.item_no') DBSETPROP('v_nljdtl.acctno','Field','UpdateName','nljdtl.acctno') DBSETPROP('v_nljdtl.db_or_cr','Field','UpdateName','nljdtl.db_or_cr') DBSETPROP('v_nljdtl.tran_amt','Field','UpdateName','nljdtl.tran_amt') DBSETPROP('v_nljdtl.property','Field','UpdateName','nljdtl.property') DBSETPROP('v_nljdtl.reference','Field','UpdateName','nljdtl.reference') DBSETPROP('v_nljdtl.reconc_id','Field','UpdateName','nljdtl.reconc_id') DBSETPROP('v_nljdtl.added_dt','Field','UpdateName','nljdtl.added_dt') DBSETPROP('v_nljdtl.changed_dt','Field','UpdateName','nljdtl.changed_dt') DBSETPROP('v_nljdtl.vatst_pr','Field','UpdateName','nljdtl.vatst_pr') DBSETPROP('v_nljdtl.nljdtl_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.nljhead_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.item_no','Field','Updatable',.T.) DBSETPROP('v_nljdtl.acctno','Field','Updatable',.T.) DBSETPROP('v_nljdtl.db_or_cr','Field','Updatable',.T.) DBSETPROP('v_nljdtl.tran_amt','Field','Updatable',.T.) DBSETPROP('v_nljdtl.property','Field','Updatable',.T.) DBSETPROP('v_nljdtl.reference','Field','Updatable',.T.) DBSETPROP('v_nljdtl.reconc_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.added_dt','Field','Updatable',.T.) DBSETPROP('v_nljdtl.changed_dt','Field','Updatable',.T.) DBSETPROP('v_nljdtl.vatst_pr','Field','Updatable',.T.) DBSETPROP('v_nljdtl.rcveble_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.plinv_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.compulsprp','Field','Updatable',.T.) DBSETPROP('v_nljdtl.acctype_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl','View','SendUpdates',.T.) *open the view SELECT SELECT(1) USE V_NLJDTL EXCL INDEX ON STR(nljhead_id)+STR(item_no,3) TAG UNIQUE_KEY INDEX ON item_no TAG item_no INDEX ON acctno TAG acctno INDEX ON Debit TAG Debit INDEX ON Credit TAG Credit INDEX ON UPPER(property) TAG property INDEX ON UPPER(REFERENCE) TAG REFERENCE CURSORSETPROP("buffering",5) &&optimistic table buffering Tag: Checkbox in grid Tag: 215118
  - 4
    - Multi-Lingual in VFP I've got to make a multi lingual application in VFP 9.0, exept the Steven Black INT'L component, does someone have a native and free soluton. Thanks. Patrick Tag: Checkbox in grid Tag: 215115
  - 5
    - Bugg? in tableupdate - VFP8-SP1 I have problems with tableupdate. Tableupdate returns F even after success. It happens if the field below is of type memo and the corespondending .fpt file is quite large (10M). Small files - no problems. * write to table SET REPROCESS TO 3 SECONDS && 10 seconds is not better IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias) llUpdated = tableupdate(1,.F.,lcAlias) IF llUpdated = .T. wait 'Saved' nowait window ELSE && i.e. unother user has removed the record TABLEREVERT(.F.,lcAlias) MESSAGEBOX('Save failed, record removed by unother user', ; 0+48,'Securityinformation') ENDIF ENDIF The code above fires the messagebox. But if I continue to use the app I can see that the view´s sourcetable is updated after all. Hints about this should bee very appreciated. Best regards Christina Tag: Checkbox in grid Tag: 215108
  - 6
    - Excel automation I'm getting an "Unknown COM status error" on the second line of code below (owb is an Excel Workbook object). This works fine in the development environment, but not on the end user deployment. I'm guessing that VFP being installed might help. Does anyone know what I need to install to make this work? Briefly, the code populates a worksheet, creates a graph from it, saves the graph as HTML and displays it in a browser. lcWeekChart = sys(5) + curdir() + "graphs\" + sys(2015) + ".htm" with owb.PublishObjects.Add(xlSourceChart, lcWeekChart, "Chart1", "", xlHtmlChart, "Weekly Sales", "") AFAIK, the development and production environments are using the same Office 2003 install. Thanks for any help, Neil Tag: Checkbox in grid Tag: 215098
  - 7
    - Help Files I have made a chm help file called scgHelp.chm I have "set help on" Set help to scgHelp.chm It works great on my system XP Home, however my customers with XP Home, nothing happens, help doesn't work. Any Suggestions ? Loren Tag: Checkbox in grid Tag: 215097
  - 8
    - seek I have tables with compound indexes. Performing a seek seems to require the padding of the fields (at least the first field of the index). The index in not based on the padding. Am I missing something? Do I need to pad the variables I am seeking? Tag: Checkbox in grid Tag: 215076
  - 9
    - Image name with image oddity on forms and reports. I have an app done for somebody else where photos shown on form and report. I have never got this, myself but the client sometimes reports strange image titles included with the image. For example it would show or print the image and right underneath it it would print the name of the image file. -------- | | | | |(Image) | | | | | | | -------- Logo.bmp Anybody seen this and a solution? ----------------------------------------------------------------- Paul Lee ........... Abri Technologies ......... http://abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: Checkbox in grid Tag: 215072
  - 10
    - VFP9 report anomalies with picture I'm adding a gif picture to a VFP9 report (REPORTBEHAVIOR = 80, non-GDI+). I don't know whether this matters, but it's a label printer, 1" x 3", landscape mode. 1. When I tap the arrow keys to move the picture, it shrinks instead of moving, as if it were moving only the left or top sides. 2. When I double-click the object to edit the properties manually, the path to the picture gets corrupted. For example, if the path is c:\folder\mypic.gif it gets changed to c:\folder\folder\mypic.gif Anyone else seen this, or is my computer going crazy? Tag: Checkbox in grid Tag: 215069
  - 11
    - COPY TO FIELDS x,x,x TYPE SDF - Erratic Integer translations! Does anyone know what FoxPro is doing when it writes out SDF files and converts integer fields? I am attempting to copy out an SDF file for BULK INSERT into SQL. I need only a subset of fields, so I am using the FIELDS x,x,x parameter, and this seems to throw FoxPro's Integer column conversion into a bit of a tailspin. For example: CREATE CURSOR Mewp (char1 c(10), char2 c(10), int1 I, int2 I) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6) COPY TO C:\Temp\Temp1.txt TYPE SDF ^ the above reacts as it should, integer columns are 11 characters long, right justified. Now: CREATE CURSOR Mewp (int1 I, int2 I, char1 c(10), char2 c(10)) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6) COPY TO c:\temp\temp2.txt FIELDS Int1, Int2, Char1, Char2 TYPE sdf ^ Field order in the source is different, but same field names and datatypes. In Temp2.txt, the integer columns are LEFT justified, and only 10 characters. In the table I first tested on and discovered the erratic behavior, I have a much wider field layout, a much wider integer range, and a much larger dataset, and in that instance, the integer column (first in the FIELDS list, last in the table structure) in the SDF file is 11 characters, right justified, followed by 10 spaces. In another large test I ran with a slightly smaller field layout and dataset, it was 11 characters right justified, followed by 4 spaces. I haven't been able to reproduce either of these outside of the tables i'm using, so I'm not sure if the field types, field names, integer values, table size, or what is causing the change in conversion. Anyone have any experience on this that might lend some insite? Tag: Checkbox in grid Tag: 215068
  - 12
    - Citizen CBM1000 Type II receipt printer How to open the cash drawer model POSIFLEX CR4100 connect with Citizen CBM 1000 Type II receipt printer ? thank you. Tag: Checkbox in grid Tag: 215061
  - 13
    - Localhost VFP7 application. Need to connect to web service, which is running locally on the same PC. I have some sample code (I think it's .net) that I need help converting to VFP for the objSdk and objError objects. Dim sHandle As String Dim objSdk As New localhost.SmpSdk Dim objError As New localhost.clsSdkError sHandle = objSdk.SdkZLogin (cUser,cPassword, objError) If (sHandle = "") MsgBox ("Invalid Login") Else MsgBox ("Login Success") End if TIA Tag: Checkbox in grid Tag: 215054
  - 14
    - Get file from URL in VFP 5.0 Our application sends data to a third party's website who will manipulate it. I've got this part working just fine by opening an instance of IE and sending our data in the address. But now we need to retrieve the data back from their server. Any clues on how to get the file to our hard drive? We asked them to drop a cookie, but they don't want to go that route. Since I'm working in 5.0 I'm not sure what options are available. I might be able to convince them to display the data in the browser window if that makes a difference. Thanks very much in advance, Tag: Checkbox in grid Tag: 215046
  - 15
    - Find I most often use the "All objects" on Find. Is there any way to make that the default instead of the current procedure? TIA Tag: Checkbox in grid Tag: 215044
  - 16
    - frx2word I use for my reports frx2word. All reports works. But by some windows 2000 Computer with office 2000 it dosnt work.It comes no Error Messages. But the doc file is empty. Thanx -- Cengiz Zengin CZ Computer Tag: Checkbox in grid Tag: 215034
  - 17
    - installshield The InstallShield of VFP 9 really `scared` me.. So much complicated than VFP6's setup wizard... -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.4.31 ^ ^ 8:48pm up 37 min 5 users 1.57 1.66 Tag: Checkbox in grid Tag: 215029
  - 18
    - FPW2.6 check if report available programmatically I'm writing a program that uses a report. This program is usually compiled into .exes, and when building, the project manager finds the report and includes it in the .exe. However, this program is sometimes called from a standalone prg I run in the IDE. The report almost certainly won't be visible at run time and I don't want to make an identical copy elsewhere (although that would work.) What I would like to do is something like IF isexe() REPORT FORM report.frx TO PRINTER PROMPT ELSE REPORT FORM <full path to report>\report.frx ... ENDIF The best I've thought of is an ugly error trap: m.lno_frx=.F. ON ERROR m.lno_frx=.T. REPORT FORM report.frx TO PRINTER PROMPT ON ERROR IF m.lno_frx REPORT FORM <full path>.... ENDIF Any other ideas? -- TIA Andrew Howell Tag: Checkbox in grid Tag: 215019
  - 19
    - How to update characte(binary) field on dbf table using cursoradap i create a dbf table that have some binary char fields and i want to use cusroradaptier via ADO to update. it cannot update when execute tableupdate() command. aerror() get the error as following error : 1435 Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value. it is same error either set mapbinary property on cursoradapter object to .t. or .f. sample code : ******************** IF !file("c:\test\test.dbf") CREATE TABLE c:\test\test.dbf (testval c(10) nocptrans) APPEND BLANK USE endif set multilocks on oca=createobject("cursoradapter") oca.alias="catest" oca.buffermodeoverride=5 oca.cursorschema="TESTVAL M" oca.datasourcetype="ADO" oca.keyfieldlist="TESTVAL" oca.mapbinary=.T. oca.selectcmd="Select * From test" oca.tables="test" oca.updatablefieldlist="TESTVAL" oca.updatenamelist="TESTVAL test.TESTVAL" loConnDataSource = createobject('ADODB.Connection') loConnDataSource.ConnectionString = [Provider=VFPOLEDB.1;Data Source=c:\test;Password="";Collating Sequence=MACHINE;] loConnDataSource.Open() oca.DataSource = createobject('ADODB.RecordSet') oca.DataSource.CursorLocation = 3 && adUseClient oca.DataSource.LockType = 3 && adLockOptimistic oca.DataSource.ActiveConnection = loConnDataSource oca.cursorfill() SELECT catest replace testval WITH "test" IF TABLEUPDATE(1) else =AERROR(amessage) =MESSAGEbox(amessage(2)) endif ******************** i'm using vfp9. -- Ray Tag: Checkbox in grid Tag: 215018
  - 20
    - Third party tool required I need a third party tool to repair a corrupt dbf file. Thanx in advance Regards Nishu Tag: Checkbox in grid Tag: 215012
  - 21
    - What does this mean ? I have come across a code snippet which I am unable to understand - the color statement - Can anybody help me understand this thing ? What does these so many RGB means in the deffinition ? MODIFY WINDOW lw_invoice NOGROW ; COLOR RGB(0,0,0,192,192,192), ; RGB(0,0,0,255,255,255),,,,,,,, ; RGB(0,0,0,192,192,192) ; FONT "Courier New", 9 Tag: Checkbox in grid Tag: 215011
  - 22
    - How to make a user interface like Windows Explorer? Windows Explorer-style user interface is more kindly for user. how can I make it? TIA Song Tag: Checkbox in grid Tag: 215009
  - 23
    - Replace question and table precision * make sure there are no DBCs open create cursor zoot (zz n(3,1)) append blank replace zz with 9.9 ? zz && prints 9.9 replace zz with 999 ? zz && prints 999 The last replace command should not work, but it does. Why? I've learned from experience that VFP is pretty sloppy about numeric fields if the table is not associated with a DBC, but I figured they would have fixed this by now? Is this left in for legacy purposes? Tag: Checkbox in grid Tag: 215004
  - 24
    - [OT] User-Defined string Functions Transact-SQL <-> VFP Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions Transact-SQL: AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps). PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side. PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters. STRFILTER(): Removes all characters from a string except those specified. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a string. PROPER(): Returns from a character expression a string capitalized as appropriate for proper names. RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search. ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999). ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. More than 4000 people have already downloaded my functions. I hope you will find them useful as well. For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 or http://nikiforov.developpez.com/ (the beautiful French language) Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. Tag: Checkbox in grid Tag: 215002
  - 25
    - VFP 6: clear events with Nonmodal Forms You might recall my question not too long ago about copy-cut-paste with toolbars. I am now looking at using nonmodal forms. I have a couple of problems. 1) Where do I put the clear events command? If I do not have it, my program does not terminate when all forms are closed. Since any form might be the last, what is the best placement? If I am using a menu, then presumably, I put it in the exit selection, but if I am not using a menu, what do I do? I suppose that I can have if _screen.formcount=0 && or 1, I am not sure clear events endif in a suitable event's (.unload()?) code, but it looks kludgy. 2) What is the best way to store the object references (so the forms stay in scope)? A global array? Do you have hardcoded references to array elements, search for a free element, or do something else? Sincerely, Gene Wirchenko Tag: Checkbox in grid Tag: 215001
- Next
  - 1
    - VFP8 Intellisense issue I'm writing an ActiveX control (non-attributed ATL project in VS7). I've noticed a problem when testing this ActiveX control in Visual FoxPro 8 and 9. If I type "ThisForm.oleCtrl.", the trailing "." which triggers the intellisense code completion, causes vfp to shut down with a Buffer Overrun error message shown below. Anyone encountered this problem? Thanks, Greg ... Microsoft Visual C++ Runtime Library Buffer overrun detected! Program: ...ogram Files\Microsoft Visual FoxPro 8\vfp8.exe A buffer overrun has been detected which has corrupted the programs' internal state. The program cannot safely continue execution and must now be terminated. ... Tag: Checkbox in grid Tag: 214997
  - 2
    - Connecting To DBF Using vfpoledb I have the need to connect to a remote DBF table across the network. Currently, I able to do this using a mapped drive which maps to the remote system where the DBF is stored, as such. Provider=vfpoledb;Data Source= \\remoteserver\dbffiles\; Mode=ReadWrite;Collating Sequence=MACHINE; However, mapped drives can be finicky. Now, the purpose of this post is to ask; "Is there a better way to do this, without the need for a mapped drive?" Tag: Checkbox in grid Tag: 214982
  - 3
    - Printing on a dot matrix with vfp9 When I set report behavior 90, The fonts no longer print out correctly on a dot matrix printer. When I set report behavior 80 everything is fine. What Can I do to insure the fonts print out correctly? I tried saving the printer environment and it did not help. Sending output to generic text printer driver does not work well either. Tag: Checkbox in grid Tag: 214979
  - 4
    - Migration from XBase++ to Visual FoxPro 9 Hi, I am working on a project in Visual FoxPro 9 which will eventually replace the existing software written in XBase++. During this migration process, I will use the existing XBase++ tables with cdx indexes. Does anyone have any recommendations or any data recommendations during this migration. I seem to have random index problems. The problem will not be there and then it shows up. I then delete the index file and reindex with the XBase++ software and the VFP9 software will still show the error. I then open the free table and the index in VFP9 and then issue reindex (This is done without trying to browse the table). All is cured. The table is still accessable from XBase++ software and VFP9 software. Anybody know what is going on here and what I need to start doing in order to make this work? Thank you, Mike Tag: Checkbox in grid Tag: 214973
  - 5
    - PCL Codes Can you embed PCL printer codes to directly control the printer in a VFP report? Tag: Checkbox in grid Tag: 214971
  - 6
    - Change colors of the Window Globaly ? I want all the windows in my application - which is already running and using different back ground colors - to have a specific color say blue - irrespective of the colors the windows are defined with - ? Is it possible either ? I am looking for a solution like a hook which keeps on looking whenever a user defined window becomes visible OR no matter is defined its back ground color changes to that specific color. Tag: Checkbox in grid Tag: 214963
  - 7
    - CREATE OBJECT I develop application in vfp9 using the command CREATE OBJECT for link ole application and work fine with EXCEL, WORD and PP, but i cant do the same to link with WORDPAD or NOTEPAD, i will appreciate if could help to to fix these problem. Thanks. Tag: Checkbox in grid Tag: 214962
  - 8
    - writing map software Not sure if this is the right place or not, but does anyone know how mapping software is written? i'd like to write a baby program to map out my building and where the different meeting rooms are located (time and distance to each room from a disgnated spot, etc). if anyone has any suggestions please send me an email. Tag: Checkbox in grid Tag: 214960
  - 9
    - Keypress event F2 works in VFP6 but not VFP7 onwards I am converting an application from VFP6 to VFP9 and have discovered an issue that I hope someone can help with. I am trying to capture the F2 key being pressed within a textbox on a form in the keypress event (nKeyCode=-1). This would not work in VFP9 so after trying many things I built a basic form with one text control and a capture of the key press events to screen. It appears that in VFP6 the textbox keypress event happily tells me that F2 has been pressed, however in VFP7 onwards it appears that the F2 is not captured and nothing happens. The ON KEY LABEL is not active and F3, F4 etc are all working e.g. nKeyCode=-2, nKeyCode=-3 etc. This happens only with F2 (nKeyCode=-1). Does anyone know why? Is there something I am missing? This seems too simple an issue to be a bug? Thanks John R. Tag: Checkbox in grid Tag: 214955
  - 10
    - DOS Filenames I am integrating an ActiveX control into my app. One of the properties is 'FileName'. Works fine till the property is set to a string containing the '~1' characters one gets from SYS(2023). Is there a utility/command that will convert the DOS path to a the real pathname? tnx, Howard Tag: Checkbox in grid Tag: 214953
  - 11
    - Foxpro dll and Installshield I built a multithreaded com server (dll) in FoxPro 9 and put it into my installshield to install. When it tries to build the installer I get this message. The build was unable to extract COM information from the file <my dll file> in component <my dll file>. Please ensure that the file is self-registering and verify that the self-registration process does not fail. I can register it fine manually with regsvr32 but I do not want to manually register it. Is there any way around this or do I have to manually register this? -- TIA Altman VFP9 Tag: Checkbox in grid Tag: 214948
  - 12
    - Predict Page Count When printing out a report, is there a way of counting the pages before you print them so that you can print something like Page 1 of 20. page 2 of 20 etc: on each page in the header? TonySper Tag: Checkbox in grid Tag: 214945
  - 13
    - VFP6: open excel file and dump to .dbf Need to open a spreadsheet (Excel 2k) and dump contents to .dbf file using VFP6. Pretty generic really, sorry if this request isn't a challenge! Any sample type code would be appreciated. - Ben Tag: Checkbox in grid Tag: 214942
  - 14
    - Rounding question and trig functions set decimals to 4 ? SIN(1)*COS(1) 0.45464871 ? .5*sin(2) 0.45465 VFP rounds the result, but why does the first get rounded to 8 digits, and the second get rounded to 5? SIN(1)*COS(1) is the same number as .5*sin(2), but VFP somehow treats the above calculations differently. If I put them in the watch window, they display the same as what is printed to _screen, with the same inconsistent rounding. Tag: Checkbox in grid Tag: 214938
  - 15
    - sys(1500) This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5A28A.658070B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am just experimenting with this command. On a form with an editbox and = a commandbutton I have this code in the commandbutton click() _CLIPTEXT =3D "Hello world"=20 ThisForm.Edit1.SetFocus() SYS(1500, '_MED_PASTE', '_MEDIT') thisform.Refresh() The first time I click the button the edit cursor appears in the edit = box but nothing else. Thereafter every time I click the commandbutton, = the phrase appears as expected in the edit box, concatenating with the = previous paste.. Can somebody explain why it doesn't appear the first time? Many thanks Stephen ------=_NextPart_000_0006_01C5A28A.658070B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I am just experimenting with this = command. On a=20 form with an editbox and a commandbutton I have this code in the = commandbutton=20 click()</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>_CLIPTEXT =3D "Hello world"=20 <BR>ThisForm.Edit1.SetFocus()<BR>SYS(1500, '_MED_PASTE',=20 '_MEDIT')<BR>thisform.Refresh()</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The first time I click the button the = edit cursor=20 appears in the edit box but nothing else. Thereafter every time I click = the=20 commandbutton, the phrase appears as expected in the edit box, = concatenating=20 with the previous paste..</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Can somebody explain why it doesn't = appear the=20 first time?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C5A28A.658070B0-- Tag: Checkbox in grid Tag: 214931
  - 16
    - Append data into excel file Dear All, Do anyone know how to append data into excel file from dbf file. Thanks for any reply or solution Choi Tag: Checkbox in grid Tag: 214926
  - 17
    - MYSQL Database Has anyone converted a MySql database to a VFP table? I have a guy who has his database on MySql and would like me to enter it into a VFP Database table. I have not looked at it yet so do not know what to expect. Any ideas?? TonySper Tag: Checkbox in grid Tag: 214922
  - 18
    - won't stay docked every time I open vfp8 I need to uncheck the dockable on all windows. How do I make it permanent? thanks sherry Tag: Checkbox in grid Tag: 214918
  - 19
    - Using custom PAGE objects in a custome PAGEFRAME Hi I have been reading 1001 Things which seems to mainly reference VFP 6. I am trying to create a base _PAGE class for use in my base _PAGEFRAME class with some custom methods and properties. I can't work out how to trick my _PAGEFRAME to use my _PAGE class rather than the standard VFP Page object. In 1001 we are told that you cannot visually create a Page object - clearly this is no longer the case with VFP 9 so can anyone tell me how i can implement my visual _PAGE object? -- Kind regards Phil Hollingworth phil@wrltd.co.uk System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: Checkbox in grid Tag: 214912
  - 20
    - Derfining a color Scheme ? How can I define a Color scheme at runtime based on the color scheme of certain control ? Want to have separate values for Red, Green and Black instead of using a single color value ? Tag: Checkbox in grid Tag: 214908
  - 21
    - Custom window Color ? I want to set the color of a window which is to be determined at run time .. will be picked from the property of a color ? Don't know how to set it up like this ? Tag: Checkbox in grid Tag: 214905
  - 22
    - Define a Window with Custom Color ? I want to define a window which should borrow a color from another controls Back Color Property to be determined at run time ? Not aware how to set it up ? Urgent pls help ? Tag: Checkbox in grid Tag: 214904
  - 23
    - Statusbar Color Scheme ? Can anybody tell me what color scheme is used by the VFP 8.0 StatusBar ? I want to use my own status bar but with the same color scheme as being used by the VFP StatusBar. My Statusbar control will appear in only selected segments of the application. Tag: Checkbox in grid Tag: 214903
  - 24
    - Protecting your code Hi, How to protect your code when distributing class libraries (vcx) and Databases. How to stop some customer to make "improvements" to your stored procedures? I do not want to include the Databases and or class libraries in the project(s) as some of the libraries are shared by multiple APP/EXE and the Databases need to change depending on customer needs (like for example adding a new index to a table or to repair indexes and reestablish relations). Is there a way to make the source code (equivalent to a prg) disappear? Tag: Checkbox in grid Tag: 214891
  - 25
    - Menu Path solve Taking the "IN LOCFILE(.....) portion out of the menu generator allows menues truely to be integrated in APP/EXE files. With the standard menu generator you will have to include the menu.mpx in the original location which also does not allow to make a true setup where the enduser selects the destination directory. Scenario. app directory: F:\myproject source fiels: F:\myproject\source The menu on the developing machine with the other SCX and prg is in the source directory. Running the "standard" Menu generator will generate some code like ON SELECTION PAD _1hv06ai6t OF (m.cMenuName) ; DO _1hv06ai6u ; IN LOCFILE("\Myproject\sourc\MyMENU" ,"MPX;MPR|FXP;PRG" ,"WHERE is MyMENU?") Now if on the destination machine there is no directory Myproject\source then the above menu code will popup that file selection box asking for the MyMENU even though the menu had been included in the project and compiled into the app file and had been already executed with the "DO Mymenu.mpr ....." Command earlier in the code. Changing the code to ON SELECTION PAD _1hv06ai6t OF (m.cMenuName) ; DO _1hv06ai6u - ommitting the LOCFILE part will work and resolve the above problem. Tag: Checkbox in grid Tag: 214890

Hi

I would like to use a checkbox in a column of a grid but I am not sure how
to do this and also what type of field would the checkbox require.

Help appreciated,

warrenjw
warrenjw@internode.on.net

Top

Re: Checkbox in grid by Mark

Mark
Mon Aug 22 21:14:49 CDT 2005

Put the grid in edit mode (right click on grid and click edit). Click on the
Checkbox from your class library then click in the column where you want it
in. On the Property Sheet, change the CurrentControl property for that
column to the checkbox. The data type for the checkbox is the same as it
would be for any other checkbox. It can be numeric where the possible values
can be 0, 1 or null or a logical.

"warrenjw" <warrenjw@discussions.microsoft.com> wrote in message
news:294DA586-C179-497D-A741-86D3A48283C6@microsoft.com...
> Hi
>
> I would like to use a checkbox in a column of a grid but I am not sure how
> to do this and also what type of field would the checkbox require.
>
> Help appreciated,
>
> warrenjw
> warrenjw@internode.on.net

Top

Re: Checkbox in grid by man-wai

man-wai
Tue Aug 23 08:38:14 CDT 2005

also, make set the grid.column.sparse to .f.

--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 9:37pm up 1:14 1 user 0.17 0.23

Top