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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Inserting a null value?
insert into STUDENT (Last_Name,Email_Address,First_Name,Sex,Address,Race,City,Ty pe,State,Evaluation,Zip,Recom_Action,Telephone,Refer_Divisio n,MAJOR_GROUP,HIRING_STATUS,Degree,Employee_Number,Graduatio n_Date,Comment) values ('Schmo','','Joe','','','','','','','',NULL,'','','','','','...- bigtrick
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Inserting a null value?
keep in mind, all this is via an sql statement that my java server page passes to access....- bigtrick
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Inserting a null value?
Nope, using "vbNull" doesn't work. And zero-length strings are what got me into this mess.... i can insert them, but it messes up the joins that i have going in a separate recordset. There's got to be some way just to tell access to make it null..... right?- bigtrick
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Inserting a null value?
Hey, I'm trying to insert a row into an access database. problem is, how do i get one of the fields to insert as a null value? i'm using java server pages, and the way i have it set up it's not possible for me to "skip" a field - that is, the JSP must insert a value for every field...- bigtrick
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
