how to block ?
-
how can i block the data in Data base (SQL server 2000) by variable in the data base like Year please some definition and detailes ahmed eldeghedy
-
how can i block the data in Data base (SQL server 2000) by variable in the data base like Year please some definition and detailes ahmed eldeghedy
ahmed eldeghedy wrote:
please some definition and detailes
Yes, that would be nice.
ahmed eldeghedy wrote:
how can i block the data in Data base (SQL server 2000) by variable in the data base like Year
What do you mean by "block"? Do you mean filter out?
SELECT * FROM SomeTable WHERE Year = 2007
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website
-
how can i block the data in Data base (SQL server 2000) by variable in the data base like Year please some definition and detailes ahmed eldeghedy
Do not email me - If I respond it is for everyones benefit, not just yours. Other people make have the same problem and are searching the forums for an answer, if I email a response those people will not benefit.
ahmed eldeghedy wrote:
what i mean when i take instans form the object (tabel database) i whant the data bases retrun table by the data not block not filter ahmed eldeghedy
That still does not make sense. What do you mean by "block"? How do you want data blocked? What sort of data do you want blocked? Perhaps you want to revoke access to the tables and have everything done through views and grant access to the views based on the role the user has. Perhaps you want to do everything through stored procedures which will only do what the stored procedure has been programmed to do and nothing more. But I just don't know from your description.
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website
-
ahmed eldeghedy wrote:
please some definition and detailes
Yes, that would be nice.
ahmed eldeghedy wrote:
how can i block the data in Data base (SQL server 2000) by variable in the data base like Year
What do you mean by "block"? Do you mean filter out?
SELECT * FROM SomeTable WHERE Year = 2007
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website
Colin Angus Mackay wrote:
What do you mean by "block"?
What does he mean?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
Do not email me - If I respond it is for everyones benefit, not just yours. Other people make have the same problem and are searching the forums for an answer, if I email a response those people will not benefit.
ahmed eldeghedy wrote:
what i mean when i take instans form the object (tabel database) i whant the data bases retrun table by the data not block not filter ahmed eldeghedy
That still does not make sense. What do you mean by "block"? How do you want data blocked? What sort of data do you want blocked? Perhaps you want to revoke access to the tables and have everything done through views and grant access to the views based on the role the user has. Perhaps you want to do everything through stored procedures which will only do what the stored procedure has been programmed to do and nothing more. But I just don't know from your description.
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website
Colin Angus Mackay wrote:
That still does not make sense.
It certainly still makes no sense :confused:
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus