Example of create index with ADOX

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
    - OLEcontrol in a form and winsock I am stuck again. The wincsock control was added, but it didn't connect to remote host. Clicking the connect button didn't initiate any tcp connection to my smtp server. local owinsock oform=createobject("myform") oform.show(1) define class myform as form add object owinsock as myole with ; protocol=0, ; remotehost="192.168.2.1", ; remoteport=25 add object text1 as textbox with top=0 add object command1 as commandbutton with ; top=220, left=100, caption="\<connect" procedure command1.click thisform.caption=thisform.owinsock.localip thisform.owinsock.connect * should dispaly 6 for connecting, 7 for connected thisform.text1.value=thisform.owinsock.state thisform.owinsock.close endproc enddefine define class myole as olecontrol oleclass="MSWinsock.Winsock.1" enddefine -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 5:38pm up 22:44 1 user 0.95 0.92 Tag: Example of create index with ADOX Tag: 190794
  - 2
    - Putting Formatted Text into Email I am using Word automation to open a document, edit the formatted text, and somehow email it to a recipient list I have in a DBF. I have created an Outlook.application item but can't figure out how to paste the formatted text into it (there is no 'paste' method in the Outlook object model). I also tried to figure out how to email directly from Word but can't find a 'recipient' property to set. Any help would be appreciated. --Mike Tag: Example of create index with ADOX Tag: 190790
  - 3
    - Passing parameter to an EXE Hi I want to pass a parameter to my VFP EXE such as running it like MyApp.EXE /s / How can I do this? I am using a .PRG as my "main". I tried using PARAMETER on the first line of my "main".PRG but I can't use the "/" switch. It gives me a "datatype mismatch". Please help ALC Tag: Example of create index with ADOX Tag: 190788
  - 4
    - Ken Levy's March 2004 Letter from the Editor From http://msdn.microsoft.com/vfoxpro/letters/ March 2004 Letter from the Editor There are many exciting announcements in this month's letter, so we'll dive right into the details. There is life on Europa... Visual FoxPro 9.0! Announcing here formally (insert mental drum roll here)... the next version of Visual FoxPro from Microsoft, code named Europa, will be named Visual FoxPro 9.0. Visual FoxPro 9.0 is scheduled to be released during the second half of this year. Announcing the official name of the next version of Visual FoxPro now will allow upcoming articles, conferences, events, etc. to freely use the name Visual FoxPro 9.0 instead of the Europa code name. Oh, beta! This coming June, Microsoft will release a public beta version of Visual FoxPro 9.0 on msdn.com for anyone world-wide to download and install for free! Life is like a box of Visual FoxPro 9.0 We have recently started the process with the packaging and branding group within Microsoft to create the product box for Visual FoxPro 9.0. It is very likely that the screen shot used on the back of the Visual FoxPro 9.0 box will be of the enhanced Report Writer. For the Visual FoxPro 8.0 back-of-the-box product highlight listing, I was unable to convince the team that we should include a bullet item for the return of the Puzzle: ACTIVATE WINDOW Puzzle FoxTalk Reloaded FoxTalk has been in existence for many years and is a great technical resource for FoxPro developers. I was a contributing author and editor of FoxTalk during the early days of GenScrnX and the new object-oriented features of Visual FoxPro 3.0. The publishers of FoxTalk, Ragan Communications (which acquired Pinnacle Publishing 15 months ago), have recently been making some big decisions concerning FoxTalk. After talking with the FoxTalk team at Ragan, we've come up with a plan to make the publication better than ever. FoxTalk welcomes to the team David Stevenson who is an experienced technical editor. Additionally, FoxTalk will now include a monthly column submitted by the VFP team at Microsoft called "Tips from the VFP Team", to give an insider's view of how to get the most from VFP. Along with the editorial changes, Ragan has decided to offer a new lower subscription rate! Ragan has confirmed with me that all of these changes will begin with the May 2004 issue of the publication now called FoxTalk 2.0. While Microsoft will be contributing monthly to the FoxTalk 2.0 publication, editor David Stevenson and the FoxTalk team will of course make all of the decisions regarding content, editing, etc. For example, if the VFP team suggests an article on the FoxPro "Puzzle", they may decline for other content readers would prefer to see. You should expect to see articles in FoxTalk 2.0 submitted by VFP team members as well as the top FoxPro authors world-wide. Stay tuned for more information about FoxTalk 2.0 and visit to subscribe at PinPub.com or renew your subscription today to show your support for FoxTalk while obtaining great upcoming Visual FoxPro content. The June issue of FoxTalk 2.0 will be dedicated exclusively to articles and information on Visual FoxPro 9.0 to complement the upcoming free public beta download on msdn.com. The May issue of FoxTalk 2.0 will include more details from the editor on the plans for exciting upcoming issues. Hocus pocus, more CoDe Focus David Stevenson, while previously working at EPS Software, worked with the VFP team on the special CoDe Focus issue for Visual FoxPro 8.0. The VFP team is currently working with Markus Egger at EPS Software on another great CoDe Focus issue for Visual FoxPro 9.0. That special issue is scheduled to be released and given to attendees at Advisor DevCon in Las Vegas, September 29, when we launch Visual FoxPro 9.0. The Visual FoxPro 8.0 issue of CoDe Focus, as well as a new issue on the topic of Office 2003, can be found free online at code-magazine.com/focus. FoxPro books in your FoxToolbox.com The online e-commerce store FoxToolbox.com, owned by DBX-Technologies, is a great resource for obtaining Visual FoxPro, Visual Studio .NET 2003, and MSDN Subscriptions as well as third party add-on products for Visual FoxPro. Our friends at FoxToolbox.com, including Jim Eddins, are busy working on plans to create, publish, and sell Visual FoxPro books on the upcoming release of Visual FoxPro 9.0. David Stevenson, the new technical editor for FoxTalk 2.0, is working part-time with the folks at DBX on their Visual FoxPro book publishing plans. The Eight FoxPro wonders of the world Yet more exciting news in the FoxPro community is the fact there will be eight conferences world-wide this year focusing on Visual FoxPro. DevEssentials - June in Kansas City, MO DevTeach - June in Montreal, Canada Praha DevCon - June in Prague, Czech Republic Advisor DevCon - September in Las Vegas, NV SouthwestFox - October in Phoenix, AZ Germany DevCon - November in Frankfurt, Germany PortalFox Conference - November in La Coruna, Spain OzFox - November in Sydney, Australia Take one Tablet PC with VFP and call me in the morning Later this month, we will be posting a new whitepaper on msdn.com called Creating Tablet PC Applications with Microsoft Visual FoxPro written by Mike Stewart of the VFP team. This new whitepaper will complement the article by Markus Egger of EPS Software in the July 2003 issue of FoxPro Advisor Magazine entitled Build Tablet PC Applications with Visual FoxPro. For more information on Microsoft's strategy with Tablet PCs, refer to the ZDNet article called Microsoft swallows tablet concept whole. In case you missed it, Visual FoxPro was recently mentioned in an article on InternetNews.com called Small Business Embraces the Tablet. AccountMate of the Month Last month in San Francisco, Softline AccountMate introduced a new interface to its software line at Evolution (its reseller conference). I spoke at a general session to almost 200 attendees, most of whom were FoxPro developers who have not yet upgraded to Visual FoxPro 8.0 but who plan to do so soon with the new release of AccountMate 6.5. It was stressed in AccountMate's keynote presentation that Visual FoxPro 8.0 played a significant role in AccountMate's new version 6.5 release. Most people (including the press) at the conference were amazed what AccountMate has done in the user interface using Visual FoxPro 8.0. The event made the news for Accounting Technology , which has 30,000 readers with 3 times that via pass along rate. AccountMate and AccPac are now both owned by the same parent company, see the article Best Strikes Again. A case of FoxPro identity We have several new case studies highlighting solutions based on Visual FoxPro 8.0 submitted to the case study team at Microsoft which are currently in the process of being posted on the Microsoft web site. These case studies will be targeting non-developers such as IT managers, decision makers, and executives. When the upcoming case studies on Visual FoxPro 8.0 are added to the Microsoft case studies web site, we will also make sure that the proper announcements go out about them in various Microsoft newsletters such as MSDN Flash, just like what occurs for Visual Studio and other case studies announced. Stay tuned for these new Visual FoxPro 8.0 case studies to be posted, and when they are, we will include links to them on the Visual FoxPro home page. Don't get blogged down without weblogs The new VS Data Team's WebBlog will have regular entries from VS Data group manager Alan Griver, myself, and others on the VS Data team, which includes the VFP team. The list of Microsoft employees and teams with their own weblogs is growing weekly at blogs.msdn.com. We encourage FoxPro developers to consider creating their own blog to discuss FoxPro related topics. A great example of a FoxPro related weblog is Craig Bernston's FoxBlog. For FoxPro developers adding .NET Framework programming to their toolbox of knowledge, read Rick Strahl's WebLog. For more generalized geek topics, check out master blog commander Robert Scoble's weblog at Scobleizer. For more Visual FoxPro resources in general, check out the listings on the Visual FoxPro Dev Center at Related Communities for Visual FoxPro. March to the beat of the FoxPro drum Here are some calls to action for all FoxPro developers to consider. It is important to not only say thanks to the vendors and sponsors within the community, but to also be active to show your support. Upgrade to Visual FoxPro 8.0 via product or MSDN at FoxtoolBox.com. Subscribe to BOTH FoxTalk 2.0 and FoxPro Advisor. Attend at least one Visual FoxPro conference this year to learn about Visual FoxPro 9.0, make contacts with other Visual FoxPro developers, and help continue to improve our great FoxPro community. As Gordon Gecko says in the movie Wall Street, "The most valuable commodity I know is information." Same Fox time, same Fox channel If you missed reading any of the letters from previous months, check them out at the side bar links on this web page under Archive. In next month's letter, we will have more Visual FoxPro whitepapers, new Visual FoxPro 8.0 sample downloads posted on msdn.com, and more juicy details on new features coming in Visual FoxPro 9.0. Ken Levy VS Data Product Manager Microsoft E-mail: klevy@microsoft.com -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy.winegarden@mvps.org www.cindywinegarden.com Tag: Example of create index with ADOX Tag: 190787
  - 5
    - Foxpro 2.6w under XP database access issues I have been testing out using a legacy 2.6w app on XP boxes and have been encountering "Not A Table/DBF" error messages which are temporary and incorrect. It will happen when I am using a shared table in 2 different instances of foxpro at the same time. Does anyone have any knowledge of a work around or fix to this? Thanks, Jonathan Kadish Tag: Example of create index with ADOX Tag: 190784
  - 6
    - Pass parm to form, form is "main" in project - doesn't work! I have a simple form that receives two parameters in form.init. I run form with parameters from within VFP, it works. I put form in project, set form as "main", compile into exe. I run the exe, with the same parameters. I get "no parameter statement is found". I'm thinking that you can't do this, anyone else confirm or comment? Tag: Example of create index with ADOX Tag: 190780
  - 7
    - How to remove code page warning on tables from fox 2.6? I use vfp8 and winxp. On a regular basis I have to append records from a fox 2.6 table to a table in a vfp8 database. The code below works, but it gives me two windows the user have to deal with. A 'table update warning' window and a 'select code page' window. As far as I gather from previous postings the first window no one knows how to get rid of, but what about the second? Sincerely, Jan Nordgreen The code: * oapp.cdatfolpat is the folder for the database and cfilepath is the fox 2.6 table caux = oapp.cdatfolpat + 'newathlt.dbf' COPY FILE (cfilepath) TO (caux) IF INDBC('newathlt', 'TABLE') then REMOVE TABLE 'newathlt' endif ADD TABLE 'newathlt' * append the new records to the sdstud.dbf table USE newathlt IN 0 EXCLUSIVE SELECT sdstud INSERT INTO sdstud (st_house, st_sex, st_studid, st_class, st_name) ; SELECT st_house, st_sex, st_studid, st_class, st_name FROM newathlt Tag: Example of create index with ADOX Tag: 190777
  - 8
    - ReportDepot for .NET Announcement: New version of ReportDepot for .NET released by Semurg Enterprise Now ReportDepot for .NET provides complete code integration with the Visual FoxPro environment ReportDepot for .NET can make your reporting solutions more flexible, since it allows you to output FRX reports to PDF, RTF, XML SpreadSheet, and HTML files Take a look at how easy it is to incorporate ReportDepot for .NET in your VFP application ReportDepot for .NET v. 04.02.00 is currently available fo download at http://www.semurg.c Tag: Example of create index with ADOX Tag: 190775
  - 9
    - Need HELP...! I have problem with formset. Hi, my problem is that i have a program and i want that the first windows to be in a formset. In this formset i've got my main windows. But i don't know why my windows appears only if i set it to 'As top level form'. But the fact is that i don't want this windows in 'As top level form' cause i'm not abble to open another windows over. frmLoading : As top level form frmSetMain --> frmMain : In top level form --> frmAccess : As top level form --> frmSetOther --> frmOther : In top level form --> frmForm2 : As top level form --> frmForm3 : As top level form From my program (program.prg) i call frmSetMain and frmSetMain open frmMain. If i set frmMain to "As top level form" it's work but when i load my frmAccess windows (to type an access code to acces my form) the windows appears in back of the frmMain windows. And if i set frmMain to "In Top Level form" the windows is loading but everything is close and i return to foxpro windows. I'm going to be crazy.... I hope that you will understand my problem..(sorry for my bad english). thanks maxime Tag: Example of create index with ADOX Tag: 190774
  - 10
    - Foxprow I have several old programs running on Foxprow alongside some new ones developed in VFP6. I use the patch so that Foxprow runs on faster machines. My query is this. My machine is getting old and runs at 450 mz using Windows 98. If I upgrade to a new machine using Windows XP and running at a much faster speed, is there a speed limit at which the Foxprow patch stops being effective ? Will Windows XP run old foxprow programs ? Thanks. -- Tim Hobson Tag: Example of create index with ADOX Tag: 190771
  - 11
    - Union problem in view I use vfp8 and winxp. This parametric view I have used as a recordsource for a list. CREATE VIEW v_Sdstud AS ; SELECT ; sdstud.st_name AS Athletes, ; sdstud.st_studid ; FROM ; Sdstud ; WHERE ; sdstud.st_house = ?choicehouse ; AND sdstud.st_sex = ?choicesex ; AND sdstud.st_athlete = .T. ; AND (Sdstud.st_class = ?choiceclass OR upper(?choiceclass) = 'OPEN') ; order by ; sdstud.st_name It works fine. When I run the form, the list is filled the way it should with name of students. Now, on the top of the list of students I would like to add the record '(No athlete)'. I have tried this: CREATE VIEW v_Sdstud AS ; SELECT ; sdstud.st_name as Athletes, ; sdstud.st_studid ; FROM ; Sdstud ; WHERE ; sdstud.st_house = ?choicehouse ; AND sdstud.st_sex = ?choicesex ; AND sdstud.st_athlete = .T. ; AND (Sdstud.st_class = ?choiceclass OR upper(?choiceclass) = 'OPEN') ; union ; SELECT ; '(No athlete)' as Athletes, ; 0 as st_studid ; from sdstud ; order by ; 1 When I browse the query from the data environment and feed it the parameters it works fine. However, when the form is running it gives me an empty list. What am I doing wrong? Is there a better way of doing this? Sincerely, Jan Nordgreen Tag: Example of create index with ADOX Tag: 190765
  - 12
    - use run in xp? can the FVP6 command RUN (used in a PRG) be used in Windows XP? Tag: Example of create index with ADOX Tag: 190763
  - 13
    - file is in use and used('tablename') I use vfp8 and winxp. When I run this code something strange happens. IF USED('sdstud') then USE IN 'sdstud' endif USE sdstud IN 0 exclusive && line 47 In line 47 I get 'file is in use' error message. How come, when I closed it in the instructions above line 47? When I run the code a step at a time, used('sdstud') is false so it goes straight to line 47 and reports 'file is in use'. Can anyone help me? Sincerely, Jan Nordgreen Tag: Example of create index with ADOX Tag: 190754
  - 14
    - Open DB Exclusively I need to open the Database exclusively but I don't want to get an error if someone else has the DB opened and has it shared. Is there a way to find out if the Database is currently opened by anyone else? VFP8 sp1 Tag: Example of create index with ADOX Tag: 190743
  - 15
    - Triggers Hi Q1. I have a small problem, actually I am looking for something we use in SQL server Inserted.CustName or Deleted.CustNam Q2. I have a table A. I have some triggers in this to update table I am flocking table A before updation. Do I need to flock table B in the trigger ? If I flock table B in the trigger, will the locking and unlocking will happen fo every record ? because my updation is 'update where <condition>' for more that on record. Will it execute the trigger and lock table B for all the record separatly ? That is if the update condition is for 10 records, it will update record in A and execute the trigger then update the 2nd record and execute th trigger etc Mike Tag: Example of create index with ADOX Tag: 190740
  - 16
    - Function argument value ... is invalid when buiding EXE In VFP 8.0 (sp 1 installed), when i build the EXE of a project containing an OLE public class, i get the following error message "Function argument value, type, or count is invalid" This error is displayed when the status bar has shown : "Creating type library & registering Com component". Any help will be appreciated, Kind regards, Guy Tag: Example of create index with ADOX Tag: 190735
  - 17
    - Future support for Visual Foxpro Hi Our company has a product written in Visual Foxpro. We have a potential customer who is worried about purchasing our product because they say "we have concerns that FoxPro will not be supported by Microsoft in a few years" Can anyone suggest any papers and/or statements which I could show them to reassure them Thanks in advance for any help Pauline Pearc Tag: Example of create index with ADOX Tag: 190732
  - 18
    - to GURUs Not exactly a VFP question Is there a firing event that can be used when someone opens a folder? I would like to make an app that would start when the user enters into a folder, in order, let us say, to remind you something. Demetrios, Greece Tag: Example of create index with ADOX Tag: 190729
  - 19
    - how to specify the directory where I want to get the file Hi, I have used GetFile('txt') to get file using browsing table. However, I don't know how to specify the directory where I want to get the file. Please Help. Thanks a lot, Ray Tag: Example of create index with ADOX Tag: 190727
  - 20
    - SQLProcedures equivalent for FoxPro I'm writing a C++ tool that will list among other things, the stored procedures in FoxPro dbc file. Is there an ODBC API for that? Has anyone done that? SQLProcedures is not supported in FoxPro. --Kobby Tag: Example of create index with ADOX Tag: 190723
  - 21
    - Newbie question I am fairly new to programming/foxpro. I am rewriting an existing dos application using vfp 8. The application has the ability to setup new company files. Upon creating these company files, it creates a folder in the application directory (for example if I setup company 54, a folder called "Data54" will be created with all the dbf files in that folder). My question is, how can I make this happen? I want to create a folder for a company to work out of. Any help at all would be much, much appreciated!! Tag: Example of create index with ADOX Tag: 190719
  - 22
    - Microsoft MAPI Message control... Hi, did someone knows how i can add attachment files (JPG, AVI etc...) to a message with Microsoft MAPI Message Control ? I try this but it dosn't work: IF !this.parent.signon() && Use the custom method RETURN ENDIF IF this.parent.LogSession && Check if the user was able to login this.parent.OleMMess.sessionid=this.parent.OleMSess.sessionid * Start a new mail message and build the text this.parent.OleMMess.compose lcMessageText="My message ....bla bla bla" SET STEP ON this.parent.OleMMess.msgnotetext=lcMessageText this.parent.OleMMess.msgsubject="subject.....bla bla bla" this.parent.OleMMess.attachmentIndex=1 this.parent.OleMMess.attachmentName ="dsc0001.jpg" this.parent.OleMMess.attachmentPathName="c:\temp\dsc0001.jpg" this.parent.OleMMess.send(1) IF this.parent.logsession this.parent.OleMSess.signoff ENDIF && Session Handle test ENDIF Thanks for your help ! Tag: Example of create index with ADOX Tag: 190715
  - 23
    - Running Fox Exe's from a local network, VFP5.0 vs VFP6 - 8 I have several small office applications written in Foxpro. Years ago I bought some of them up from Foxpro 2.6 & FPW 3.x into the what was then the newest 'Foxpro', 5.x, and then wrote a few more apps. When later on 6.0 had been out for a while I tried to move up to that version. To that point all I had to do when distributing an application was to put the exe, two Dlls, DBFs and a few other files in a directory on the local network protected by the appropriate NT security. Then put an shortcut on the users desktop pointing that exe. With lots of changes in our office responsibilties this is easy to connect new workstations to these apps. With 6.0 that all changed to have to setup the apps on each computer even though the exe and dbfs could be shared on the network. This is what I had to do with VB apps (which is one among other reasons I didn't use VB alot). I tried to putting all the files the 6.0 setup wizard was putting on each computer on the network in the exe's directory but it didn't work. I guess this is because of the files not being registered properly in the setup. I was hoping that Foxpro would just look for these files in that directory first without checking the registry The upshot of all this is that all the apps are still on 5.x . I suppose that I could set up one VFP 6.0 app on each workstation and then as long as the rest of the apps used the same componets they would not require an individual setup. Before I go that route I'm wondering if there is a way to run 6.0 ( or actually I have 7.0 now) the way that I ran the 5.x apps on the network ?? Tag: Example of create index with ADOX Tag: 190712
  - 24
    - ADIR() Question I have a directory with the file extensions of .LOG and .LOG_LIX. When I do a numberof = adir(testing,'*.log'). I get all the files, but what I want is just the files with the LOG extension and not the ones with LOG_LIX. Is there something that I am missing with the ADIR() command? Any help is grateful, Dale Tag: Example of create index with ADOX Tag: 190709
  - 25
    - Multiple detail band Which of the third party report generator offering multiple detail band that works well with VFP8? sp Tag: Example of create index with ADOX Tag: 190701
