Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
not null default value set automatically
I thought the whole point of "not null" is to prevent records from being inserted w/o missing key information. The default is to allow nulls to be inserted into the record. I'm looking for the opposite effect. -
how do I make not null work
How do I make mysql enforce not null for columns in tables? I think it's an admin setting... -
not null default value set automatically
Here's my problem: Create table my_table ( ... locationid int not null); When I execute the above, mysql automatically assigns a default value of 0. therefore, locationid can never be null! What is going on? -
using datagrid control to pick a record
I have a form which searches for a customers' last name in a table. The result of the search goes to a datagrid control. How do I retrieve the value of the bound column (i.e. customerid)? The bookmark property only returns the absolute position of the record.- fwonny
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
mysql auto increment problem
I have an access 2000 form linked to several mysql tables. These tables have auto increment fields (int,11). However, these auto increment fields do not behave like the access autonumber field. In my bound form, the auto id field will not provide a unique number to the user nor to the child...- fwonny
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
I have an access 2000 form linked t
I have an access 2000 form linked to several mysql tables. These tables have auto increment fields (int,11). However, these auto increment fields do not behave like the access autonumber field. In my bound form, the auto id field will not provide a unique number to the user nor to the child...
