sql - Error when inserting Description Column -


below code have add description column in spotfire. works in microsoft sql.how supposed write in spotfire?

select    v1."datetime" "discretelivedatetime",    v1."tagname" "discretelivetagname",    v1."value" "discretelivevalue",    v2.description "description"    "runtime"."dbo"."v_discretelive" v1  inner join [runtime].[dbo].tag v2 on v1.tagname = v2.tagname

the above code made giving me error below.

error message: failed execute data source query.  importexception @ spotfire.dxp.data: failed execute data source query. (hresult: 80131500)  stack trace:    @ spotfire.dxp.data.datasourceconnection.executequery2()    @ spotfire.dxp.data.dataflow.execute()    @ spotfire.dxp.data.dataflow.dataflowconnection.executequerycore2()    @ spotfire.dxp.data.datasourceconnection.executequery2()    @ spotfire.dxp.data.producers.sourcecolumnproducer.<>c__displayclass11.<getcolumnsandproperties>b__e()    @ spotfire.dxp.framework.applicationmodel.progress.executesubtask(string title, progressoperation operation)    @ spotfire.dxp.data.producers.sourcecolumnproducer.getcolumnsandproperties(datasourceconnection connection)    @ spotfire.dxp.data.persistence.dataitem.performupdate(sourcecolumnproducer producer, datasourceconnection connection)    @ spotfire.dxp.data.persistence.dataitem.update(sourcecolumnproducer producer, datasourceconnection connection)    @ spotfire.dxp.data.persistence.datapool.<loaddata>d__1.movenext()    @ spotfire.dxp.data.producers.sourcecolumnproducer.<refresh>d__0.movenext()    @ spotfire.dxp.data.datatable.<>c__displayclass66.<>c__displayclass69.<beginrefresh>b__62()    @ spotfire.dxp.framework.documentmodel.node.spotfire.dxp.framework.documentmodel.inode.internaltransaction(executor executor)    @ spotfire.dxp.data.datatable.<>c__displayclass66.<beginrefresh>b__60()    @ spotfire.dxp.framework.commands.commandhistory.transaction(executor executor, boolean visible, boolean sticky, guid stickyguid)    @ spotfire.dxp.framework.commands.commandhistory.stickytransaction(guid guid, executor executor)    @ spotfire.dxp.framework.documentmodel.documentnode.stickytransaction(guid guid, executor executor)    @ spotfire.dxp.framework.documentmodel.documentnode.spotfire.dxp.framework.documentmodel.itransactions.executestickytransaction(guid guid, executor executor)    @ spotfire.dxp.data.datatable.beginrefresh(boolean showdataloadreport)    @ spotfire.dxp.data.datatable.refresh(boolean showdataloadreport)    @ spotfire.dxp.data.datatablecollection.refreshproducers(ienumerable`1 tablestorefresh, boolean showdataloadreport)    @ spotfire.dxp.data.datatablecollection.refresh(ienumerable`1 tablestorefresh)    @ spotfire.dxp.forms.data.dataformsuseractions.<>c__displayclassc.<refreshdata>b__a()    @ spotfire.dxp.forms.application.formsprogressservice.progressthread.dooperationloop()   informationmodelexception @ spotfire.dxp.data: failed execute query: incorrect syntax near 'v2'. (hresult: 80131500)  stack trace:    @ spotfire.dxp.data.informationmodel.internalinformationmodelmanager.datastream.getnextblock()    @ spotfire.dxp.data.informationmodel.internalinformationmodelmanager.datastream.read(byte[] buffer, int32 offset, int32 count)    @ spotfire.dxp.internal.utilities.seekablestream.read(byte[] buffer, int32 offset, int32 count)    @ system.io.binaryreader.fillbuffer(int32 numbytes)    @ system.io.binaryreader.readuint16()    @ spotfire.dxp.data.formats.sbdf.sbdfsectionheader.readsectiontype(binaryreader reader, sbdfsectiontypeid expectedtype)    @ spotfire.dxp.data.import.sbdfdatarowreader.delayedinit()    @ spotfire.dxp.data.import.informationlinkdatasourceconnection.executequerycore2()    @ spotfire.dxp.data.datasourceconnection.executequery2()   informationmodelserviceexception @ spotfire.dxp.services: failed execute query: incorrect syntax near 'v2'. (hresult: 80131509)  stack trace:    @ spotfire.dxp.services.webservicebase`1.invokeservice[t](servicemethod`1 servicemethod, exceptionfactorymethod exceptionfactorymethod)    @ spotfire.dxp.data.informationmodel.internalinformationmodelmanager.datastream.getnextblock()

i think problem here changing sql query. think able add clause. if want add column must model in information designer.


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria...
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w...
Read more