Store procedure

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
    - 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: Store procedure Tag: 213061
  - 2
    - incorrectly decrypted data -different default non-unicode languages aGksIA0KaSdtIGVuY3J5cHRpbmcgZGF0YSAoZmllbGRzIGluIGRiZikgaW4gUEMgIyAxLCB3aGVy ZSBkZWZhdWx0IG5vbi11bmljb2RlIGxhbmd1YWdlIGlzIHNldCAgZm9yIGV4YW1wbGUgInh4eCIu IHdoZW4gaW0gZGVjcnlwdGluZyB0aGUgc2FtZSBkYXRhIG9uIHRoZSBzYW1lIFBDLCBldmVyeXRo aW5nIE9LLiANCkJ1dCB3aGVuIGltIHRyeWluZyB0byBkZWNyeXB0IGl0IG9uIFBDICMyIChkZWZh dWx0IG5vbi11bmljb2RlIGxhbmd1YWdlIGlzICJZWVkiLCBub3QgInh4eCIpLCBkYXRhIGlzIGJl ZWluZyBkZWNyeXB0ZWQgaW5jb3JyZWN0bHkuLi4gaG93ICBhd29pZCB0aGlzPw0KDQp0aGFua3Mu Lg0K Tag: Store procedure Tag: 213050
  - 3
    - 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: Store procedure Tag: 213041
  - 4
    - simple data encryption algorythm? aGksIA0KZG9lcyBhbnlib2R5IGtub3cgYW55IHNpbXBsZSBhbmQgRkFTVCBhbGdvcnl0aG0gdG8g ZW5jcnlwdCBkYXRhIGluIHRoZSBkYmYgZmllbGRzPw0KKGV4Y2VwdCBfY3J5cHQudmN4KQ== Tag: Store procedure Tag: 213032
  - 5
    - 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: Store procedure Tag: 213031
  - 6
    - 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: Store procedure Tag: 213025
  - 7
    - 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: Store procedure Tag: 213024
  - 8
    - 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: Store procedure Tag: 213016
  - 9
    - 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: Store procedure Tag: 213010
  - 10
    - 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: Store procedure Tag: 213003
  - 11
    - 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: Store procedure Tag: 212998
  - 12
    - 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: Store procedure Tag: 212988
  - 13
    - 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: Store procedure Tag: 212984
  - 14
    - 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: Store procedure Tag: 212983
  - 15
    - 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: Store procedure Tag: 212981
  - 16
    - Holiday in the world is there any website provide XML downlod of holiday in the world or any forms of format ? Thanks Tag: Store procedure Tag: 212979
  - 17
    - 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: Store procedure Tag: 212977
  - 18
    - 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: Store procedure Tag: 212973
  - 19
    - 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: Store procedure Tag: 212967
  - 20
    - 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: Store procedure Tag: 212958
  - 21
    - 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: Store procedure Tag: 212952
  - 22
    - 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: Store procedure Tag: 212951
  - 23
    - 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: Store procedure Tag: 212949
  - 24
    - 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: Store procedure Tag: 212934
  - 25
    - 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: Store procedure Tag: 212926
