Hello,
Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like
PL/SQL
Thanks a lot 5 1839
Yes, conditional expressions are possible in Access. For instance, there are
the Choose, IIf and Case functions. Note, however, that if you're trying to
get at the data from outside of Access, you can't use functions such as
this.
Sorry, I have no idea what you mean instead of "bucles".
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Jero" <jz*********@ono.com> wrote in message
news:gH******************@news.ono.com... Hello, Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like PL/SQL Thanks a lot
Sorry, what I want to say is loops, while, for ..etc.
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> escribió en el
mensaje news:q4********************@rogers.com... Yes, conditional expressions are possible in Access. For instance, there are the Choose, IIf and Case functions. Note, however, that if you're trying to get at the data from outside of Access, you can't use functions such as this.
Sorry, I have no idea what you mean instead of "bucles".
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jero" <jz*********@ono.com> wrote in message news:gH******************@news.ono.com... Hello, Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like PL/SQL Thanks a lot
No, Access queries don't allow you to have loops in them. You'll have to use
VBA to do that sort of stuff.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Jero" <jz*********@ono.com> wrote in message
news:m6*****************@news.ono.com... Sorry, what I want to say is loops, while, for ..etc.
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> escribió en el mensaje news:q4********************@rogers.com... Yes, conditional expressions are possible in Access. For instance, there are the Choose, IIf and Case functions. Note, however, that if you're trying to get at the data from outside of Access, you can't use functions such as this.
Sorry, I have no idea what you mean instead of "bucles".
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jero" <jz*********@ono.com> wrote in message news:gH******************@news.ono.com... Hello, Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like PL/SQL Thanks a lot
"Jero" <jz*********@ono.com> wrote in message news:<gH******************@news.ono.com>... Hello, Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like PL/SQL Thanks a lot
You can have loops in SQL within SQL Server, using cursors.
HTH
Edward
--
The reading group's reading group: http://www.bookgroup.org.uk
Thank you.
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> escribió en el
mensaje news:bK********************@rogers.com... No, Access queries don't allow you to have loops in them. You'll have to use VBA to do that sort of stuff.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jero" <jz*********@ono.com> wrote in message news:m6*****************@news.ono.com... Sorry, what I want to say is loops, while, for ..etc.
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> escribió en el mensaje news:q4********************@rogers.com... Yes, conditional expressions are possible in Access. For instance, there are the Choose, IIf and Case functions. Note, however, that if you're trying to get at the data from outside of Access, you can't use functions such as this.
Sorry, I have no idea what you mean instead of "bucles".
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jero" <jz*********@ono.com> wrote in message news:gH******************@news.ono.com... Hello, Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like PL/SQL Thanks a lot
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: FHuang |
last post by:
Ok, I'm having some trouble with conditionals, for some reason PHP is screwing them up.
First off, here is the code:
<?php
$username = "fred";
$userdata = "./$username.txt";
$fp =...
|
by: Joshua Ginsberg |
last post by:
Is there any plan to include inline conditionals in Python? For example:
def isNegative(x):
return x < 0 ? True : False
Thanks!
-jag
--
|
by: Paul Dale |
last post by:
Hi All,
I know that several of you will probably want to reply "you should write
a parser", and I may. For that matter any tips on theory in that
direction would be appreciated.
However, if...
|
by: steven |
last post by:
Is it possible to combine conditionals to call out data?
I have a list of records that include a date. I can call out all dates
after the date after tomorrow:
IIf(Date()+1)<,...,...
And I can...
|
by: Leon Lambert |
last post by:
I would appreciate it if someone could help me understand NaN handling
with respect to conditionals in IL code. I am playing with a small IL
interpreter and having a little problem with it....
| |
by: .Net Sports |
last post by:
I need to convert some C# ?Conditionals over to vb.net (most likely in
vb.net using If..Then statements), but the C#2VBNETconverter by
KamalPatel isn't converting them:
string PurchaseType =...
|
by: Hul Tytus |
last post by:
comp.lang.c
c programs & shell conditionals
How is a unix shell script made to respond to the value returned
by a program compiled from c code?
The shell script below is my current effort,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |