padl() gaff refresher needed

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
    - Date field update Sir, I have a table with 2 fields as data type date. I have to append the records from text file with date shown in the file as 01-JUN-2008. I tried different date settings but date fileds are not updated and kept blank only. I tried with short date settings in the control panel also. Which shows the date i want as 01-Jun-2008 but still the fields are not updated & has the value blank. This is very unusal as we may require the different date setting during the programme execution. Bankim Tag: padl() gaff refresher needed Tag: 241236
  - 2
    - Validating a DBC After opening a DBC I issue: VALIDATE DATABASE RECOVER I got the message: Tag not found (structural CDX). Do you want eliminate it or cancel validation? I realize that the father table primary key and a sister table CDX are lost. How I can by code reindex these tables and rebuild the proper relations and IR ? Thanks. Alejandro Fernandez Tag: padl() gaff refresher needed Tag: 241233
  - 3
    - DBC internal consistency error - FP crash I got this immediately after issuing VALIDATE DATABASE (which reported no problems). Now in the database designer, all the field names are shown as "??". Before validating, everything seemed fine. Some "validation"! Now I cannot get rid of the message, keeps popping up again after I click OK. Nothing to do but kill FP with the Task Manager. Too bad too, because I have unsaved changes in a prg file. If anyone has advice, that's fine, but mostly I'm venting. Dammit! VFP9SP2 Tag: padl() gaff refresher needed Tag: 241231
  - 4
    - Sub classing question (vfp 9 sp1) I have subclassed all the base classes, and customized some of them. Based on prior experience, however, it seems that I don't want to build a new project with this set of classes, but rather, but rather to sublcass them and create a new base set for the new project. How do you do this without going one by one? Thanks Tag: padl() gaff refresher needed Tag: 241223
  - 5
    - Code signing - how to digitally sign VFP apps? Anyone know how to do that? Tag: padl() gaff refresher needed Tag: 241220
  - 6
    - Local or not Local There seems to be a gap in the Local implementation in VFP. Thought it might be worth to share, at least I did not know about it until Surinder Singh wrote about it in the foxite.com forum. In VFP9 SP2 the following test indicates that content of a Local variable declared in the calling procedure is visible for a modalForm.control.ControlSource although IMO it should not. Works with an SCX form, too: * local_or_not_local.prg LOCAL testLocal testLocal = "local value" testUndeclared = "undeclared/private" LOCAL loForm as Form loForm = CREATEOBJECT('TestForm') loForm.Show(1) Return DEFINE CLASS TestForm as Form ADD OBJECT txtTest as Textbox WITH ; Left = 50, Top = 10, ControlSource = "m.testLocal" ADD OBJECT cmdTest as CommandButton WITH ; Left = 50, Top = 50, Height = 24, Caption = "Scope Test" PROCEDURE cmdTest.Click MESSAGEBOX( "VARTYPE(m.testLocal): " + VARTYPE(m.testLocal) ) MESSAGEBOX( "VARTYPE(m.testUndeclared): " + VARTYPE(m.testUndeclared) ) ENDPROC ENDDEFINE * Regards -Stefan Tag: padl() gaff refresher needed Tag: 241213
  - 7
    - textbox.nulldisplay is ignored in grid I can't get textbox.nulldisplay to work if the textbox is in a grid column. Actually, what I really want is to have column.nulldisplay, or a column format code that addresses nulls, but there don't seem to be such things. Am I out of luck? Tag: padl() gaff refresher needed Tag: 241201
  - 8
    - Container Toolbar My boss actually had our container class docked on the toolbar and dropped the appropriate container into our form. How did she do this??? PSULionRP Tag: padl() gaff refresher needed Tag: 241196
  - 9
    - Copying an Existing Project Bear with me here...Newbie on board... What is the best way to copy an existing project in order to create a new .PJX I have to do??? I want ALL the class libraries to get copied over to this new project. Is this done in FoxPro or through Windows Explorer??? Thanks. PSULionRP Tag: padl() gaff refresher needed Tag: 241191
  - 10
    - Corrupted database in vfp 9 sp1 I have a database that is really just a set of definitions for an odbc connection. That is, it has the connection and a few view definitions. If I try to open it, I get a message that it has become corrupted and must be repaired before using. Unfortunately, since I can't open it, I'm not quite sure how to go about repairing it! A quick search of the help didn't turn anything up. Is it worth worrying about, or is it better to just restore it from yesterday? Thanks Tag: padl() gaff refresher needed Tag: 241187
  - 11
    - print jpg in app Hi I have a very larg application. Looks like a book. Can I create code to print a jpg when I right click the picture. If so how? Thanks Sherry Tag: padl() gaff refresher needed Tag: 241185
  - 12
    - New VFP project at Codeplex - DynamicDNS New Visual Foxpro project at Codeplex called DynamicDNS: If you've ever been stuck with a dynamic IP and wished you could assign whatever the IP is to a static name, this may be the solution for you. Also good examples of foxpro systray, timer, web page crawling and other goodies. All source code is included. http://www.codeplex.com/ddns Tag: padl() gaff refresher needed Tag: 241182
  - 13
    - IF AND Is the IF AND structure in Visual FoxPro valid??? Tell me I don't have to stack them...please... Thanks in advance. PSULionRP Tag: padl() gaff refresher needed Tag: 241176
  - 14
    - convert text file to unix Sir, I have created a text file in upload format with the help of VFP 5.00. I have used set alternate command for file name. File contents are generated with ? & ??. Is the file generated is windows output file or dos output file. & real need is how can i convert the file in Unix as in one of the third party application it requires the file to be in unix mode instead of dos. Bankim Tag: padl() gaff refresher needed Tag: 241169
  - 15
    - Report Writer - Need a Summary at bottom of last page (VFP9.0 sp2) Hi, I am producing an invoice form that may run into several pages and must have a single remittance slip at the end of the last page Is there a way to either make the summary band print at the end of the page, or to only print the page footer on the last page? - Or is there a better way? As usual, any help would be appreciated... Cheers, John Davy Tag: padl() gaff refresher needed Tag: 241166
  - 16
    - Add Tab to existing Form Learning by the seat of my pants here. I have to add a tab to a form that already has a lot of tabs on it. How do I add a new Tab??? I tried Form ==> New Property but when I added the Property Name it didn't show up on the Properties. Can anyone help me and if anyone has a crash course in Microsoft Visual FoxPro, that would be awesome. Thanks in advance. PSULionRP Tag: padl() gaff refresher needed Tag: 241163
  - 17
    - copy to .... type and ms Access Why wouldn't ms access be able to open xls's or dbf's that I create in VFP via copy to ...type xls or type fox2x ? -- -Lew The workers took the robot for Maria. Tag: padl() gaff refresher needed Tag: 241157
  - 18
    - Retrieving header and body on server from VFP XMLHTTP post I want to send data from VFP on the client to VFP on the server using XMLHTTP. I have found plenty of samples for handling the server side with PHP, but have not found any asp samples. Could someone please let me know how I need to change the code in the asp document to retrieve the header and body received from VFP. Thanks in advance John Pugh Adelaide, South Australia * VFP prg to test sending to a server and a response LOCAL lc_body,lc_received,lc_response,lc_status, lc_target_href LOCAL oHttp AS MSXML2.ServerXMLHTTP oHttp = CREATEOBJECT('MSXML2.ServerXMLHTTP') WITH oHttp lc_target_href="http://localhost/ab5_com.asp" .OPEN('POST', lc_target_href, 0) .setRequestHeader('VfpRequest', TRANSFORM(DATETIME())) * Load data into the body to be transferred lc_body='this is a dummy XML file' .SEND(lc_body) lc_status= .StatusText lc_response= .GetAllResponseHeaders() lc_received= .ResponseText MESSAGEBOX( lc_status,64,'status ') MESSAGEBOX( lc_response,64,'response ') MESSAGEBOX( lc_received,64,'received ') ENDWITH <% @ Language=VBScript %> <% ' Title: ab5_com.asp ' Subtitle: Test receiving from and sending back to VFP %> <% lc_test = Request.Form( "txtTest" ) lc_header="Retrieve header" lc_body="Retrieve body" lc_return="From asp: "&lc_header&lc_body Response.Write( lc_return ) %> Tag: padl() gaff refresher needed Tag: 241155
  - 19
    - PLEASE! EXE automation: Fox or IIS problem ? hi i wrote these few lines: define class MyTest as Custom OlePublic hello= "hello" function getHello() return hello endfunc enddefine i build the project (MyTest) as an EXE Com Server and register it with : MyTest.exe /regserver i can instantiate the com-server within VFP, with no problems but when i try to do the same in ASP (with Server.CreateObject) : the page seems hung on the client and, on the server, the TaskManager shows that the .Exe is still loaded that is, i have to kill "MyTest.exe" this is One year ago, this was easy... what happened ? is this a Fox or IIS problem ?? thanks ks Tag: padl() gaff refresher needed Tag: 241151
  - 20
    - Building with a project class I have a project class in my project to make use of project hooks when I do builds. I always check the "recompile all files" option, so I receive a "File proj_lib.vcx is in use and cannot be recomiled" message whenever I build. This is not a real big deal, I just hit the ignore button. But I was wondering if there was an easy way to avoid this and still do a "recompile all files". I've tried variations on use of the CLEAR command, but can't find anything that yields an error-free build. I suspect it's all in the timing of things since I have a good chunk of code that runs whenever a build is done (forms run to collect build details, tables are updated, printer info cleared from reports, etc). Any insights? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: padl() gaff refresher needed Tag: 241148
  - 21
    - ProjectHook Creating a ProjectHook and puting it in your project. I added some code that runs each time I build the project. This works great as I often forgot to run some code to set up some data tables before I compiled. The one hangup is that the program runs when I run the Rebuild The Project and also when I make up the Win32 Executable. Is there any code like an IF that I can put in front of the program so that it only runs when I Rebuild The Project. I do not need it to run when I build the exe file. It is not harming anything but a time consumer to see the program run twice. Still using VFP8. Thanks TonySper Tag: padl() gaff refresher needed Tag: 241142
  - 22
    - Modify report in VFP 7, save, but it reverts I'm modifying a report, making the simplest of changes, being changing the font of a field expression from bold to regular, I save the report, but when I reopen it or run it, the field is still bold. What could be at play here? Dan Tag: padl() gaff refresher needed Tag: 241140
  - 23
    - SQL Comments at last! An annoyance I find in long sql statements is what I thought was the inability to break long statements into sections for commenting. Having &&'d comments off to the right of the code is annoying when there are many windows open, etc... I have finally discovered that the following works: select; afield,; anotherfield,; ; && Here is the second section of my code. ; && I think I can write as many comments ; && as I like! evenathird field,; ; && etc -- -Lew The workers took the robot for Maria. Tag: padl() gaff refresher needed Tag: 241135
  - 24
    - Dynamic call to Excel for exploded pie chart Does anyone know the paramaters for a dynamic call to Excel to create an 3D exploded pie chart? Currently I have the 3D pie chart working, but I'd rather have the 3D exploded pie chart, but can't find the code anywhere. Perhaps it can't be done dynamically? i.e. The parameter call for the 3D pie is -4102,7,2,1,0,1 in the following statement: objxlsheet.chartobjects(1).chart.; chartwizard(objxlsheet.range(objxlsheet.cells(1,1),objxlsheet.cells(pni, 2)),; -4102,7,2,1,0,1,"","","","") Tag: padl() gaff refresher needed Tag: 241131
  - 25
    - Inputbox function suddenly not working on VFP9 I have VF9 and was using the inputbox function successfully till yesterday. Now, it suddenly shows a message 'Program inputbox.prg does not exist' I haven't made any programming changes. Any ideas? Thanks Zoom Tag: padl() gaff refresher needed Tag: 241128
