is there a max int constant?

Posted on 2009-07-15
Last Modified: 2013-11-05
is there a predefined "constant" for the maximum integer value? I'd like to do something like: update myTable set myIntCol = #maxIntVal
Question by:jmarkfoley
LVL 142

Accepted Solution

Guy Hengel [angelIII / a3] earned 500 total points
ID: 24863368
LVL 60

Expert Comment

ID: 24863385
Nope, there isn't.  But, you can create yourself a table and pull the value(s) you need from that....shoudl be easy enough to do.
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24863464
or update with   '2147483647' which is the maximum an integer variable can store
LVL 60

Expert Comment

ID: 24863484
Im sure the user knows the value, but doesn't want to have to remember it.....pulling from a table seems like an easy solution.

Author Closing Comment

ID: 31603946
Bummer :(  Thanks.

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now