473,236 Members | 1,443 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,236 software developers and data experts.

SQl Question with VB .NET

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

Jul 21 '05 #1
6 1202

"Hermione" <He******@discussions.microsoft.com> wrote in message
news:47**********************************@microsof t.com...
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


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
Jul 21 '05 #2
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" wrote:

"Hermione" <He******@discussions.microsoft.com> wrote in message
news:47**********************************@microsof t.com...
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


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

Jul 21 '05 #3

"Hermione" <He******@discussions.microsoft.com> wrote in message
news:C2**********************************@microsof t.com...
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

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
Jul 21 '05 #4
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" <He******@discussions.microsoft.com> wrote in message
news:47**********************************@microsof t.com...
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

Jul 21 '05 #5
thanks Nick

"Nick Malik [Microsoft]" wrote:
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" <He******@discussions.microsoft.com> wrote in message
news:47**********************************@microsof t.com...
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


Jul 21 '05 #6
thanks Fredrik

"Fredrik Wahlgren" wrote:

"Hermione" <He******@discussions.microsoft.com> wrote in message
news:C2**********************************@microsof t.com...
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

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

Jul 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Madhusudan Singh | last post by:
Hi After months of waiting for Redhat to come out with up to date rpms, I decided to compile a working OpenSSL/ MySQL / PHP / httpd installation for myself. Installed the latest versions of...
0
by: Alexander Skwar | last post by:
Hello! I'm having problems getting PHP 4.3.3RC4 successfully to install on my HP-UX 11.00 server. After a (successfull?) compile, "make install" errors out with this error message: ...
7
by: Darren Gamble | last post by:
Good day, I've sent a message on this to the php-general list already, but unfortunately no one replied. Sorry for the repost. to those that read both... I'm having a problem working with an...
7
by: kecebong | last post by:
I tried to compile php 4.3.3 with gd but it doesn't work, it wasnt show in phpinfo(). My system is redhat 9 and apache 2.0.47 webserver.
0
by: Slavik | last post by:
All libraries were installed (precompiled) This is FreeBSD 5.1 installed zlib, installed jpeg and png libraries (in default directories) GD 2.0.11 source is in /usr/gd-2.0.11 (compiled and...
3
by: Garrett Albright | last post by:
Trying to compile PHP 5 beta 4, and not having much fun... % ./configure --with-apxs --with-mod_charset --with-zlib --with-bz2 --with-curl --with-gd --with-mhash --with-pspell...
0
by: LRW | last post by:
(Not even sure if that's the right way to word the question.) We're trying to migrate to a new server, and upgrade the PHP on the new server in the process. We're using a RedHat Enterprise Server...
9
by: Penn Markham | last post by:
Hello all, I am writing a script where I need to use the system() function to call htpasswd. I can do this just fine on the command line...works great (see attached file, test.php). When my...
3
by: Ron King | last post by:
When I installed Mandrake 10.0 I thought I had Apache, PHP, and MySQL installed correctly. I could serve web pages, MySQL worked, and when I tried the phpinfo() function, I got a page that looked...
13
by: Gary Quiring | last post by:
I need to create an XML string using PHP5. The examples I have followed seem to be using out dated libary calls. I tried new_xmldoc() and new DomDocument. Both get undefined errors. How do I...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.