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 strongm 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: ahaws
  • Order by date
  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...
  16. ahaws

    on shutdown command - not performing what I ask

    Hi all- Been having a problem with temp ".dbf" files remaining in my active directory when a program is prematurely shutdown due to user not exiting the program properly,power failure, etc. I have a program that checks to see if a temp file exists, and if it exists, make sure it's closed, then...
  17. ahaws

    grid controlsource based on IIF

    Thanks Barbara. I just realized that I had a post earlier that asked the same thing, kind of, Ramani had answered before -but it seemed to work. .column4.ControlSource = 'Iif(Empty(BKPROPID.claimfiled),"NO","YES")' just had to put quotes around entire thing. Thanks again- angie
  18. ahaws

    grid controlsource based on IIF

    Hi - Have a column4 - control source is a date field, however, if the field is empty I want the grid to say "NO" and if not empty - then "YES". If I control source to the field, then the data type error happens - because it is a data field. How can I achieve this? thanks in advance
  19. ahaws

    grid with multiple recordsources for different columns

    Thanks Darrell- If the name is not valid, It should bring to first "near" match...Say "Long" isn't found, but Lonie is...will show lonie. Thanks so much - all is finally working. Angie
  20. ahaws

    grid with multiple recordsources for different columns

    This is what I have in a 'find.click()' button on page1 in a pageframe1 with 2 pages: Set Talk Off Set Exact Off thisform.debtorname = allt(thisform.pageframe1.page1.txtname.value) Select bkmaster Set Order To casenumber Select bkpeople Set Relation To casenumber Into bkmaster Set Order To...

Part and Inventory Search

Back
Top