please, how to promt user in mu sql 2005 script? For example, I need user to
confirm some operations.. .
Thx in advance 10 2334
"fireball" <fi******@onet.kropka.euwrote in message
news:em**********@nemesis.news.tpi.pl...
please, how to promt user in mu sql 2005 script? For example, I need user
to confirm some operations.. .
Unless something has changed in T-SQL 2005 that I'm not aware of, you can't.
Thx in advance
so, I neither I can't call one script from another (from the batch I run),
right?
:(
"fireball" <fi******@onet.kropka.euwrote in message
news:em**********@nemesis.news.tpi.pl...
so, I neither I can't call one script from another (from the batch I run),
right?
No, you can do that.
>
:(
Sql is 4gl and asking it to do 3gl operations like prompts and loops
and if then else logic should be illegal although now allowed.
fireball wrote:
please, how to promt user in mu sql 2005 script? For example, I need user to
confirm some operations.. .
Thx in advance
well,
is that possible at least, to exit script on given condition?
fireball wrote:
well,
is that possible at least, to exit script on given condition?
Do you want a return code or not? If you don't want a return code
then you can wirite:
If <conditionReturn
If you want a return code then you need to use a stored proc and inside
the procedure you can write:
If <conditionreturn 100
In your application you can check for status of the called procedure
and take action based on that.
Uzytkownik "Erland Sommarskog" <es****@sommarskog.senapisal w wiadomosci
RAISERROR('Got a good reson for taking the easy way out now', 16, 127)
Uzytkownik <ot*******@yahoo.comnapisal w wiadomosci
If <conditionReturn
all this hepled. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: danijela.simunovic |
last post by:
Hi!
Is there a way that when I run a "make table query" and an "append
query" that i won't be asked those 2 or 3 questions from access like
:"you are about to run a make table...","the existing...
|
by: Jefferson Cowart |
last post by:
I am writting a program that has a button that a user can click to start
isntalltions of various software across the network. Some of the software is
on a network share that is password protected....
|
by: mattmerc |
last post by:
Hi all,
We have all seen lot of method for exporting datagrids to Excel. I have
a slightly different need. I think it should be easy to accomplish but
I am not sure how. I would like when a user...
|
by: uoL |
last post by:
Hello,
I'd like to know how to prompt two values with prompt(); function.
I need to get things like 'pass' and 'user, 'article' and 'value', etc
... in a document and I dont want to make a...
|
by: Joe |
last post by:
Every time our application starts it prompts the user to allow it access to
the internet because our application is checking for updates. Is there
anyway programically to tell Vista to allow this...
|
by: jeffkatyspanky |
last post by:
I am prompting for the user to enter an IP address and I can't figure out a cleaner way to re-prompt if the user enters something other than a valid IP address. I'd like to just clear the "bad" entry...
|
by: cdm2883 |
last post by:
the first one!
1) takes vaule 1 as a command line parameter
2) takes vaule 2 as a command line parameter
3) outputs a result which adds vaule 1 to itself vaule 2 number of times .
the...
|
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= |
last post by:
I have a asp.net page, it uses js to print in IE.
It always has the prompting user window appear.
I have tried:
<input onclick="document.all.WebBrowser.ExecWB(6,6)" type="button"...
|
by: =?Utf-8?B?QWxoYW1icmEgRWlkb3MgS2lxdWVuZXQ=?= |
last post by:
Hi mister,
I have an Winforms app (Client) and Web app + WCF Services + Windows
Services (Server). In server, I have installed SQL SERVER 2000.
Now, I want create a installer (MSI.exe or...
|
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...
|
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: 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: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |