Dealing With Nulls and SQL

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Dealing With Nulls and SQL

Message

From

18/06/2002 12:42:00

18/06/2002 12:20:21

General information

Forum:

Visual Basic

Category:

Database DAO/RDO/ODBC/ADO

Title:

Miscellaneous

Thread ID:

00669800

Message ID:

00669811

Views:

you may try these shorter syntax:

Loading Values

cboGender.Text = RSLoadData.Fields("GenderDesc") & ""

Saving Values

 Then
RSSaveData.Fields("StreetAddress2") = iIf (Trim$(txtStreetAddress2.Text) <> "", txtStreetAddress2.Text, vbNullString)

Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com