Search results for query: *

HI, In my opinion ---------------------------------------------- thisform.grdDetails.RecordSource=&quot;xorder&quot; thisform.grdDetails.RecordSourceType = 1 thisform.grdDetails.column1.ControlSource='xorder.<desired_field>' thisform.grdDetails.column2.ControlSource='xorder.<desired_field>'...

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

bon011 , would u plz be more specific. I mean for which area u are talking about ? write more clearly .... for a quick reply.

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

cremang, try this. <here the cursor is created> is must have some name. select cursor_name_here report form report_name_here preview

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(&quot;Record is...

Where u write SELECT pqr GO TOP

change your locate statement like this : ---------------------------------------------- mfield=allt(uppe(thisform.combo1.displayvalue)) mfield2=allt(uppe(thisform.combo2.displayvalue)) Do Case case mfield=&quot;CODE&quot; locate for <tablename>.CODE = mfield2 case...

hey try using DISPLAYVALUE of the combo box instead of VALUE.like : if .combo1.displayvalue=&quot;code&quot; 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.)...