Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mcoupal
  • Order by date
  1. mcoupal

    Merant ODBC

    ...and get data from tables with/without hyphens, but I would like to be able to modify data within hyphenated tables. Any general or specific suggestions appreciated! p.s.- My driver is: Merant 3.60 32-bit Progress SQL92 v9.1D and I'm trying to hit a database that I *think* is in Progress 92b...
  2. mcoupal

    Using Numeric Indexes

    Thanks everyone who replied. The last 3 responses are exactly what I need. I couldn't just use a cursor because I need the user to modify this data and wanted to keep the records in order and not read-only. I've gotten burnt in the past by trying to auto-sort tables rather than simply using...
  3. mcoupal

    Using Numeric Indexes

    Hi Mike, I didn't make it clear, but I'd like to sort by the first column, then second, then third. Summing them wouldn't necessarily sort them due to their variance. .25, 100, 300 .50, 11, 80 If going by their sum, the .50 record would be sorted above .25 .. which isn't what I'd want...
  4. mcoupal

    Using Numeric Indexes

    I tried searching with no luck. I would like to sort a table based on 3 numeric fields with values like: Col1 | Col2 | Col3 ------------------- .75 | 103 | 299.5 To create an index on these three fields so that they are sorted ascending, do I have to convert them all to strings and...
  5. mcoupal

    Unattended Printing Stalling

    I suspect the computer's asleep in some way. Yeah, that would sound more plausible if it happened every day but that's my theory. I would recommend doing a few queries about 30 seconds before running the reports to help wake it up. Also, look into the MOUSE command to click on a safe part of the...
  6. mcoupal

    Updateable cursor from SQL Passthrough

    ...cSQL, lcCursor) IF !USED(lcCursor) MESSAGEBOX('Error! Select statement could not be executed!') RETU ENDIF * - Build a list of fields lcFields='' FOR lnCnt = 1 to fcoun() lcFields = lcFields + IIF(lnCnt=1, '', ",") + FIELD(lnCnt) ENDFOR...
  7. mcoupal

    Navigating Forms Via a Menu

    (VFP 8.0) I use menus (via the DO Main.MPR method called within my main.prg) in a program and would like a menu item listing all the open forms. Some forms can open more than once (multiple instances/copies). Is there a good way to accomplish this? I assume you could use the system menu...
  8. mcoupal

    opening & closing forms from the menu

    I did a search and looked for a FAQ with no luck. I would like to have a "Windows" menu item that shows all the currently-opened forms. Some of my forms can have multiple copies open. I use the following code to populate the list of open forms and to bring the selected form into...
  9. mcoupal

    VFP to AS400

    Using VFP 8 on Windows 2000, I have been unable to programmatically connect to an AS/400 without manually typing in a password. I am using IBM's Client Access Express. I'll be using SQLExec() commands over this connection. I have tried creating a connection in the DBC using both the Data Source...
  10. mcoupal

    macro substitution (> 255 characters) trouble

    I have a very large =sqlconnectstring command to run, but haven't figured out how to do this. I put the whole command into a textfile and tried doing =execscript(fileto('a.txt')) with no luck. I've also tried populating it with variables like: =execscript(lcText1+lcText2) -but it still...
  11. mcoupal

    SQL Pass Through

    ...characters) that must be broken up. I have it set to VFP7 compatibility, too using --> SYS(3099, 70) ---------------- cSQL = "SELECT Prpern.*, MNM25, MSSNO, MEECL, MA25A, MA25B, MCITY, MST, MZIP, MDTBR, MDTHR, MDTTE, MDTBG " +; "from prpern, prpmst " +; "where...
  12. mcoupal

    When you don't want time for SQL Server

    Additional note: I have tried both the datetime and smalldatetime datatypes on SQL Server with no luck.
  13. mcoupal

    When you don't want time for SQL Server

    In Fox 6, I am doing a SQL passthru command to get a table's structure from SQL Server 7, making the resulting cursor modifiable, and then setting several textboxes' ControlSource to the various fields. The date field in the cursor has the long date format that includes time. I would like the...
  14. mcoupal

    Remote Views: Cancel/Save button possible?

    Perhaps if someone could give a conceptual overview of how (using SQL passthru) to make textboxes first load a single record and a secondary button that would save any changes, that would be helpful. Thanks in advance
  15. mcoupal

    Remote Views: Cancel/Save button possible?

    Assumptions: VFP 6 hitting SQL SERVER 7 If you have a remote view in your DBC in a multi-user environment (multiple users modifying different records in same table) is it possible to have some textboxes bound to that view with save and cancel buttons? That is, the user can choose to edit a...
  16. mcoupal

    VFP6 and VB6 Loaded Simultaneously?

    I have VFP6 SP5 and would like to install VB6. When trying to install it, I get a warning that VFP may not run correctly after installing. I'm running Win2000 Professional. Has anyone had any experience with both on one system?
  17. mcoupal

    Report oddity in Header/Footer

    I'm using Service Pack 5. I read a recent thread in here which mentioned the use of functions stored in a .PRG file. That may work, but I assume it'll be difficult. It's like the record pointer is moving to the next record before the first detail line is shown and thus messes up the second...
  18. mcoupal

    Report oddity in Header/Footer

    In VFP6, I have a report that is grouped by a numeric field called Cnum. This Cnum field is showing in the header and footer of each page. It starts a new page for each Cnum grouping. In the group footing for Cnum I have to show some fields which stretches that footer to about 2 inches...
  19. mcoupal

    Deletion of files

    Or rather the code was: store 'car.dbf' to lcTest erase &lcTest
  20. mcoupal

    Deletion of files

    Have you tried the ERASE command? store 'car.dbf' to lcTest erase &lcmike Seems to work work for me (deletes just one file) [Note: in VFP 6]

Part and Inventory Search

Back
Top