- Next
  - 1
    - Intellisense manager Can somebody help me How can I switch off automaticly the Intellisense Manager My config.fpw file contains the following line _VFP.EditorOptions = " But -sorry- this does not work. Every time when I start to use VFP8 I have to switch off Intellisense manager by hand Many thanks Sandor Tag: Example of create index with ADOX Tag: 190691
  - 2
    - Uploading Large files using XMLHTTP Hi All, I am using XMLHTTP object in VFP to upload files using VFP and having the problem of string too long to fit when uploading files more than 16MB. The error occurs when I try to concatenate the FILETOSTR data with the header info. Temporarily I worked around it by using a memo field. But then it gives the same error in the XMLHTTPObject.Send method. Any body knows any workarounds? * This is a pseudo code only x = FILETOSTR(FileToUpload) BuildPostData(x) && Builds the Header information etc XMLHTTPObject.Send(x) If the above cannot be fixed any other fox pro code that may work? I recall Rick had a wwHTTP class, will it support files more than 16 MB? Tag: Example of create index with ADOX Tag: 190689
  - 3
    - sharing of data HI i m using dos base foxpro i wnt to know wherether i can share data among few computers if can ah how to do it Tag: Example of create index with ADOX Tag: 190682
  - 4
    - VFP email client Hi, I asked recently about accessing port 110 using VFP to be able to parse email in a POP3 account before it was downloaded to a client. I got some great help on the Winsock control which did the job well. Couple of questions: Any ideas how to cleanly disconnect? The POP3 server keeps the connection open for a period of time if I use the Winsock Close() method, and VFP hangs for a similar period of time if I issue a POP3 "QUIT" command. This is just annoying, not important. Now I can access POP3, and can send email in various ways (using BLAT for this, but CDO and wwipstuff are other SMTP based options), I wanted to see if I could write a basic email client using VFP. All works well so far unless I want to reply to an HTML email. In OE or Outlook, you click "Reply" and you can type your reply into what looks like an edit box, but with the original HTML nicely rendered below. Can this be done in VFP? I can display the original HTML using the Web Browser control, but I'm a bit stuck on creating an interactively editable browser object. I'm only doing this as an experiment. It's non-production, but would welcome any help. Neil Tag: Example of create index with ADOX Tag: 190672
  - 5
    - What is the SYS(1104)? What is the SYS(1104)? I found no docs about it! (VFP 6.0sp5) I test also the SYS(1101), SYS(1102), SYS(1103). They also return numeric values, but no docs about these... Have a nice day (or night), Nick Pofiris, ErmisPliroforiki Athens-Greece www.ermis-pliroforiki.com.gr Tag: Example of create index with ADOX Tag: 190663
  - 6
    - Subreport w/ External Foxpro DBF I'm having a problem with a report. I have a problem getting my subreport linked to my main report. I have a primary file used for the main report, and a second (stand alone) file for the subreport. The subreport is not showing any information from the second file. I'm at a loss, and could use some advise. I have included some details below. I have a file that includes multiple fields that are used in the main report: customer name, customer number, job number, company number, and equipment id. I have a second file which is a list of equipment used on a given job: (subreport) job number, company number, equipment id, serial number, model # These files are not joined in the report, I wish to use subreport links to join the two together. The second file will list the detail info for a given piece of equipment and for a given job. I setup the links as follows: ?Pm-Customer_history.ncompany = cs_equip.nCompany ?Pm-Customer_history.nsite_equipid = cs_equip.nsite_equipID ?Pm-Customer_history.njobnumber = cs_equip.njobnumer The selection formula (record) on the subreport was left as it was created by the SubReport Links window. -------------------------------- Thx in advance, Dan Tallent Tag: Example of create index with ADOX Tag: 190658
  - 7
    - Unique Identifier for .MNX file I need to grant access to a particular menu option depending on which user has logged in. I am planning to create a DBF file which will contain the menu options that accessible by each userid. Then at the time of running the MPR file, I can modify the SKIP FOR clause if the userid has access to that menu or not To accomplish this task, I need to know if there is a unique identifier in the MNX file that is created by Menu Builder. I want to tie in the userid with the key for MNX file for the purpose of lookup. I browsed the MNX file but I am a little confused about the records in that file. For some reason it has two records for every menu option that I created. Can someone throw some more light on the structure and contents of MNX file and suggest how best I can do what I want to do Thanks a lot.... Subhash. Tag: Example of create index with ADOX Tag: 190655
  - 8
    - Excell Automation Hi ther I am trying to use the insert command from foxpro but keep getting an error, the vb syntax is Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelo it's the shift things such as xldown or before on other commands that i am struggling with foxpro intelisence gives you insert([shit as variant] ....etc I'm not sure how to use this thank Ke Tag: Example of create index with ADOX Tag: 190654
  - 9
    - pls help me.... i need to finish my database project using the visual fox pro but our professor told us to use the version 6.0. my problem is our professor didnt told us on how to link two forms. we dont know the syntax... please help us to finish our project Tag: Example of create index with ADOX Tag: 190648
  - 10
    - Insert and update function! Hi All I have just created two database files with master and detail relationship. For now I'm getting trouble with writing "insert and save" function. Firstly I used VFP6.0 built in master detail relationship to create a form. It works fine. My first question: Can I get into their built in "Insert" and "Update" function for my little modification purpose Or if not, I wrote "Insert" and "save" by myself. As I clicked them the first time, it works fine. But after click "save" and it jumped back to "insert" mode, the old data were displayed on the screen, instead of creating a new record, or even my code was included "append blank" Now I found that the problems were from "the cursor were still pointed at the last record after I hit "save and insert". What exactly should be the problem of my coding Please help Sam. Tag: Example of create index with ADOX Tag: 190646
  - 11
    - How to display integer value when there is no decimal part? I am using vfp8 and winxp. I have a grid column with recordsource a numeric field with width 5 and decimal 2 in a table. The value is calculated, never entered manually. When the value is 12.25 I want 12.25 displayed, but when the value is 12.00 I want 12 displayed. That is, I want only the integer value to show when there are no decimals. What is the easy way to do this? Regards, Jan Nordgreen Tag: Example of create index with ADOX Tag: 190645
  - 12
    - The use of "Activate PopUp .... NoWait" How can I use the option NoWait in a popup menu? While typing in an edit box and after each typed letter a popup appears and remains there. I have to use NoWait option in order to be able to continue typing. The same popup is activated if I right click on the textbox. If I click an item on the popup that is activated with the NoWait option, Bar() returns nothing. Demetrios, Greece Tag: Example of create index with ADOX Tag: 190644
  - 13
    - the winsock control I tried this and failed with "class mywinsock not found" at the createobject() line. Can we subclass an ActiveX control? oWinsock=createobject("mywinsock") ... define window mywinsock as MSWinsock.Winsock.1 procedure DataArrival lparameter m.length ? m.length endproc endefine -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 8:26pm up 1 day 10:53 load average: 1.00 1.00 1.00 Tag: Example of create index with ADOX Tag: 190641
  - 14
    - erro 1113 Dear Group, I have a free table that can not be openned from my pc (error : 1113 --> file is not opened), it can be opened in other pc we using win98 so no security is concerned the only diffirent between mine and theirs is that my pc got sp5, they don't (we are using vfp6) Any way, i have tried the following: go to diff pc use the dbf copy stru exte to test.dbf copy that test.dbf to my pc use test sele test copy to array myarray create table mytable from array myarray I got error 9: data type mismatch So how can i fix this problem? The table has quite a lot of fields (240) so i don't really want to manually create it by hand (i wasn't the one who created it) TIA Peter Tag: Example of create index with ADOX Tag: 190634
  - 15
    - MessageBox function Hi to all Can I position the MessageBox function instead of it appearing at the center of the screen ALC Tag: Example of create index with ADOX Tag: 190630
  - 16
    - toolbar and form Other than creating a formset, is there a way to associate a toolbar with a form visually? If there is no visual way, must I do it programmatically? I am using VFP 6. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 10:32am up 1 day 59 min load average: 1.05 0.99 0.99 Tag: Example of create index with ADOX Tag: 190623
  - 17
    - vfp8 does the RUN and/or ! work in VFP8 Tag: Example of create index with ADOX Tag: 190622
  - 18
    - New offline FoxPro Wiki is available For those of you that need access to the content of the FoxPro Wiki when you don't have internet connection there is a new updated snapshot of the Wiki available for download. Check out this topic for more information: http://fox.wikis.com/wc.dll?Wiki~WikiOfflineMirrorSites And if you don't happen to know what a cool resource the Wiki is check it out here: http://fox.wikis.com/ -- df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro Tag: Example of create index with ADOX Tag: 190621
  - 19
    - How to get a value back from a sql server udf... I can get the return value of a SQL stored procedure back like so (in T-SQL) declare @rc int exec @rc = dupint 10 print @rc -- 20 define proc dupint @i int as return @i + @i How can I do this using SQL pass through: ?sqlexec(1, "exec ?i = dupint 20") Also, how do I get the return value from SQL user defined function: ?sqlexec(1, "exec ?i = dbo.dupint(20)") Any help is appreciated. Jacobus Terhorst Tag: Example of create index with ADOX Tag: 190618
  - 20
    - number to RGB ? Hi, I know that we can convert an RGB value to a number, but is this possible to do the inverse... ex: ? RGB(255,255,255) = 16777215 but i want to have the 3 RGB number of 16777215 Thanks Tag: Example of create index with ADOX Tag: 190615
  - 21
    - treeview in a dbc R.I. Hello, I try to use a treeview (for its non-visual properties) in a R.I. stored procedure of a dbc. Is it possible ? How can I create an instance of this object in a RI ? Michel (in France) Tag: Example of create index with ADOX Tag: 190599
  - 22
    - report with a jpg or gif file How can I personalize a clients reports to include there logo on it? Is it necessary that I build the application with there logo included in the other files or can I just use a generic file called logo.jpg and logo.gif then simply have them copy there logo to the installation folder and rename it logo.jpg or logo.gif? R Gallo OGES Tag: Example of create index with ADOX Tag: 190592
  - 23
    - Sending files to a web site folder If my clients have DSL lines. Is there a way to send files directly to a web folder using Visual Foxpro6 and creating a form to do so. At the same time can they also download files from a web site through a form. R Gallo Tag: Example of create index with ADOX Tag: 190590
  - 24
    - Internal consistency error - during appending When i used "append from", displayed "Internal consistency error". Two tables are same but i can't "append", why Somebody help me ? Tag: Example of create index with ADOX Tag: 190586
  - 25
    - run a vfp program when the computer starts (or login) Hi guys, Is there a way to ensure that a VFP program is executed when the computer starts or when a user logs into the system. NOTE : I do not want to use Scheduled tasks. I want to be able to achieve this using install shield or by some other means (where the user doesn't have to do anything, esp not to set up a scheduled task) -- Best Regards, TJ Tag: Example of create index with ADOX Tag: 190582

Hi,
I need an example of How to create an index of a fox table with ADOX,
using VFP8 OLEDB Provider.
Thank you,

Gonzalo Ferreyra
Córdoba, Argentina

Top

Re: Example of create index with ADOX by Cindy

Cindy
Sat Mar 06 21:16:36 CST 2004

In news: uiPTMLrAEHA.3712@tk2msftngp13.phx.gbl,
Gonzalo Ferreyra <gferreyra@capatazsoft.com.ar> wrote:
> I need an example of How to create an index of a fox table with
> ADOX, using VFP8 OLEDB Provider.

Hi Gonzalo,

The following KB article should get you started:

"FIX: Index Created Using ADOX and the Visual FoxPro OLE DB Provider
Contains the TRANSFORM Function"
http://support.microsoft.com/?id=314653

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Top

Re: Example of create index with ADOX by Anders

Anders
Sat Mar 06 09:58:06 CST 2004

ALTER TABLE x ADD FOREIGN KEY y TAG z REFERENCES Table2 [TAG tagname]
This works only if you have the VFP table in a database and a Primary Key
somewhere youi can use as reference. A regular index will be created but the
PK reference will not have any further consequences.
Primary Key and Unique (Candidate) indexes can also be created with ALTER
TABLE. If there's no table with a PK you can use as reference for the FK,
you can create one for this purpose, then drop it if you like..
Yiou'll need Exclusive access to the database and table,
-Anders

"Gonzalo Ferreyra" <gferreyra@capatazsoft.com.ar> wrote in message
news:uiPTMLrAEHA.3712@tk2msftngp13.phx.gbl...
> Hi,
> I need an example of How to create an index of a fox table with
ADOX,
> using VFP8 OLEDB Provider.
> Thank you,
>
> Gonzalo Ferreyra
> Córdoba, Argentina
>
>

Top