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!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ahaws

  1. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Antonio- Im still learning myself, only since 2001 have I been trying to! I will probably post here so everyone can benefit..so if I find a solution I will let you know via Tek-Tips.. Take care! Angie
  2. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Antonio- Try Universal Thread or Experts Exchange-they are forums as well, although there are alot of experts here as well. That's why I cant believe no one has popped in with other suggestions, although it could be a program setting, local to your machine... If I find anything I will let you...
  3. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Antonio- What field does it join to? Not sure what's going on here...Havent ever seen where there is a join for only one table. Maybe a guru will pop in at any time... angie
  4. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Antonio- Not sure- I use VFP7.0, but that doesn't sound like it should be operating that way. Do you use the view wizard or set up by yourself? Angie
  5. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Hi Ramani- I didnt that of that...thanks. Hi Antonio If I understand Ramani- If you are using a form, then in the Data Environment of the form you should be able to see which .dbc your view is pointing to. Find the 'charges' table that your 'vcharges' is pointing to in your DE of your form...
  6. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Hi again- looking at my code that I had a problem with earlier- Craidsboyd had offered: >>You probably have an additional layer of buffering that exists...umm...I think you could confirm if this is the case by calling tableupdate() twice instead of once and see if values actually make it to the...
  7. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    HI Antonio- do you have SET MULTILOCKS ON? Angie
  8. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Im sorry, maybe I misunderstood... if it doesnt update, it never gets to the error message? You could try stepping through to see how far it gets in code.. let me know angie
  9. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    kueyiar- Hi Again- You would have to write your own error message...something like: messagebox("UpDate was Not Successful",16)---- So lcsuccess = cursorsetprop('buffering',5,'tablename') if lcsuccess =tableupdate(2,.t.,'viewname') =tableupdate(2,.t.,'tablename') else messagebox("UpDate was...
  10. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Hi Again Kueyiar >> By the way, the table i'm using is a free table, i only keep the views on the database.! Same here. Are you making sure that the "Send Updates" is checked in the Update Criteria section of the view? I use VFP 7.0, although I Do not think if matters.
  11. ahaws

    Updateable view Not Updating...have Send SQL Updates checked....

    Hi keuyiar- I issue a TABLEUPDATE on the view as well as the table...that seems to work. ** Save changes? lcsuccess = cursorsetprop('buffering',5,'tablename') if lcsuccess =tableupdate(2,.t.,'viewname') =tableupdate(2,.t.,'tablename') else ** some error message endif Hope this helps.. Ahaws
  12. ahaws

    How to access FoxPro database from ASP code

    Hi PriyaJay- Maybe telling you what I do will give you an idea... I have a website that looks up property tax information from our Network (non-shared). I have a static "lookup" foxpro .dbf that resides on the webserver via ODBC. When the user enters a name, for example, I do a select...
  13. ahaws

    on shutdown command - not performing what I ask

    Thanks Guys! I appreciate all your help and everything is working as it should! [thumbsup2] Have a great weekend. Angie
  14. ahaws

    on shutdown command - not performing what I ask

    clr_sets: Hi Chris- here is what those programs do: *********************************************************************** * CLR_SETS clears FoxPro SET statements back to their default * values * *********************************************************************** PROCEDURE clr_sets ON...
  15. ahaws

    on shutdown command - not performing what I ask

    Hi Chris- >>Apologies - I omitted the QUIT command from the example code in the previous post. DO I put the QUIT command in my Quitapp procedure? I was having a problem at one point where when I quit my program, it sort of 'hung' - in the command window, 'QUIT' did not work. The sysmenu kind...

Part and Inventory Search

Back
Top