Search results for query: *

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

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

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

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

You can loop through all the open forms, testing each one's DataSessionID against the required 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...

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