Search results for query: *

Hi, I have database SQL Server (MSDE) and Access project which is interface of this database. I want to have a view with records that my field "blabla" (of type datetime in source table) is equal to current date. But when I use criterion "where (blabla = Date())" and I want...

I tried Dim conX As ADODB.Connection but it return error: User-defined type not defined. By the way, do you know any Visual Basic for Application forum? Thanks, Bye

Hi I'm writing macro in Excel and I need to get data from database which is in Access. As I know I need to add some libraries in Tool/References and I added: Microsoft Access 10.0 Object Library Microsoft DAO 3.6 Object Library Microsoft ADO ... How can I declare variable as ADODB.Connection...

Hi! I had one network card and everything worked fine. I add second network card and linux moved configuration of the first one on the second one and works with the second right, but it doesn`t search the first one. Have you got any sugestions? Thanks in advance.

Hi! I`ve installed Redhat 8 and I have a problem. Hardware browser window frame opens with no data and then disappears. Any sugestions? Thanks in advance.

Hello I`ve got a problem with lack of memory when I`m creating list dynamically using double *h = new double[i] where i is for example 177*177*171*171 How can I store more memory for my program that I could create such lists? Have you got any ideas? Thanks

Sorry, I haven't got element named count, I've just change names like my_primary_key and count to make my question shorter but unfortunately I complicated it. So names cannot be a problem. I'm wondering if I have rights to set permissions like these, I'm the owner of database objects, but I'm...

My code is like this: IF EXIST... DROP VIEW CREATE VIEW state_view AS SELECT my_primary_key, count FROM dbo.name_table WHERE count <> 0 GO GRANT ALL ON state_view TO public GO As I read view like this can be updateable, but it's not. Where are mistakes? Thanks

I created a view and added statement: Grant all on nameofview to public but this view is still read-only. Have you got any sugestions how to change it? Thanks in advance

Hi, I have two tables and I created a view on them. But when I open a view I cannot update anything. One of the column is primary key in one table and foreign in the second, other elements are not keys. My question is: what do I have to do to make a user able to update this view and tables which...

Thanks SwampBoogie Your advice was very helpful, I just needed to change form a little, so my second question is not actual.

The problem is that I know nothing about any values of this element, so I cannot write condition WHERE... and this element isn't deleted yet. The situation is: user wants to delete an element, but it cannot be done ad hoc, so I need a trigger, which do sth with elements referencing to this one...

Hello, I'm writing trigger INSTEAD OF DELETE and I want to get values of element which is going to be deleted. How can I retrieve it? Thanks for help :)

Hello I need to use ON DELETE SET NULL what`s in a stadnard of sql, but I cannot find it in sql2000. Have you got any ideas how to do this? Please advise, Thanks