Answer Questions
Darren Neimke unsorted records in grid control
I just noticed it yesterday after working with grids for about two months. Until yesterday, I realized, all tables or aliases I connected to grids were presorted meaning that their record NATUAL order was always alphabethical. It is a different situation for me now. It turns out when I SET ORDER TO TAG <tagname> before I connect a table to a grid's .recordSource, the records appear in a nuatual, unsorted order nonetheless. If I use this ...Show All
Amitkm Converting FoxPro application to a SQL server backend
Hi We would like to convert an existing FoxPro application to a SQL database. If possible, we would like to do it in multiple-phases. For example, Is it possible to keep the UI as is and convert the code and the table to SQLin the first phase And for the first phase, we would like to translate the code and the table to SQL. Is this a viable strategy If not, what should we be doing You haven't said which version of FoxPro y ...Show All
Deutschland vor&#33; Inserting and Updating images file from VFP9 to SQL Server 2005
i am developing a form where i am collecting personal information such as name, address and signature of the person as a bmp file........ i am saving the data in the SQL Server 2005 . My front end is VFP 9 forms. i am building a SQL query to insert the record....... the prob that i m facing is that i cannot concatenate the image type with the SQL string that i m building the insert works fine if i dont try to insert the image the imag ...Show All
Tomas Kiss Determining nXYCOORDINATES for the Typing Cursor (Insertion Point) in myEditBox.Selstart
(to help with an autotext class in an editfield) I'd prefer not to use Mouse Cursor Coordinates nor myEditBox.Selstart Derivations. Both frequently elude the Typing Cursor in myEditBox.SELSTART ... (See code below) (Intellisense pinpoints nXYCOORDINATES of the selstart in Native VFP-9 editors) Is _WGetCursor() a solution here Thanks, Philip *Failing Code: lnXY= (this.Width * this.height /(70000)) &&1 lLineIncr=lnXY*pLoadedSelStart/8.5+ ...Show All
Jung Yi Using LAN in Visual Foxpro 9.0
Hi....I'm new here and I only know the basics in Visual FoxPro. I just want to ask on how can the client computers access my monetary system when it is on the server or other computers. The whole folder of my monetary system is located on one computer and i want to have access using other computers. I'm currently using SET DEFAULT TO C:\MONETARY to set the default folder for all the tables, forms, progs and reports. What should the path in ...Show All
Dorny video control
While waiting for answers to my other post I tried to play with a video control. It gives me an error I cannot understand: cFileName = JUSTSTEM ( JUSTFNAME ( cLine )) THISFORM . O_VIDEOPLAYER1 . cfilename = cLine THISFORM . O_VIDEOPLAYER1 . playvideo ( cFileName , 100 , 100 ) cLine is the complete path to an .AVI file. The error is that "no parameter statement is found" Is anybody familiar ...Show All
Erik11 report temp file not found
I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All
Avesta Info Combining on Page 2 in Page Frames
How can I get my info on Page 1 to stay on Page 1 when I select Page 2 When I select Page 1 just the info I placed on Page 1 appears. When I select Page 2 however, the info I placed on Page 1 also appears on Page 2 along with Page 2's info. Thanks! It's fairly easy once you get the hang of it. You have Pageframe. It is a container for Pages inside. As Drew said, you have to drill i ...Show All
Arcady Suppress Prompts
Is there anyway to suppress dialog prompts in vfp 8 I'm writing over a file about 60 times, so I don't want to click everytime it needs to over write the file. Thanks! set safety off Dave You use line comand: SET NOTIFY OFF ...Show All
Dan Codorean editbox programmatic change
I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All
rbreidenstein Any better source code to search for file/folder
hi all, I've just finished a small program to search some filetype on my harddisk. The code run very well but it seems to me that it 's a bit too.... lenghy. Is there anyway else to search file without having to use ADIR function *//CODE SearchFile("D:","mp3") &&This will show the number of all mp3 files found on drive D: *//Contain of file SearchFile.PRG parameters cStartFolder, cExtention private _nCount & ...Show All
mendi deployment, building exe problem
OK, this is the third round. I still cannot run an exec file. I cannot build it properly. When I issue (in the Command Window) BUILD EXE the intellisense prompt appears with my app name. So, I accept the rest of the clause as default. Until today I could generate .exe with no problem but had problem getting it started. Today finally for reason I cannot explain an error appeared during BUILD: Unable to find Unknown ARR . Jus ...Show All
Westrick data from one table1 that isn't in table2
Yallo, I know there is an easy fix, but I have spent to much time on it and can't figure it out. I have two tables that share some id numbers. I want to pull all the data from one table where the id isn't in the other table. Table1 id name 1 steve 2 clarith 3 dorthy 4 pudbo Table 2 id name 8 clem 2 clarith 6 fursmorth 4 pudbo two tables: they share records with ID 2 and 4. I need to pu ...Show All
JimBoDH n-tier design
I am designing an application and I want to start using n-tier design. I have no problem with the user interface but have some questions about the business and data tiers. My application will probably be all in one vfp exe so I don't particularly have to get into ADO or XML. Am I correct in assuming the actual data reading and writing statements (eg Replace, Insert etc) go into the data tier I am thinking that I would need some sort of data hand ...Show All
IdahoErick Vue File Format Structure Needed
Can anyone help me on where I can find information on the structure and format for the VFP Vue files that are created with the command: Create View MyView.Vue Please thanks, Terry Hi Terry I understand what you are saying, but I would still say that a better approach is simply to set up programs that replicate these environments and that will accept a parameter (or use something like CURDIR() to define the starting location. ...Show All