WARIK,
I dont think so, that there is a way for achieving this from VFP. However, u need to create a DLL, from VC++. and u must go through this Article Provided by Microsoft.
SUMMARY
This article describes some windows attributes related to a Report Preview Window. The tasks described in this...
Kerbouchard !
U can add two buttons at the side of the Grid. 1 for UP and 1 for DOWN. and for example i m using the following code for the UP.
SELECT detail
SET filter TO detail.sno=thisform.txtno.value
IF NOT BOF() THEN
SKIP -1
thisform.txtDescr.value = detail.descr
thisform.txtQty.Value...
robsuttonjr, here is a suggestion, but i dont know if this will work with the SQL Server. Try using LOCK(). I m using following code to lock and prevent multi user to edit a record at the same time.
SELECT table alias
mrecno = RECNO()
IF LOCK(mrecno) = .F. then
MESSAGEBOX("Record is...
change your locate statement like this :
----------------------------------------------
mfield=allt(uppe(thisform.combo1.displayvalue))
mfield2=allt(uppe(thisform.combo2.displayvalue))
Do Case
case mfield="CODE"
locate for <tablename>.CODE = mfield2
case...
hey try using DISPLAYVALUE of the combo box instead of VALUE.like :
if .combo1.displayvalue="code"
sele code from pqr into cursor xxx order by code
endif
same for name,address,phone values.
Then I have added a command button in which I have written :
SELECT pqr
GO TOP
LOCATE FOR...
Handoko, I m working on a similar project. I m not allowing the user to enter the data directly In Grid. I use the TextBoxes and when the user press ENTER on the last textbox, the validated data inserted into the grid. NOw if the User press REVERT, i use:
SELECT purchases
TABLEREVERT(.t.)...
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.