Search results for query: *

In a filter condition, make sure the data type is same on either side. DTOS() function is ideal to use instead of DTOC() - if only date needs to be filtered. DTOS will return values in YYYYMMDD format. DTOC will return in SET date format order and so could return MMDDYYY etc depending on your...

It is likely that you are using an alias in the form control which is not the same as your tables opened. So check the data environment or your code where you open the data files and use the same alias in the control source of the form. (alias names used). that should fix the problem. :-)...

Hi You dont have to change the value as per the code you use. Instead, set the columns, Format property to Date format. This will make the date appear in date format. :-) ____________________________________________ ramani - (Subramanian.G) :-) http://winnersoft.coolfreepages.com/

Hi ExtraD, I assume, the 2nd form you run will be release before the 1st form is released. In this case, you want to create an object in 1st form and use it in second form. So in the Form1.Init.. PUBLIC oTable oTable = NEWOBJECT([CUSTOM]) SELECT myTable SCATTER NAME oTable BLANK This is to...

Brian, thanks for sharing your code under FAQ. Somehow, I did not see that earlier. My star to you. :-) ____________________________________________ ramani - (Subramanian.G) :-) http://winnersoft.coolfreepages.com/

I generally provide a button to my report forms to export the results to excel format. The reports are pulled into a cursor and stays as default alias. Or open a table and leave it as default alias. Call the following code saved as a prg Example * lcExcelFile = name of Excel file to create *...

How can anyone proved who actually clicked the button? It might have been the office cleaner, for all anyone knows. - Mike Lewis SO what if you call the cleaner and ask him to click and continue with installation with every software you install. My God ! I am just making a lighter point and...

Hi It is probably, you are using different versions of FoxPro applications run by different people. For example FoxPro 2.6 or such older version application and also, VFP applications. OR some user is running FoxPro 2.6 or such older version using the same terminal server. In these cases, VFP...

Hi The very definition of Primary Key is that it has to be unique. So you cannot duplicate the value in a primary key. Make the field as regularindex type. :-) ____________________________________________ ramani - (Subramanian.G) :-) http://winnersoft.coolfreepages.com/

Hi You can use a view as your child table with the view itself being a filtered one for the filter value equal to the master table field value. The view can be indexed on your date field. This can solve the problem. You can update based on view. :-)...

So something is turning it on. Just give a try by putting the code in its INIT event.. This.lNoNetworkButton = .t. This.lNoChangeDir = .t. Or try putting it with proper reference in the init of the form. :-) ____________________________________________ ramani - (Subramanian.G) :-)...

1) If you have developed on VFP9, then best way is to compile an executable and use the free distribution to run the application using VFP9 instead of running it using VFP7. Your programmer must be able to do this easily. 2) The reason for suggestion 1 is that there are many possible reasons...

Hi Auguy, I keep the themes on, and dont bother to change it based on OS, simply because, that they dont create any problem. So it is your preference. However, I have my base classes subclassed and customized. So that is the only place I have to touch, in case, it creates a problem some day in...

Hi Sorry to doubt the fundamentals.. When you say field, every one here assumed it is a field in your table or database. By any chance do you mean that the variable which holds a data field (a field of a table). If it is variable, you can try.. myDateVariable = CTOD("") or myDateVariable =...

Mike Yearwood, My star to you.. though I am not still sure if this is one of the reasons for minor hitches in a larger site I have. I get into issues at times, with duplicated primary keys, often the key value ending with a zero value and in duplicates which has given me concern for a long long...

One way is to initialize the values to DATE() value. You can use ThisForm.Controls and loop thru them .. find the date type text boxes and set the initial value to DATE() value. This code can be in the init of the form. Surely there are more ways to do the same thing. :-)...

Hi, Look into this FAQ.. thogh not a straight answer, it can help you force users out, in case you need to do so. A way to force Users out of your VFP application. faq184-3152 :-) ____________________________________________ ramani - (Subramanian.G) :-) http://winnersoft.coolfreepages.com/

Hi I would have provided a straight answer to you to solve this. But I am not doing so to get you familiarized with the site. 1. Click on the Search button appearing next to Forum buttom above. 2. Enter 'DOS WINDOW' in the Key Words box and you will know to proceed with that search. 3. Dont...

A config.fp file may be sitting somewhere disturbing the whole thing. Or a foxuser resource file could be there. You can make a wild search on the computer for config.fp and foxuser.dbf. Or you can create a config.fp in the same directory as the application and try and see what happens. A temp...

Hi Set the forms KEYPREVIEW = .t. That should solve your problem.. While I dont comment too much as to everything in it.. lot of codeing has been done. You can simplify.. LPARAMETERS nKeyCode, nShiftAltCtrl LOCAL lcWord IF (THISFORM.PgfRelated.ActivePage = 3) m.loActiveControl =...