Answer Questions

• startlet 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. Alright guys, it's looking like there are new problems afoot! What you guys suggested with the sqlstringconnect() works, with on exception: it is not stable. It will work sometimes, and othertimes it will not. On my workstation it always works; however, unless I go, open up Microsoft Excel on a co-worker's machine, and then use the sqlstringconnect(), it will not work. I get error 1446: Connection handle is inv ...Show All

• Mirific201201 Listbox causing error

  Hi I have a listbox in which I fill with values from a SQL based on a selection chosen by the user. The listbox allows the user to select the value they want from the list and enter payments for that person. However my problem occurs in instances where the list box contains more records that are shown in the main listbox window and the user has to scroll down the list. This is usually 500 or more records. When the user selects any of the records nearing the end of the list, the entire application closes with an error saying "Syntax error" and it is going straight to the read events. It however does not tell me where the syntax error is. For any of the records closer to the beginning, everything works fine. Help please. ...Show All

• araujox2002 foxpro + mysql

  hi all, i try to connect foxpro using MYSQL 5.0 and SQL YOG as my database connection. but everytime is failed and the error msg is "connected to localhost 10061 is failed". pls guide. thanks in advance. oooo ic . actually i tested at my company and i join domain. tks shud be security issues. How are you connecting Are you using a "ServiceHost" Is the port 10061 restricted by a firewall ...Show All

• mstcrow5429 Merge 2 text file

  Hi... I have to text file. Can anyone advise how to combine 2 text file into one file using Visual Foxpro 6.0. Thank you. if u know the layout of destination.txt, you can create a blank structrue and say use destination appe from desitnation.txt sdf or u can open destination.txt in excel and save it as dbf. then u can match product and destination to get a 3rd file i.e. sele a.productid,a.description,a.productgroup,b.destination from product a,destination b where a.productid = b.productid into dbf prddest.dbf your prddest.dbf will have all product codes with destination,description and group Hi, sorry, probably I's mistaken....I've not tried. The following code ...Show All

• MichaelChesapeake Help creating a folder!!

  I am trying to create a folder with Visual Fox Pro, using the MD commnad, and i the name of the folder to be the currnet date, anyone has an ideea md date() doens't work lcFolderName = dtoc(date(),1) && or ttoc(datetime(),1) to include time md (m.lcFolderName) You can even do this in one shot: lcFolderName = 'backups\' + dtoc(date(),1) md (m.lcFolderName) Yes thank you both, it works. But now i wanna copy the database in this folder i just made, with the name as he current date. This doens't work: COPY FILE "receptii.dbf" TO (m.lcFolderName)\ Any ideea how Thank you. Hi, md Comman ...Show All

• sweet_salt arabic

  hi i want write arabic in the textbox (right to left) what must ido Hi, Please check this article http://www.microsoft.com/middleeast/msdn/VisualFoxPro.aspx i would like to write in russian but when ever i try to put something in a text box i see " " Bijansaba: Besides setting the language (Windows version) to Arabic in Control Panel, in VFP forms use Alignment=1 and RightToLeft=.t. for Text/Edit boxes. In Reports use the RightToleft from the format menu and select the font as Arabic script. This supposes you have the latest version of VFP and Windows XP, as you do not specify version used. Previous versions of VFP may have had so ...Show All

• 3D Paul how could I change the Client's IP address automatically

  Good day to all experts, how could we change the client's IP address automatically from the server . I have a small program running at the workstation and have also a program that monitor the workstation at the server which both works fine. But sometimes the user change the ip address which was manually configure and if i use DHCP they put an IP manually just for fun or just for experimenting or what-ever their motives i don't know. So i am thinking, if why not checking it at the server if one station's IP address has change , why bothering going to the workstation if it can be easily replace automatically from the server Thank you very much for your help regarding this matter. Have a nice day to all "I don' ...Show All

• mary jane Auto-updating application

  I have an applicaiton that needs to auto-update via the web, I have done this before so the web process is all sorted. However, this application is a sub-component of an existing app so I need to shut down the sub-component for update, but not the main application. I am not sure this is even possible, but any pointers would be great. Basically the file is in use - can't update etc. I have pulled the code back to it's barest minimum that fails: main exe calling a separate application with the following code only in startup: LOCAL loObject loObject = createobject("SomeClass") DEFINE CLASS SomeClass as Custom ENDDEFINE Basically the introduction of a class creation prevets me from then unloading the application. btw I have trie ...Show All

