SQl Question with VB .NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I<m wrting a SQL string in my VB .NET application.

There is a function in my string but it<n not seem working
I have always an syntax error message

this is my quesry
strSQL = "INSERT INTO Tb_client( IDclient, c1CommUOM )" _
& " SELECT Tb_Temp.COMPFILE, " & getAbbrUM( "[TYPE1]" ) & " AS
c1CommUOM FROM Tb_Temp"

Where Type1 is a string in the Table Tb_Temp

Any idea who can I use a function in a SQl Query in a VB .NEt code

Thanks
 
Hermione said:
Hi

I<m wrting a SQL string in my VB .NET application.

There is a function in my string but it<n not seem working
I have always an syntax error message

this is my quesry
strSQL = "INSERT INTO Tb_client( IDclient, c1CommUOM )" _
& " SELECT Tb_Temp.COMPFILE, " & getAbbrUM( "[TYPE1]" ) & " AS
c1CommUOM FROM Tb_Temp"

Where Type1 is a string in the Table Tb_Temp

Any idea who can I use a function in a SQl Query in a VB .NEt code

Thanks
Click to expand...

What do you want your function to do? Do you want to calculate something
from a column called TYPE1?
What database do you use?

/Fredrik
 
Hi Fredrik
Thank for your answer

YEs acctually I want to calculate some value regardingthe Type1, and I
already programed the function getAbbrUM.

If you have any idea it<ll be great


Fredrik Wahlgren said:
Hermione said:
Hi

I<m wrting a SQL string in my VB .NET application.

There is a function in my string but it<n not seem working
I have always an syntax error message

this is my quesry
strSQL = "INSERT INTO Tb_client( IDclient, c1CommUOM )" _
& " SELECT Tb_Temp.COMPFILE, " & getAbbrUM( "[TYPE1]" ) & " AS
c1CommUOM FROM Tb_Temp"

Where Type1 is a string in the Table Tb_Temp

Any idea who can I use a function in a SQl Query in a VB .NEt code

Thanks
Click to expand...

What do you want your function to do? Do you want to calculate something
from a column called TYPE1?
What database do you use?

/Fredrik
Click to expand...
 
Hermione said:
Hi Fredrik
Thank for your answer

YEs acctually I want to calculate some value regardingthe Type1, and I
already programed the function getAbbrUM.

If you have any idea it<ll be great
Click to expand...
I cab think of 3 ways, I'm not sure about the last one

1) If you use something like Oracle or SQL Server, you need to create a
stored procedure where you define getAbbrUM.

2) Get the values from the mentioned column and loop over them, calling
getAbbrUM on each row

3) Maybe ADO.NET has some kind of built-in functionality that makes this
easier than looping. I think you should ask the ...public.framework.adonet
newsgroup.

/Fredrik
 
Hello Hermione,

your query cannot call the method GetAbbrUM. You need to create the SQL
statement, send it to SQL Server or whatever database you are using, get
back the results (which will come back as one or more rows), then loop
through the results. In each result, you can extract the field and perform
the calculation.

All you are doing, in the statement below, is passing in the string
"[TYPE1]" to your function... which is probably not what you want.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
 
thanks Nick

Nick Malik said:
Hello Hermione,

your query cannot call the method GetAbbrUM. You need to create the SQL
statement, send it to SQL Server or whatever database you are using, get
back the results (which will come back as one or more rows), then loop
through the results. In each result, you can extract the field and perform
the calculation.

All you are doing, in the statement below, is passing in the string
"[TYPE1]" to your function... which is probably not what you want.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
Hermione said:
Hi

I<m wrting a SQL string in my VB .NET application.

There is a function in my string but it<n not seem working
I have always an syntax error message

this is my quesry
strSQL = "INSERT INTO Tb_client( IDclient, c1CommUOM )" _
& " SELECT Tb_Temp.COMPFILE, " & getAbbrUM( "[TYPE1]" ) & " AS
c1CommUOM FROM Tb_Temp"

Where Type1 is a string in the Table Tb_Temp

Any idea who can I use a function in a SQl Query in a VB .NEt code

Thanks
Click to expand...
Click to expand...
 
thanks Fredrik

Fredrik Wahlgren said:
I cab think of 3 ways, I'm not sure about the last one

1) If you use something like Oracle or SQL Server, you need to create a
stored procedure where you define getAbbrUM.

2) Get the values from the mentioned column and loop over them, calling
getAbbrUM on each row

3) Maybe ADO.NET has some kind of built-in functionality that makes this
easier than looping. I think you should ask the ...public.framework.adonet
newsgroup.

/Fredrik
Click to expand...
 
Back
Top