- Next
  - 1
    - foxpro 9.0 problem when SET REPORTBEHAVIOR 90 the report cannot show chinese at preveiw or printing how can i solve this problem ? -- Tag: padl() gaff refresher needed Tag: 241126
  - 2
    - VFPUG NYC meets 6/5 The Visual Foxpro Users Group of New York City meets Thursday, June 5, at 7 pm. in NYU's Silver building, NE corner of Washington Square, room #803. The topic is "Using MS SQL from VFP". The speaker is Jay Berardinelli. Tell guard you are going to the "computer club". Tag: padl() gaff refresher needed Tag: 241123
  - 3
    - Is VFP able to deal with fully qualified domain names? Hi All, Thanks for the help. Can VFP understand fully qualified domain names to locate files? Is there anything specific that I would need to do to use them? Thanks, Jeff Tag: padl() gaff refresher needed Tag: 241116
  - 4
    - Conditional shading of a cell using Excel Automation & VFP Need to set the background color of a cell to red if the result of the cell's formula is negative. Not sure how to do this conditionally. I know the color is set as: oSheet.Range("A1").Interior.Color = RGB(255,0,0) &&- Red Tag: padl() gaff refresher needed Tag: 241115
  - 5
    - When include tables in a project In an app I have several tables which never are updated. They have only information to be consulted. The biggest has 98 Mb, other 42 Mb and others some Kb. When can I include these non updatable tables as readonly in the project? What are the real advantages of including them? Or perhaps build a DLL with them? Thanks. Alejandro Fernandez Tag: padl() gaff refresher needed Tag: 241112
  - 6
    - Problem Creating View I'd like to create a Remote View that links four common SQL tables as shown below. ORDER HEADER | | | ------------> ORDER_ITEMS | | | | | | | | SUPPLIERS DEL_POINTS i.e. Any order can have multiple items and each item can have a list of possible suppliers AND delivery points I've tried all different sorts of concoctions of joins when trying to setup the view but none of them seem to work. I can link the tables on the appropriate fields but as soon as I try and save the view I get an error message. Could anyone point me in the right direction...either on how to create the view or what the SQL statement should be? Tag: padl() gaff refresher needed Tag: 241108
  - 7
    - Update SQL table - VFP9 Can anyone tell me - step by step - how can I update an SQL table using remote view? Or where can I find examples? Many thanks in advance. -- Sandor Tag: padl() gaff refresher needed Tag: 241091
  - 8
    - Add/Remove job into Task Scheduler Is the XP and Vi$ta Task Scheduler programmable? Anyone done work on it? -- @~@ Might, Courage, Vision, SINCERITY. / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Xubuntu 8.04) Linux 2.6.25.4 ^ ^ 16:48:01 up 1 day 2:29 1 user load average: 3.00 3.15 3.19 ? ? (CSSA): http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa/ Tag: padl() gaff refresher needed Tag: 241089
  - 9
    - Mixed Language reports - English & Chinese Is it possible within Foxpro to produce a report containing both English and Chinese representations of the report content? thanks pete Tag: padl() gaff refresher needed Tag: 241088
  - 10
    - How can I list all the users logged on to a server in my domain at any time? Tag: padl() gaff refresher needed Tag: 241082
  - 11
    - Troubles with an utility for DB validation (GENDBC) Un an app I have a DB with 3 tables. One with a primary key for a field CODIGO is linked to the others. I got the code generated by GENDBC (VFP7),and I´d recreated the following utility to fix and validate this DB. It worked sometimes well but now always crash. I use VFP 7 in WinXP but I must write a version for Vista too. the BD is named pacientes.dbc The tables are ingreso.dbf && primary key diagnos.dbf sintoma.dbf This is the procedure PROCEDURE reconstructorData &&& recreate a DB ** Recreate indexes and validate BD CLOSE DATAbase ALL OPEN DATABASE pacientes EXCLUSIVE remove table diagnos remove table sintoma remove table ingreso ADD TABLE ingreso =USE2("ingreso") SET COLLATE TO 'MACHINE' *INDEX ON CODIGO TAG HAV FOR TIENETABLA=.T. ALTER TABLE 'INGRESO' ADD PRIMARY KEY CODIGO TAG CODIGO ***** Change properties for INGRESO ***** CREATE TRIGGER ON 'INGRESO' FOR DELETE AS __ri_delete_ingreso() CREATE TRIGGER ON 'INGRESO' FOR UPDATE AS __ri_update_ingreso() ***** Create each index for DIAGNOS ***** ADD TABLE diagnos =USE2("diagnos") SET COLLATE TO 'MACHINE' INDEX ON CODIGO TAG CODIGO ***** Change properties for DIAGNOS ***** CREATE TRIGGER ON 'DIAGNOS' FOR INSERT AS __ri_insert_diagnos() CREATE TRIGGER ON 'DIAGNOS' FOR UPDATE AS __ri_update_diagnos() ***** Create each index for SINTOMA ***** ADD TABLE sintoma =USE2("SINTOMA") SET COLLATE TO 'MACHINE' INDEX ON CODIGO TAG CODIGO ***** Change properties for SINTOMA ***** CREATE TRIGGER ON 'SINTOMA' FOR INSERT AS __ri_insert_sintoma() CREATE TRIGGER ON 'SINTOMA' FOR UPDATE AS __ri_update_sintoma() *************** Begin Relations Setup ************** *FUNCTION MakeRelation_1 ALTER TABLE 'DIAGNOS' ADD FOREIGN KEY TAG CODIGO REFERENCES INGRESO TAG CODIGO *ENDFUNC *FUNCTION MakeRelation_2 ALTER TABLE 'SINTOMA' ADD FOREIGN KEY TAG CODIGO REFERENCES INGRESO TAG CODIGO *ENDFUNC *FUNCTION MakeRI ***** Referential Integrity Setup ***** && Now open BD as a table to add it stored procedures with RI CLOSE DATABASES all && It don´t close this BD USE IN 'PACIENTES.DBC' IF NOT USED('PACIENTES.DBC') USE 'PACIENTES.DBC' && Trouble. Don´t open the DB as a table ENDIF SELECT pacientes g_SetSafety = SET('SAFETY') SET SAFETY OFF LOCATE FOR Objectname = 'StoredProceduresSource' IF FOUND() APPEND MEMO Code FROM [PACIENTES.krt] OVERWRITE REPLACE Code WITH SUBSTR(Code, 70, 21726) ENDIF LOCATE FOR Objectname = 'StoredProceduresObject' IF FOUND() * APPEND MEMO Code FROM [PACIENTES.krt] OVERWRITE REPLACE Code WITH SUBSTR(Code, 21796) ENDIF SET SAFETY &g_SetSafety * USE LOCATE FOR ObjectType = 'Table' AND ObjectName = 'diagnos' IF FOUND() nObjectID = ObjectID LOCATE FOR ObjectType = 'Relation' AND 'codigo'$Property AND 'ingreso'$Property AND 'codigo'$Property AND ParentID = nObjectID IF FOUND() REPLACE RiInfo WITH 'CCR ' ELSE ? "Could not set RI Information." ENDIF ENDIF LOCATE FOR ObjectType = 'Table' AND ObjectName = 'sintoma' IF FOUND() nObjectID = ObjectID LOCATE FOR ObjectType = 'Relation' AND 'codigo'$Property AND 'ingreso'$Property AND 'codigo'$Property AND ParentID = nObjectID IF FOUND() REPLACE RiInfo WITH 'CCR ' ELSE ? "Could not set RI Information." ENDIF ENDIF USE OPEN DATABASE pacientes EXCLUSIVE VALIDATE DATABASE noco PACK DATABASE ********************************* Thanks for your help. Alejandro Fernandez Tag: padl() gaff refresher needed Tag: 241081
  - 12
    - Fieldtypes in ADOdb Hello, Group. I use ADODB from VFP 9 to retrieve values from excel spreadsheets. The spreadsheets are unknown in advance. Everything goes fine, but there is one problem. I can retrieve the data type for a column using: sType = oRs.Fields(ii-1).type However, even if this type is 5, which is a numeric type, the column can include text mixed with numbers. In such cases I want to get the values as text. How can I do this? I inclulde the code I use (in summary) to go through the spreadsheet. TIA Krister *!* (sample code) cFil = '<my xls file>' strConnection = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + cFil + ";" oConn = Createobject('ADODB.Connection') oConn.Open(strConnection) oRs = Createobject('ADODB.recordset') cOpensheet='Sheet1' strSQL = 'SELECT * FROM [Sheet1$]' oRs.Open(strsql, oConn) nFlt = oRs.fields.count oRs.MoveFirst Do While Not oRs.Eof For ii=1 To nFlt sTyp = oRs.Fields(ii-1).type eValue = oRs.Fields(ii-1).value next oRs.movenext() Enddo oRs.Close() oConn.Close() Tag: padl() gaff refresher needed Tag: 241072
  - 13
    - gotfocus Firing Twice I have one form in my app which is used to control invoicing. It has a number of functions that are internal and some that are external. These functions are started by the operator clicking a button. The form also has some data about the current client. Some of this data can be changed. It should be saved before doing something. With most buttons -- the exceptions are unimportant -- the gotfocus of the button contains code to save the client data. The valid contains the code to run. In the case of the external functions, other forms are created. The problem that I have is that when these functions return, the focus goes back to the first form. gotfocus fires a second time. I do not want it to, or I want to avoid the save. I think I have a solution. I can set a status flag in the valid's code which the save routine will check to determine whether it should save. At the end, the save routine would reset this flag. This seems somewhat convoluted. Is there something I am missing, or is this the way to go? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: padl() gaff refresher needed Tag: 241062
  - 14
    - This is weird: I go to install an audio utility and Visual FoxPro 9.0 installation takes over !!! I installed an audio utility a few days ago that I use occasionally, a freebie named MP3 Gain. I downloaded the most recent version and installed it, evidently without problems. I just ran the shortcut and instead of the utility opening I get screens indicating that an installation of Visual FoxPro 9.0 is in progress and I'm asked to insert a CD in my optical drive! I do have Visual FoxPro 9.0 SP2 installed: Visual FoxPro 09.00.0000.5815 for Windows [Oct 15 2007 09:11:06] Product ID 76683-335-3466054-18620 I uninstalled MP3 Gain and installed it again in a new location, and at the end of the installation I left the checkbox checked to launch the newly installed program. What started was the same screens asking me to insert a CD in my optical drive and proceed with the installation of Visual FoxPro 9.0!!! What the devil is going on? Dan Tag: padl() gaff refresher needed Tag: 241046
  - 15
    - SQL links twice I have 3 tables that relate as follows: TableA Key1 Key2 NumValA TableB Key1 Key3 NumValB LinkTable Key2 Key3 The idea is to create a cross tab so I can see the sum(NumValA) & sum(NumValB) side by side by their common keys. My basic approach is: Select TableA.Key1, LinkTable.Key3, sum(NumValA), sum(NumValB) from TableA, TableB, LinkTable; where TableA.Key1 = TableB.Key1 and TableA.Key2 = LinkTable.Key2 and TableB.Key3 = LinkTable.Key3 .... group by 1,2 order by 1,2 etc I realize that it's somewhat peculiar in that tableA links to tableB by a one common value but the relationship has to be completed by linking both to a third table which maps Key2 to Key3. My results are off in that the roll up of NumValA is doubled in some cases. I know I can make this work by creating an intermediate cursor that joins TableA and the LinkTable so that I needn't reference it in the final query, but I'd like to be able to do this in a single statement. Any ideas or insights? -- -Lew The workers took the robot for Maria. Tag: padl() gaff refresher needed Tag: 241044
  - 16
    - Form Comes Up Dimmed VFP9 SP1, XP This is a minor annoyance with probably a simple solution, but it's baffled me so far. When my app's Main form appears, the title bar and the main menu are dimmed until the user clicks on the form, as the operating system's focus is somewhere else (e.g. some icon on the task bar). This occurs whether the app is invoked from the project manager or from an exe build. My app uses a prg with DO FORM Main and READ EVENTS. I tried putting SetFocus(), KEYBOARD '{LEFTMOUSE}' in various places and added NOWAIT and/or PAD <padname> clauses to my ACTIVATE MENU command, but nothing seems to work. It really doesn't even cause an extra click to activate the menu pads, but I'd like things not to be dimmed when the user invokes my app. Any suggestions would be appreciated. Thanks. Steve Tag: padl() gaff refresher needed Tag: 241038
  - 17
    - NTVDM Hi All one of our customers got this error msgbox ntvdm.exe - System Error NTVDM encountered a hard error anybody know what is going on ? al Tag: padl() gaff refresher needed Tag: 241031
  - 18
    - implements Hi All, I am about to use implements for a com object for the 1st time when I drag the interface to a prg, all procedures are defined I only want to use one. does the "default" code run after my code for all procedures ? can I stop the "default" from running ? al Tag: padl() gaff refresher needed Tag: 241030
  - 19
    - Win XP SP3 : Curious behavior of Sendkeys and AppActivate Hello, I have an application that has been working fine till now. Yesterday I upgraded my Win XP Pro to SP3. since then Sendkeys function has been giving curious results, sometimes it works as expected, sometimes it does not. Have some other users also experienced similar behavior. I will look forward to your comments and views. Win XP Pro, SP3, VFP 8 with regards S Bans Tag: padl() gaff refresher needed Tag: 241017
  - 20
    - FoxPro app usage by year Is anyone aware of any stats about the number of FoxPro apps in production by year, or FoxPro usage in general by year? I'm charting the history of Fox usage, specifically it's usage on a yearly basis. I can make some guesses based on my own experiences, but would welcome any comments and stats anyone has about this topic. I'm making a rough guess that the peak occurred during the heyday of VFP6/7 somewhere around the year 1999 or 2000, and I would guess that VFP6 was the most used version. It was certainly the version I did the largest number of different apps in. Anyone else? Tag: padl() gaff refresher needed Tag: 241015
  - 21
    - Is this true? Will there be a VFP 10? I saw this on Wiki... In March 2007, Microsoft announced "that there will be no VFP 10"[2], thus making VFP9 (released to manufacturing on December 17, 2004) the last commercial VFP release from Microsoft. The support of Version 9 is ongoing with service packs that were released December 8, 2005 and October 11, 2007. Respectfully, Jonathan Morningstar Tag: padl() gaff refresher needed Tag: 241012
  - 22
    - cast() vs round() It seems to me that in some situations these functions perform can perform identically. For instance, for n = 123.4567, round(n,2) and cast(n as n(8,2)) produce the same value. Any opinions or observations about this? -- -Lew The workers took the robot for Maria. Tag: padl() gaff refresher needed Tag: 241011
  - 23
    - MSCAL.OCX v7 overwritten by v11 of control? We have a program that uses MSCAL.OCX v7, but just recently when it is installed on some Windows platforms the calendar is cosmetically different because the v11 control is somehow being used instead. Is there someway to force our program to use the v7 control even though the v11 control appears to have overwritten it? My guess is that the installation of MS Office is what has overwritten the control. v7 control: week displays from Sunday to Saturday, day columns use 3-letter day abbreviations (MON, TUE, etc.) v11 control: week displays from Monday to Sunday, day columns use full day names but in same size columns so they are not readable. Tag: padl() gaff refresher needed Tag: 241003
  - 24
    - Bizzare text selection behavior in VFP9. Hi, Ocassionally, when I click on a textbox in a form, the entire text will be highlighted and cannot be overwritten with simple typing. I have to double-shift or do a shift and mouseclick to release the text selection. This happens randomly but often and the selectonentry option property in the textbox is turned off. This feature also happens randomly when I am using the VFP editor to edit my PRG. Any help would be appreciated. Zoom Tag: padl() gaff refresher needed Tag: 240999
  - 25
    - General protection fault foxprow 2.6 I use FoxPro for Windows 2.6 on a Windows XP machine. I get the error message: Application error: Foxprow caused a general protection fault in module <unknown> 0677:BAEDFOXPROW will close The strange thing is that I get this error message when I edit a program and run it from the command window. The program ran fine before, but sometimes when I edit it the error occurs. Sometimes the error goes away if I trace the program a bit. I have no idea why. I have tried to restart the machine, reinstall FoxPro 2.6, run the program on another machine to no avail. The error still occurs. I have also run CHKDSK on my machine. I know Foxpro 2.6 is not the latest version ;), but maybe someone can still help. Regards, Jan Nordgreen Tag: padl() gaff refresher needed Tag: 240998

