Hello,

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.


~~ Tc

Hello,

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

Regards
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

Hello,

Im using SQL, that explenation will be adequate. And yes, I'll post my code when I have most of the kinks worked out.

~~ Tc

Hi,
Using IS operator u can check for balnk values in any type of column.
eg:-
select sal from emp where ename is null;

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.


~~Tc


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: "".

Good luck.