Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ADO and Autoinc

Posted on 2004-08-18
2
Medium Priority
?
296 Views
Last Modified: 2010-04-05
I am using MQ SQL and Access tables. In MS-SQL, I use the identity clause with a LongInt to allow for autoincrementing. When I use Access, I use the AutoInc datatype.

I would like to use either Access or MS-SQL tables from within my program. However, the datatypes are stored differently within the form. Depending on the database used, one is stored AutoInc and the other is LongInt.

Is there anyway to rectify this problem? (i.e. can I make Delphi think they are both LongInt without losing the AutoInc capability?)
0
Comment
Question by:CalvinDay
  • 2
2 Comments
 
LVL 13

Accepted Solution

by:
BlackTigerX earned 1000 total points
ID: 11836576
you can treat both of those ase LongInt in your Delphi code
0
 
LVL 13

Expert Comment

by:BlackTigerX
ID: 11836610
AutoInc field is actually defined as:

TAutoIncField = class(TIntegerField)
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

972 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