multiple update in one trip
-
how can i do mulitple update in one trip back to the server Love you all
-
how can i do mulitple update in one trip back to the server Love you all
i'm not getting your problem:suss: please explain your problem in detail so that if possible i can help you.
-
how can i do mulitple update in one trip back to the server Love you all
1. this is a repost 2. this is a cross post 3. this is not possible X|
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VisualCalc 3.0] -
1. this is a repost 2. this is a cross post 3. this is not possible X|
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VisualCalc 3.0]May be it is possible?? I saw in an article that you can execute several queries by separating several sql statements with a ';'. You may want to try that. Example: update users set name = 'someone' where id = 1 ; update addresses set address = 'someplace' where id = 1 By the way, this should be found / asked in SQL / ADO.NET Message board. daniero -- modified at 10:25 Tuesday 17th January, 2006
-
May be it is possible?? I saw in an article that you can execute several queries by separating several sql statements with a ';'. You may want to try that. Example: update users set name = 'someone' where id = 1 ; update addresses set address = 'someplace' where id = 1 By the way, this should be found / asked in SQL / ADO.NET Message board. daniero -- modified at 10:25 Tuesday 17th January, 2006
what's that crap ? the ';' is only the ending character for sql statements. never this will be once statement... one more thing. you told this to me but i'm not the one who asked the question, and if you had read mine, you'd seen that this is a repost (which means the question was already posted) and a cross post (which mean the question has been asked another forum)...
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...] -- modified at 11:47 Tuesday 17th January, 2006 -
what's that crap ? the ';' is only the ending character for sql statements. never this will be once statement... one more thing. you told this to me but i'm not the one who asked the question, and if you had read mine, you'd seen that this is a repost (which means the question was already posted) and a cross post (which mean the question has been asked another forum)...
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...] -- modified at 11:47 Tuesday 17th January, 2006Oh sorry, I told that to you, I just wanted to give an answer to the user of the question, I didn't see it was to you I was replying to. This is the article I'm talking about: ADO.NET for the Object-Oriented Programmer[^] In the Loading Hierarchical Data section. Sorry for the misunderstanding daniero -- modified at 10:32 Tuesday 17th January, 2006
-
Oh sorry, I told that to you, I just wanted to give an answer to the user of the question, I didn't see it was to you I was replying to. This is the article I'm talking about: ADO.NET for the Object-Oriented Programmer[^] In the Loading Hierarchical Data section. Sorry for the misunderstanding daniero -- modified at 10:32 Tuesday 17th January, 2006
arf, you didn't undertand me. of course it is possible to place a ';' between 2 sql queries but it will actually result into 2 effective statements, not once ! and you could write like this, 3, 4 and more more queries, for the simple reason that ADO.NET don't analyse the SQL query and calling then the sql server ; it does pass the whole string to the server, ,and the server parses it. this is a sql problem, not an ADO, ODBC, or whatever one...
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...] -
arf, you didn't undertand me. of course it is possible to place a ';' between 2 sql queries but it will actually result into 2 effective statements, not once ! and you could write like this, 3, 4 and more more queries, for the simple reason that ADO.NET don't analyse the SQL query and calling then the sql server ; it does pass the whole string to the server, ,and the server parses it. this is a sql problem, not an ADO, ODBC, or whatever one...
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]roger daniero
-
roger daniero
-
I think you are annoyed with that other person, I don't want to be a nuisance as well, we are here just to help each other / other people, not to create problems between us. So 'Roger' meant I understand what you meant. daniero
-
I think you are annoyed with that other person, I don't want to be a nuisance as well, we are here just to help each other / other people, not to create problems between us. So 'Roger' meant I understand what you meant. daniero
daniero wrote:
So 'Roger' meant I understand what you meant.
ok, didn't know that
daniero wrote:
we are here just to help each other / other people, not to create problems between us.
there's no problem, i just found that you talked about something you didn't really know, or you express it a bad manner, that's all. nevermind, :rose:
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...] -
May be it is possible?? I saw in an article that you can execute several queries by separating several sql statements with a ';'. You may want to try that. Example: update users set name = 'someone' where id = 1 ; update addresses set address = 'someplace' where id = 1 By the way, this should be found / asked in SQL / ADO.NET Message board. daniero -- modified at 10:25 Tuesday 17th January, 2006
Multiple statements (batches) work in SQL Server, but not in Access databases. Jet doesn't support them. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome