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 Chriss Miller 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: *

  1. Mike Lewis

    Set a TAG for a field programmaticaly

    One further point ... You say you have the INDEX IN ... in "some parts of the program". Do you know that you only need to create a given index tag once (for a given table). Once it has been created, it stays in existence until explicitly deleted, even after you close the table or terminate the...
  2. Mike Lewis

    Set a TAG for a field programmaticaly

    You mentioned that this is a free table. Although you can use ALTER TABLE to create an index and assign it a tag, you can only do that if the table is part of a database. From the VFP Help: For free tables, you would do this: INDEX ON <some expression> TAG <tag name> Mike
  3. Mike Lewis

    Simple VFP App to reimplement in Android... anyone got any advice...

    Good luck with this idea, Griff. I've occasionally considered doing something similar myself - more as an intellectual exercise than to meet a need. I would guess that the first step might be to get to know Java. Let us know how you get on. Mike
  4. Mike Lewis

    VFP Issue with date selection 1/1/25 returns 1/1/1925

    Just to be clear, the correct syntax is: SET CENTURY TO c ROLLOVER y where c is the century and y is the rollover year. This only applies for dates that are entered with a two-digit year. The command takes precedence over SET CENTURY ON/OFF. Mike
  5. Mike Lewis

    Using 1 table in 2 different forms

    This is a separate issue - not related to the error you are seeing or your DataSession settings. The problem occurs when you set the grid's RecordSource, but then later close the underlying table (the one that the RecordSource point to), and then re-open the table. I don't know the exact...
  6. Mike Lewis

    Need to build web service, pronto :)

    You are not wrong, Griff. In my experience, it is almost always easier to rewrite the app from scratch using a dedicated server-based language such as PHP. Herbstgy, you say you are using FoxISAPI. This is very old technology. I'm not sure to what extent it is still supported. In any case, it...
  7. Mike Lewis

    settings in config.fpw

    That's not my experience. I have the four system windows (Command, Document View, Properties and Data Session) all set to Dockable and Docked. Those settings are always retained between sessions. The only exception is if I need to start VFP with a different resource file, but in general there is...
  8. Mike Lewis

    VFP9 to run external command as admin and capture exit code, WScript, ShellExecute

    The only reply that ShellExecute() returns to the calling program is a code that indicates an error in ShellExecute() itself, such as passing it an invalid filename or an invalid action parameter. If there is no error, it returns the handle of the main window of the called application. What...
  9. Mike Lewis

    A way to make all ReadOnly

    From the VFP Help: ReadOnly Property For combo box controls, the ReadOnly property cannot be set to true (.T.) when the Style property is set to 2 – Drop-down List. As EinTerraner says, you can always drop down the list portion of the control, but you cannot necesserily edit the contents. Mike
  10. Mike Lewis

    A way to make all ReadOnly

    Hmmm. I don't think a button can be read-only. Or, more exactly, it doesn't have a ReadOnly property. After all, buttons can't be edited in the same way as a checkbox or textbox. Perhaps you are referring to making the button enabled / disabled? Mike
  11. Mike Lewis

    VFP Report : Dynamics

    You say "columns are not updated for the configured conditions". But you neglect to tell us what those configured conditions are. That makes it a little tricky for us to suggest a solution. Mike
  12. Mike Lewis

    Combobox populated with data from a table

    Try setting the combo's ListIndex to 0. I think that will do what you want. Having said that, I would take a different approach. I would add a checkbox to the form, to let the user choose between filtering on a name or leaving the filter blank. The caption of the checkbox could be something...
  13. Mike Lewis

    Some issues with scroll bars in a form

    Can you open the form in the Form Designer? If so, right-click on each of the following properties in turn, and choose "Rest to Default" : Top, Left, Height and Width. Mike
  14. Mike Lewis

    VFP to doesn't launch Ms Word's mailmerge

    Thanks for that, Tamar. Mike
  15. Mike Lewis

    VFP to doesn't launch Ms Word's mailmerge

    How about bypassing the VFP Mailmerge class and the ODBC driver? In other words, see what happens when you do this: loWord = CREATEOBJECT("word.applicaiton") This will not give you the solution, but it will tell you whether it is Word (or more precisely the Word Automation server) which is at...
  16. Mike Lewis

    Automatic date completion

    Not a direct answer to your question, but you might enjoying reading this article from Tamar: Easier Date Entry Mike
  17. Mike Lewis

    Update data in a Cursor

    You're quite right, Doug. When you SELECT ... INTO CURSOR <cursor name>, the existing cursor is destroyed before the new one is created. When that happens, the grid's "knowledge" of its columns is also destroyed, which means the grid can't display the new data. The solution is to set the...
  18. Mike Lewis

    Update data in a Cursor

    Well, you can set a filter on the cursor in the normal way: SET FILTER TO <your filter condition here> IN curReservas and then refresh the grid. But it might be more efficient to regenerate the cursor. In other words, do the SELECT again, with the relevant data in the WHERE clause. And then...
  19. Mike Lewis

    Determine owner of private data sessions

    ...value. Something like this: lnID = 2 && this is the ID you are looking for FOR EACH loForm IN _screen.Forms IF loForm.DataSessionID = lnID * this is the one you want ENDIF ENDFOR Keep in mind that forms are not the only object that have a DataSessionID. Session objects and...
  20. Mike Lewis

    long vs short filenames

    Welcome to the forum. We deal with all versions of FoxPro here, so you are in the right place. The reason that you are seeing the short filename is that FoxPro 2.6 was written to run under MS-DOS and Windows 3.x Those versions did not support long filenames, so FoxPro 2.6 is unable to show...

Part and Inventory Search

Back
Top