I know I'm supposed to use transform(nVar, "@L 99") to turn 1 into "01"
instead of padl(nVar, 2, '0') .... but I just ran into "1." and I don't
remember what setting causes the padl() idea to fail.
Please remind me.

Top

Re: padl() gaff refresher needed by Sergey

Sergey
Wed Jun 18 16:56:33 CDT 2008

Lew wrote:
> I know I'm supposed to use transform(nVar, "@L 99") to turn 1 into "01"
> instead of padl(nVar, 2, '0') .... but I just ran into "1." and I don't
> remember what setting causes the padl() idea to fail.
> Please remind me.

Make sure that value is an integer

padl(INT(nVar), 2, '0')

--
--sb--

VFP MVP

Top

Re: padl() gaff refresher needed by Zootal

Zootal
Wed Jun 18 18:47:59 CDT 2008

transform( val( transform(nVar)), "@L 99" )

If nVar = "1.", then it isn't numeric. The transform(nVar) function converts
both "1." and 1 into a char, and the val converts it back to numeric. This
way it works whether nVar is char or numeric. The val function will throw
out the decimal sign, and give you 1, which you finally feed into the outer
transform function, giving you "01".

"Lew" <Lew@discussions.microsoft.com> wrote in message
news:E90B5D1E-924D-4FCA-80B9-EC6A498E241F@microsoft.com...
>I know I'm supposed to use transform(nVar, "@L 99") to turn 1 into "01"
> instead of padl(nVar, 2, '0') .... but I just ran into "1." and I don't
> remember what setting causes the padl() idea to fail.
> Please remind me.

Top