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!

  • Congratulations Mike Lewis 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: *

  • Users: button71
  • Order by date
  1. button71

    Help with a small SQL problem

    I have SELECT * FROM PTEMP ; INTO TABLE pictures ; ORDER BY Fname I wish to exclude all files except jpg , bmp , tif, gif etc Can anyone help? Thanks William
  2. button71

    Help with array to find files

    My apologies the code is LOCAL ARRAY aryTemp(1,5) LOCAL nCount, nMax, nLen, cFile SET DEFAULT TO (cDirectory) readpwini(inifile,'write','Paths','SearchPath',curdir() ) =ADIR(aryTemp, "*.*","AHRSD",1) logging('GetSomeFiles folder '+cDirectory) nMax = ALEN(aryTemp,1) FOR nCount = 1 TO nMax...
  3. button71

    Help with array to find files

    I have found the following code But I want the full number of columns in the original to be added to the final array - rather than just the fname =ADIR(aryTemp,"*.*","AHRSD",1) logging('GetSomeFiles folder '+cDirectory) nMax = ALEN(aryTemp,1) FOR nCount = 1 TO nMax cFile =...
  4. button71

    VFP 6 Form created by Form Wizard

    Dan, Thanks for that. I've put a [Search] button on the form ( in addition to the [Find] ) and written code and it's now working to my satisfaction. I can search 3 terms - either AND or OR ing them William
  5. button71

    VFP 6 Form created by Form Wizard

    On a form created by form wizard - using the [Find] button - I cannot see any Memo fields to choose to search in from the drop down list box. Is this as designed - is there a way to add them to the list and search in them? Or do I do a LOCATE in the memo field from another [Search] button...
  6. button71

    VFP 6 trouble with paths

    Thanks everyone. Mike had the one I wanted ( to see what paths had been set when in the debugger - SET("PATH") William
  7. button71

    VFP 6 trouble with paths

    <sigh> I've just forgotten how to see the path as set at the moment , in the debugger. I'm not finding a table when I open a form. Anyone help? William
  8. button71

    Finding root of a folder

    Dan, Many thanks - simplicity itself! I just needed to set defa to the original path first - then bingo. Great! William
  9. button71

    Finding root of a folder

    Sorry about the 'sleep' delay in answering we're 9.5 hrs in front of GMT down here <G> To clarify I should have used a longer path - I need the folder above the one used before. The start path will be of unknown length so the number of iterations is variable. In my own clumsy way I coded...
  10. button71

    Finding root of a folder

    Is there a function around to find the root of a folder? I am using a folder Aviation It has a path - say C:\My Pictures\Aviation I want to get to C:\My Pictures\ Anybody help? Willaim
  11. button71

    Topr right control box on form

    Wow, I thought I was asking a 'simple' question. Thanks to everyone - it seems that Mike's solution is working for me. William
  12. button71

    Topr right control box on form

    Folks, Further to the above Sometimes my app closes Ok, on others it locks up at this DO WHILE loop and the form does not close. PROCEDURE PropShutdown() * --- Release/Close All Open Forms --- *!*Any other clean up code you may want goes here DO WHILE _SCREEN.FORMCOUNT > 0...
  13. button71

    Logo on form

    Mike, In looking at the Other Tab in the Project I see the two logo and icon files I have used in the project already there. I recompiled the form.prg and Built an exe. I deleted the image files from the runtime project folder. When the app runs the icon shows on the Title Bar but the logo...
  14. button71

    Topr right control box on form

    Mike, I still got the error - so I put a Set Step On before the CLEAR EVENTS in destroy. When I click the X on the Main Form it justs goes directly to the error. So the Destroy method isn't being used possibly? Regards William
  15. button71

    Logo on form

    I have a manually coded form on which I wish to place an icon. I have used ADD OBJECT img as image WITH ; Top = 40, ; Left = 70, ; Height = 60, ; Width = 60, ; Picture = full development path to logo file,; Name = "img" It works OK in the dev environment but on other machines in which I...
  16. button71

    Mousing a cropping selection box over an image

    I am using .container1.imgcontrol1.Picture = (mypicture) ( mypicture being the fullpathname of a say jpg file). to put a picture in a container on my form. I would like to know if it is possible to have a control which sets the mouse to draw a selection area on the image - collect the...
  17. button71

    Topr right control box on form

    Mike, I have put the - and x buttons back at top right. I used a [Close] button on my working form that is always visible over the top of a black 'Main' form to run this code DO cleaner Clear EVENTS Quit I have put the above code on the Unload Method on the Main Form. Minimise...
  18. button71

    Desktop in seldirdlg() gives error

    I used IF oBrowseObject.Self.Name="Desktop" WshShell = CreateObject("WScript.Shell") cPathToReturn = WshShell.SpecialFolders(4) RETURN cPathToReturn ENDIF to open on the users desktop. Thanks William
  19. button71

    Desktop in seldirdlg() gives error

    Many thanks Brian
  20. button71

    Desktop in seldirdlg() gives error

    I have been using this function for years and never had a user select 'desktop' This gives the error Member PARENTFOLDER does not evaluate to an object Line : FOR EACH item IN oBrowseObject.ParentFolder.Items FUNCTION SelDirDlg LPARAMETERS cDialogTitle, cStartingFolder, nBrowseFlags *...

Part and Inventory Search

Back
Top