How to "force" SET RELATION?

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
    - Error 111 Cannot update the cursor... Hi, I'm running into error 111 and can't see any reason. Removing the dbc from the project has no effect. When the dbc is in the project it is marked as "Exclude". When I start the app, and every time the table goes to a new row, I get the 111 error but the error appears to come from code that is NOT trying to write to the table! The full error message: ".txtValue.Value = Symbols.TotShares * Symbols.Price Error: 111 Cannot update the cursor Symbols, since it is read-only. Method navrefresh Line: 53" How would a simple calculation on data in the table require an update? Symbols is a vfp table. All data is local (Drive C). No server is involved. This vfp9. Thanks for any help, Frank Tag: How to "force" SET RELATION? Tag: 213095
  - 2
    - Launching Foxisapi process in "debug" mode I am attempting to launch Foxisapi in debug mode by following the instructions in Article ID: Q156223 I am getting the following message: FOXISAPI call failed Progid is: bulkM.x2 Method is: eval parameters are: Invoke failed with err code 80020009: Exception occurred. I can actually run the server as a normal foxisapi application, it returns pages and every thing works fine. I wanted to try out getting to an interactive foxpro session. If I go into foxpro and run the following: oServer=CREATEOBjECT("VisualFoxPro.Application") oServer.EVAL( [oDebug("bulkM.x2.Method('lcFormVars','lcIni',0)")] ) Another session of foxpro will load and the oDebug.prg is loaded. I was thinking that maybe foxisapi does not have the access rights to load VisualFoxPro.Application. Within DCOMCNFG I cannot find an entry for VisualFoxPro.Application but I have set the default launch & access permissions for IUSR & IWAM. I have set permissions on the vfp directory for read & write for IUSR. Any ideas? Tag: How to "force" SET RELATION? Tag: 213090
  - 3
    - About the command "Set Exclusive Off" Hi All, This is Sam. I'm now running on troubles by using the command "Set Exclusive Off". I designed the whole system using Visual Foxpro 6.0, and complied to exe file. For now the system has been installed to three computers, one as a server(with exe file), and other two for clients only. I had used so many "Index on" commands and thought to be "not shared". I added "Set Exclusive Off" before getting into my system, and added "Set Exclusive On" before the command "Index On" and "Set Exclusive Off" after that. Like this: ***************** Set Exclusive on select table1 use table1 index on idnumber to table1 set exclusive off ***************** And now I'm still running on this trouble. The system can only be opened by itself(Server), but not able for other two computers through the local area network. Please help, thanks Sam. Tag: How to "force" SET RELATION? Tag: 213089
  - 4
    - APPEND FROM text file containing " in data Hi, I have a text file in which every 'field' is fixed length, separated with ',' and character fields are DELIMITED with "" i.e. "Field1","Field2","Name contains double quots in data "a"", 999 However in some rows third column contains double quotes inside data. What should be APPEND FROM .... in this case so that the result should be: Field1 Field2 Name contains double quots in data "a" 999 TIA Kamran Tag: How to "force" SET RELATION? Tag: 213082
  - 5
    - Child form Opens & immediately closes Hi, I have a form that's called from another form (user selects a menu item on first form). It opens and flashes on the screen but immediately closes. Strangely, if I RUN the form from the Project Manager. It opens and stays open. I can close it and then call it from the parent form and it works! So something about the way it's being called isn't doing something correctly. I have no clue what's wrong. The only non-default property (other than size, position and Caption) of the child form is Desktop = .T. The form is called from the parent form's menu with: SET SKIP OF BAR 1 OF "view" .T. DO FORM Securities NAME Securities LINKED ; WITH _VFP.ActiveForm && Pass handle of calling form to the child Here are the methods of the child form: LOAD: PUBLIC OldSym OldSym = SPACE(LEN(Symbols.Symbol)) INIT: LPARAMETERS oCallingForm This.oCaller = oCallingForm (I have added an oCaller property to the form) UNLOAD: RELEASE OldSym TRY This.oCaller.SetTransMenu(1) && undoes skip of bar 1 CATCH * do nothing ENDTRY That's it. What could be causing this. How can I trap the problem. I've tried stepping through the startup code but the code just jumps INIT to UNLOAD w/o any intervening steps. Thanks for your help, Frank Tag: How to "force" SET RELATION? Tag: 213081
  - 6
    - Foxisapi and Blat.dll (or wwipstuff.sendMail) I am using vfp6 SP5 I am calling a com component through foxisapi, everything works fine. The last part of the project is to create an email when a page is submitted. I wanted to use a tool that could communicate directly with an SMTP server. I used the following code with blat.dll (only the relevant code is shown). LOCAL lcDll, lcCmd, lnResult lcDll = locFile("..\common\bin\blat.dll") cBodyFile = tempFile("txt", .t.) strToFile("Please do not resply to this message as it was generated by an automated process", cBodyFile) DECLARE INTEGER Send IN (lcDll) STRING blatstring lcCmd = cBodyFile + ' -t ' + alltrim(Email) + ' -s "EDI" -f stuff@address.com.au ' + '-server ' + alltrim(SMTPserver) + ' -attach ' + oEDI.cFileName lnResult = Send(lcCmd) I also tried using a different approach with wwipstuff. Both have the same problem, if I step through the code in a standard foxpro environment an email is generated. If I run it through the web server, no email is generated and the process completes but becomes unstable and eventually locks up. To communicate directly with the mail server these processes must be using sockets, so that must be causing the problem for them both to be failing, but I don't understand how that could be. I downloaded the latest version of Foxisapi from the MS site but it didn't help. It's a tough one but I was hoping someone might have some insight into what's going on. Thanks. Tag: How to "force" SET RELATION? Tag: 213073
  - 7
    - Determine Scope of Variables ? Is there anyway to determine the Scope [Public, Private or Local] of a Variable. Using Foxpro 8.0 Pro. Tag: How to "force" SET RELATION? Tag: 213071
  - 8
    - crystal question At one of our installations one of the machines cannot print reports. We ar using crystal version 10 with the report viewer. When we try to print from this machine we get an error message which says Failed to load database information Details: Unable to load query builder component. I have searched the crystal site without success, has anybody got any idea of what is missing from this installation. Thanks in advance Dave Tag: How to "force" SET RELATION? Tag: 213069
  - 9
    - Store procedure Foxpro kept promt me "A store procedure is executing" ! i can't remember what i did, but now i can't issue a "close all". i've tried issue: clear all, release all and close table all. (no luck) worse still can't even quite foxpro. when i issue quit. foxpro seem to show as "not responding" question: on what situaltion will cause this kind of problem ? and how can i resolved this if the user were to hit this kind of problem ?? currently no one else is accessing this database. pls help. Tag: How to "force" SET RELATION? Tag: 213066
  - 10
    - FoxPro 2.0 question This is really kind of two questions. I've been programming VB6 to access our LAN version of FoxPro 2.0 and even gotten help already from this newsgroup. I've gotten the code to work well but the view is in a minimized dos style box. I'd like to be in a maximized state. Part of my code uses the following VB6/FoxPro commands: Open CustDirPath & "do_me.prg" For Output As #newfile Print #newfile, "FILENAME = '" & Path_to_File & "'" Print #newfile, "RESTORE MACRO FROM P:\SOFT\ABSSHELL\FOXMACR.FKY" Print #newfile, "USE &FILENAME" Print #newfile, "COUNT" Print #newfile, "BROW NOWAIT" Close newfile RunShell "foxprol -T " & CustDirPath & "do_me.prg" I've been researching in what documentation for FoxPro 2.0 just what the "-T" indicates in the last line. I assume it is a switch of some sort but can't find out what it means/accomplishes. I'm hoping that finding the right switch may help me cure the screen size issue. So, to ask a specific question(s) 1. What does the -T indicate? 2. Is there place I can find out all switches besides the @#$$%^&*( documentation? 3. Given the code I've got so far, can someone recommend a way to influence the screen/display size of the view area. Tag: How to "force" SET RELATION? Tag: 213061
  - 11
    - incorrectly decrypted data -different default non-unicode languages aGksIA0KaSdtIGVuY3J5cHRpbmcgZGF0YSAoZmllbGRzIGluIGRiZikgaW4gUEMgIyAxLCB3aGVy ZSBkZWZhdWx0IG5vbi11bmljb2RlIGxhbmd1YWdlIGlzIHNldCAgZm9yIGV4YW1wbGUgInh4eCIu IHdoZW4gaW0gZGVjcnlwdGluZyB0aGUgc2FtZSBkYXRhIG9uIHRoZSBzYW1lIFBDLCBldmVyeXRo aW5nIE9LLiANCkJ1dCB3aGVuIGltIHRyeWluZyB0byBkZWNyeXB0IGl0IG9uIFBDICMyIChkZWZh dWx0IG5vbi11bmljb2RlIGxhbmd1YWdlIGlzICJZWVkiLCBub3QgInh4eCIpLCBkYXRhIGlzIGJl ZWluZyBkZWNyeXB0ZWQgaW5jb3JyZWN0bHkuLi4gaG93ICBhd29pZCB0aGlzPw0KDQp0aGFua3Mu Lg0K Tag: How to "force" SET RELATION? Tag: 213050
  - 12
    - Problem with _systray.vcx : difference between prg and exe Hi Mi app use a systray.vcx I compile I lauch That's OK : the app' icone is in the systray near the clock I want to simulate a click on the icon : In my VFP command window, I tape : iHwnd = FindWindow(cNameApp+"9c000000" ,"Microsoft Visual FoxPro") = sendMessage(iHwnd,0x020A,0x40010000,0x00000400) That' OK but if the code is in an exe, it doesnt work The question is : Why the design mode allow to send a WM_MOUSEWHEEL (0x020A) event and not in an exe ??? I known, the FFC class is a bit tricky : the creator said *!*This is where the magic happens. *!*This is an unabashed hack to allow us to get the full functionality *!*of the Taskbar Notification Area ("System Tray") without having to *!*use an external C++ library. *!*To communicate with the systray, we tell it to send us messages via *!*the MouseWheel event. (This is the only VFP event that doesn't alter *!*or discard event data before firing the corresponding internal event.) but my british is too poor to understand the next, it may be a way ? *!*The second trick is that only the main VFP window will accept the events *!*without checking to see if the event coordinates are invalid. (The screen *!* doesn't even need to be visible, so you can have SCREEN=OFF in your *!* config.fpw file.) So we use VFP8's BINDEVENT() function to bind to the *!* _SCREEN.MouseWheel event. *!*This method sets up that communication path. thank by advance Olivier Tag: How to "force" SET RELATION? Tag: 213041
  - 13
    - simple data encryption algorythm? aGksIA0KZG9lcyBhbnlib2R5IGtub3cgYW55IHNpbXBsZSBhbmQgRkFTVCBhbGdvcnl0aG0gdG8g ZW5jcnlwdCBkYXRhIGluIHRoZSBkYmYgZmllbGRzPw0KKGV4Y2VwdCBfY3J5cHQudmN4KQ== Tag: How to "force" SET RELATION? Tag: 213032
  - 14
    - delete to recycle bin in foxpro 2.6 for windows I use foxpro 2.6 for windows and windows xp. None of these work: delete file c:\a.xls recycle erase c:\a.xls recycle They delete the file, but it is not being put in the recycle bin. Can a file be deleted to the recycle bin in foxpro 2.6 for windows? Regards, Jan Nordgreen Tag: How to "force" SET RELATION? Tag: 213031
  - 15
    - Check for instance of Is there a way to check an object type. for example looping through all the controls on and form, and checking if a control is an 'instance of' a textfield. Bob Welke Tag: How to "force" SET RELATION? Tag: 213025
  - 16
    - Automate Comparing Reports This is a multi-part message in MIME format. ------=_NextPart_000_0064_01C57CBF.12ED5A70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Anyone have a program that will compare reports to see if they're the = same? I know you can open the report as a table, but Memo fields = complicate the comparison somewhat. Thanks, Mark A. Tillman ------=_NextPart_000_0064_01C57CBF.12ED5A70 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.3790.327" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Anyone have a program that will compare = reports to=20 see if they're the same?  I know you can open the report as a = table, but=20 Memo fields complicate the comparison somewhat.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks,</DIV> <DIV><BR>Mark A. Tillman<BR></FONT></DIV></BODY></HTML> ------=_NextPart_000_0064_01C57CBF.12ED5A70-- Tag: How to "force" SET RELATION? Tag: 213024
  - 17
    - Suppress report designer "do you want to save changes" Hi-- I am using VFP 9. I need to programatically save a report after the user has made changes in the designer, and do not want him to get the DO YOU WANT TO SAVE CHANGES MessageBox. I thought I could modify the source to reportbuilder.app, but it apparently is not all of the source of the report designer. If someone can point me in the right direction, I would appreciate it. Thanks, Dennis Tag: How to "force" SET RELATION? Tag: 213016
  - 18
    - Error Handling I have an error handler that gives the user the option of closing the current form and continuing. I am using the Release method of the current form to release the activeform. However, the problem is that even after using the release method, whatever procedure was running in the activeform continues running through to the end of the procedure. When that procedure finishes, the form will be released. The problem is, the user might end up getting multiple error messages before the form releases. Is there any way to stop the form from running through all the code in the current procedure before releasing? Kevin Clark Seton Home Study School Tag: How to "force" SET RELATION? Tag: 213010
  - 19
    - DLL and FoxPro I need to implement a DLL from an accounting program and I need to figure out how to do it. The sample code bits I have refer to Visual Basic or C++. Here a sample in VB: Dim Acomba As New AcoX0127.AcombaX Dim Exist CompanyPath = "C:\F1000.dta\Demo" Exist = Acomba.CompanyExists(CompanyPath) ... Now in FoxPro, I use a DECLARE for the function but I get a message when I use the function (no entry point). Here's my code: DECLARE INTEGER CompanyExists IN C:\Aco_SDK\SDK\AcoX0127 String Compagnie="C:\F1000.dta\Demo" nExist=CompanyExists(Compagnie) <-- Error occurs here Can you help me? Pat Tag: How to "force" SET RELATION? Tag: 213003
  - 20
    - Elapsed time for a timer control Hi, Is it possible to display the elapsed time for a timer control before the Timer event is triggered;something like a decrementing counter to display the count down? Thanks, kd Tag: How to "force" SET RELATION? Tag: 212998
  - 21
    - Failure of Office automation I have an app that's been running happily for years, but which suddenly started getting an error. The line is like this: xx = CREATEOBJECT("outlook.application") and the error message is "OLE error code 0x8007007e: the specified module could not be found" It's as if Outlook was uninstalled from that machine, but it wasn't: Outlook still runs normally. Maybe I will need to reinstall Outlook, or is there something simpler I can do? Tag: How to "force" SET RELATION? Tag: 212988
  - 22
    - Checking the Scope of Variable ? Is there anyway to determine the Scope [Public, Private or Local] of a Variable. Using Foxpro 8.0 Pro. Tag: How to "force" SET RELATION? Tag: 212984
  - 23
    - Force execution of parent code how to force the codes in the parent class to be executed even there's code in the same method or event ? (Parent class's code will be ignore if there's user code in the same method/event) i know that by issuing dodefault() will archive this. but this function have be put in every form in the method i want. My goal: the code in the parent class will automatically executed after the users code in the method or event i choose. Thanks! Tag: How to "force" SET RELATION? Tag: 212983
  - 24
    - Combo Box w/table in relation Hi, Please correct me if I'm wrong. I have a Combo Box with RowSourceType=fields and RowSource=TableName.FieldName The Table is the child in a relation so that only a subset of records are accessible at any time. Yet the Combo Box doesn't seem to respect the relation even after a Requery. Is that the way it works? I had assumed that the Combo Box would only display the rows that are currently available based on the relation. Thanks for your help, Frank Tag: How to "force" SET RELATION? Tag: 212981
  - 25
    - Holiday in the world is there any website provide XML downlod of holiday in the world or any forms of format ? Thanks Tag: How to "force" SET RELATION? Tag: 212979
- Next
  - 1
    - Suggestions needed on printing checks I need to print checks with a stub. The information on the stub may cause it to go to a second page. I wish to use standard check stock in bin 1 of a printer and place standard paper in bin 2 of the same printer. I wish to print page 1 from bin 1 (check stock) and any subsequent pages from bin 2 (standard paper). I also want to print a signature graphic. Is this possible using a standard FoxPro report? (Specifically the switching of bins). If not would the @SAY method of printing be a better solution? Would the ??? method of printing be the best choice? Is it better to print the MICR and check image on plain paper using magnetic toner (any suggestions for a printer)? or, Is there a third party solution I am unaware of that would help? The trick is the switching of bins. I have tried many ways to do the report form, but the escape sequences are sent to the report (and printing as qarbage) instead of controling the printer. TIA Mark Tag: How to "force" SET RELATION? Tag: 212977
  - 2
    - Word Automation - Need help I'm using foxpro to automate a search through thousands of files for hundreds of search terms. I'm writting the results to a file Here is the basic code: <<<Begin code>>> THIS.oWord=CREATEOBJECT("Word.Application") ....CODE CODE cdoc=TRIM(filenames->cpath) oDocument=THISFORM.oWord.Documents.OPEN(cdoc,.F.,.T.) oRange=oDocument.RANGE oRange.FIND.MatchCase=.F. myend=oRange.END SELECT srchfor SCAN srchtext=ALLTRIM(srchfor->srchterm) oRange.FIND.TEXT=m.srchtext oRange.START=0 oRange.END=m.myend lfound=.F. oRange.FIND.clearformatting lfound=oRange.FIND.Execute() IF lfound ..... CODE CODE CODE ENDIF ENDSCAN <<<End code>>> It works fine I get thousands of hits BUT it misses items in footnotes. WHY WHY?? Please help if you can. This is for an important job and I'm stymied Thank You Tag: How to "force" SET RELATION? Tag: 212973
  - 3
    - Cursor across multiple tables I am selecting information from multiple tables into a cursor 'cur'. I need to bind these fields to textfields. My problem occurs when I try to move the cursor. When i use skip or go I dont know what table alias to use. 'cur' doesnt work. Bobber Tag: How to "force" SET RELATION? Tag: 212967
  - 4
    - RUN with parameters? Is it possible to call RUN and send parameters to the called program? In particular, I'm trying to pass a handle to a WinAPI object. Tag: How to "force" SET RELATION? Tag: 212958
  - 5
    - Programmatically bring up the command window I have FoxPro 2.0. I need to bring up the command window via code. When I run this .PRG file the command window is not present. If I hit escape, the browse window disapears and up comes the command window. I'd like both to be present when the code finishes. FILENAME = 'J:\ML\WPS\W23301.dbf' RESTORE MACRO FROM P:\SOFT\ABSSHELL\FOXMACR.FKY USE &FILENAME COUNT BROW Regards Dale Jones Tag: How to "force" SET RELATION? Tag: 212952
  - 6
    - Adding a Container I am new to VFP and am trying to dynamically add a container to one of my forms. This container is inherited from container, and contains some custom code. Anyways I am trying to use the forms addobject method, and VFP says that the class cannot be found. Is there something I have to do so that my inherited class shows up in the default search path. I have also tried passing the library that contains the inherited class with no luck. Tag: How to "force" SET RELATION? Tag: 212951
  - 7
    - IRC User group for Foxpro Hi, Come join us on irc at irc.freenode.net on the #vfp channel, for help and general foxpro chat. Tag: How to "force" SET RELATION? Tag: 212949
  - 8
    - some advice again again thank you for all you help on previous items. again, i have hit the WALL!! in your eyes i am not doing anything tough, i just cant seem to think past it. please advise. ok, I open a table, get data from it and place it into a new one. Now I will open the New table, add to fields to itâ?¦(2 fields manually) no big deal.. Open a third tableâ?¦scan it for the 2 fields, I need and place them in the proper place. My code is below. It keeps telling me I have no table open but I do (I thought) clear all set default to f: USE f:\foxpro25\lagers\dbases\lagchk.dbf IN 0 shared copy to f:\foxpro25\lagers\dbases\forauditors.dbf for checkdte >= ctod('06/01/04') and checkdte <= ctod('06/01/05') use f:\foxpro25\lagers\dbases\forauditors.dbf shared use f:\foxpro25\lagers\dbases\fulagmas.dbf in 0 shared select 0 set order to PADL(agency,6,"0")+PADL(dpt,3,"0")+PADL(employee,6,"0") go top scan if !eof() if fulagmas.agency = forauditors.agency and fulagmas.dpt = forauditors and fulagmas.employee = forauditors.employee replace forauditors.brthdt with fulagmas.brthdt, forauditors.benprgflg with fulagmas.benprgflg endif endif endscan Tag: How to "force" SET RELATION? Tag: 212934
  - 9
    - TEXTMERGE problem Hi, What's the problem (tested with VFP 8 + 9) with following textmerge? ----8<---- #DEFINE myConst "myText" TEXT TO lcStmt TEXTMERGE NOSHOW select * from myTable where field = "<<myConst>>" ENDTEXT ---->8---- Ok, this would be a workaround, but it's not that nice :( ----8<---- #DEFINE myConst "myText" TEXT TO lcStmt TEXTMERGE NOSHOW select * from myTable where field = <<'"' + myConst + "'">> ENDTEXT ---->8---- Thanks Marco Tag: How to "force" SET RELATION? Tag: 212926
  - 10
    - replace a word in all SCX ? hi how can i replace a specific word by another in all Forms without having to open everyone ? thanks -- atte, Hernán Castelo SGA - UTN - FRBA Tag: How to "force" SET RELATION? Tag: 212920
  - 11
    - make a copy of "Scatter"ed object ? hi my proc receives a parameter of type object that object is product of SCATTER NAME i need to make a LOCAL copy in a local variable, i can't do it with Lparameters and Local var combination Yes, everything works if i get a parameter of "other kind of object", like custom, form, text...... but not with Scattered Objects I need something like "CloneObject" but the Scattered Objects has not methods In the case of an array, it can be achieved with ACOPY how can I make my local copy ? ( a kind of C's memcpy ? ) thanks IA -- atte, Hernán Castelo SGA - UTN - FRBA Tag: How to "force" SET RELATION? Tag: 212917
  - 12
    - Changing Fontcharset in report... aGkgYWxsLA0KYWZ0ZXIgY2hhbmdpbmcgZm9udCBzY3JpcHQgaW50byBCbGF0aWMgKHdpbmRvd3Mg IHNldCB1cCB0byBkaXNwbGF5IG5vbiB1bmljb2RlIGFzIGN5cmlsbGljKSBpbiBSZXBvcnQgZGVz aWduZXIgbGV0dGVycyBhcmUgc2hvd24gaW4gQmFsdGljIChPSykgLCBidXQgYWZ0ZXIgY29tcGls aW5nIGV4ZSBmaWxlIGFuZCBydW5uaW5nIGl0IC0gbGV0dGVycyBpbiBteSByZXBvcnQgYXJlIHNo b3duIGFzIGN5cmlsbGljLi4uIGhvdyBjYW4gaSBtYWtlIG15IHJlcG9ydCBkaXNwbGF5IGJhbHRp YyBsZXR0ZXJzIGNvcmVjdGx5IHdoaWxlIHdpbmRvd3MgaXMgdXNpbmcgbm9uLXVuaWNvZGUgbGFu Z3VhZ2UgY3lyaWxsaWM/DQoNClZGUCA5DQo= Tag: How to "force" SET RELATION? Tag: 212914
  - 13
    - Table Activity trace Log. is there a way to keep a log of all transaction for specific table ? (updates that could come from multiple modules that performing delete, add and change of data) using Foxpro Database. Tag: How to "force" SET RELATION? Tag: 212913
  - 14
    - Expression Validity Tester I am looking for a cheap or free expression tester for my application. I have various parts in my application where the user is allowed to freeform enter an expression and I need a way to ensure the expression is valid so the program does not error out when it is miskeyed etc. Any help is appreciated, Scott Tag: How to "force" SET RELATION? Tag: 212907
  - 15
    - Click and DblClick conflict? (VFP6) I have a form which contains a grid. I want the user to be able to (left)Click on a row of the grid to perform a Click method; and to DoubleClick to do a different, DblClick method. I can't get them to work together, even when I increase the _DBLCLICK value to its maximum (about 5.5 seconds). The form seems to respond to a doubleclick as if it were a singleclick. I *am* able to get Click and RightClick to coexist. I can also code for a DblClick by itself. But the bottom line is: I can't get Click, DblClick, and RightClick all to function in the same control or object. Why is this? (By the way, I think the explanation of _DBLCLICK in the VFP 6.0 Language Reference is wrong. It says the syntax is _DBLCLICK = nTicks, but it should say _DBLCLICK = nSeconds, where 0 < nSeconds <= 5.5) -- Peter Rooney magnetix@ix.netcom.com Tag: How to "force" SET RELATION? Tag: 212903
  - 16
    - Store (obj.ref) to (local var) ??? hi i need to make a local object from an object reference ... how can i do ? the reference to the object is received into a LParameters variable but it does not work... not even assigning other the argument to a local variable .... thanks -- atte, Hernán Castelo SGA - UTN - FRBA Tag: How to "force" SET RELATION? Tag: 212902
  - 17
    - Windows XP - Cannot find dll entry point Hi There, I have a problem with the following code: cSEntry = REPLICATE(CHR(0),8)Thisform.dregister = ; && register foxpro as an shell api event handler SHChangeNotifyRegister(_vfp.hWnd, 2, SHCNE_ALLEVENTS, WM_USER_SHNOTIFY,1,@cSEntry) BINDEVENT(_VFP.hWnd, WM_USER_SHNOTIFY, Thisform, "DragNDropFiles") SHChangeNotifyRegister: On some computers it cannot find the entry point to the api call. Why is this? I am having the problem on Windows XP (no SP) but works fine on SP2. Thanks Glenn Tag: How to "force" SET RELATION? Tag: 212891
  - 18
    - Browses on Pocket PC You may download a working demo of Harbour and FiveWin for Pocket PC using browses from here: http://www.fivetechsoft.com/files/fwce10.zip This is how browses look: http://www.fivetechsoft.com/files/fwce10.jpg The source code is as simple as this: #include "FWCE.ch" REQUEST DBFCDX function Main() local oWnd, oBrw USE "storage card\Customer" VIA "DBFCDX" DEFINE WINDOW oWnd TITLE "Tutor10" @ 1, 1 LISTBOX oBrw FIELDS SIZE 220, 167 @ 12, 2 BUTTON "Done" SIZE 80, 30 ; ACTION oWnd:End() ACTIVATE WINDOW oWnd ; ON CLICK MsgInfo( "Click!" ) return nil regards, Antonio Linares www.fivetechsoft.com Tag: How to "force" SET RELATION? Tag: 212889
  - 19
    - FoxPro, Clipper and dBase for Pocket PC and SmartPhone! FoxPro, Clipper and dBase applications development for Pocket PC is already available from: http://www.fivetechsoft.com/english/fwppc.html FWPPC uses Harbour (www.harbour-project.org), the open source Clipper compatible compiler, already ported to Windows Mobile operating system. Full DBFs, Indexes (CDXs, NTXs) support, plus all the Clipper language features. Lars Tag: How to "force" SET RELATION? Tag: 212882
  - 20
    - combobox I created a combobox in a form (style=dropdown combo). user can input his own text or select from an existing one. I entered some text into it. After a thisform.refresh(), the combox.value was cleared. Why? how could I keep the user-inputted value persistent? As a result, I couldn't save the value to the combobox.controlsource. The underlying table is having buffering=5. Tag: How to "force" SET RELATION? Tag: 212881
  - 21
    - report form 1. How could print a logo on a report form with transparent background? Must I use a gif? 2. Could I use a variable in path property of a PictureOLE Bound object? Tag: How to "force" SET RELATION? Tag: 212880
  - 22
    - universalthread.com Not Up-to-date? There is no news today. The date at the top of the page is Bathurst, June 23, 2005 17:44 AST. Is anyone else seeing this? Sincerely, Gene Wirchenko Tag: How to "force" SET RELATION? Tag: 212866
  - 23
    - Data session issues - VFP9 Has anyone come across any quirks with VFP9 forms and reports with respect to using private data sessions? Several of us are running into intermittent issues. I've not yet been able to duplicate it 100%, but I'm working on that. Issue: You run a report from a program, and the find file dialog appears. No apparent reason. Suspend program immediately before report form is run. Open debugger, add set('datasession'). Edit report. Preview. Previews fine, datasession stays at 1. Immediately preview again. Datasession changes, find file dialog appears. Cancel. Preview again, previews fine. Preview again, find file dialog appearrs and datasessions is changed. Every other time we previewed the report, it would change datasession and error out, and every other time it would preview fine. Issue: Modify report. Ensure private data session is not selected. Save report. Edit report. Private datasession is selected. Unselect it. Save report. Edit report. Private datasession is selected. Issue: Create form. Set to private datasession. Add tables to DE. Save. Edit, set to default datasession. Save and run. Form opens in private datasession, even though you set it to default. We are seeing enough of these to establish a pattern, but not enough to duplicate it 100%. (and, no, I'm not the only one here that is seeing this :-P ) Tag: How to "force" SET RELATION? Tag: 212862
  - 24
    - VFP 8: Grids (bug problem) I have a container class that contains a grid. The grid was setup to have specific column names. I set the grid to point to a cursor during runtime. This allows me the ability to have multiple instances of the container using different cursors. The container is loaded onto a form at runtime as the user needs this interface. The code below is my standard way of "binding" the data to the grid. cTempFile1 = "somecursor" this.Grid_Codes.recordsource = 1 && Alias this.Grid_Codes.recordsource = cTempFile1 this.Grid_Codes.col_code.controlsource = cTempFile1 + ".cCode" this.Grid_Codes.col_desc.controlsource = cTempFile1 + ".cDesc" The problem I am having is, sometimes (hard to repeat), I get errors because the code is referring to the col_code column. VFP errors out stating "Unknown member COL_CODE". It turns out, that the grid has lost the names of the grid, and now has the names Column1 and Column2 instead of col_code and col_desc. Has anyone else seen this problem, and does anyone have a resolution? Thanks, Dan Tallent Tag: How to "force" SET RELATION? Tag: 212853
  - 25
    - Passing Macro Output Value to a Variable or TextFile ? I am using TextMerge on Memo Field in Foxpro 2.6 for Dos. use customer set textmerge on a="/ Dear <<Name>>" &a 'This will produce Dear Luqman Now, I need to print result of &a to report, how can I save this result into a table or cursor ? Best Regards, Luqman Tag: How to "force" SET RELATION? Tag: 212848

Hi,

I'm having a problem in VFP9. I set a relation between two tables so that
the child should always be tied to the current row in the parent.

I have two grids on a form. One for the parent table and one for the child.

The problem is that when I move to a different record in the parent grid
the child grid doesn't change. The relation doesn't appear to be working.

I know my SET RELATION is correct b/c I can BROWSE the two tables and see
that the relation is working.

What do I have to do to make the relation work on the form?

Thanks, Frank

SV: How to "force" SET RELATION? by Anders

Anders
Mon Jul 04 12:39:31 CDT 2005

Try Childgrid.Refresh()

-Anders

Den 05-07-04 16.57, i artikeln
Xns96896F85B2854adfslur0mdoaur03jadl@207.115.63.158, skrev "Frank Dreyfus"
<fdreyfus@nyw.com>:

> Hi,
>
> I'm having a problem in VFP9. I set a relation between two tables so that
> the child should always be tied to the current row in the parent.
>
> I have two grids on a form. One for the parent table and one for the child.
>
> The problem is that when I move to a different record in the parent grid
> the child grid doesn't change. The relation doesn't appear to be working.
>
> I know my SET RELATION is correct b/c I can BROWSE the two tables and see
> that the relation is working.
>
> What do I have to do to make the relation work on the form?
>
> Thanks, Frank
>
>
>

Re: SV: How to "force" SET RELATION? by man-wai

man-wai
Wed Jul 06 09:09:51 CDT 2005

Anders wrote:
> Try Childgrid.Refresh()

How about this way:

select parent_dbf_alias
go recno()

--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.30
^ ^ 10:09pm up 54 days 10:19 load average: 0.61 1.17 1.38

Re: How to "force" SET RELATION? by Ben

Ben
Thu Jul 07 02:25:54 CDT 2005

I would go for a Thisform.Refresh() or a Childgrid.Refresh()