|
Written by Administrator
|
|
Saving changes is not permitted.The changes you have made require the following tables to be dropped and re-created.You have either made changes to a table that can't be re-create or enabled the option Prevent saving changes that require the table to be re-created. Go to Tools --> Options --> Designer uncheck "Prevent saving changes that require table re-creation" |
|
Last Updated ( Friday, 15 May 2009 20:13 )
|
|
|
Written by Administrator
|
ASP.NET SqlMembershipProvider schema version error
The ‘System.Web.Security.SqlMembershipProvider’ requires a database schema compatible with schema version ‘1′. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_reqsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. - use aspnet_regsql(c:/windows/framework/.net 2.0 ) : remove and add
- Restart the web application
|
|
Last Updated ( Friday, 15 May 2009 20:07 )
|
|
Written by Administrator
|
|
ie does not support canvas tag. when u use excanvas.js it gives an error object doesn't support this property or method ( excanvas.js ) <canvas id="someid"></canvas> this works in firefox , google chrome but not in ie. the solution is: <div id="insertCanvas"></div> <script type="text/javascript"> // new canvas element var canvasElem = document.createElement('canvas'); // you need to add canvasElem to the document before doing anything else. document.getElementById("insertCanvas").appendChild(canvasElem); // if it is IE... if (typeof G_vmlCanvasManager != 'undefined') { // you've to reassign the variable to the new element created by initElement canvasElem = G_vmlCanvasManager.initElement(canvasElem); } canvasElem.setAttribute("id","analiz"); // now you can do getContext on this canvasElem... </script> |
|
Last Updated ( Friday, 15 May 2009 20:08 )
|
|
Written by Administrator
|
|
do not declare any variables with the same name as any of your controls. |
|
Last Updated ( Friday, 15 May 2009 20:13 )
|
|
Written by Administrator
|
|
Example Number 1 ... create sequence product_seq start with 1 increment 1 / create or replace trigger product_insert before insert for each row begin select productseq.nextval into :new.product_id from dual; end; / Example Number 2 ... How to create an autoincrement field in a table with a sequence ...
SQLWKS> create table bob(a number , b varchar2(21)); Statement processed.
First create a sequence SQLWKS> create sequence x ; Statement processed.
Then create the trigger. create trigger y before insert on bob for each row when (new.a is null) begin select x.nextval into :new.a from dual; end; /
Example Number 3 ... First create a sequence: create sequence emp_no_seq; By default it increments by 1 starting at 0. Use its values when inserting data into the table: insert into t_emp values (emp_no_seq.nexval, 'Joe Black'); |
|
Last Updated ( Friday, 15 May 2009 20:14 )
|
|
|
|
|
|
|
Page 5 of 8 |