var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do I Check for null fields?
Im working on an administrator utility for a database, and I need to know a way for a just-created database to detect first-time run. If that is true, then my program will ask that the administrator enter their new password. But what I need to know is how to detect a blank field in SQL.
normally you can use IS NULL - means
SELECT * FROM table WHERE field IS NULL
or in procedures
IF(var IS NULL) THEN
But this depends on the database and the language that you use. Please give me hint which database you ar using.
You are developing an adminstration software for relational databases. Can I see your work ? I am very interested in such programs
Im using SQL, that explenation will be adequate. And yes, I'll post my code when I have most of the kinks worked out.
Using IS operator u can check for balnk values in any type of column.
select sal from emp where ename is null;
Bam! 'er somethin'
It would be better if everyone could stick to
VB code please, Im having trouble understanding the relationship between the VB code and the SQL statements.
Ps. Thanks robert.
Blank and NULL are 2 different creatures. In VB to test for null - use the ISNULL function. If you are looking for an empty string then use: "".