RunSQL INSERT

[sstreet]

I am trying to run an insert query using the following code:

DoCmd.RunSQL "INSERT INTO Software ( PCID, Name, Version ) VALUES ( '" & Me.txtPCID & "', '" & CStr(lngSoftware) & "', '" & CStr(lngVersion) & "');"

The program loops through the registry extracting software information and runs the query after each loop. The query works but only inserts data where all the fields contain values.

Any ideas how I can get around this?


Thanks in advance.

 

[FLabrecque]

Do your fields from the SOFTWARE table accept Null values?

 

[WayneRyan]

s,

You have to either get the table in Design View and allow for Null values.

Or you can use the Nz() function to provide a suitable default value.

Wayne

 

[sstreet]

The table does accept null values, but I think the query only inserts a record if all the fields have a value.

 

[sstreet]

Resolved

Thanks, I used the Nz() function when looping through the registry.

 

[modest]

for future reference, it's just good programming etiquette to put your SQL statement in it's only string variable.

this provides for several things: it increases readability, it helps make your code adaptable, it helps reduce reader seek/debug time.

in such a short snipet as this is, readability is not a problem, but still, it's good practice none the less =)


Glad to see the Nz() function, that wayne suggested, worked for you