The problem seems to have fixed itself. I am not sure as to what could have caused it and how it was resolved but after running a delete statement on the web, it seems to have remembered how to update. It could just be a co-incidence. But thanks anyway
I have recently moved my data from one sql server to another one. My problem right now is that all my update queries are not working from the web but a direct update to the database works. All the insert statements seem to be working fine. What could be the issue?
It's fine guys i found it.
Use of OBJECTPROPERTY function will accomplish this as follows: SELECT OBJECTPROPERTY(OBJECT_ID('tr_Test'),'ExecIsTriggerDisabled') You will receive a return value of 1 for a disabled trigger and 0 for and enabled trigger. This can be helpfull to check first instead...
How do I know if a trigger has been disabled (disabled using : alter table XXXXX disable trigger YYYYY). I have been relaxed thinking that my triggers were running OK until I lost the data from the original table and when I had a look at the audit table(created from the trigger) I find that...
I have just started using C++ and I don't understand the whole logic for having a class and an initialiser for it. What exactly is an initialiser and why can't we move the code on the initialiser to the class definition? I am really sorry if this sounds stupid but OO is new to me.
I need to know if there is a onwindow.close() (or something like that) function that I can use coz I need to perform some function when the user closes the window
I need to create a dynamic menu that is database driven. I am struggling to find a way to incorporate the two aspect i.e make it dynamic and database driven somebody help
I Need to be able to return the day of the week (e.g.Monday,Tuesday etc) from a give date(e.g. 12/09/2001).
Is there a function or anyway at all that I can do this
is this problem still happening because normall when you change anything on your report(in crystal) it takes a few minutes before the cache is cleared and the new changes reflected(sometimes a good 30 min)on the web.
You need to go the database option on your manu and select "View SQL ". what ever you see there is the query (code) that is used by crystal for you to display your data
I have setup the web server and everything else to view crystal reports and i have also added the crystal viewer on the tool bar. My problem is that when I drag and drop the viewer icon it brings up an empty box.How do i create a report from there?
How do I search for a word in a string without using %like% because %like% only finds a string that begins with the word and not that actually has an occurance of the word(it could be in the middle of the string)
This happens because frames represent different web pages and the back button will go back one page at a time. Normally it would go back back by one frame then the main page. Unfortunaltely I don`t know if this can be avoided because I also found it to be quite problematic.
Normally an ODBC error refers to your database connections. Checl from the control panel--> ODBC setup and make sure that your ODBC drivers are looking at the correct database
Is it possible to use java script( and not SQL) to read the table ( access data base). If not is there any other widely used language except SQL that can be used and how can that be done?
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.