Recent content by cdms

I have a grid that is pointing at a view. As soon as I set order on the view using an IDX index the vertical scroll bar on the grid goes funny. ie. when the top record is at the top of the grid the vertical scroll bar looks as though there are lots more records above. Weird Has anyone come...

thanks Mike thats great

How can I update a table in a data environment using tableupdate() without having to select a different workarea. eg. tableupdate(site) instead of select site tableupdate() Appreciate the help Chris

Stewart There is a very handy tool in VFP6 where you can copy all of your Options setting to the command window. I presume it is the same for VFP7. Make sure your command window is cleared of any commands. Open the Tools Options dialog screen. Hold down the shift key and click OK. All of your...

Ramani I don’t think I explained myself well enough in my first query (Sorry). There is not a code record on the person table. There is a unique identifier field that is called person_no. On the codes table the field person_no is the "MANY". On the code table there is a field called...

Hi guys Just got round to testing that code and i'm having a few problems. Below is what I am writing : SELECT * ; FROM PERSON P INNER JOIN CODE C1 INNER JOIN CODE C2 ; ON PERSON.PERSON_NO = C2.PERSON_NO ; ON PERSON.PERSON_NO = C1.PERSON_NO ; INTO CURSOR CODERESULTS ; WHERE...

Thanks guys I'll give it a try Chris

I am using SQL select in VFP6 and I have two tables with a “One to Many” relationship. Person.dbf & Codes.dbf I want to select all the people from the person table that have both code A1 and code A2 on the code table. The problem I have is that on the Code table these two codes would be on two...

I have been using the below code to move codes from one lstbox to a another. THIS.PARENT.LSTSELECTED.ADDITEM(THIS.LIST(THIS.LISTINDEX,1)) My problem is I now want to use 2 columns in my listboxes and be able to drag and drop both columns into another 2 column listbox. Any tips would be...

Dave Unfortunitly header files are not included in the office package BUT as it happens I do have a vfp program that helps with this problem. As I'm sure you are aware, every office product ships with a .olb file which stores all the specific commands in that program. The following code...

Hi Holm A public variable should do it. Simply declare your public variable. Set the variable to the various strings in your buttons and then set a text boxs expression property in the report to your variable. Hope this helps Chris

See what you think! It's fairly simple apart from the opentext() ********* EXCEL CODE START ********* #INCLUDE EXCEL9.H #DEFINE FALSE .F. #DEFINE TRUE .T. TMPSHEET = GETOBJECT('','excel.sheet') GEXCEL = TMPSHEET.APPLICATION GEXCEL.VISIBLE = .T...

I think it is the actual word array vfp doesn't like. I keep getting the error : "array.prg does not exist"????? I am using the numeric qualifier for the above commands in the 2nd parameter but I think you can do it either way. Thanks Chris