Answer Questions
truepantera foxpro training and/or classes
Hi there. Does anyone know of any good training sessions or classes for VFP I'm from vegas myself, and there's nothing out here. I have an alright grasp on it (VFP), but I would like to really dive into it. It's not too easy to learn on your own when there's not much out there to teach ya, ya know I appreciate it in advance. Thanks MarciaAkins - very helpful. The website is actually www.swfox.net - I appreciate it! thereisnomike wrote: Hi there. Does anyone know of any good training sessions or classes for VFP I'm from vegas myself, and there's nothing out here. I have an alright grasp on it (VFP), but I would like to really dive into it. Sign up for Southwest Fox at www.swfox.org . The price is reasonable, i ...Show All
Adama0 Display marked records for deletion using SELECT statement
Hi to all, I have a table T where all of the records are marked for deletion everytime the table is uploaded with new records. When issuing the BROWSE command the records are displayed but with SELECT command no records are displayed. I want the records to be displayed using the SELECT command. Is this possible and how Actually I have a web page in asp connected to the table T. And i want the records to be displayed there. Thanks Hi, thanks for the help, the deleted() function is working in the command window for fox pro. But in the asp page it is not working.I have use the following sql. No records are displayed SELECT a.sitenum sitenum, b.desc sitename,a.cardnum cardnum, dtos(a.date) date, ...Show All
Giber Strip HTML out of a memo field
What is the best way to Strip all HTML out of a memo field I can’t think of a better method than of looping thought every charter copying one at a time but ignoring those between “<” and ”>” . Is there a better way A faster way Thanks, Sammy Regular expressions might help you out here. lcMemo = "<HTML><HEAD><TITLE>Title</TITLE></HEAD>" ; + "<BODY><H1>Header</H1><P>Paragraph</P></BODY></HTML>" _regexp = NEWOBJECT("_regexp", HOME(1) + "ffc\_REGEXP.VCX") _regexp.Pattern = "<\/ \w*>" lnMatchCount = _regexp.Execute(lcMemo) lcTest = lcMem ...Show All
Jehan Badshah using tow field index with codebase
Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay Can you tell the first byte value of table file Is 0x30 Beginning with vfp8 is something changed in table header(AutotIncrement) who can affect compability with codebase. Would you try this (I don't use codebase to know if that'd work): Create in ...Show All
george_v Foxpro memo field in ado (or ado.net)
I see that this question in various forms has been asked and answered here before, but none of them address my needs...:-( What I need to do is a simple vb6 or vb.net (or even c#) oleDB read from the foxpro database where the table contains memo fields. I get data in the field, but its garbage. I suppose I need to get the field contents in another way but have no idea how to.. I have the latest foxpro drives sfrom MS Any help out there example code VB6 sConnString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;" & sSourceDB & ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;" Set oConn = New Connection oConn.CommandTimeout = 300 oConn.ConnectionTimeout = 5 o ...Show All
MNour.AI fix corrupted dbf
hello, i'm opening a table in the command window and it display a message that the table is corrupted and needs to be repaired before it can be use again. Can anyone help me fix the dbf Is there a free software to fix the corrupted dbf any help will be greatly appreciated thank you jason Hi I used Xitech Foxfix... Great tool. I implemented following functions to check and fix damaged dbfs. You could try to open damaged dbfs with Vfp6 and Pack + Reindex or export/zap/reimport data with copy to/zap/append from. If you (or your customers) don't have Vfp6, try these functions (make a copy of all files before)... Bye, Giulio #Define CRLF CHR(13)+CHR(10) Function xCheckDBFHeader(cFileName, cFileType, dLastUpdate, nRecCount, n ...Show All
vgrigor config.fpw
how i can find my config.fpw how i can call my program that use only my codepage=950 for hongkong characters i wan create my own config.fpw and at my main.prg call this config.fpw... how i can do that thanks in advance. To add to Cetin's, you can find the location of your config file with SYS(2019) http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/60c1a9a7-3f99-486a-a131-590baf487aa2.asp frame=true If not overriden in command line it's in startup folder (ie: for IDE it's at home()). Put codepage=950 in config.fpw You can create a config.fpw with notepad or "modify command" from IDE. Config.fpw cannot be called from main.prg. ...Show All
MuscleHead sharing connections between applications
Pehaps I better wrote: sharing databases between applications . This is the thing. I have a VFP application which is 99% complete. Occasionally I add some embelishments or premium features. I am also in the process of developing a C# app of Winsock style. It is a console app in Visual Studio 2005. It is supposed to use some of the same ODBC VFP9 databases. I've read that VFP databases are much superiod to SQLServer databases in terms of speed. I spent a day trying to figure out why I could not open a connection while my VFP app was open all the time and those databases were linked to it. Finally, even superstupid get their break and I realized that there was nothing wrong with my connection string. I shut the VFP app down. This brings m ...Show All
Godspeed 2.0 Deleted -SQL HELP
I am having trouble with a form i created. It is a form with a grid of an email address book - table. I want to the user an option of deleting names from the grid/table and it works fine when i "Set Delete On" and test it. But when I implement it into the program and call the form from a main program it gives me an error that says "Deleted variable not found". any suggestions this is the code for the command button that deleted the record: select emailaddressbook DELETE FROM emailaddressbook where idemail = temp thisform.grd_Email.Refresh like i said, it works stand-alone How about putting Go Top after the delete, but before the refresh. This will move the record pointe ...Show All
CsNetworks Uppercase in Edit Box
Somebody how can I force to Uppercase in a Edit Box . This control doesnt have a Input Mask property, and dont know if the Format property can make it. Thank you in advance. JLucio wrote: Somebody how can I force to Uppercase in a Edit Box . This control doesnt have a Input Mask property, and dont know if the Format property can make it. Thank you in advance. Try this code in the control's valid: REPLACE MyField WITH UPPER( This.Value ) IN MyAlias The "!" in format doesnt work. Yes, it looks bad, but it is necessary in a user form. JLucio Try ! in the format. All upper case will look bad to the user, are you sure you want to do this Don ...Show All
Thomas Frohberg How to handle transaction consisting of different data sources?
I want to know how to handle transaction consisting of different data sources (e.g. VFP dbfs and MS SQL tables). Thanks, Peter Seems to me you'll need to handle this yourself. Your best bet is to create your own StartMixed, CommitMixed and RollbackMixed functions or methods. (I'd use methods of an object to which I'd give information about what servers and tables are to updated.) Then, in those methods, handle starting, committing or rolling back all the relevant sources. Tamar Yeah, you can do that. The DTC supports several types of transactions natively and others through a CRM. Unfortunately, Fox transactions aren't supported at all, s ...Show All
Ion101 Future of Visual Foxpro
Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. We have been a VFP shop for almost 10 years. It is a great environment for quick development and stable applications. That said, we're done with new development in VFP. Here's why: -The won't be a 64-bit version. In my opinion, this is the biggest e ...Show All
-D- Page frame tabs will not refresh
I have a page frame with a 5 page tabs. Sometimes clicking a certain tab will only partially refresh the page frame. In other words some of the info from the previous active tab would still show in the currently active tab. This happens on several computers on the network but not always. Anyone has experienced this problem thanks. Check the setting of the LockScreen property first. This can cause the symptoms you describe ...Show All
guilherme mendes appending data into an existing DBF with an autoincrement field
I have a table called special.dbf. It has a autoincrement field. I would like to append records to this file. The autoincrement field always defaults to zero and produces an error message. Any suggestions on how to append or insert records would be helpful. I would like to append using a text file or excel file from MS Access table Or import directly from Access to FoxPro. I have tried using append from and I get a zero in the autoincrement field. The file with records to import is in special.txt I left the autoincrement field off the .txt file and still get an error message saying it the Spe__pk is compromised and a zero is in the record. I do not have the source code for this application just the DBC with DBF files. I have data i ...Show All
progames25 Emailing newly converted reports.
Hi; I have converted some older Foxpro reports to VFP9. Everything looks great, but: Before the conversion I could very easily save the report to file and then email it. After the conversion, obviously, I can't do that anymore. I have tried the ASCII option but it is not very good with spacing and columns don't line up etc. What is the best way to solve this issue Do I need to create a pdf/rtf/tif etc or is there a built in VFP feature that can help me Thank you all. Wow!!! What I wanted and much more. Thx. I didn't venture into report listeners yet, but I guess that gives me native graphic functionality for report output files. Thank you so much!!! Alen. ...Show All