How to get the names of the files in a subdirectory

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Re: Tag: How to get the names of the files in a subdirectory Tag: 225959
  - 2
    - Report Generator in VFP Before I spring for a manual on the Report Generator, I would like to know if it has a general capability to do what my client requires. I am aware that the Report Generator can easily produce a complete report, with heading, footer, multipage control, and the like. But, it appears (to this untrained eye) to be able to only produce a line by line listing within the body of the report. I have a situation where a client needs to produce sub-totals of various item classes within a single report; and, it doesn't appear that the Report Generator has that capability. Am I wrong? Many thanks. Tag: How to get the names of the files in a subdirectory Tag: 225955
  - 3
    - Combo Box help needed Hi, I feel like a dolt here but I can not get this combo box to do what I want and I'm not sure what my problem is. I'm setting up a simple inventory database, I have two tables; computers and users. The computers table as three fields in it: prop_no Integer description C(25) user_id Integer The users table has three fields in it: user_id Integer first_name C(15) last_name C(20) I'm using the treeview control to list the users and thier computers, this works. When I click on a computer node it looks up the computer and displays the information, this works. Here's my problem: I want to have a combo box that initially lists the current user's full name. For now I'd accept the first name. So I have my combo box configured like this: BoundColumn = 2 BoundTo = T ControlSource = computers.user_id RowSource = users.first_name, users.user_id RowSourceType = I tried both, 2 - Alias and 6 - Fields, both give the same result. ColumnCount = 2 Style = 2 - Dropdown List When I run my form I get an error, "Field phrase is not found." What am I doing wrong?? I have used this object before and I thought I set it up like this. I'm sure it's something simple and I do appologize for taking up everyone's time and bandwidth with these simple problems. Thanks in advance, Linn Tag: How to get the names of the files in a subdirectory Tag: 225952
  - 4
    - Copying classes? Hi, Is it possible to move or copy a class from one class library to another in VFP 9.0? If so, how could I do it? Thanks in advance, Linn Tag: How to get the names of the files in a subdirectory Tag: 225943
  - 5
    - Re: Tag: How to get the names of the files in a subdirectory Tag: 225941
  - 6
    - Need help on CURSORTOXML method Hi I have used the CURSORTOXML method to convert the cursor to XML file. However all the tags are in lower case. Anyone knows how to set the tags to UPPER CASE? Appreciate your help. Tham Tag: How to get the names of the files in a subdirectory Tag: 225936
  - 7
    - Appending from file delimiter I have a flat file with delimiter with char ~ it has date field also with format as dd-mmm-yyyy i changed the date setting as short or long in vfp in regional setting of windows control panel also i have kept the setting as dd-mmm-yyyy . But while appending the data i am getting the blank field in the all the date fileds , Pleae let us help. Bankim Tag: How to get the names of the files in a subdirectory Tag: 225935
  - 8
    - Can I get some help with VFP9 in Installshield? I have an app - using vfp9 - and Installshield 5. I need to have installshield install some barcode fonts on the users system. Anyone faced this problem before. My apologies. I can't seem to get any help from Installshield and I know it ships with VFP products. Been using foxpro since it was dbase IV. I have installshield put the fonts in the c:\windows\fonts directory but my app does not see them. Any help would be greatly appreciated. Thanks Tag: How to get the names of the files in a subdirectory Tag: 225933
  - 9
    - Need Help with Search Hi everyone. I have a search menu that works if I select "ALL", with tells me "ALIAS NOT FOUND" if I try to search by typing in the first few letters of the patient's last name. Here is the code I am using: #DEFINE DELKEY 127 LPARAMETERS nKeyCode, nShiftAltCtrl LOCAL cDisplayValue IF nKeyCode = DELKEY cDisplayValue = ALLTRIM(THIS.DisplayValue) IF LEN(m.cDisplayValue)=1 cDisplayValue = "" ELSE cDisplayValue = LEFT(cDisplayValue,LEN(cDisplayValue)-1) ENDIF ELSE cDisplayValue = ALLTRIM(THIS.DisplayValue)+CHR(nKeyCode) ENDIF THISFORM.LockScreen = .T. DO CASE CASE EMPTY(m.cDisplayValue) THISFORM.grdcust.recordsource = " " CASE THIS.Value = "(All)" SELECT l_name AS lname,* FROM patients; INTO CURSOR Custs thisform.grdcust.recordsource = "Custs" OTHERWISE SELECT l_name AS lname,* FROM patients ; WHERE UPPER(ALLTRIM(l_name.patients)) = UPPER(m.cDisplayValue); INTO CURSOR Custs thisform.grdcust.recordsource = "Custs" ENDCASE THISFORM.ResetCombos(THIS) THISFORM.LockScreen = .F. _____________________________________________________________________________ In my other search field, I have the search set up so that all of the patients last name's appear in the drop down menu in alphabetical order, but if I select a last name to display, I get the error "ALIAS L_NAME IS NOT FOUND". Here is the code I am using here: LOCAL cDisplayValue THISFORM.LockScreen = .T. IF THIS.Value = "(All)" SELECT l_name AS Location,* FROM patients INTO CURSOR pats ORDER BY l_name thisform.grdcust.recordsource = "pats" ELSE SELECT l_name AS Location,* FROM patients ; WHERE UPPER(ALLTRIM(l_name.patients)) = UPPER(ALLTRIM(THIS.Value)); INTO CURSOR pats thisform.grdcust.recordsource = "pats" ENDIF THISFORM.ResetCombos(THIS) THISFORM.LockScreen = .F. ------------------------------------------------------------------------------------------------------------------------------------ I have both of these codes in the Interactive Change of each combobox. Can someone please point me in the right direction? Thanks in advance. Arvin Tag: How to get the names of the files in a subdirectory Tag: 225919
  - 10
    - Change file reference on OLE object Hi, I have an Excel file that I'm displaying in a VFP form using an OLE control, linking it to a local file. Problem is, sometimes that local file gets locked up, and I can't overwrite it with new data in order to display it in my form. Either the user has it open in Excel, or in some cases, just having Excel open locks it up (can't figure that one out...) I would like to be able to dynamically change the file name that I'm displaying, so that I can control it from within the program and not have it hard-coded. But the OLE control's DocumentFile property is read-only at run time. Any ideas on this? Am I using the control wrong, or the wrong control? Thanks, Cathy Tag: How to get the names of the files in a subdirectory Tag: 225916
  - 11
    - Is it possible to use Foxpro forms as a backbone to generate PHP+MySQL+AJAX -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 21:55:01 up 10 days 2:51 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: How to get the names of the files in a subdirectory Tag: 225905
  - 12
    - macro substitution in a report I am generating a cursor with field names produced on the fly, depending on the month that the routine is run. I want to design a report and display these fields and wondered whether I could do it via macro substitution, along the lines of lcVariable = <fieldname> and then in the report detail band put &lcVariable but it failed. I tried making the variable private or public but this had no effect. Is there a way of doing this? Sincerely Stephen Tag: How to get the names of the files in a subdirectory Tag: 225902
  - 13
    - [MSDE] What is the command to truncate the logs? The size of my database is growing. There is no need to backup anything and I could stop the server anytime. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 19:04:01 up 10 days 0 min 0 users load average: 1.02 1.02 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: How to get the names of the files in a subdirectory Tag: 225901
  - 14
    - Upgrade Time I am finally going to get a shiny, new computer; one that was built in this millennium. The same goes with VFP. I will shortly be using VFP 9. (If you are thinking of joking that this is a sure sign that VFP 10 and 11 will be released RSN, I thought of it first. Neener, neener!) My question, which is not answered by the Microsoft Website as far as I could see, is is VFP 6 sufficient in order to order the VFP 9 upgrade? Lee Mitchell, I might have gone with VFP 9 sooner if there were a clear statement that VFP 9 development works on a Windows 98 machine. (Tying software upgrades to hardware upgrades can delay the software upgrade, something a software company should think about not doing.) Sincerely, Gene Wirchenko Tag: How to get the names of the files in a subdirectory Tag: 225890
  - 15
    - VFP 9 Reports v's Crystal I have a series of reports in VFP 7 that have a large number of fields in the cursor they are based upon. Segments of these fields are printed in specific detail bands on the report. They are a little difficult to maintain and also present some paging issues. I am considering moving them to use either Crystal Reports or the VFP 9 report writer. The typical format of these reports are: report header detail band 1 detail band 2 detail band 3 report footer The data in the detail bands all have a key field that references the data in the report header and are simply linked so a query like select * from table where linknumber = header.linknumber would get the data required. Are reports like this easily implemented in VFP 9? Will I be able to get rid of my monolithic cursors? thanks Tag: How to get the names of the files in a subdirectory Tag: 225889
  - 16
    - Mixed databases I have a free tables database in my application (currently in VFP 7). I need to integrate the application with another application that uses an SQL/Server database. I will need to execute some queries and stored procedures on the SQL database. Can I do that from VFP 7 or do I need to move to VFP 9? thanks pete Tag: How to get the names of the files in a subdirectory Tag: 225888
  - 17
    - VFP 6 (and ?): Lazy Parsing I just corrected a bug where VFP could have parsed better. I had a do case. Somehow, I left off the case keyword on the two cases. There were no compilation or run-time errors. Here is the corrected code with the correction in caps: do case CASE cwhoshad.stnbusy="L" busymsg="Station is busy (Local use)." CASE cwhoshad.stnbusy="R" busymsg="Station is busy (Remote use)." otherwise busymsg=; "Station is busy. The access type is unknown ("+cwhoshad.stnbusy+")." endcase Shades of * This is a comment; ? "and so is this." Sincerely, Gene Wirchenko Tag: How to get the names of the files in a subdirectory Tag: 225887
  - 18
    - Searching for a good ARJ and PAR compression activex or dll Hi, I would like to add ARJ and PAR to our VFP based backup software. All the stuff I've found on google so far has been C++ libraries or stuff for Borland Delphi etc. Thanks Tristan BackPack Product Manager www.backpackpro.com Tag: How to get the names of the files in a subdirectory Tag: 225886
  - 19
    - How to enable Print Preview in Editing Window and Form Designer? I'm using Visual FoxPro 9 SP1. How can I enable Print Preview in Editing Window and Form Designer? Thanks. Tag: How to get the names of the files in a subdirectory Tag: 225882
  - 20
    - DBSETPROP - IdleTimeout documentation error? Hi there, I'm comparing the MSDN for DBSETPROP "IdleTimeOut" to the tooltip that comes up in the IDE. MSDN says that the value is in minutes, but the tooltip says the value is in seconds. Tag: How to get the names of the files in a subdirectory Tag: 225881
  - 21
    - strange behaviour - MODIFY FILE VFP8 SP1 I have an error handling routine I would like to popup a box that the user can type into to say what they were doing at the time of the error. The file is then emailed to us. When the MODIFY FILE command finishes I get this message "Session number is invalid" repeated many times CANCEL IGNORE & HELP buttons are available, cancel fixes the problem and the email is generated. cReasonFile = TRANSFORM( INT(rand()*10^8) ) + ".txt" STRTOFILE(CRLF + CRLF + CRLF + "[Please include a brief description of how the error occurred]", cReasonFile) MODIFY FILE (cReasonFile) *** Seems to occur here after the Modify completes but before the fileToStr() executes. cReason = FILETOSTR(cReasonFile) ERASE (cReasonFile) If I use the debugger to step through the code the problem doesn't occur. The only way I have been able to determine where the error occurs is through "wait window ..." Any ideas - I am stumped, it could be the error being reported is wrong. Tag: How to get the names of the files in a subdirectory Tag: 225867
  - 22
    - SQL result difference between VFP8 and VFP9 CREATE CURSOR cur1 (field1 c(1) NULL) INSERT into cur1 VALUES (.Null.) SELECT field1 as field2, field1 from cur1 INTO CURSOR cur2 VFP 8 shows field2 - blank field1 - .Null. VFP9 shows field2 - .Null. field1 - .Null. Any setting can fix it? Tag: How to get the names of the files in a subdirectory Tag: 225865
  - 23
    - Using Setup Wizard 6.0 Using Setup Wizard (VFp 6.0) how do i create a Desktop icon to run my application and also to place it on the Start Menu (i.e Start...>Programs...> MyApp). plz help. Tag: How to get the names of the files in a subdirectory Tag: 225863
  - 24
    - problem with Fsize Fsize() returns an error "File does not exist" for hidden files Tag: How to get the names of the files in a subdirectory Tag: 225861
  - 25
    - Add money to your Paypal account with OPRAH Hlt8* Read this message until the end, and you will find out how the money flows in easy !!!!. Follow the steps and it WILL work. Trust me !!!!!. It's NOT illegal and it is NOT a scam !!!!!. PROVEN ON OPRAH! Reported in the Wall Street Journal!!!! The only thing you need is : - E-MAIL ACCOUNT - PREMIER (FREE) or BUSINESS PAYPAL ACCOUNT - $6 on this account (The only investment) - 30 minutes of your time There is no limit on how much money you can recieve, and you haven't got anything to lose with this Business program. I will explain how it works !!!!!. Follow these 4 easy steps and it WILL work !!!!!. STEP 1 : SIGN UP FOR A FREE PAYPAL ACCOUNT !!!!!. Paypal is a free and safe way to pay and receive money on the Internet. Creating a account is as easy as creating a MSN account. Copy and paste the next line in your Internet browser and sign up. HTTP://WWW.PAYPAL.COM Be sure to sign up for a FREE Premier or Business account and not for a Personal account. You cannot receive CREDITCARD payments with a Personal account and we can't have that. Do we !!!!!. STEP 2 : SENT $6 TO YOUR PAYPAL ACCOUNT This is your only investment to receive the money with ease. With your Paypal account, send $1 to each e-mailadres listed below. !!!!! IMPORTANT !!!!! Be sure to use this SUBJECT : *PLEASE PUT ME ON YOUR EMAIL LIST* when you send the money. 1) martine@pilote.net 2) dexxatol@netcourrier.com 3) armygirl8568@hotmail.com 4) comjii@starband.net 5) sinnek@bellsouth.net 6) nsi@nelasat.com STEP 3 : PUT YOUR E-MAIL ADDRESS ON THE BOTTOM OF THE LIST After you have send $1 to each e-mail address, put your e-mail address on the 6th place. Remove e-mail address number 1, and move each e-mail address 1 step up the ladder. !!!!! IMPORTANT !!!!! BE SURE THAT THE E-MAIL ADDRESS YOU USE IS THE SAME AS YOU USED TO SIGN UP AT PAYPAL. Remember that this is LEGAL. You are creating a service : an e-mail servicelist. STEP 4 : UPLOAD OR COPY THIS MESSAGE TO NEWSGROUPS, FORUMS ETC AND EMAIL IT TO ALL YOUR FRIENDS! There are 32,000 newsgroups. Upload or copy this message to at least 200 newsgroups or forums etc, but ........ remember that the more your upload the more people will see your message and the MORE MONEY WILL FLOW IN. How to upload to newsgroups and forums? : After you have followed step 1,2,3 and 4, save this message (and copy so you can use it again). Use your Internet browser and Outlook Express or another newsreader and try to find FORUMS, NEWSGROUPS, BULLETIN BOARDS, DISCUSSION GROUPS, CHAT SITES and ONLINE COMMUNITIES. Use GOOGLE or use a NEWSERVER. Use every option to post this message. Download PostXpert to send 1 message to more NEWSGROUPS at the same time. !!!!! REMEMBER !!!!! The more you post this message the more MONEY WILL FLOW IN. Why does this Business program work so well !!!!!. Lets asume that from the 200 (or more) messages that you have posted, only 5 people respond, you will have your $6 back that you have invested. Those 5 people will each send at least 200 messages with your e-mailadres on number 4. That's 6 x 6 x $1 = $36. The next 25 people will also send 200 messages with your adres on number 3. That's 36 x 6 x $1 = $216. The next 216 people also send 200 messages with your name on number 2. That's 216 x 6 x $1 = $1296!. Those 1296 people again also send 200 messages with your name on number 1. That will give us a total of 1296 x 6 x $1 = $7,776. Now the last tier! 7776 x 6 x $1 = $46,656!!!!!! This is only a EXAMPLE with 6 reactions. You WILL get MORE responses than that. Remember that most newsservers will leave the posted messages on there servers for about 2 weeks. If you will post your message again, it WILL again start from the beginning. So you can repeat this over and over again. Everyday MILLIONS of people are ONLINE and reading these messages, JUST LIKE YOU RIGHT NOW. I also was sceptical in the beginning and have read a lot of these messages. I also thought that it was bullshit. Until I thought : What the hell!, only $6. What's $6 and a couple of minutes of my time to solve my money problems. !!!!! REMEMBER !!!!! Follow every step, and IT WILL WORK, TRUST ME. !!!!! !!!!! BEST WISHES AND GOOD LUCK !!!!! w)O>+;)<9UVS;F>qaGL<Uq#v`V6(F]- rM;$g+!4IIQ*827?H4 Tag: How to get the names of the files in a subdirectory Tag: 225860
- Next
  - 1
    - Who has file open in Netware Hi, I need to know who as a particular file open. The file is on a Netware server and it's possible that several users have the file open at the same time (not exclusively of course). Gplib used to be great for this but AFAICS there is no version of gplib for VFP. Any ideas how to do this? Thanks, Frank Tag: How to get the names of the files in a subdirectory Tag: 225855
  - 2
    - Usability question? Hi, I'm developing multiple projects in VFP 9.0 and I'm wondering if it is possible to have a shortcut on my desktop that launches a specific project in the development environment? That way I could have a shortcut to each project that would have the correct startup folder and all. Does that make sense? Is it possible? How do you handle developing multiple projects on the same system? Thanks in advanced, Linn Tag: How to get the names of the files in a subdirectory Tag: 225851
  - 3
    - print with word97 I have an exe I think was originally created in vfp 5 , has been upgraded to 8 and then to 9. It creates a word document and populates it with variables created in same exe. The problem is it will only print correctly if word 97 is the only version of word on the computer running it. The part that doesn't print properly is a variable that uses chr(13)+chr(10). The newer versions of word do not have the carriage return . Only a space. I don't know what to look for ? thanks sherry Tag: How to get the names of the files in a subdirectory Tag: 225843
  - 4
    - Connection Handle Disconnect? This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6BFE4.B675A5D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I am creating a connection to MySQL with the code below and using it in = my CursorAdapter classes. lnConnectionHandle =3D SQLSTRINGCONNECT(lcConnectionString,.T.) Testing the application, I noticed that if I left one of my forms open = without any user activity for some period of time the connection gets = lost. What am I missing here? --=20 Edhy ------=_NextPart_000_0006_01C6BFE4.B675A5D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am creating a connection to MySQL = with the code=20 below and using it in my CursorAdapter classes.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2> <P>lnConnectionHandle =3D </FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20 size=3D2>(lcConnectionString,.T.)</P></FONT></DIV><FONT face=3DArial = size=3D2> <DIV>Testing the application, I noticed that if I left one of my forms = open=20 without any user activity for some period of time the connection gets=20 lost.</DIV> <DIV> </DIV> <DIV>What am I missing here?</DIV> <DIV><BR>-- <BR>Edhy</DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C6BFE4.B675A5D0-- Tag: How to get the names of the files in a subdirectory Tag: 225825
  - 5
    - How to import data from text file created from List Memory or Obje I want to import data from text files created from List Memory or List Object in VFP SP1. Is there any tools available for such import? Thanks Tag: How to get the names of the files in a subdirectory Tag: 225821
  - 6
    - VFP How do I determine table buffering setting. I want to be able to determine if cursorsetprop has been used to set buffering to something besides 1 for a free table. How do I do that? Help says you can find out by using cursorsetprop but doesn't tell how. Tag: How to get the names of the files in a subdirectory Tag: 225812
  - 7
    - Case studies in VFP Trying to submit a case study to MS, The Case study is for a 80GB 100% pure VFP 9 application. The site is not very helpful. Anybody know the procedure? Thanks Mohammed Tag: How to get the names of the files in a subdirectory Tag: 225799
  - 8
    - Clipper to VFP Anybody done this? What should I be aware of? Is it easy? Used to use Clipper as a compiler for dBase, did some programming in it when they broke away, Lost track of it over the years. Any and all information, Tips etc would be greatly appreciated. Thanks Mohammed Tag: How to get the names of the files in a subdirectory Tag: 225798
  - 9
    - The buffer overrun problem I encounted. It's the projecthook class. If I unhooked it, nothing would go wrong. If I ever tried to hook it up again, it would keep crashing even if you unhooked it after a failed compile. It seemed that the project builder would remember something that could bring about the crash. I believe my codes in projecthook.beforebuild and projecthook.afterbuild are clean and simple (mainly about hacking the report forms). Even if I just added some comments into these 2 events, the compile would still crash. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 12:22:01 up 5 days 17:18 0 users load average: 1.11 1.10 1.07 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: How to get the names of the files in a subdirectory Tag: 225794
  - 10
    - Indexing a table on multiple fields with a date field in descending order I have a table with the following fields: id, date, testrecord. What I want to do is to order the table so that the records are ordered as follows: id by date by testrecord. I want id to be in ascending order, but date and testrecord in descending order. I created an index file called testdata with the expression: id+dtoc(date,1)+testrecord. Id and testrecord are character fields.This index file will sort in ascending order. My question is: what do I need to do to get the table sorted as I want it - that is id in ascending order, but date and testrecord in descending order? Tag: How to get the names of the files in a subdirectory Tag: 225790
  - 11
    - If I was to submit the test case Could I request M$ to sign an Non-Disclosure Agreemnt? :) Ok, I knew our stuffs aren't that mission-critical, but ....it's still my company's property. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 22:12:01 up 5 days 3:08 0 users load average: 1.02 1.03 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: How to get the names of the files in a subdirectory Tag: 225786
  - 12
    - Winsock Control Help Thanks in advance for the help. I'm trying to build messaging into my app using the Winsock control and there is something that I don't quite understand. I need each instance of the app to act as both a client and a server so that it can receive messages from anywhere and so that it can send messages to anywhere. Do I need two controls? Do I listen and send on different ports? Has anyone ever built this type of app using this control? Thanks, Jeff Tag: How to get the names of the files in a subdirectory Tag: 225769
  - 13
    - Confused by sample code Hello and thanks for the help. I am looking at some sample code which works but there is an element of the syntax which is confusing. The code is: ThisForm.tcpServer.Object.LocalPort = 1001 ThisForm.tcpServer.Object.Listen where tcpServer refers to an instance of the Winsock control. Why is the .Object in this code? What is the difference between Thisform.tcpServer.Object.LocalPort and Thisform.TcpServer.LocalPort? Thanks again, Jeff Tag: How to get the names of the files in a subdirectory Tag: 225764
  - 14
    - Append general error Just trying to append a .jpg file and get an error I haven't had before. When using Append general photofield from temp.jpg I get "OLE error code 0x80070002. The system cannot find the file specified" Is there something wrong with my VFP9 installation? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: How to get the names of the files in a subdirectory Tag: 225758
  - 15
    - Sending Control G to serial port In the code below I want to send CTRL G as the output. How do I do it or what is the code I need to enter. ***Program code*** PUBLIC ComForm ComForm = CREATEOBJECT('Form') ComForm.AddObject("Testcom","Olecontrol","MSCOMMLib.MSComm") ComForm.Testcom.CommPort = 2 && Use Comm2, The second Serial Port. ComForm.Testcom.Settings = "14400,N,8,1" && 14.4 Kbaud, No Parity, && 8 data Bits, 1 Stop Bit ComForm.Testcom.PortOpen = .T. ComForm.Testcom.Output = "ATDT555-1234" + chr(13) && Dialing the number * The chr(13) is needed to complete the modem command sequence ComForm.Testcom.PortOpen = .F. ***** End Code ***** Rusty Tag: How to get the names of the files in a subdirectory Tag: 225751
  - 16
    - TIF Files I have been using the kodak image viewer to open TIF files from my foxpro applications and it has been giving me memory errors since the last patch to Windows XP. Kodak image viewer is no longer supported. I was wondering if anyone else had another view they were working with. I have Adobe 7 but have not figured out how to initiate the program from within Foxpro. Any ideas? Tag: How to get the names of the files in a subdirectory Tag: 225745
  - 17
    - Converting Tabs to Spaces Does anyone know of command to convert Tabs into Spaces? of course a STRT will do the trick, except for the tabs that are less than the characters specified in the STRT. There is a VB command which I've seen referenced although I don't know if it will address the problem above. Edit.ConvertTabsToSpaces -- Thank You, Louis Tag: How to get the names of the files in a subdirectory Tag: 225744
  - 18
    - Need URGENT help with interactivechange with 2 combo boxes I am unable to change selection in 1st combo box when I try to clear the value of the 2nd combo box in the interactivechange area. Here is a little better explanation: I have 2 combo boxes on my form. Both combo boxes get populated using a select statement. Everything worked fine until I decided that I want to clear the value of the second combo box if the first one changes to force the user to make a new selection so I put this in the first combo box in the interactivechange event: thisform.cmbBox2.value = "" Now when you try to change the selection in the 1st combo box, the 2nd combo box does get cleared, but the first combo box doesn't change like it is supposed to. When I remove this line from the interactivechange event you can change the 1st combo box and the new selection appears. What am I missing? Is there another way to force them to make new selections in corresponding comboboxes when one changes the primary one? Thanks in advance for any help you can give me. Tag: How to get the names of the files in a subdirectory Tag: 225741
  - 19
    - Damaged/Corrupted DBF I have a corrupted .dbf file that can not be opened. What are my best options for getting this file repaired? The file does not have a .fpt associated with it. I know there are many utilities that can be purchased, but which one. I can't believe Microsoft hasn't included a utility to repair damaged files within VFP. I don't like the thought of paying $199 for a utility that I almost never need. I have this one client that seems to come up with a damaged file every six months or so. Any clues of why this is happening? They are running the application off of a Citrix server, meaning it is accessed via Citrix and actually loaded on the Citrix server. I have many apps that have been running for years and years without any corruption? All my apps are running on file servers? VFP9 / Windows XP Tag: How to get the names of the files in a subdirectory Tag: 225738
  - 20
    - Speaking of code generator using Foxpro... Mr. Ed Leafe didn't use Foxpro to generate python codes for his Dabo Framwork as well.. :) I wondered whether Dabo could generate PHP code.... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 21:18:01 up 3 days 2:14 0 users load average: 1.01 1.02 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: How to get the names of the files in a subdirectory Tag: 225734
  - 21
    - How to get the complextype data return from a web services? Hi I am actually testing how to use web services using VFP8. I have written a sample code (see below) to consume the web service on the link below: http://www.webservicex.net/WS/WSDetails.aspx?CATID=12&WSID=64 --------------------------------------------------------------------------------------------------------- LOCAL oWS AS "XML Web Service" LOCAL loGeoIP TRY oWS = CREATEOBJECT("MSSOAP.SoapClient") oWS.MSSoapInit("http://www.webservicex.net/geoipservice.asmx?WSDL") loGeoIP = oWS.GetGeoIPContext() CATCH TO oErr MESSAGEBOX(oErr.Message) ENDTRY IF VARTYPE(oWS) = "O" RELEASE oWS ENDIF --------------------------------------------------------------------------------------------------------- The method GetGeoIPContext() return a complextype GeoIP. Below is the GeoIP extract portion from the WSDL file. - <s:complexType name="GeoIP"> - <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="ReturnCode" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="IP" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="ReturnCodeDetails" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="CountryName" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="CountryCode" type="s:string" /> </s:sequence> </s:complexType> Does anyone know how to extract the complextype data in VFP8? Appreciate your help. Tham Tag: How to get the names of the files in a subdirectory Tag: 225720
  - 22
    - How to determine the input method for the textbox control? Hi I have a PC with a barcode scanner and keyboard attached to its PS/2 plug using the Y cable. In my VFP8 application, I want to control the type of input method for a textbox control in a form. That means that I want the data to be input to a textbox control ONLY from the barcode scanner, NOT from the keyboard. Is there a way to determine or control the input method for textbox control? Appreciate your help. Tham Tag: How to get the names of the files in a subdirectory Tag: 225718
  - 23
    - License If I bought Visual Foxpro via Amazon.com from Hong Kong, is the license valid? Not many shops in Hong Kong sell VFP... -- SoftMedia Technology Co., Ltd. Website: http://www.softmedia.hk Tel: (852)2743 4228 * TryEasy Accounting/POS/Trading/ERP solutions Tag: How to get the names of the files in a subdirectory Tag: 225717
  - 24
    - project file The project that I have been working on for some months loads fine in the vfp 9 ide. It looks like all the forms and code are present. When I try to build the project it says the memo file, name.pjt, is missing or invalid. I see that yes, the file is present where it should be. Is there some way that I can regenerate this file? Tag: How to get the names of the files in a subdirectory Tag: 225711
  - 25
    - Need help with combobox Hi everyone. I need some help with using a drop down combobox. I have a table (physicians) that contains physician's names and phone numbers. I want to be able to create a drop down menu where users can click on the drop down menu and select the physician. Once the usr selects the physician, I want a text box to display the physician's phone number automatically. How would I go about doing this? I am using VFP 8 with SP2. Thank you in advance. Arvin Tag: How to get the names of the files in a subdirectory Tag: 225710

I have some raw data which stored in txt files in a subdirectory. The
file names are actually in the form of "yyyymmdd.txt" which is the date
of these data collected. This date is also a data to be input into the
database.

I would like to go to this subdirectory and open all the files inside
and transfer the data into the database. How can I get all the names
of these files (preferably using vpf commands) so that I can open them
one by one and transfer in the data inside?

Top

Re: How to get the names of the files in a subdirectory by Man-wai

Man-wai
Sun Aug 20 04:54:18 CDT 2006

> I would like to go to this subdirectory and open all the files inside
> and transfer the data into the database. How can I get all the names
> of these files (preferably using vpf commands) so that I can open them
> one by one and transfer in the data inside?

check out adir()

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 17:53:01 up 12 days 22:49 0 users load average: 1.07 1.04 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Top