Content View Hits : 18853

Giriş Formu






Forgot your password?
Forgot your username?
No Account Yet? Create an account

sql server 2008 - Prevent saving changes that require the table to be re-created PDF Print E-mail
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 )
 
ASP.NET SqlMembershipProvider schema version error PDF Print E-mail
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.

  1. use aspnet_regsql(c:/windows/framework/.net 2.0 ) : remove and add
  2. Restart the web application
Last Updated ( Friday, 15 May 2009 20:07 )
 
using canvas in ie PDF Print E-mail
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 )
 
Parser Error Message: Ambiguous match found. PDF Print E-mail
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 )
 
oracle auto increment - sequence PDF Print E-mail
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 )
 
More Articles...
« StartPrev12345678NextEnd »

Page 5 of 8