sql server - Conversion failed when converting from a character string to a uniqueidentifier while importing table? -

-

i'm trying import table navicat sql server , error:

[err] [row1] [imp] 42000 - [sql server]conversion failed when converting character string uniqueidentifier.

[err] [row1] [imp] 

insert [edfi].[studentschoolassociation]         ([studentusi],[schoolid], [schoolyear],[entrydate],         [entrygradeleveldescriptorid], [entrygradelevelreasontypeid],          [entrytypedescriptorid], [repeatgradeindicator],         [schoolchoicetransfer], [exitwithdrawdate],          [exitwithdrawtypedescriptorid],[residencystatusdescriptorid],          [primaryschool], [employedwhileenrolled],         [classofschoolyear], [educationorganizationid],          [graduationplantypedescriptorid], [graduationschoolyear],         [id], [lastmodifieddate], [createdate])  values ('89', '2',          '2014', '1913-9-9',          '133', null,          '2184038928404', null,          null, null, null, null, null, null, null, null, null, '1776',         '', 0, 0)

[err] [row1] [imp] 42000 - [sql server]conversion failed when converting character string uniqueidentifier.

the third last column id, not null uniqueidentifier (newid()). want autogenerate these id's, empty in csv file.


Comments

Post a Comment

Popular posts from this blog

c# - Store DBContext Log in other EF table -

-
i want store logs in db table (imported ef code). my code looks this: public pmcontext() : base("myentities") { configuration.proxycreationenabled = false; configuration.lazyloadingenabled = false; this.database.log = s => logstore(s); } private void logstore(string message) { tlog log = new tlog(); log.description = message; log.insertdate = datetime.now; logs.add(log); savechanges(); } public virtual dbset<tlog> logs { get; set; } i cannot use savechanges() (get error "sqlconnection not support parallel transactions") , if remove line nothing stored in db table. how can fix this? i think happens during savechanges call anywhere in app, because sql generated call logged, triggers nested savechanges call tries start own transaction. and there thing: savechanges call in logstore method trigger logging itself, you'd end starting infin...
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

-
i lost "unknown" error: karma.conf.js: frameworks: ['mocha', 'should'], plugins: ['karma-mocha', 'karma-should', 'karma-phantomjs-launcher'], ... browsers: ['phantomjs'], error: 23 07 2015 14:35:37.691:warn [karma]: no captured browser, open http://localhost:9876/ 23 07 2015 14:35:37.701:info [karma]: karma v0.13.3 server started @ http://localhost:9876/ 23 07 2015 14:35:37.707:info [launcher]: starting browser phantomjs 23 07 2015 14:35:37.738:error [karma]: { [error: spawn unknown] code: 'unknown', errno: 'unknown', syscall: 'spawn' } error: spawn unknown @ exports._errnoexception (util.js:749:11) @ childprocess.spawn (child_process.js:1093:11) @ exports.spawn (child_process.js:933:9) @ object._execcommand (c:\users\jinga4x\git\mdl-sample-project\node_modules\karma\lib\launchers\process.js:63:21) @ object._start (c:\users\jinga4x\git\md...
Read more