Answer Questions

• QWERTYtech Some thing like edit box with picture control support???

  Hi there experts. How can I make a control like editbox where can I type in and phrases like ":)" will automatically change into o graphical picture(best will be gif file). I mean something like. Or is there an control which can do it without creating a difficult code Thanks in an advice . Bye I see... Is there another control like editbox, that support displaying animated gif files Maybe a paid control from internet I was looking for some controls but unsuccessfuly... :( I think you could be able to do this with a RichText (Ole Control)... No, sorry... It seems animations are not supported by RichText... I know it is able to display an RTF f ...Show All

• dontknow Grid Reusable Form or Active-X question. Any Help?

  Hi, A problem I am always facing when I am creating a new software is the following: I usually need in every software a grid to display my records in some sort of way from a table of cursor. Ok the grid will change a bit from form to form and from software to software (different row colors, sometimes I ll need to sort by columns somentimes not, different fonts, buttons in grid or not or others things etc etc). Is there anywhere around the Internet such a ready made form-grid or Active X control that will do my job instead of each time spend a day of recreating it from almost scratch If it is also free (or cheap!) it would be really really very very nice :) Any help Thanks, Athan PS. Also any other forms - or links that ...Show All

• JennyMQuinn find/search button

  anyone can teach me...hw can i create a find or search button in a form in visual foxpro or give me a simple example of coding thanks.. i was just telling him to have a form with text boxes for all the fields of a table. then have a command button to search. then u have to write the code systematically. open the table have all textboxes disabled and initialize it to 0 or spaces then when he clicks on search set focus to first field he types in some value then search the table and if found() display the record else display "error message" set focus to search if he does not type in value then focus shifts to next fields if he types in some value search if u write the code b ...Show All

• tokie install shield Express & FoxPro 9

  I am having a wierd problem creating my install with install shield Express. I seem to be creating the setup file okay and it is even installing good and running the app good, with 2 exceptions. the shortcuts that are created on the desktop and the start menu are only available for the user profile of the person who installed the app. The program seems to execute only when the installing person not anyone else. Even if the other person is an administrator. Please help I am new to this Install shield, before I used VFP 6 with its own installer. Thank You in advance. The user that installed was an administrator and is able to run the application just fine. He can read, write and even del ...Show All

• tabdalla Foxpro Power!

  Hai Everybody, I jus wanted to have some sort of opinion poll from u people. IS FOXPRO ONE OF THE POWERFUL TOOL AVAILABLE NOW In my opinion its really powerful and very much useful even now i am very much found of it.... foxpro is amazing. i love it to death, it was my first language i learned and its the easiest language i think. Cetin, I have extreme respect for your words and humbly stand corrected in anything you say. For me to pity one evolved-language over another may seem a bit bigotted, as each language indeed has its benefits. My corporate friends are suffering under VB and C++/Sharp for Intergraph here in Huntsville, AL. They engineer very well with these languages. But they might a ...Show All

• Marco Russo XML and .Net

  I'm having an issue with sending XML from VFP to a .Net application. In VFP I create a cursor, populate some data, then use xmltocursor("mycursor","lcXml",1) to create an XML string. I then pass this string to the .NET app. The problem is that .NET complains about the string. (I also get the same error if I save the XML to a file) According to the intellisense, the third parameter of 1 is supposed to create xml that can be consumed by .net This does not seem to be the case. Here is the error I receive from .Net "Unexpected end of file while parsing Name has occurred. Line 1, position 6." Line 1: < xml version = "1.0" encoding="UTF-8" standalone="yes" I can cre ...Show All

• Joe Hegarty Memo field conversion

  I am using a Microsoft ODBC Driver to connect to 4 DBF files . One of them has Memo Fields in it and I am not able to see this particular table when I try to import it in Access. All the others I am able to see and they do not have memo fields. Any idea guys How I can fix this Deepak Patil wrote: I am using a Microsoft ODBC Driver to connect to 4 DBF files . One of them has Memo Fields in it and I am not able to see this particular table when I try to import it in Access. All the others I am able to see and they do not have memo fields. Which Microsoft ODBC driver are you using Is it the Visual FoxPro driver, or a different one Deepak Patil wrote: ...Show All

• din attarwala Excel to cursor?

  Hi guys, I am working with some data that is about 400 lines long, and I need to update it into MS SQL 2000 via Visual FoxPro. I need to know, is there a way I can take excel data and import it into a FoxPro cursor Thanks http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 Dave M. Dave M. wrote: I don’t understand... What’s giving you trouble Dave M. I'm sorry Dave, I completely misunderstood what you had written there in the other thread. What you wrote was helpful, and the answer, as was what Alex posted. Again, sorry for the confusion. I don’t understand... What’s giving you trouble Dave M. Alright guys, it's looking like th ...Show All

