Solved

How to make a MS Access field 'Allow Zero Length' = true

Posted on 2004-09-10
6
344 Views
Last Modified: 2010-04-05
How to make a MS Access field 'Allow Zero Length' = true from delphi
in CREATE database dunction?
0
Comment
Question by:djuzoran
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 12025222
You mean a Text field?
If you do not specify nothing it is intended as it can accept zero length, otherwise it must be declared as Not Null

for example:

create table MyTable(MyField Text(10), //accept zero length
                               MySecondField(19) not null, //value is required
                               MyThirdField Integer);

0
 

Author Comment

by:djuzoran
ID: 12025233
So
MyField Text(10)

is not the same as

MyField Varchar(10) ?

0
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 12025267
Yes it's the same, btw forgot mi last comment, it's about required property, not zero length, sorry
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:djuzoran
ID: 12025293
So what should i write for nullable and zero length column?

0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 125 total points
ID: 12025329
0
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 12025346
Well i was looking at it at all but look at here also http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ217156
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

759 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