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 Chriss Miller 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. carloalexi

    Corrupted Views

    If I dropp the MODEL column or one of the ID columns, obviously I need to modify the view to eliminate the reference to the dropped column, but that columns has been not dropped. For now, I dropp and re-create the view using scripts wich are executed from QueryAnalyzer when I change any table
  2. carloalexi

    Corrupted Views

    The columns which were dropped are not listed or referenced in the view This is may view: SELECT Products.*, Marks.*, Colours.*, Groups.*, SubGroups.*, (Groups.NameG + SubGroups.NameSG + Marks.NameM + Product.Model + Colours.NameC) AS Description, (Groups.CodeG + SubGroups.CodeSG +...
  3. carloalexi

    Corrupted Views

    Thanks guys! BINGO! The problems were: 1- I wasn't aware that views were affected by changing or adding a field in a table that the view depend on, even if the changed field wasn't used by the view (I simply noticed that views got corrupted FOR NO APPARENT REASON from time to time) 2- Not...
  4. carloalexi

    Corrupted Views

    Thanks guys! BINGO! The problems were: 1- I wasn't aware that views were affected by changing or adding a field in a table that the view depend on, even if the changed field wasn't used by the view (I simply noticed that views got corrupted FOR NO APPARENT REASON from time to time) 2- Not...
  5. carloalexi

    Corrupted Views

    I made a view with one table joined to other four tables, the resulset is fine, but suddenly the data in the resulset no match to field names. Example: My normal view resulset is: IDProduct= 1345 Category= Electronic Description= Sony MP3 Player, included battery and case ShortDescription=...
  6. carloalexi

    Displaying photos

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  7. carloalexi

    Displaying blob fields in crystal : problem

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  8. carloalexi

    Images using CR6

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  9. carloalexi

    Printing Pictures

    I got a problem like that, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  10. carloalexi

    Printing Pictures

    I a problem like that, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  11. carloalexi

    BLOB field graphics don't display in Crystal

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  12. carloalexi

    Displaying IMAGES stored in access!!

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  13. carloalexi

    picture and record

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  14. carloalexi

    image issues

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  15. carloalexi

    Displaying jpegs on reports

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...
  16. carloalexi

    Hod do I store an image/photo/picture in a database?

    I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs. Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For...

Part and Inventory Search

Back
Top