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 SkipVought 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: advancepack
  • Order by date
  1. advancepack

    Counting strings in memo fields

    Hi virtualranger , Try this ONE LINE CODE ? occu(var2,subs(MyTable.Memo1,at(var1,MyTable.Memo1))) Example.. sele details as Memo1 from \fpd26\foxhelp into cursor Mytable where recn()=16 var1='Most of the configuration' var2='Configuring' ? occu(var2,subs(MyTable.Memo1,at(var1,MyTable.Memo1)))
  2. advancepack

    Show Get vs Show Gets with Memo Field @Edit

    Hi Brak, Can you post a sample code ?
  3. advancepack

    how to protect my system exe from REFOX

    Hi, Is buying/upgrading decompiler/brander adding overheads for developer ?
  4. advancepack

    Fox purchase...

    Try this link http://www.emsps.com/oldtools/msfoxv.htm
  5. advancepack

    hide ms-dos command window in RUN command

    try this RUN /n7 pkzip I did not find any logic for totaly working in backgroud as works on VFP applications, bcoz it requires API functions.
  6. advancepack

    How do I set the FPD path in WindowsXP?

    Hi amartureo, Try this ************************ DbfPath=getdir() use DbfPath+"Dbf1" use DbfPath+"Dbf2" ************************
  7. advancepack

    Refresh in browse when using a filter

    Hi kunti Subject to the thread is SHOULD REFRESH BROWSE , are you sure above code refreshes browse with go mrec ?
  8. advancepack

    SET EXCLUSIVE OFF

    Check for when you append records with USE mydbf and when you edit records with USE mydbf [NOUPDATE] clause added ? You will have to check your code. Why don't you try simple code if it is working then your code should work. ***************** set excl off use customer browse *****************...
  9. advancepack

    Refresh in browse when using a filter

    HI ShortyII, I worked on your question many ways, after all GO TOP I found the best even before filtering. Anyway, good luck.
  10. advancepack

    Refresh in browse when using a filter

    Hi ShortyII, Go Top refreshes the browse but you loss the record where you on. ON my above example of customer.dbf you browse with no filteration, you are on 1st record which starts from "A" if you type F2 for filteration and filter by company="J" and browse gets filtered...
  11. advancepack

    Refresh in browse when using a filter

    Hi ShortyII, Try this, on key labe f2 do DF2 on key labe f3 do DF3 USE \fpw26\customer browse on key labe f2 on key labe f3 RETURN function Df2 set filt to company="J" go top RETURN function Df3 set filt to go top RETURN my idea is, only GO TOP command works insted of set refresh...
  12. advancepack

    Utility for Type, List & Select / Incremental Search

    set talk OFF define window customer from 0,0 to 20,80 in window screen font 'arial',10 title 'Customer Database' move window customer center activate window customer @ .1,1 say 'Type some Characters to Find, Press <DOWNARRAY> & <ENTER> to select' style "B" color R+/w* Use Customer...
  13. advancepack

    SET EXCLUSIVE OFF command

    Hi WESLEY55 I have already posted some CODE which you try on LAN ******************* clos data set excl OFF use customer browse ******************* Another way, if you ready to share your code , you can send to adv_pack@hotmail.com
  14. advancepack

    I am looking to run some simple cod

    FASTER APPLICATION ALWAYS WIN !! Whenever you want to calculate GRAND TOTAL above post is good. But speed is depend on your number of records in dbf. If you have large dbf then you should create CASH dbf to maintain READY TOTAL vchage, pay, adj. When you require you can retrive from CASH dbf...
  15. advancepack

    SET EXCLUSIVE OFF command

    Again one thing, find FLOCK() statement in your code bcoz, FLOCK() stop sharing. try this test on LAN ******************* clos data set excl OFF use customer browse *******************
  16. advancepack

    Can't share .dbf's with SQL-Select

    Try this add following lines in your config.fp/config.fpw TMPFILES=c:\WINDOWS\TEMP EDITWORK=c:\WINDOWS\TEMP SORTWORK=c:\WINDOWS\TEMP PROGWORK=c:\WINDOWS\TEMP restart foxpro, then try sele * from customer into cursor mytmp NOTE : use DBF in excl ON/OFF does not matter select SQL handle...
  17. advancepack

    Incremental Search Fox Version 2.0

    Hi KB Still you are looking for incremental search for v2.0. I don't have V2.0 but I think above code should work with V2.0 if not let me know ? will try some other way.
  18. advancepack

    print usb to foxpro.26 for dos

    You will have to use third party software like http://www.lerup.com/printfile/
  19. advancepack

    Incremental Search Fox Version 2.0

    Try this use customer define window customer from 0,0 to 20,80 in window screen font 'arial',8 title 'Customer Database F2=Serach' move window customer center ON key labe F2 do CustFind browse window customer noedit ON key labe F2 release window customer RETURN function CustFind...
  20. advancepack

    Incremental Search Fox Version 2.0

    I don't have Version 2. but did you try Ctrl+F & Ctrl+G.

Part and Inventory Search

Back
Top