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

  1. ramani

    Filter date and time

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

    Error Loading a Form

    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. :-)...
  3. ramani

    How do I get a grid cell to display a modified value?

    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/
  4. ramani

    how to use the addproperty function correct

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

    How can I use ODBC to populate an xls file with data?

    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/
  6. ramani

    How can I use ODBC to populate an xls file with data?

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

    Help for VFP running on Linux

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

    Resource file is not valid

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

    Violation of Primary Key Constraint

    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/
  10. ramani

    Grid Order Problem

    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. :-)...
  11. ramani

    Common Dialog issues...

    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) :-)...
  12. ramani

    fatal error

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

    Windows XP Themes in Commercial Apps

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

    SET DATE TO BLANK

    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 =...
  15. ramani

    VFP and Open Sessions on Win2003 Server

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

    invalid date

    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. :-)...
  17. ramani

    Update tables on network

    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/
  18. ramani

    Hide MS-DOS WINDOW

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

    Invalid path or filename before EXE executes

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

    Pageframe Controls reference

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

Part and Inventory Search

Back
Top