• LynnScott Dbf Autoincrement with ADO

  Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks, Connection pooling is activated automated when you connect.You may disable it with OLE DB Services= -2 inserted in connection string (at the end). You are opening as adOpenForwardOnly client cursor, not server cursor which expects to work in disconnected mode at the client side. If you are a VFP developer and are a little unfamiliar with the old ADO, maybe this old article can help as i ...Show All

• veci_aus Median

  Hi all, I have a simple table with ages listed (called c_age). Does one know how to find the median of these ages Does VFP have a built in Median() function Mike Tomik, Reading your response, and need further clarification. Why do you have logic to calculate the median value of the array has not data (IF MOD(nCount,2) = 0) Also, can you explain what is happening when you are creating the variables nLo and nUp Thanks. GR1206 SELECT age FROM c_age ORDER BY age INTO ARRAY aTemp   nCount = ALEN(aTemp, 1)   IF MOD(nCount, 2) = 0     nLo = aTemp(nCount / 2)     nUp = aTemp(nCount / 2 + 1)     nMedian = (nLo + nU ...Show All

• K Sumeet Copy classes or subclass from a classlib

  I am obviously still learning and making changes in my original classes in my first application. I have a second application which I am developing now. The second application will need to use classes similar to the first application, but some classes will require  minor and others major changes. I'm not sure if I should copy the classlib and modify it for the second application, or sub-class from the first class lib. Also, is there an easy way to copy individual classes from one classlib to another Please keep in mind that the first classlib will be modified heavily in the future. Any ideas for a strategy would be greatly apreciated. If these are un-connected ap ...Show All

• KC416 Error when building exe in VFP 9.0.

  Hi All, I am getting the following error while building the exe in VFP, i am not able to clearly locate the area of problem The Error : " Object File <exe name & location> is in use and cannot be reoved from the memory " please suggest me a solution. Thanks in advance Venkatram Issue a CLEAR ALL and a RELEASE ALL before building the project. Before I build an exe for distribution, I always exit out of foxpro and restart, just to make sure nothing interferes with the build. The build exe command is the first line of code after restarting. (actually I have a command called DO BUILDNEW that sets everything up for me then builds the exe, copies the files to the distrubution d ...Show All

• psmithphil Aplication VFP9 can comunicate via computer's port?

  I need to send from VPF9 aplication a signal (grpup of chatacter) to a external device, via COM2 port, and receive also other signal from that device. I dont know what is VFP9 code that I must write in program to do this comunication. Is it posible  without use any auxiliary executable file Thank you.   Yes you can, using MSComm32.OCX See: http://fox.wikis.com/wc.dll Wiki~MsComm32 http://www.universalthread.com/wconnect/wc.dll 2,54,33,9336 http://www.universalthread.com/wconnect/wc.dll 2,84,14,7943 ...Show All

• odv RESOLVED! Browsers Insert html in my code

  I'm useing foxpro to create content for my webpages, I insert html code into a memo field. then a web page will grab the data. I like to use ascii characters to keep my code tidy so I can read it when its a web page. My problem is that the browser reads the ascii text and inserts <BR> messing up my javascript. What can I do i.e. Javascript = "function AlertMe() { "; +chr(13)+chr(10)+" Alert(' Alert! ');"; +chr(13)+chr(10)+" } " after browsers: function AlertMe(){<BR> Alert(' Alert! ');<BR> }<BR> RESOLVED! chr(13) will place a <br> in the script. chr(10) is suffecient enough to move the code to the next line and help readability ...Show All

• stujol How to overwrite a disk file that is read-only?

  While trying to run oFS = Createobject('Scripting.FileSystemObject') ...... oFS.CopyFile (file1,file2,.T.) I get an error on statement # 2 if file2 is read-only. It is a errant situation. This file is not supposed to be this way. I have to transfer about 2,000 files each time and a couple of them turn out to be this way for no apparent reason. The program breaks down. How can I change this property on the fly programmatically Thanks. Thank you, Cetin. It is already working. Was there a problem with the forum website yesterday I could not sign in for a while. Function ModifyFileattribs lparameters tcFileName, tlReadOnly, tlHidden, tlSystem #define FILE_ATTRIBUTE_READONLY 0x00000001 #define FILE_ATTRIBUTE_ ...Show All