连接器已经连接conn
下列的sql语句不能在一个strtemp1中表示完。所以拆分成两个.运行时就会报第一行'GO'附近有语法错误,下列的语句是先创建的视图然后复制出来的,查询分析器里都可以创建.下列语句就是创建一个视图
不知为什么在VB中反而不行了呢? 每一语句末要放了空格的。谢谢!strtemp1 = " if exists ( select * from dbo.sysobjects where id = object_id(N'[dbo].[PUdata]') and OBJECTPROPERTY(id, N'IsView') = 1) " + _
" drop view [dbo].[PUdata] " + _
" GO " + _
" SET QUOTED_IDENTIFIER ON " + _
" GO " + _
" SET ANSI_NULLS ON " + _
" GO " + _
"CREATE VIEW dbo.PUdata " + _
"AS " + _
"SELECT TOP 100 PERCENT dbo.ProductActived.ProductNM, " + _
"dbo.SalesOrder.SalesOrderNM AS FuBTO, " + _
"dbo.MfgOrder.MfgOrderName AS vendorWO, dbo.Lot.LotNM AS UnSerialN, " + _
"dbo.CurrentStatus.LastMoveDate, dbo.Lot.LotId, dbo.SalesOrder.Description, " + _
"dbo.Product.CustomerProductNumber, " + _
"dbo.ProductActived.Description AS Prodescription " + _
"FROM dbo.SalesOrder INNER JOIN " + _
"dbo.MfgOrder ON " + _
"dbo.SalesOrder.SalesOrderId = dbo.MfgOrder.SalesOrderId INNER JOIN " + _
"dbo.Lot ON dbo.MfgOrder.MfgOrderId = dbo.Lot.MfgOrderId INNER JOIN " + _
"dbo.ProductActived ON dbo.Lot.ProductId = dbo.ProductActived.ProductId INNER JOIN " + _
"dbo.MoveHistory ON dbo.Lot.LotId = dbo.MoveHistory.HistoryId INNER JOIN " + _
"dbo.CurrentStatus ON" + _
"dbo.Lot.CurrentStatusId = dbo.CurrentStatus.CurrentStatusId INNER JOIN " + _
"dbo.WorkflowStep ON " + _
"dbo.CurrentStatus.WorkflowStepId = dbo.WorkflowStep.WorkflowStepId INNER JOIN "
strtemp2 = " dbo.Product ON dbo.SalesOrder.ProductId = dbo.Product.ProductId " + _
"GROUP BY dbo.ProductActived.ProductNM, dbo.SalesOrder.SalesOrderNM, " + _
"dbo.MfgOrder.MfgOrderName, dbo.Lot.LotNM, dbo.MoveHistory.TxnId, " + _
"dbo.WorkflowStep.WorkflowStepNM, dbo.CurrentStatus.NextWorkflowStepId, " + _
"dbo.CurrentStatus.LastMoveDate, dbo.Lot.LotId, dbo.SalesOrder.Description, " + _
"dbo.ProductActived.Description, dbo.Product.CustomerProductNumber, " + _
"dbo.ProductActived.Description, dbo.ProductActived.Description, " + _
"dbo.ProductActived.Description " + _
"HAVING (dbo.CurrentStatus.NextWorkflowStepId = '') " + _
"ORDER BY dbo.CurrentStatus.LastMoveDate " + _
"GO " + _
"SET QUOTED_IDENTIFIER OFF " + _
"GO " + _
"SET ANSI_NULLS ON " + _
"GO "
creatpudata = strtemp1 + strtemp2 conn.Execute creatpudata
下列的sql语句不能在一个strtemp1中表示完。所以拆分成两个.运行时就会报第一行'GO'附近有语法错误,下列的语句是先创建的视图然后复制出来的,查询分析器里都可以创建.下列语句就是创建一个视图
不知为什么在VB中反而不行了呢? 每一语句末要放了空格的。谢谢!strtemp1 = " if exists ( select * from dbo.sysobjects where id = object_id(N'[dbo].[PUdata]') and OBJECTPROPERTY(id, N'IsView') = 1) " + _
" drop view [dbo].[PUdata] " + _
" GO " + _
" SET QUOTED_IDENTIFIER ON " + _
" GO " + _
" SET ANSI_NULLS ON " + _
" GO " + _
"CREATE VIEW dbo.PUdata " + _
"AS " + _
"SELECT TOP 100 PERCENT dbo.ProductActived.ProductNM, " + _
"dbo.SalesOrder.SalesOrderNM AS FuBTO, " + _
"dbo.MfgOrder.MfgOrderName AS vendorWO, dbo.Lot.LotNM AS UnSerialN, " + _
"dbo.CurrentStatus.LastMoveDate, dbo.Lot.LotId, dbo.SalesOrder.Description, " + _
"dbo.Product.CustomerProductNumber, " + _
"dbo.ProductActived.Description AS Prodescription " + _
"FROM dbo.SalesOrder INNER JOIN " + _
"dbo.MfgOrder ON " + _
"dbo.SalesOrder.SalesOrderId = dbo.MfgOrder.SalesOrderId INNER JOIN " + _
"dbo.Lot ON dbo.MfgOrder.MfgOrderId = dbo.Lot.MfgOrderId INNER JOIN " + _
"dbo.ProductActived ON dbo.Lot.ProductId = dbo.ProductActived.ProductId INNER JOIN " + _
"dbo.MoveHistory ON dbo.Lot.LotId = dbo.MoveHistory.HistoryId INNER JOIN " + _
"dbo.CurrentStatus ON" + _
"dbo.Lot.CurrentStatusId = dbo.CurrentStatus.CurrentStatusId INNER JOIN " + _
"dbo.WorkflowStep ON " + _
"dbo.CurrentStatus.WorkflowStepId = dbo.WorkflowStep.WorkflowStepId INNER JOIN "
strtemp2 = " dbo.Product ON dbo.SalesOrder.ProductId = dbo.Product.ProductId " + _
"GROUP BY dbo.ProductActived.ProductNM, dbo.SalesOrder.SalesOrderNM, " + _
"dbo.MfgOrder.MfgOrderName, dbo.Lot.LotNM, dbo.MoveHistory.TxnId, " + _
"dbo.WorkflowStep.WorkflowStepNM, dbo.CurrentStatus.NextWorkflowStepId, " + _
"dbo.CurrentStatus.LastMoveDate, dbo.Lot.LotId, dbo.SalesOrder.Description, " + _
"dbo.ProductActived.Description, dbo.Product.CustomerProductNumber, " + _
"dbo.ProductActived.Description, dbo.ProductActived.Description, " + _
"dbo.ProductActived.Description " + _
"HAVING (dbo.CurrentStatus.NextWorkflowStepId = '') " + _
"ORDER BY dbo.CurrentStatus.LastMoveDate " + _
"GO " + _
"SET QUOTED_IDENTIFIER OFF " + _
"GO " + _
"SET ANSI_NULLS ON " + _
"GO "
creatpudata = strtemp1 + strtemp2 conn.Execute creatpudata
而直接使用conn.excute "XXXXXXXXXXXXXXXXXXXXXXXXX"
conn.excute "XXXXXXXXXXXXXXX"
.....
.....
不过还是谢谢啊!