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 Mike Lewis 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: *

  1. AnthonyWhitehouse

    reading a foxpro table using the record number (in VB6)

    Thanks Tedsmith I managed to resolve this just before your post in the way that you suggested - similar to what I tried before posting the issue - so not quite sure what I did wrong the first time. Anyway to complete the thread - this is what I did. If IsNumeric(strTemp) Then Set...
  2. AnthonyWhitehouse

    reading a foxpro table using the record number (in VB6)

    Greetings A process at our site stores a record number. Can anyone help me with some VB6 code to read from a foxpro table using a record number? For example - the process stores 35 - which I can see in foxpro is the 35th record in my table. I have tried the following - but it gets a record that...
  3. AnthonyWhitehouse

    Trigger not updating a field with a null value

    Thanks gmmastros - I have modified my trigger to use your suggested join but I still have the same problem. A clarification - I am actually trying to update two fields in the products table whenever the plocdetails quantity changes. I am updating products.zsohakl with the quantity in plocdetails...
  4. AnthonyWhitehouse

    Trigger not updating a field with a null value

    Is there anyway that I could test to see if there are multiple entries in Inserted?
  5. AnthonyWhitehouse

    Trigger not updating a field with a null value

    Ahhhh - I think normally the database would be updating the product quantity in just one location ... but perhaps there is more than one when they do a Stock Transfer between locations? Is there anyway that I could test to see if there are multiple entries in Inserted? How would you suggest that...
  6. AnthonyWhitehouse

    Trigger not updating a field with a null value

    Greetings - I have a sql trigger that sets the value on a field called SOH in the products table whenever the quantity for location 1 is updated. This works - but sometimes it doesnt work. Investigating I think this is when the existing value of SOH is null. I can not understand why this is - or...
  7. AnthonyWhitehouse

    Linking a DBF to a SQL Table

    Greetings. I work with an older Foxpro system and have created a utility to extract data via setting ExportSQL = "Select......" and then Set dbCompany = OpenDatabase(strDatabase, dbDriverComplete, False, "FoxPro 2.6") Set RsTmp = dbCompany.OpenRecordset(ExportSQL, dbOpenDynaset) This works...
  8. AnthonyWhitehouse

    Picture shows Blank

    Greetings. I have a simple problem that has taken me hours of frustration without resolution so far. I am simply trying to add a picture to a crystal report, but when I print it, it shows as blank (or just the border if I put one around it) If I edit the report again the picture also shows as...

Part and Inventory Search

Back
Top