env: sql server 2000
objective:
add a formula for an INT column to the FORMULA field or the DEFAULT
VALUE field in DESIGN VIEW.
all of the following attempts failed
IIF (columnName = 0, "1", columnName + 1)
IIF (columnName = 0, 1, columnName + 1)
IIF (0, "1", columnName + 1)
caveat: cannot use IDENTITY
REASON: I'd like have sets of repeatable values for this row, e.g.
set a
1 -- row 1
2 -- row 2
3
4
5
set b
1 -- row 6
2
3
set c
1 -- row 9
2
3
4
Underlying rationale is to support OO design I understand probably it's
going to be huge headache for lots of people down the road but ...
TIA. 3 1169
NickName (da****@rock.com) writes: env: sql server 2000
objective: add a formula for an INT column to the FORMULA field or the DEFAULT VALUE field in DESIGN VIEW.
all of the following attempts failed IIF (columnName = 0, "1", columnName + 1) IIF (columnName = 0, 1, columnName + 1) IIF (0, "1", columnName + 1)
I will have to admit that I don't understand much of your post.
IIF is Access/VB, but I guess you know that.
In case not, the syntax in SQL server is
CASE WHEN columnName = 0 THEN 1 ELSE columnName + 1 END
Then again, this can be simiplied to:
columnName + 1
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Oops, haven't touched db for a couple of months, now it seems that I
totally forgot everything or mix everything. Ok, joke aside, case stmt
does not seem to work, strange.
Ahe, because of the default NULL value. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ernie |
last post by:
Hi,
I spent more than an hour wondering why the following works in my
Python 2.3.4 Linux box:
formula = """
def dummy():
print "This is Ok!"
"""
|
by: Andreas Schmitt |
last post by:
Hi,
Sorry for posting in German before, totally forgot about that when I was
pasting this in here from another German newsgroup I was writing to, trying
to get help
I am programming a simple...
|
by: Roy |
last post by:
Ok, here's my problem and I'm a first year webbie, so you'll have to
bear with me. I'm converting some Access reports over to a .NET
website. It's your typical Access cluster$#@$ (pardon my...
|
by: Wade |
last post by:
Hi guys,
I am building a string in code that is a mathematical formula, based on a
lot of criteria specified by the user. Once the formula is complete, I want
to evaluate it to get a result. ...
|
by: Brian VanPelt |
last post by:
I am not a very experienced VB user, but I was trying to make a form
that a user could input a formula for summation.
For example, I would like the user to input the beginning and end
values of...
| |
by: nedian |
last post by:
Hello
I am student and trying to learn access.I am having problem in making a program can any one help me?
i wanted to make 2 tables in access and then create a link.First i am telling u what...
|
by: Tony |
last post by:
I'm trying to create a formula in dot net to achieve the following:
Input: Output:
1 1
2 1
3 1
4 4
5 4...
|
by: mukesh |
last post by:
One another problem
I have used a formula in the calculated field of a query as -
IIf( <=, (IIf(<=, , ), (IIf (<=, , ))
the above formula is working properly to give the lowest of , and ...
|
by: chethan |
last post by:
hai every body,
i am working as a SAP Business one developper using vb.net as a 3ed party application language and sql 2000 as back end,
my problem is to calculate the value of a formula...
|
by: JHaworth |
last post by:
Hi,
Please could someone point me in the right direction with a formula I am trying to create which will enable me to calculate a Net IRR for a series of data?
My Problem:
•My formula in...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
| |
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 ...
| |