- Next
  - 1
    - 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: Store procedure Tag: 212920
  - 2
    - 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: Store procedure Tag: 212917
  - 3
    - Changing Fontcharset in report... aGkgYWxsLA0KYWZ0ZXIgY2hhbmdpbmcgZm9udCBzY3JpcHQgaW50byBCbGF0aWMgKHdpbmRvd3Mg IHNldCB1cCB0byBkaXNwbGF5IG5vbiB1bmljb2RlIGFzIGN5cmlsbGljKSBpbiBSZXBvcnQgZGVz aWduZXIgbGV0dGVycyBhcmUgc2hvd24gaW4gQmFsdGljIChPSykgLCBidXQgYWZ0ZXIgY29tcGls aW5nIGV4ZSBmaWxlIGFuZCBydW5uaW5nIGl0IC0gbGV0dGVycyBpbiBteSByZXBvcnQgYXJlIHNo b3duIGFzIGN5cmlsbGljLi4uIGhvdyBjYW4gaSBtYWtlIG15IHJlcG9ydCBkaXNwbGF5IGJhbHRp YyBsZXR0ZXJzIGNvcmVjdGx5IHdoaWxlIHdpbmRvd3MgaXMgdXNpbmcgbm9uLXVuaWNvZGUgbGFu Z3VhZ2UgY3lyaWxsaWM/DQoNClZGUCA5DQo= Tag: Store procedure Tag: 212914
  - 4
    - 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: Store procedure Tag: 212913
  - 5
    - 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: Store procedure Tag: 212907
  - 6
    - 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: Store procedure Tag: 212903
  - 7
    - 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: Store procedure Tag: 212902
  - 8
    - 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: Store procedure Tag: 212891
  - 9
    - 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: Store procedure Tag: 212889
  - 10
    - 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: Store procedure Tag: 212882
  - 11
    - 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: Store procedure Tag: 212881
  - 12
    - 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: Store procedure Tag: 212880
  - 13
    - 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: Store procedure Tag: 212866
  - 14
    - 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: Store procedure Tag: 212862
  - 15
    - 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: Store procedure Tag: 212853
  - 16
    - 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: Store procedure Tag: 212848
  - 17
    - Using Fields within Memo Text and use in Report ? Is it possible in Foxpro 2.6 for Dos, to use Fields within Memo Text, and then print that Memo in Report, which should replace the field names with their values. Something like TextMerge option in foxpro. For example: I put following in Memo Field. My Name is <<<cName>>> When I print this field in report, it should display following. My Name is Luqman My Name is Usman My Name is Aman Is it possible ? Best Regards, Luqman Tag: Store procedure Tag: 212841
  - 18
    - VFP6 exception Falal Error Exception code = C00000FD called from - ar_invoice.apppageframe.page2.g_recordmaintenance.cmd_save.click (line 0) Windows\system32\vfp6r.dll Any hint? Tag: Store procedure Tag: 212839
  - 19
    - text search in a class lib Is there a good tool to do text search on classlib, listing the object.method containing the text? I tried class browser, but the find function doesn't quite work. Tag: Store procedure Tag: 212832
  - 20
    - VFP 9 Report gibberish Has anyone else had trouble with SET REPORTBEHAVIOR 90 printing gibberish either to a printer or to a PDF print driver? I was able to make the printer work by changing to a generic HP LaserJet III driver, but I still get black boxes instead of text for the Amyuni 2.50 PDF print driver and random alphanumerics for the Adobe Acrobat 4.0 print driver. I've turned off the Save Printer Settings checkbox, but no difference. The reports work fine with SET REPORTBEHAVIOR 80. Any suggestions? Tag: Store procedure Tag: 212828
  - 21
    - Controlling the Size of a TIF File I have a process that uses the report listener to output a TIF file. It works great except for one thing: The size of the TIF file. I set up the report to be only 6 in. high by 6 in. wide, but when the report is output as a TIF, the image has the actual report (6 x 6) in the upper right of an image that is 8.5 in by 11 in. How do I make the size of the TIF file be 6 in. by 6 in.? Thanks. Charlie Parker Tag: Store procedure Tag: 212827
  - 22
    - MSXML 4.0 merge modules The VFP9 Help file says there are two of these, and they are described, along with the VFP runtime, as required. However, I have inadvertently left them out of setups I've built, and gotten no problems (so far). Does anyone know what these things do? Something with XML apparently (which this app doesn't use), but if that's the case, why are they listed as required? Tag: Store procedure Tag: 212826
  - 23
    - CURSORADAPTER DOES NOT COMMIT DATA in MYSQL DATABASE Hi guys I am using a code that I have found in internet (CURSORADAPTER.ZIP) and I am using it to retrieve data from MYSQL database but after I change the data and use an "TABLEUPDATE(0, .F., 'cursor')" just the cursor data is changed adn MYSQL does not reflect the changes, I know I have to send an COMMIT command to MYSQL but How can I do this (send a commit to mysql) using this cursoradapter. Thanks. Tag: Store procedure Tag: 212825
  - 24
    - create a date field in a select stmt??? How do you create a date field in a select statement. In other words, I could create a numeric field called age by the following: select name, id, 000 as age from <table> order by name into <newtable> What if I wanted to also create a date field called birthdate. How would I do that? Tag: Store procedure Tag: 212813
  - 25
    - cursors Hi All How do I transfer the contents of a cursor created by an sql select into a table? SELECT * FROM issues WHERE keyfld=Tfind INTO cursor toutput I have got the select in a do while loop to pick-up steel issued to jobs (there can be multilple). I could probably do it with a join, but its tooooo hot and my brain packed in two hours ago! Phwew Steve Tag: Store procedure Tag: 212812

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.

Top