Answer Questions

• Gage my SQL passthrough problem

  Good day to all, could i ask where i got wrong with this code , because when i run the .prg for this code, at first try it won't work, then the second time around it works, as if no error. Like when you open VFP, then at the command window you execute the do command, it won't work, but at the second or 3rd try it works. Please help...thanks in advance LOCAL lcConnect STORE 0 TO lcConnect STORE SQLCONNECT ('My SQL Server C ...Show All

• al2torres With ... EndWith

  How does nesting work with With ... EndWith Does VFP work out which object I am referring to if I just enter .cDescription for example Is there a potential for ambiguity if the 2 objects have the same property I would like to use nested With ... EndWith but I am wary of introducing some difficult to find bugs. Darren, I am glad you are finding help. VFP is a wonderful product. Do not worry about my sensib ...Show All

• Devrim _screen.ContinuousScroll problem

  I noticed this problem just this morning after spending many hundred hours debugging my app for the past few months when everything worked just fine. This is the setup which is hardly unusual. There is a function in a prg file and a Click method that calls it. There are a couple of print statements like: "coimng out of the function: "+numeric_id and such in the function(s) and one in the Click method. All output is character s ...Show All

• myIT_Agent Help with - "Do you want fries with that?"

  Hi I wrote an app a long time ago that looked perfectly suited for a touch screen display.  The user could choose the item or items that they want to enter into a POS terminal and could enter the cash or check transaction and generate a receipt. I just realized after installing a touchscreen that I never programmed the buttons with the numbers 0-9 or the decimal point to replace their keyboard equivalents.  Does anyone know what code ...Show All

• Zoheb Vacheri - MSFT MySQL and VFP9.0

  Hi. I don't know how to make a connection to MySQL. I used Connector/ODBC 3.51.12 to connect to MySql with no responce. When I clicked on OK after I set up parameters a massage was displayed like User Cancled. Don't know what to do... Can anybody help me Has anybody experience with connectivity with MySQL I have an idea. Can you make a sample project with a database connected to a MySql database. I was told via Connector/ODBC 3.51.12 it'll ...Show All

• DJGizbo Need to run "BUILD EXE" command in an EXE file

  Hi All, We have about 100 projects. Time to time we need to recreate the individual EXE files for all projects. We want to create another executable program which is going to create all individual EXE files when needed. In foxpro command window we can run BUILD EXE command, but if we try to run it within the executable, we get error "Feature is not available". Is there any way around this Thank you very much for your hel ...Show All

• Carl97 Remote View SQL 2005 REQUERY Puzzle

  Hi, I have an interesting puzzle. I'm using Remote Views in VFP9 for the MS SQL Server database access. I'm trying not to store the connection string within DBC with remote views. When I'm opening remote views I'm supplying a nStatementHandle ("USE a!b CONNSTRING nStatementHandle") from the established shared SQLSTRING connection. Everything works OK till I'm doing REQUERY() for some parameterized views. Program gives me a ...Show All

• object object is not defined but uncatchable

  It is a very strange situation and I have tried various combinations to beat it for a few days--to no avail. The code kept getting more complicated so bear with me please. The issue here is that there is a treeView and an outside button that is supposed to trigger some action. This action (search) needs TreeView.SelectedItem.Text and Tag properties. If I forget to make a selection beforehand the Type (" SelectedItem") is Undefined (&qu ...Show All

• s_a_p_k_o_t_a Hijr calender

  Hello Profissionals, This is really URGENT and I need your replay as soon as possible... I am using MS Foxpro 7.0 I am using a datepicker objec in a form and it should work for Hijri and Georganian Date according to user defined settings. When using hijri date the controll it self still shows Georganian values but the selected date apprears in hijri... e.g. the avaliable date range when you click on the datepicker is 1-31 but it should ...Show All

• jpiterak Zip Folder

  Dear Experts, How I zip the folder using FoxPro Thanks a lots. I am using libraries from this site :  http://www.eetasoft.ee/zipmaster.htm Dear Expert, Can I know are you have any example to run the zip libraries That all need to pay the money... Can I know have any free libraries file Thanks a lots. EEVA ZIPMASTER is for free and documen ...Show All

• Jandler2 reading html file in foxpro

  Hi I want to check an .html (or TXT if thats easier) file with foxpro for this line: src="cid:image001.jpg@01C67F47.26775C40" and replace it with src="image001.jpg" how can I do this, I can't figure it out :( Something like this: local lcText lcText = FILETOSTR("c:\temp\MyFile.HTM") lcText = STRTRAN(lcText,[src="cid:image001.jpg@01C67F47.26775C40"], ...Show All

• Alex Me Questions regarding connecting to an ADP server

  I would like to use VFP as a frontend to reach in and pull data from our company's ADP server. I know the addressing ( IP and port ) used by the ADP client software and have administrative access on the User level ( I'm the sys admin), but am unsure where to begin. I do see a Reflection for Unix and Digital OLE control listed... is this related  The goal is to be able to automate the execution of ADP english statement scripts to extract dat ...Show All

• GlennDek SELECT - SQL executed partically

  I have 11,000 directories in my machine on one partition only (C:). In order to expedite search for file I need (I found MS search engine too slow) I scan all directories once in 10 days and create a table with directory shorthands and a field where extensions of the files located there are stored. Some directories have too many various types of files and I use a memo field to store extensions for them. Thus the primary field has 80 char length ...Show All

• szucconi Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All

• Nate K Preview container toolbar doesn't respond

  Hi: I'm creating a report that contains several chained reports. The obtained report is OK The problem is that I can't to do any actions with the bar. PreviewContainer. ToolbarIsVisible = .T. OK I'm able to change some properties: Caption, ZoomLevel, etc. That's also OK. I'm able to scroll pages with keyboard or mouse clicking to the Preview container screen. That's also runs OK. But the problem is that toolbar do not react anyway to a mouse cli ...Show All