• CaptainSmudge Convert ADO recordset to a Foxpro DBF free table

  Hi,     I currently have a need to convert an ADO recordset to a DBF. I've seen some posts here on how to create and write to a DBF using C# in conjunction with the VFPOLEDB provider. I mocked some code up in VB6 similar to the example and I am able to open the dbf in VFP6 no problem. However, I'd like to find out what ADO to Foxpro field type conversions would work. The ADO recordset comes as a result of a query from SQL Server 2000, so there are bound to be some datatypes that will not convert natively. I've come up with this matrix so far based on some MSDN Library materials.     SQL DataType              ADO DataType   &nb ...Show All

• Bernaridho software problem.

  Hi there. I have question regarding one software that is builded on Visual Foxpro 7. I have a company and i have 4 computers in my office, i have a software for my company installed only in my computer... The problem is that i dont have the cd from my software and i have tried to copy all files from one computer to run that software in other pc`s. I have installed foxpro in other pc, i build the files from begining but isn`t working... When i click on the software it opens but after 1-2 seconds the program is closed automaticly, cannot run.. What can be the problem can anyone tell me any solution about this I will wait further for your message Thanks and best regards, armandino Thank you for yo ...Show All

• Tom v E Interactive queries in an executable

  Does anyone have an easy way to give experienced users a “MODI QUERY” type capability inside of an executable without programmatically building it from scratch We have a client that is experienced in FoxPro and knows how to create queries using MODI QUERY from the command box. They have quite a few of these and use them to select data by changing the selection criteria in the query designer. In an old FoxPro for Windows module of the application (running as an app), we made it easier for them to run these queries by letting them put them in a directory that we read and used to build a pick list. When they selected the query, we would execute the MODI QUERY command inside of the app for them with the selected query. We are now upgrad ...Show All

• DaveDB Working with field General!

  Hi, all! Help me to update field type General: append object, edit, open,... in VFP from program control with bottom command. (use line command MODIFY GENERAL <field gen> don't open object) Thank! Backward compatibility. Putiing in is easier than dropping off. For example what would happen if they removed "public" or made default data session for forms 2 etc. Just to add to what Alex said: DON'T USE GENERAL FIELDS! (Are you seeing a theme here.... ) Alex Feldstein wrote: ... Instead: - Use BLOB fields (VFP9) or - Use a text field to keep the path+filename and keep the original file on disk You'll be ...Show All

• Rusty_Lane how to know which field i index

  hi all, i 1 idx but i dun have documentation to know which fields it index. so i just use set index to idx then set order to && it shown the field. hehe but is that the only way to know or got other method thanks in advance. Hi, You can achieve the same with tagcount() and sys(14,<n>). for ii=1 to tagcount() tag(ii),sys(14,ii) next ii Regards, Markish Hi, I never use IDX. I am not sure the code below can work or not ... USE mytable lnTag = TAGCOUNT() FOR i = 1 TO lnTag TAG(i), KEY(i) NEXT Update: Also check out ATAGINFO() and TAGNO() HTH No its my company that i working now still use idx. thanks all your info. sys(14) hm thanks and tag() and ...Show All

• Eric Robert VFP9 SP1 DLL Error

  Hi All Shot in the dark, but just wanted to see if anyone else is getting a similar problem. My VFP9 SP1 application has been working fine but over the last month, one of my forms has been returning an error with vfp9r.dll. It's the standard error with the "send report to Microsoft". The forms in question do not do anything different to any other form and I've cut down the code and tried to isolate the problem. However, the error does not happen all the time and some users experience it more than others. The form has not changed recently either. I've tried reinstalling the VFP runtime, giving users admin privledges, etc. Nothing works. The only thing I've got is an entry in the event viewer: The descriptio ...Show All

• Seth Cohen Visual Studio 2k5 Database tools problem with Fox pro 9.0 sp1 ole db provider

  I have MicrosoftR Visual FoxProR OLE DB Provider 9.0.0.3504 installed. In the visual database tool, when I run "SELECT DATE() FROM MYTABLE", visual studio will give me the follow error: Error in SELECT clause: expression near ')'. Error in SELECT clause: expression near 'FROM'. Missing FROM clause. Unable to parse query text. However in visual studio 2003 on another machine, everything works fine. I tried to reinstall visual studio 2005 and the fox pro ole db provider many times. I still get the errors. Also, I remember it works on my friend's visual studio 2005. Can someone give me some help to fix this Thanks. Also, "Verify SQL Syntax" returns "This command is not supported by this provider&quo ...Show All