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
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 +...
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...
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...
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=...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.