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!

Register Log in
  • Congratulations derfloh 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: andyk
  • Order by date
  1. andyk

    Copying new Fields 'WITH PRODUCTION'

    Mike, Top man! - Thanks problem solved Cheers Andy
  2. andyk

    Copying new Fields 'WITH PRODUCTION'

    Hi All, I recently had a problem whereby I had two tables, both containing a field named 'f_name' joined by a single view. The problem was that the view seemed to not be able to resolve where the updates should go for each of the corresponding 'f_name' view fields (I used appropiate aliases in...
  3. andyk

    Sending View Updates to base tables.

    Hi, I have a complicated view which I have been using to update its base tables. In the latest release of my software it has stopped updating the base one of the bases tables. To debug I simplified the view to just get two fields (the primary index & the field I'm trying to update) from a...
  4. andyk

    Owner Drawn CListCtrl & GetSubItemRect()

    Hi, I have a 'owner draw fix' CListCtrl which does not return the values I expect when I call GetSubItemRect(). GetSubItemRect() always seems to return the values expected it the owning dialog's font size is 8pt. If I change the font to 16pt the cell heights are unaffected, resulting in any...
  5. andyk

    Backups

    Scott, Thanks for that - I've tried it out in the command window and I'm confident I can get it to work that way. As a restore facility would you suggest using the COPY FILE command (with the database close)? Is this the safest way? It feels safer that emptying a table and then doing an...
  6. andyk

    Backups

    Hi, I've developed a small database that I would now like to deliver to a number of PCs to be used by people who are not too knowledgeable of PCs. I would like them to backup the data regularly to a Zip/CDW drive and to be able to create multiple backups on the same media e.g by allowing the...
  7. andyk

    Disabling Menu Items which disable Modal Dialogs.

    Hi, Can anyone help? I would like to invoke a modal dialog from a menu item/toolbar button and whilst the dialog is being displayed, I would like the menu item and button disabled. I have no problem doing this for the items which result in a modeless dialog being displayed. It is because I...
  8. andyk

    Double Clicking on a Read-Only Grid?

    Thanks Vlad, I've managed to get it working to a fashion. Your suggestion of turning the cursor OFF and ON seems to have no affect though. Also I am using the DynamicBackColor property, consequently the Selected Color needs to change according to the expression in the DynamicBackGround...
  9. andyk

    Double Clicking on a Read-Only Grid?

    Hi, I have a grid which is populated and all cells are read-only. I would like to be able to double click on one of the rows and active a 'details' form for that row. Obviously, the cells of the grid being disabled results in the Click/Double Click events being inactive. Any ideas?? Many...
  10. andyk

    Sending Emails

    Thanks for all your replies, I am actually running Outlook Express 5 on my development machine. My problem is that the target machine may be running Outlook or Outlook Express. Therefore I assume Ropje's solution is the most suitable. I have had some success with this solution after I swopped...
  11. andyk

    Sending Emails

    I would like to send an email from within FoxPro. The VFP Help gives an example of invoking Excel using OLE and this works fine. Could anyone give me an example of sending an email using Outlook Express? When I run the command: oleApp = createobject("outlook.Application") I get...
  12. andyk

    Updating the base tables of a Parameterized View

    Sorry Rob, I'll keep it to American in future!
  13. andyk

    Updating the base tables of a Parameterized View

    Jon/Robert, I tried setting the cursor property to no avail. When Robert said he had had the same problem well I knew I was in trouble!! Thanks for you rapid responses though - both within an hour or so, that's service for you. I've got around the problem by only allowing edits within a set...
  14. andyk

    Updating the base tables of a Parameterized View

    Dear All, I've got a parameterized view that I have created as follows: create sql view as SELECT T_worklog.ip_work_lo,; T_worklog.i_activity,; T_worklog.i_bf,; T_worklog.f_date,; T_worklog.f_ncode,; T_worklog.f_ndesign,; T_worklog.f_ntest,; T_worklog.f_ndocs...
  15. andyk

    View/Table One-To-Many Syntax Error.

    Dear All, I'm getting a less than helpful 'Syntax Error' when I'm issuing a 'SET RELATION' command. The situation is this: I've got a view which I'm using at the 'one' end of the relation and a table for the 'Many' end. The table is actually one of the base tables of the view. The...
  16. andyk

    Joins and Forms

    Sorry, problem solved - I had some combo boxes being populated from other tables. I'm not sure what was wrong but I've re-done them and all it fine.
  17. andyk

    Joins and Forms

    Thanks, sounds like sound advice. Can I just comfirm that what you are suggesting si neat way to re-order views? My original query was really about how to build complex views in the Studio and display the result in forms. I'll try what you have said, but due to by inexperience, I am unsure of...
  18. andyk

    Joins and Forms

    Thanks Robert,<br><br>I think I'm on the right track now.&nbsp;&nbsp;Having to use DBSETPROP() to get the updates working is also making sence to me now (being essentially a C++ developer).&nbsp;&nbsp;The FoxPro Designers are far too nice for people like myself!<br><br>Many Thanks Andy.
  19. andyk

    Joins and Forms

    Hi All,<br><br>I've posted a similar question previously on the FoxPro Forum, with your help (thanks David and John!) I've managed to get a bit further, but I am still not quite there, so a bit more help would be gratefully received.<br><br>The Problem:<br><br>I have a table containing records...
  20. andyk

    From relations between Views and Tables.

    Jon,<br><br>Thanks, I've managed to create the temp index solution in the command window!&nbsp;&nbsp;I'll try doing it in the form shortly.<br><br>I had played with Parameterized Views as per your second solution, however I could not get the child view to update with new parameter...

Part and Inventory Search

Back
Top