Answer Questions

• Sivaraman A (simple I suppose!) grid question ....

  Hi all! I used to work with VFP a long time ago and I have almost forgot most of it so I ll need your help here! :) I have a table (called myTable) with 4 fields (3 of C(20) and 1 Memo- ID,Title,Location,Descr.). When I am displaying that on a grid, I do that through a new cursor called myTable_cursor. But in the cursor I added a new field because what I wanna do is to display the first 20 characters of the memo and if the user wants then to double click on the memo cell and a new window to open and view all the memo field or edit the memo. So my problems are: 1. Whatever I put in the click event in the textbox cell in the grid (in the correct memo column) it does not respond! Any solutions here 2. I use a cursor to display ...Show All

• Rafael Leonhardt MySQL and VFP

  Hi experts. I have a MySQL database. I operate with them using syntax like SQL(sqlhandle, "select * from...") I copy them into cursor and than operate with a cursor. Is there a simplier way how to work with them Thanks in an advice. >> I understand but I have asked whether the problem may be that I am using free MySQL database, whether this speed isue can be one of the database limits. And the answer, as I have told you at least twice, is that My SQL is used by thousands of people all over the world and speed does NOT seem to be an issue for any of them. I am sorry but I do not NOT use MySQL (I have enough problems dealing with SQL Server 2000, SQL Server 2005 and Oracle ...Show All

• E Davis VFP Preprocessor Problem

  i have probelem with VFP9 preprocessor ! i would like to define new statements syntx to the language. i want a replacement for #command statement (like in Clipper lanaguge) , any helpful idea Greetings, thanks , this mean that i should write converter (simple compiler) from my syntax to VFP syntax. This functionality is not exposed that I am aware of. You cannot write new preprocessor statements yourself unless you happen to have the source code for the VFP Compiler (which as far as I know is only held by Microsoft). ...Show All

• dragoncells VFP9 Installation

  Hi gurus I in the process of installing VFP 9 on my server w2k sp4, it looks and tells me that prereq are needed and three componets came up runtime files,data access something and soap toolkit. only de data access component was installed but runtime files and soap don't want to install. I tried to install indivudually as per troubleshooting from wcu folder within the VFP cd but it hangs. where do I start my troubleshooting to install the runtme files and the soap in order to install my VFP, it seems like without this compnents VFP9 wont install. Thanks for all the help First, you may check that, may it's working with vfp 9 : http://support.microsoft.com/kb/824850 ...Show All

• Javier Ramos MySQL and VFP

  Hi experts. I have a MySQL database. I operate with them using syntax like SQL(sqlhandle, "select * from...") I copy them into cursor and than operate with a cursor. Is there a simplier way how to work with them Thanks in an advice. Once Again... I am using VFP and I want to connect a via ODBC to a SQL database which is faster than the one I have. I want it free without paying. No mather whether MySQL database or MSSQL database. Just a SQL database which won't slow down for a second after typing SQLEXEC(sqlhandle,"select * from table01",cursor1). You believe me or not this simple code no mather There are 5 fields and 5records takes a second to realize. And guys, don't be so a ...Show All

• WPF Fan Status of Backend process...

  Hi, I'm having a application in VFP 9.0 using MySQL as backend....I've some SP there to do some book-keeping jobs. I let the user to call them from VFP.... The SP take a quite noticable time..... Is there a way to show the status in progressbar or something in the frontend.... Thanks and Regards, Markish No, unless the backend SP sends some kind of periodic status report, which would only slow down the process some more. You could show an animated gif or some other image to convey the impression of work being done. If you have an idea of how much time it normally takes, you could give the user a timer or an idea of when it might finish, or if it is appropiate for your app, you could run it asynchronously and hav ...Show All

• ivanchain Why the datas from the .dbf file (table) on the form are not displayed?

  Hi all Need help very badly.. I purely have no idea where i go wrong. I'm trying to get the datas (such as CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, etc) from the table (.dbf) display and then trim into "CHEVSINSMZ 100 & 101 & 102 itself. What i get the result on {.xdf_bl.value= OutPutSTring} of the form is (1)_________ when testing this form. Why cannot the datas be shown on the text field when searching for the value in the .dbf _-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-_ tnfjob is the name of the table. Jt_hblno is an attribute of the table (.dbf)in the form. It is like something that originally contains CHEVSINSMZ 100,CHEVSINSMZ 100, ...Show All

• sunny123 excel and foxpro

  Dear friends, when exporting datas to excel from foxpro using the copy to command, there after trying to do some calculations and formating the excel file using automatation macros how could I integrate this in foxpro, I don't know where to start. thanks for explaining me the functionality satish http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=948945&SiteID=1 You can use macros created in Excel but first you should understand and edit the code generated there. 1) Excel macros use VBA and have named parameters ( parameters can have names). ie: ActiveCell.Replace What:="", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False ...Show All

• edenxiii Why I can't change the back color of the page frame?

  Instead of a change the value, the color is same I tried by Opaque or Transparent, but nothing. Thank you. You need to turn off themes. ie: PUBLIC oForm oForm = CREATEOBJECT('myForm') oForm.Show() DEFINE CLASS myForm as Form ADD OBJECT pgf as Pageframe WITH pagecount = 5, BackColor = RGB(0,255,255), themes=.f. PROCEDURE pgf.init this.pages(1).BackColor = RGB(0,0,0) this.pages(2).BackColor = RGB(255,0,0) this.pages(3).BackColor = RGB(0,255,0) this.pages(4).BackColor = RGB(0,0,255) this.pages(5).BackColor = RGB(255,255,0) endproc enddefine ...Show All

• Turfnsurf4me Underlining commands

  I just recently switched from VFP 8 to 9 SP1. When I type a command in the Command Window or in a program, the command is underlined as I type. Is there a way to turn this off I don't remember this happening in VFP 8. Thanks in advance! That was exactly what I was looking for! Thanks! the red inversion is awsome :)... i hated the underlining. This is the new "background compile" feature. It helps you see whether the line, as it stands, is valid. You can change the behavior or turn it off in the Options dialog. Tools | Options Editor tab Background Compile I'm using the Red Inversion setting and appreciate it. Tamar ...Show All

• Can-Ann Fonts, ? and set alternate

  Hi; I have lots of older code that uses commands and set alternate to create a text file and then it uses modify command to view the file. I have noticed that on my development PC, this created a file with Fixedsys font. On the installation pcs the font is "Courier". Is there a way to determine what font will be used when issuing commands to a set alte file I know that I can use the font clause in the command itself but I was wondering what determines the default font used. Thank you all for puting up with my "oldie" questions. TOOLS -> OPTIONS -> IDE Tab THere is a drop-down for "Specify Window/File Type" Choose "Text Files" Amend the settings to whatev ...Show All

• ChSchmidt Autoincrement and default values with Foxpro tables and ADO CursorAdapters approach ??

  Using VFP 9 SP1 is very easy and powerfull to connect to different Database providers (SQL Server, Oracle, etc.) using ADO Cursoradapters (CA). Using ADO CA we can retrieve from the database server the values for Autoincrement fields and the default values if there are defined and woks just fine. The question that I have is there is possible to do the same using Foxpro Tables: to get in the CA the values for Autoincrement and default values Thanks Ivan Sorry, but this is totally different question, I had other post regarding information about Foxpro UDF and Cursoradpaters wich I found the answer by myself. Perhaps the topic cursoradapter sounds similar but it is a big chapter and this particular question is ...Show All

• cplusplus1 How to change date type?

  How to change data type in Foxpro,and what's the function of that [Note from moderator: clarified date/data confusion as per later post.] Tracy H wrote: I just realized you meant DATE type, not DATA type. If the type is a date you can use DTOC() to change it to a character string. Or do you mean change from European to American date format or something else Do you only want to change the display style of the date Look at tools, options, regional settings in VFP or type 'HELP SET DATE' in the command window to bring up the VFP Help on date formats. Are you asking about a field or a variable What is the current data type What does type() return lcvar = 'Sally' &&am ...Show All

• Patrick Severijns Record repositioning

  There are any number of commands that move the record pointer so presumably you are using one of these in a When() or Valid(). For example: COUNT, SUM, AVERAGE, MAX, MIN, SEEK, LOOKUP etc etc etc. Are you sure that you have NONE of these anywhere Thanks for the tips. I have already run extensive traces trying to track changes in the primary key and/or record number. The problem is I can go into the exact same record that the user reports the problem on, do the exact same sequence of keystrokes, and the problem doesn't occur. I've only seen it reposition one time while tracing, and unfortunately I didn't have the break point set before the record repositioned. I've modified the data entry form to trap these "jumps&quo ...Show All

• Tom Frey the no server server?

  ok my client now wants the application i made to run on multiple computers. i am not a network wiz but i know a few things. will this work: 1. right click mynetwork places and do map network drive. ill make drive Z:\ and find a folder.... ok now i have drive Z:\.... now i do the same thing with the 2 other computers. So i now have 3 computers with drive z:\. on drive z:\ im going to have all the files. my questions are is this a good setup will it work out Yes it is very good if you can keep drivers mapping after computers restart(letter "z"), if not you can create a small setup application in you program to fix the default driver.You will also need to share t ...Show All