Recent content by Mike Lewis

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...

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

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

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

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...

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...

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...

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...

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

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

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

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...

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

Thanks for that, Tamar. Mike

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...