Foxpro Windows 2.6 - How to replace a blank space with an underscore

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - fast / draft mode printing in vfp Hai, i think there is ASCII option in report writer. but u will loose all formatting. repo form xxx to xxx.txt ascii or u can use a prg to print nrou = 0 set device to file xxx.txt &&output will be spolled to ascii text file do printheader &&routine for printing the header sele a use customer allas customer go top do while !eof() @ nrou,000 say custid pict '!!!!!' @ nrou,007 say name pict '@!' @ nrou,049 say balance pict '999999999.99' nrou = nrou + 1 if nrou > 66 do printheader endif sele customer if !eof() skip endif set device to screen !type xxx.txt > prn &&printing the text file return procedure printheader nrou = nrou + 1 @ nrou,000 say repli("-",60) nrou = nrou + 1 @ nrou,000 say "Cust ID" @ nrou,007 say "Name of the Customer" @ nrou,052 say "Balance" nrou = nrou + 1 @ nrou,000 say repli("-",60) nrou = nrou + 1 return Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 2
    - Form Variables dni wrote: You may try to put the line in load method. Sorry, but this will not work. You can only pass parameters to the form's Init(). Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 3
    - Variables Hi Indreek, Because VFP has the SQL language built into the heart of the syntax, fields and variables can get confused. The m. is a way to specify that the element is actually a memory variable and not a table field name. This is optional syntax unless you get an ambiguity between field and variable names. A lot of VFP developers append m. in their syntax as good practice to avoid these clashes. I personally have never really suffered this problem as I use Hungarian notation for my variable names (Old Habit). E.g. cText, for a variable that holds a string. Hope this helps NozFx Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 4
    - Open Source VFP? I'm referencing http://arstechnica.com/journals/microsoft.ars/2007/04/03/developers-petition-for-the-return-of-visual-foxpro which is from a week ago. I don't think it's beyond the realm of possibility that despite what YAG said at the conference, MS has since reconsidered. After all, AFAIK, YAG does not have the final say in this matter and maybe he was given instructions to investigate the possibility of fully (or more fully) opening up the source on CodePlex after he made the initial announcement. It would be nice if you MVPers could at least entertain the possibility. After all, if it turns out to be true, you might be embarrased that you thought you were so right about this... The fact that there is no definitive word denying this is sort of telling in and of itself... Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 5
    - Foxpro, left join, group by Ok, I'm at a brick wall here. I'm working on a project that uses Foxpro as the database for a .NET based website. Basically, for this table I have 4 tables People ( about 45000 records ) Addresses ( about 45000 records ) Signings ( about 36000 records after where ) Representatives ( about 500 records ) the people id is indexed in addresses and signings the representatives district is indexed in addresses I need to pull up the most recent person to sign from each district now in sql I would just do it as select people.whatever, signings.time, representatives.whatever from representatives,signings left join addresses on address.people_id=signings.people_id and addresses.district=representatives.district left join people on addresses.people_id=people.id where (signings where) group by addresses.district order by signings.date desc however this does not work because there is a group by if I remove group by it takes forever and eventually stops because the temp file grows too big because of the signings joining addresses even though they are being joined on an indexed column. what am I missing How can I speed this up How can I use group by to get just the one result from each district Thanks for any help Oh I should add that this is Foxpro 6. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 6
    - Grid check-box... Hi All, I am using a grid on a form which has a check-box included. My problem is when the users are navigating through the grid if they hit the return key when the check-box has focus it automatically checks the box. How can I prevent this from happening to ensure they must use the mouse to check the box rather than the return key. Thanks for the help, Pablo Jord. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 7
    - image from file thisform.image1.picture = myTable.Image But you still have to refresh the picture yourself, e.g. as far as I know, you can not simply bound the image to the memo field. Somebody correct me, please, if I'm wrong. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 8
    - REPLACE command help wanted I ment categories.cdx The index file assocated with the table you are useing. If you are geting an error on the "set order to" to me that indicates a problem the index. So if you cant open the index of the index is bad , you can't seek properly. ps i know next to nothing about .net . >> It is annoying to type "set order to" every time i find it more annoying to have to worry about the order.. simple things like "copy to" or "select into" become big problems. But to each there own. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 9
    - LITTLE DOUBTS WITH DATE & TIME PICKER ..... Hi There, Thanks in Advance. Iam facing little error....Really I don't know the exact mistake...where I did... Iam getting the error like... OLE IDispatch exception code 0 from DTPicker: Invalid property value... ************************************************************* My requirement is to set the Todays-Date for DT-Picker..... My codings in the DT_Picker's.....Init event() is .......... *************************************************** SET DATE BRITISH SET CENTURY ON STORE CTOD(' / / ') TO endt3 endt3=DATE() this.day=DAY(endt3) this.month=MONTH(endt3) this.year=YEAR(endt3) ****************************************************** Where I did mistake...anyone to help me...please...... Doubts By PARAMU Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 10
    - insufficient memory - foxpro Since your exe was compiled under VFP3, the very first version of Visual FoxPro, it is not used to seeing the great amounts of RAM that we effortlessly put in today's PCs. I tested a VFP3 compiled app under a PC with 1Gb RAM and it failed with the "Insufficient Memory" message, even though that message clearly doesn't reflect the problem. I then took the same VFP3 compiled executable to an older PC with only 512Mb RAM, and the application ran just fine with that very old VFP300.esl runtime file. So, just find yourself an older laptop or desktop with only 512Mb RAM and run the heck out of your old basketball scheduling application. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 11
    - form help suppose my app is on c:\employee\data\employeedetail\photo employeedetail = table photo=image field After the code that moves the record pointer: Thisform.<< Whatever the name of your image control is >>.Picture = ALLTRIM( EmployeeDetail.Photo ) Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 12
    - How to Open table with mouse click 2 tables, 120 tables or 1200 tables, it does not matters ok, lets start, the first thing we need is the list of tables. in the case that you said (lot of tables that don't feet on screen) we can do something else, make a list in a file: LIST TABLES TO FILE list.txt NOCONSOLE and load it into a multi-line string : list= FILETOSTR ("aa.txt") then put number of table names on the screen as far as we want: for example 20 tables CLEAR SPACE (10)+"/\" FOR i=1 TO 20 MLINE (List,i) ENDFOR n=20 SPACE (10)+"\/" now, all we have to do is capture mouse events, in the worst case we can use APIs. (do you want me to explain that too ) what about other tables I'll show you: remember the first and last line with "/\" and "\/" characters these are our scroll bars!. how just like this: when user clicks on the lower scrollbar(!) we have mouse Y: (for example) Y=120 and in the code we have: IF Y>110 AND Y<130 &&click on lower scroll bar button CLEAR SPACE (10)+"/\" FOR i=n+1 TO n+21 &&display the rest of list depending on mouse click MLINE (List,i) ENDFOR n=n+21 SPACE (10)+"\/" ENDIF and so on about upper scroll bar button! there are other ways to do that: like multi-column listing. hope you satisfied! Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 13
    - converting old fox 2.6 reports to vfp6 errors... IT WORKED!!!!!! I can't thank you enough for this... I hated doing the report first time around and certainly wasn't relishing the idea of doing it again. It was a bit strange for this is what I did. I open 2.6 on my old laptop and saved to a different directory. Opened fox6 on my old laptop and had no problems converting these newly saved files. I copied all the corrupted ones onto my new laptop and opened up just one report in the new copied accross report folder to see if it would work and sure enough it did. I then thought I would check all my reports on my new laptop in my original folder to see what other ones needed converting and somehow they all converted over nicely. Out of curiosity I retried the ones that were given me grief and low and behold they converted okay. How bizarre is that Oh well I'm just so happy that I don't have to redo these! YOU'RE AWESOME! Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 14
    - Indexing of foxpro application You may try ro recreate index file with REINDEX: http://msdn2.microsoft.com/en-us/library/0b2ab467(VS.80).aspx If is structural index you may use MODI STRU. How was built index files Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 15
    - Passing SQL SELECT parameters to FORM/Listbox I have a form with a listbox, I have changed the source on the listbox to a SQL SELECT, in the form of SELECT * FROM DBF INTO CURSOR myform WHERE anum=thisform.anum thisform.anum is passed from the calling program as a parameter and is initialized in form.init, yet apparently the sql select statement is called prior to the form.init (why ) and thisform.anum has an invalid value. Can I use the SQL SELECT with a variable where clause in the listbox, and if so, how should those values be passed. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 16
    - Upgrading V6 app to V9 gives strange Windows Phenomena Hi there... I'm just trying to solve this little annoying Gotcha & would appreciate help from experienced problem solvers. Old V6 code creating my data input windows, now blanks when I bring my mouse across it, then have to "hunt in the dark" for event buttons (Add, Goto, Exit, etc) which then appear when mouse is over them. Then only about half the window appears. Truly weird. Really simple x-base style code in the begining, after a number of db are opened, windows, popups, indexes being defined. Also declaring a few dozen vars. Is there some special V9 var I should be declaring to prevent or augment something Jeez. Would be a bummer and dangerous to start re-coding the app. Have switched to visual9 due to poor memory performance of my original V6 exe on xpro, vista. Any help Havent used the debugger yet, dont think that will do much but give me same phenomena in slow motion :-) Thanks much Barry Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
- Next
  - 1
    - Forum Usage Thanks to both of you. I will keep unchecking this checkbox <g> Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 2
    - Form's Show Method I am trying to display the form using formname.show() but it gives error "formname is not an object" Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 3
    - Grid class 1) You can decrease columncount to 8,7 ... in code. 2) You can use SetAll() to assign properties to all member controls of a container type class (like a grid). 3) You can't set when/valid to values like .f./.t. They are not properties but procedures. You can however return values of .f./.t. from their code. If it's saying "Inherited ..." then that means you didn't write any code but the class from which you created the instance had code in that method (otherwise just Default for built-in VFP code). When it says "User procedure" then that means you have code overriding class' code in instance. Doubleclick to see the code you have written (warning: even spaces that you might somehow left there counts as code. If you don't see any code and sure that you don't want to have instance code there then in PEM sheet, right click and select "reset"). "Am I right in assuming that in a "normal" grid, "each control in every column of the grid" refers to the text box controls (but not header controls) in the columns And, if that is correct, the code in question cannot be entered into my base class grid (or base grid class) if I choose, as you suggested, to set the number of columns to -1 " No you are not right in your assumption. A column.controls collection has header and other controls in column (typically Controls[1] is the header and Controls[2] is the textbox - unless edited). I don't know what code are you trying to add but probably it can be added to base class. Many grid aspects are controlled directly at grid level.You can also add your own column,header, textbox ... controls. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 4
    - uniqueness of index <insert index name> is violated. Hi, i'm making batch changes to several of our foxpro databases using C# and ado.net. Basically i am consolidating many lookups into the same key across multiple databases. After moving them to the proper id and deleting unused id's, i go and find out from all of the databases what lookups they have, compile them into a uniquelist and then make sure that every database has that row. My problem is that once my consolidation happens and it deletes unused rows, i'm trying to add rows that use to be there back in because they're part of my 'master list' and i need them even though they aren't being used... i then get this error even though the record has been deleted already. example id 9060 was not being used, i first go through and delete all codes that aren't being used in related tables (to clear out all of the junk --and unfortunately in some cases codes i need to keep around as well) 9060 was deleted I consolidate all of the codes i go to my master list and try to add 9060 again with it's proper description (one that matches the master list), and i get the uniqueness error. Now, i could go back and rewrite the whole architecture of my software to support this 'bug ' but i'm hoping someone knows a way to rebuild the indexes programmatically (in ado.net) so i don't have to. Thanks! Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 5
    - What fires first Init() or Load() Yes, sounds good as a separate method to refresh the grid. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 6
    - VFP7 crashes with "Fatal error: Exception code=C0000005" during data import from Excel I'm using the following statements for reading from a multiple-sheet Excel file: CREATE CURSOR Main (ID N(3,0), SUBID N(3,0), DESC C(60), D C(128), E C(10), F C(10), G C(10), H C(10), I C(10), J C(10), K C(10), L C(10), M C(10), N C(10), O C(10), P C(10), Q C(10) ) APPEND FROM (cFile) TYPE XL5 SHEET "cSheet_n" with cSheet_n = sheet names of the current spreadsheet. The tables had been saved as Excel5.0 workbooks. Typically 100 rows are being read per sheet, typically 5 to 10 sheet per file in total. If the table is somewhat larger or contains more commenting text within the columns E (from which I read 10 chars only), the procedure tends to crash, but astonishingly this isn'z really reproducible (sometimes on the 1st sheet, sometimes on the 4th only)! I tried out with XL8 instead of XL5 -> no difference. If I replaced all formula in the sheet by the values, it behaved better, but not clearly stable (still crashing sometimes). What's wrong Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 7
    - FoxPro 8 where to find information My computer died. Reload OS. I have one FoxPro program, used for over 7 years. and still have the database - reinstalling the OS only affected the boot WINDOWS partition. But the FoxPro program, which I can access, will not run - cannot find a required DLL. Where do I go for help in this kind of situation. I am sorry to ask such on FoxPro 9, but where else is there Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 8
    - Run /N *.CHM file we can't : RUN /N c:\help.chm Please help me to sovle the problem thanks Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 9
    - Copy to delimited Hi, I need to be able to create a standard ASCII file delimited with tabs. However the default for the command: COPY TO file .txt DELIMITED WITH TAB produces the character " wrapped around all fields. Does anyone know a way of producing a standard tab delimited file without the " characters Cheers, Paul. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 10
    - Outlook contact details Are you checking DistList object or a similar one oContacts there is a ContactItem object and it does have FirstName , LastName ... properties (as documented in outlook VBA help). Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 11
    - "Flush" vs. "Tableupdate(1,2,.T.)" ? Budoi and Andy, While issuing FDATE() to display "Last Modified", I *discovered* open tables don't write to disk after commanding "tableupdate(.T.)" An updated open data-file remains unsaved and not "Modified" (according to fdate("myData.dbf") and Windows Explorer "Modified") Thank you for clarifying "flush force" and its remote (OS) applicability. Andy, your thoughtful code-example clears things up alot. But your keen observation of de-chaching in SQL-Server seems to validate my suspicions that data should be force-flushed oft-betimes VFP9, perhaps during each and every save (tableupdate()) I think Budoi, that you initially understood #1 below. Flush Force to be used in conjunction with Tableupdate() during every Save as: 1) A prophylactic mechanism to help protect Server-Data-Files from becoming corrupted during their extensive habitation in RAM. 2) A better time-marker when a data file is updated, for: "Saved" = "Last-Modified" Andy, Budoi, and/or others, does this not seem more logical for the user Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 12
    - Change of Class Library ... Hi, Thanks a lot for this. This is what I've been trying to do. I'll check with this. Still any help in the code I've written (Just I want to know what is the problem with that) Best regards, Markish Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 13
    - ODBC Driver I'd best start this thread by admitting I know less than nothing about FoxPro so dummy answers would be appreciated. I have a customer who is connecting software I have written to a foxpro database via ODBC. The customer has created a System DSN using the Microsoft Visual Foxpro Driver v6.00.8167 that points to a "free table directory". My software simply runs a query on a table (Details.dbf). The software works fine until the number of records hits 10K+. At this stage each single query (which only returns one record) takes at least 5 seconds to execute. At first thought I figured the peformance was down to a lack of indexes on the table. They have since added several indexes with no improvement in performance. My suspicion is that the ODBC driver is not using the indexes. Can anybody shine any light on this and suggest possible solutions to this extremely poor performance Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 14
    - BUG: Microsoft Visual Fox Pro ODBC Driver (6.1.8630.1) The bug is: driver doesn't support autoincrement fields: while trying to use any table, contains autoincrement fileld, the exception "Not a table." is thrown. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 15
    - Performace issues over VPN / Terminal services. Hi everyone; I have tried today to connect via VPN over DSL lines to a remote system and run my VFP application. Perfomance sucked big time, but I wasn't surprised. Using remote desktop to the win2003 server is very fast for obvious reasons. My question: - Did anyone here use VFP over VPN when the application is not client/server but rather VFP files on a remote server Is there any way to get reasonable performance in a WAN connection I will post my second question in a seperate thread. Thanks. Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore
  - 16
    - Visual Foxpro Grid is hiding something from me :( ok ! I have a form with a pageframe and two pages. i have a grid on page 1 for sales_items. i have two MySql tables 'sales' and 'sales_items'. i have set the allowaddnew property of the grid to .T. . try to add a new record to the grid and save it (it works fine) now on the grid press the down arrow more than 4 times so that it will look like ur adding more than 4 new records, and then run the update on both tables and walah ! the grid loses its data, but if you browse the table using a button or something, you will see that the data is actually still there but the grid wont show it. here is a sample of how i requery my child table. Please read the notes with a NOTE marker ThisForm.pageframe1.page1.Grid1.RecordSource="" NOTE the problem starts here, after the grid1 recordsource is set to "" after this, grid hides the content NOTE the grid is set to "" before requerying the sales_items table to retain the actuall layout of the grid lcSQLStmt="Select * from sales_items where TRIM(s_ctrl)='"+ALLTRIM(sales.s_ctrl)+"'" =sqlexec(lnHandle,lcSQLStmt,"sales_items") IF !make_updatable("sales_items","si_uid","sales_items","",.F.) =MESSAGEBOX("sales_items",0,"c") ENDIF with ThisForm.pageframe1.page1.Grid1 .RecordSource="sales_items" NOTE here we set the recordsource back, u can even place a messagebox here to see if the grid recordsource NOTE has been updated (it is updated) but the grid doesnt show anything .columns(1).controlsource="sales_items.is_code" .columns(2).controlsource="sales_items.is_Ctrl" .columns(2).combo1.requery() .columns(3).controlsource="sales_items.emp_Ctrl" .columns(3).mycombobox1.requery() .columns(4).controlsource="sales_items.si_qty" .columns(5).controlsource="sales_items.si_price" .columns(6).controlsource="sales_items.si_amount" .columns(7).controlsource="sales_items.si_discount" .Refresh ENDWITH what is weird is that from my button "ADD" "EDIT "SAVE" "CANCEL" ,after the grid shows no sign of life and i press SAVE (still nothing) , and then press ADD and CANCEL the grid shows its contents back , but i cant keep on simulating the ADD CANCEL buttons everytime i execute the SAVE button , this could decrease the performance of my applications especially if im using Large Tables. NEED HELP PLSSS any1 T_T Tag: Foxpro Windows 2.6 - How to replace a blank space with an underscore

Amanpartap

Hi

This is my first post in board.

In a FoxPro database file, i have the following informaiton in one of fields:

microsoft is great
microsoft_is great

In above two values, I want to replace every blank space with an underscore, irrespective of whereever they occur.

like microsoft_is_great

What would be the syntax

Thanks in Advance.

Aman

Top

Re: Foxpro Windows 2.6 - How to replace a blank space with an underscore

CetinBasoz

Welcome.

Code Block

replace myField with chrtran(myField, ' ' ,'_')

Top

Re: Foxpro Windows 2.6 - How to replace a blank space with an underscore

Amanpartap

Great!! this almost worked but the end result was:

microsoft_is_great__________________________

Can we avoid trailing underscores

Thanks again.

Top

Re: Foxpro Windows 2.6 - How to replace a blank space with an underscore

Amanpartap

Ok got it thanks

Code Block

replace name with chrtran(alltrim(name), ' ' ,'_')

Top