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)))
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
*****************...
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...
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...
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...
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
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...
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
*******************
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.