On Label Key

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
 - VFP and MySQL Hi, 1. using VFP and MySQL, does it the exe can update data in webserver from remote pc using internet connection ? eg: open table with IP address ? 2. is VFP update speed as good as compare to VB on MySQL ? Regards Hoe Tag: On Label Key Tag: 195926
 - 2
 - CodeMine Framework I'm rebuilding an application in 8.0 using the new version of CodeMine. But, the original developer didn't use, or else save, the original CodeMine environment. Has anyone any experience with this kind of situation? Thanks Steve Tag: On Label Key Tag: 195921
 - 3
 - can u shed some light on this weird class instantiating err Hi friends i created class (class name is ctrHeight.VCX) with container,a label ,commandbutton a textbox in it. when i add this to this a form from toolbar everything works fine. but when i add this control thr code like following thisform.AddObject('cnt','container') thisform.cnt.visible=.t. thisform.cnt.newObject('cntheight','ctrlheight','D:\VSSLocal\vip\ctrHeight.VCX') thisform.cnt.cntheight=.t. i am getting following error "Error instantiating the object "txvalue" (actually it is a textbox)" i am wondering what i am doing wrong here. i just found when i add this control from toolbar and add another control thr code like abv everything working fine??? what i am missing here?? many thanks for ideas -- cheers Tag: On Label Key Tag: 195920
 - 4
 - Shortcut evaluation Hi, I'm having a bit of a headache because of the following: I want to let the user type an expression and check whether it's valid or not eg "x=1 and y=2" Now, the tricky part is that I can't be sure that y (or whatever variable the user makes up) exists at this point. Now, if x equals 0, the "y=2" part is not evaluated, so I won't get an error if Y does not exist and therefor I cannot report this error (so my "expression-validation" routine will not indicate that this expression cannot be used for all values of x). Now the user can make quite some difficult statements (with brackets etc) eg: (x=1 and y=2) or ((b<=3 or c=3) and c>2) or InList(q, 'a', 'b', 'c') So my question is: does anybody have an idea about how to generate a list of all variables used in an expression? R Robert Tag: On Label Key Tag: 195917
 - 5
 - Moving Classes Around I should like to move my classes to another folder. How can this be done without messing-up all classes lower down in hierarchy and object based upon them? Thanks in advance. Shmiel. Tag: On Label Key Tag: 195915
 - 6
 - Nesting of For loops Can the "for" loops be nested in vfp? My program is giving nesting error. for i = 1 to 6 for ..... if.... ---- ---- endif endfor endfor Tag: On Label Key Tag: 195889
 - 7
 - compatible? Can I use Foxpro for the Web? May I create aplications, put them in an internet server and run in the usersÂ´s browsers? How does this works? -- Lorenzo MÃ¡rquez Tag: On Label Key Tag: 195887
 - 8
 - Assigning objects I have a situation. From container1 I am zooming into container2 by trapping the click event of container1. Both containers represent the same thing, except that container2 looks big. When I come back to container1, I want all the control settings that I had made to container2 to appear in container1 and also when zooming to container2 from container1, I want all the settings of container1 to appear in container2. What is easiest and the best way to do this? Using a base class to represent both the containers. And creating 2 objects to represent the normal and zoomed versions of the container and assigning one object to the other when zooming back and forth. Can this be done? Is this the best approach to this? Regards Tag: On Label Key Tag: 195883
 - 9
 - How to determine PC regional setting ? How to determine current PC's regional setting through VFP ? E.g. i have one external function call which return a value base on current PC regional setting. in order for my program to manipulate the return value, i need to know the client PC's regional setting. one common problem will be american and british date format. Thanks in advance. Tag: On Label Key Tag: 195877
 - 10
 - parameter for WEb Pages Hi, sorry.. this is off topic but maybe somebody can help me.... I have a very simple question, maybe a stupid one.... but I have done several excercises building WEBpages using dynamic HTML with VB scripting, and found documentation and theo bject model hard to understand :-( what I need to do is to call a web page from a hyperlink and let such called web page to receive a parameter let say that I have the following hyperlinks <A href="http://checaproducto.htm?product=A123">producto A</A> <A href="http://checaproducto.htm?product=A235">producto B</A> the idea is that for any hiperlink the same tarjet web page will be called but passing thru a parameter (product ID) my question is what kind of instruction should I need to use in the called web page (checaproducto )to know the value of the parameter(productID) I would prefer to use stadard HTML rather than ASP, is it possible? thanks thanks in advance Oscar Taboada Tag: On Label Key Tag: 195875
 - 11
 - Graphics in VFP In one of my applicatoins I use office automation (Excel) to display business graphics. Now this application will be deployed to a client that doesn't use MS Office. Is there any other package (e.g. Active-X) that I can use so I can keep most of the code? The graphics I produce is ordinary bar and pie charts and diagrammes. Tag: On Label Key Tag: 195873
 - 12
 - Total count of contained controls H iAll, Is there a way to loop through all the controls within a container till all the controls are visited? Something like, for i = 1 to container.totalcountOfContainedControls .... .... endfor Regards Tag: On Label Key Tag: 195866
 - 13
 - Moving the record pointer backwards Hi, Is it possible to move the record pointer one record previous to its current position when traversing theough a query result stored in a cursor? Regards Tag: On Label Key Tag: 195863
 - 14
 - PassArray To Ado,Xml hi all i looking for Exsample To pass data beetwen Form And Com Server like Passarray Prg i found in unvirsalthread.com but pass data with ado or xml tankes Tag: On Label Key Tag: 195862
 - 15
 - Shamanism, Normism & Declaration of Heaven on Earth2792 Please visit http://www.normism.org for details! 151415dhfubm151415 dhfubm151415dhfubm ----------------------------------------------------------------------------- --This Message Has Been Posted Using A Trial Version Of Message Poster 2003-- ----------------------------------------------------------------------------- Would you like to reach millions of customers for only the cost of bandwidth? You can post messages like this to thousands of newsgroups with a simple to use software application called Message Poster 2003. For more details on this extremely affordable software, visit: http://www.exibitionsoftware.com Tag: On Label Key Tag: 195861
 - 16
 - Spellcheck Can anyone share their experiences trying to incorporate spell checking in a vfp app( for editbox and/or rtf text)? I can't even find the spellchk.app mentioned in the kb. -Lew Tag: On Label Key Tag: 195848
 - 17
 - To save web server resources, To save web server resources, do anyone know how to launch a VFP Report writer from a web page to print report? and can I check the VFP is being loaded to keep one copy EXE in memory only? KL Tag: On Label Key Tag: 195839
 - 18
 - VFP9 ReportListener Talent Search This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C45578.E8CB4A90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 I'm looking for interesting and innovative ideas for putting the VFP 9.0 = ReportListener class to use, for publication in either FoxTalk 2.0 or in = another alternative format. You might call this a "talent search" or = "competition" to see who can come up with the most outrageously useful = subclasses of ReportListener. =20 As you probably know, you can subclass ReportListener (or in some cases = just set properties of the standard ReportListener) to accomplish = customized output, alternative output formats, specialized preview = windows, and transformed rendering, as well as hooking together several = listeners on the same report run. =20 If you can come up with an interesting use of ReportListener, please = email it to me for consideration for publication. The code is the thing. = You should also write a few paragraphs explaining what the code does, = and the code should have some comments in it, but don't worry about = writing perfectly -- I'll take care of grammatical corrections. =20 If your example is chosen for publication, you will receive a small = author's fee or royalty as a reward. If your example is not chosen, you = will have at least learned something by exploring the ReportListener = class and the overall changes to the VFP 9 Reporting System, and you = can, of course, post your sample online at that point. =20 I would love to publish dozens of cool examples that can help educate = the VFP community worldwide about how to leverage VFP 9's extensibility = features in creative ways. We need to build up a knowledge base of = various approaches to jump-start other ideas. =20 Go ahead. Jump in and create your special listener, then email your code = sample to me at "david -AT- topstrategies. COM" (obviously, fix up the = address first). Happy experimenting! =20 David Stevenson=20 Editor, FoxTalk 2.0 www.pinpub.com ------=_NextPart_000_0008_01C45578.E8CB4A90 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.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> <FONT=20 size=3D2>Hi all,<?xml:namespace prefix =3D o ns =3D=20 "urn:schemas-microsoft-com:office:office" = /><o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">I'm looking for = interesting=20 and innovative ideas for putting the VFP 9.0 ReportListener class to = use, for=20 publication in either FoxTalk 2.0 or in another alternative format. You = might=20 call this a "talent search" or "competition" to see who can come up with = the=20 most outrageously useful subclasses of=20 ReportListener.<o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">As you probably = know, you can=20 subclass ReportListener (or in some cases just set properties of the = standard=20 ReportListener) to accomplish customized output, alternative output = formats,=20 specialized preview windows, and transformed rendering, as well as = hooking=20 together several listeners on the same report=20 run.<o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">If you can come = up with an=20 interesting use of ReportListener, please email it to me for = consideration for=20 publication. The code is the thing. You should also write a few = paragraphs=20 explaining what the code does, and the code should have some comments in = it, but=20 don't worry about writing perfectly -- I'll take care of grammatical=20 corrections.<o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">If your example = is chosen for=20 publication, you will receive a small author's fee or royalty as a = reward. If=20 your example is not chosen, you will have at least learned something by=20 exploring the ReportListener class and the overall changes to the VFP 9=20 Reporting System, and you can, of course, post your sample online at = that=20 point.<o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">I would love to = publish=20 dozens of cool examples that can help educate the VFP community = worldwide about=20 how to leverage VFP 9's extensibility features in creative ways. We need = to=20 build up a knowledge base of various approaches to jump-start other=20 ideas.<o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">Go ahead. Jump = in and create=20 your special listener, then email your code sample to me at "david -AT-=20 topstrategies. COM" (obviously, fix up the address first). Happy=20 experimenting!<o:p></o:p> <SPAN=20 style=3D"COLOR: black"><o:p> </o:p> <SPAN=20 style=3D"COLOR: black">David Stevenson = <o:p></o:p> <SPAN=20 style=3D"COLOR: black">Editor, FoxTalk = 2.0<o:p></o:p> <SPAN=20 style=3D"COLOR: black">www.pinpub.com <o:p></o:p></DIV></BODY></HTML> ------=_NextPart_000_0008_01C45578.E8CB4A90-- Tag: On Label Key Tag: 195838
 - 19
 - VFP 8.0 unstable and unreliable ? Hi I was asked about some weird behaviour of VFP 8.0 executables and IDE. The network is a mixture of Novell 5.x and Windows 2000 Server, Win2k box is running SQL Server 2000, and Novell 5.x holds several .DBFs for a legacy Clipper DOS system still in use and printing services. The workstations are mainly Win98 (several) and Win98SE, mainly with 32MB RAM and slow disks (I guess there is a lot of legacy computers still in use, Pentium II MMX 266 and K6s 300). There are a number of serious problem in the stability of the clients. And the programmer's team experienced some real problems with VFP´s IDE stability, even on Windows XP Pro, suddenly VFP 8.0 crashes and deletes the form o report you were working on until that moment. There are some other glitches at the clients, the mouse pointer frozen, no blue screen but a "Windows 98 must close.." and similar issues, with a lot of problems at the help desk (the whole network compromises about 200+ computers). They are going to switch to Delphi or .NET in these days, that unstability isses upset all the programmer's team and in-house IT crew, they almost do not want to hear about VFP anymore. Can anyone here drop any advise, any idea? Thanks in advance Carlos A. Pérez Tag: On Label Key Tag: 195836
 - 20
 - DLL Scope, etc... I'm writing a wrapper for blat.dll and I've got a couple of questions. In a method I: declare integer send in blat.dll string blatstring What is "send"? type("send") and vartype(send) tell me nothing. What is the scope of send, everywhere in VFP, ie is it kind of public? A language addition? Is there any way to limit the scope of send? Similarly, what's "blatstring"? -Lew Tag: On Label Key Tag: 195834
 - 21
 - RTF Toolbar & Menu I'm writing a shot app that includes the ability to add/edit rtf text via the MS active-x RTF control. Is there a ready-made (eg as in Outlook) formatting menu/toolbar available somewhere? -Lew Tag: On Label Key Tag: 195831
 - 22
 - LB's, arrays, VFP9b vs earlier versions & my memory I haven't been writing any VFP for a few months, but I wasn't able to get a lb to display all the rows in its rowsourcetype=5/rowsource="arrayname" until I began manually to update the numberofelements property to match the number of rows in the array. I don't remember having to do this in earlier versions. Is my memory slipping? -Lew Tag: On Label Key Tag: 195827
 - 23
 - how to get connection count Hi all, How can I get connection count when I connect to SQL vis pass through? I.e. when I issue: nCon = SQLCONNECT('SDSN', 'user', 'pw') I get a (postive) number in nCon. However if I issue this again and again there will several connections numbers. TIA Kamran Tag: On Label Key Tag: 195825
 - 24
 - OLE Automation - Excel I have a program where I create excel spreadsheets from a cursor. Then, I use ole automation to format the spreadsheet. The spreadsheet is being used as a report. However, people who will use this spreadsheet would like the ability to sort the spreadsheet on different columns. How can I programmatically add code to the spreadsheet to give an user the ability to sort on any column by clicking on it. Note: In my spreadsheet, I'm adding a couple of columns and placing in headers. Tag: On Label Key Tag: 195814
 - 25
 - $$ always displays $ not Currency Symbol In my grid I have a column which is bound to a numberic I want my column to display the numberic as currency (although I want to store it as a number) I have set my currency up: set currency to '£' I set my column inputmask propery up to be "$$9,999,999" format is none, but when run it shows a $ i.e. $12,345.67, should this not show £12,345.67 ? I have tried other combinations of format and input mask, none of which give me what I want format $, inputmask 9,999,999, result: "$ 12,345.67" format $, inputmask $$9,999,999, result: "£$12,345.67" format $, inputmask £9,999,999, result: "£ £12,345.67" format <none>, inputmask £9,999,999, result: "£ £12,345.67" format <none>, inputmask $$9,999,999, result: "$12,345.67" format <none>, inputmask $9,999,999, result: "$ 12,345.67" How can I get it to display "£12,345.67" ???? TIA, Fergus. Tag: On Label Key Tag: 195812
- Next
 - 1
 - vfp and MSexplorer (no error this time) Hi again, Is there way to override or to bypass the Security issues/restrictions that are stored in MsExplorer itself ? christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: On Label Key Tag: 195811
 - 2
 - vfp and MSexplorer ole error Hi, I've made an easy form with just a olecontrol (internet explorer) on it. in the init I've set this.navigate2("http:\\www.irs.be") So far no problems but when running the form I get this error : OLE error code 0x80004005 but it does navigate to the site. So that is not the problem. Anybody an idea ? thanks in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: On Label Key Tag: 195795
 - 3
 - Access to dbf from Excel (ODBC problem) Hi, When trying to import a dbf into Excel 2003 (using Data/Import...) I get "Unexpected error from external database driver (8961)." I dl'd and installed the latest vfp odbc drivers and now have version 6.01.8629.01. Yet, when I try to import using the older "DBase Files (*.dbf)" driver I get the same error. The installation of the new vfp driver set up a System DSN called "Visual Foxpro Tables". But that dsn doesn't appear in Excel. I finally realized that instead of Data/Import, File/Open worked fine even though using the older "DBase Files (*.dbf)" driver. But shouldn't Data/Import work as well? How do I get the new driver to show up as a file type in Excel? Thanks, Frank Tag: On Label Key Tag: 195791
 - 4
 - NT4 & VFP 8 I see that it the developer version requires Win2k but in a run-time will NT4 work? Thanks Tag: On Label Key Tag: 195788
 - 5
 - Calling Oracle Stored Procedure Is it possible to call an Oracle stored procedure? I know that I can execute an SQLEXEC statement, but I have additional processing beyond a SQL query. Tag: On Label Key Tag: 195781
 - 6
 - Order entry sample Is there a good Order entry sample out there? I'm a newbee, and trying to make a order entry system. Need desperatly a sample on how to use Parent/Child forms with lookup functions and calculations on forms and reports. Would be nice with a complete simple order entry sample... James Tag: On Label Key Tag: 195773
 - 7
 - vfpro 7.0 Have created two new forms in an application. When the command DO FORM is executed, the forms flash on the screen for a matter of seconds. The WindowType under Properties is set to 2 Read (as it is for all other forms in this application) no other forms have this behaviour. The project has been rebuilt. Am approaching a serious deadline, please help. Tag: On Label Key Tag: 195769
 - 8
 - Cursor....HELP ME!!! I create a cursor with XMLTOCURSOR(), i want to read the records (by SCAN) without the name of field, but with the index of the field. es: MyCursor.FieldName (Wrong way) ----- MyCursor(0) or MyCursor[0] is my way... HELP ME!! Tag: On Label Key Tag: 195763
 - 9
 - Manual or book I started programing with Foxplus for unix in the 80's and I am back with Visual FoxPro Beta version 9! but I am a little bit lost with so many new things and the object programing. Can someone please recommend me a good book of VP9 easy and complete? -- Lorenzo MÃ¡rquez Tag: On Label Key Tag: 195762
 - 10
 - INSERT INTO I create a cursor by XMLTOCURSOR() and I must to read his record because I must to insert into a table on SQL SERVER. I don't know to do this....help me!!! Tag: On Label Key Tag: 195750
 - 11
 - Backspace in a textbox Currently if a user presses backspace in the textbox it moves to the previous textbox. I though Set Confirm handled this but I was wrong. The problem is that users like to hold the backspace button down and then it just deletes every textbox on the form if they hold it too long. I'm thinking FoxPro has something to prevent this but I cannot find it in the documentation. Can someone help me? -- Altman VFP8 SP1 Tag: On Label Key Tag: 195749
 - 12
 - multiselect getfile ? Hi, somebody, somehow ? (instead of making my own one.) thanks christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: On Label Key Tag: 195745
 - 13
 - VFP6 rpoject upgrade to VFP8 Hi, I had developed a commercial app in VFP6 a few years back and now I intend to start work on the next release of the software but I intend to developeit in VFP8. I need to know if there are any special concerns about this upgrade, anything I should change so my VFP6 code is run & compiled seamlessly in VFP8 ? Can anyone point me to an online atricle on this issue ? TIA Saeed Tag: On Label Key Tag: 195733
 - 14
 - how to read this memo field? i've table (table2) with a memo containg primary keys of the table table1 the data in the memo will be like this AUVrPkTOrcAx4CIHXFhE AWH87WotZhAuyI67JnCc each 10 char set is a pkey .how can i read this memo 10 char by 10 char to find orphan records? many thanks for ur ideas? cheers -- cheers Tag: On Label Key Tag: 195732
 - 15
 - IE Automation I often use Automation similar to the lines below: oie=createobject('internetexplorer.application') oie.navigate(m.myurl) ** do something here with the web page. I may extract 100s of pages from the web. but: this puts each URL into IE History. How can I clear IE History *USING AUTOMATION* when I'm done.? THANKS Mike Farnesi San Diego Tag: On Label Key Tag: 195718
 - 16
 - The ever-fickle SET BELL command VFP8 SP1, WinXP Pro SP1 I've got a TOP LEVEL FORM application that has the following code in a button click method: SET BELL TO "C:\some_folder\some_sound.wav" ?? CHR(7) This works like a charm while testing the form in the VFP IDE. When I build an EXE and run the EXE on the same machine, there is no sound. It makes no difference if the WAV file is included in the app. Shall I just give up on using sounds or is there a reliable way to get this to work. The Windows API? -- TRW _______________________________________ My e-mail: t r w 7 @ i x . n e t c o m . c o m _______________________________________ Tag: On Label Key Tag: 195717
 - 17
 - Copy data to Excel file I have a dbf table in FPW2.6 and with the COPY TO xxx TYPE XLS I can generate an Excel table (release 2.1). How can I put programatically somewhere in the spreadsheet the date and time the Excel sheet was generated? There is the findexe function from J.Assing which allows to open directly the spreadsheet. Is there a way to pass commands to that function, so to format the data in Excel (column width, color, font, etc.) ? Walter Tag: On Label Key Tag: 195714
 - 18
 - Obtaining Line of Code when Error Occurs Hi Everyone, Using the ON Error command in FoxPro, you can return the line number of the statement in error. Does anyone know if it is possible to return the actual line of code that is causing the problem? For Example: On Error may return Line 40 as an error. Is there a way to return the line of code that Line 40 represents? Thank You, Kevin Markvenas Tag: On Label Key Tag: 195703
 - 19
 - Page Total on Report I process 2 invoice with 25 items at page 1 and print group and page total in page 2(it hit the page break line). the invoice total print correctly in group band, but the page band print the total amount for next invoice. It look like the foxpro report at page band have bug, any idea to solve this ? Tag: On Label Key Tag: 195686
 - 20
 - com+ sample hi All i need example How Update Data By "Com" from my Form thnkes Tag: On Label Key Tag: 195675
 - 21
 - Relationships between tables Hello. I have a table - lets call it table A and we have another table called table B I have a relationship between the two tables and i am curently browse fields in table B. If a field is blank in table A then the cursor is placed at the end of table ... why? and how do i get it to go to the top?? As soon as I turn off the relationship everything works fine but I end up with the first entry in table B in a grid list.... eg. grid tableA - customer information tableB - area and there id (location) col1 - tableA col2 - tableA col3 - tableB col1 col2 col3 "joe bloggs" "1 test drive" areaid if col3 is blank then when browsing tableB cursor is placed at end of table - not start. Thanks in advance Glenn Tag: On Label Key Tag: 195674
 - 22
 - VFP7 Service Pack cannot be installed I installed VFP7 in a new computer that is Traditional Chinese Windows XP. I would also like to install the service pack in it. When i run the program, a dialog box appears that confirm the installation. I certainly click "OK". However the installation has not been started and the process just like finish. I have changed the Windows' language setting to English, but the situation has not been changed. Does anybody help me how to do? Tag: On Label Key Tag: 195672
 - 23
 - working with SQL Server's raiserror() Given this stored procedure: create procedure mysp ( @raise char(1) ) as if @raise='Y' raiserror('tesing',16,1) select @@error as result If I call the SP from Foxpro with sqlexec(m.handle, "EXECUTE mysp","t_sp") I got a t_sp cursor containing the resultset of mySP, with t_sp.result=0. Now if I call the same SP with sqlexec(m.handle,"EXECUTE mysp 'Y'", "t_sp") sqlexec() returns an error code, and there will be no t_sp cursor. Could I make Foxpro to create a cursor from the resultset of the SP ignoring the connection error? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 10:34am up 7 days 13:40 load average: 1.35 1.62 1.49 Tag: On Label Key Tag: 195671
 - 24
 - VFP 6 Debugging Problem I am adding a call to a form. For that, I have to open a table. If I run the program, I get an error that it is already open. Fine. Where? I add a set step on (conditionally on a messagebox). I set a breakpoint for when used("cftiwiz_ccli") becomes true. I run the program again. I answer yes to wanting step on. I continue the code as needed. The only time the breakpoint is set off is in the new routine! I run the program yet again. I answer no to wanting step on. The code blows up as it did before the debugging code was added. I just want to find out where in the execution path the table is being opened. Am I doing something wrong, or is this a debugger bug? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: On Label Key Tag: 195668
 - 25
 - VFP 9 Beta and Report Designer I was hoping to see container classes in the new report designer so entire groups of objects could be manipulated at once. Will this be possible? I hope someone writes a book on the new report designer soon! John. Tag: On Label Key Tag: 195661

I need to create "Hotkeys" with "+" and "-" in my application. Is there a
way to do this? They are not options in the On Key Label command.

Thanks,

Scott

Top

Re: On Label Key by Carsten

Carsten
Tue Jun 22 00:46:30 CDT 2004

Scott,

instead of OKL's, try using the KeyPress-Event the form got.
Set the formproperty KeyPreview= .T.

Now put something like this in the Keypress-Event:

<snip>
LPARAMETERS nKeyCode, nShiftAltCtrl

MessageBox( Transform( nKeyCode ))

Note: If "+" is hit, do nothing.
IF nKeyCode == 43 THEN
NODEFAULT
ENDIF

<snip>

Cheers
Carsten

"Scott Cadreau" <scadreau@aros.net> schrieb im Newsbeitrag
news:WuednTvQHu51XkrdRVn-hg@aros.net...
> I need to create "Hotkeys" with "+" and "-" in my application. Is there a
> way to do this? They are not options in the On Key Label command.
>
>
> Thanks,
>
> Scott
>
>

Top