DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Null errors in simple database, why?

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Oct 2008

Posts: 20

Reputation: Entropy1024 is an unknown quantity at this point

Solved Threads: 0

Entropy1024 Entropy1024 is offline

Offline

Newbie Poster

Null errors in simple database, why?

Oct 13th, 2008

If I create a database that has 3 fileds per record; String1, String2 & ResultString. I want the user to enter in the first 2 strings then the program creates ‘ResultString’ by adding the String2 to String 1 itself.
Ie if you enter Big as String1 and Cat as String2 I want ResultString to be BigCat.
I guess I create a sub that is triggered by a change in either 1 of the 2 user entered fields then execute some code as below:

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Data1.Recordset.Fileds(“ResultString”) = Data1.Recordset.Fileds(“String1”) + Data1.Recordset.Fileds(“String2”)
Data1.Recordset.Fileds(“ResultString”) = Data1.Recordset.Fileds(“String1”) + Data1.Recordset.Fileds(“String2”)

But I get a Null error. What am I doing wrong?
Many thanks for any help.

•

Join Date: Dec 2007

Posts: 45

Reputation: AUGXIS is an unknown quantity at this point

Solved Threads: 11

AUGXIS

Offline

Light Poster

Re: Null errors in simple database, why?

Oct 13th, 2008

hi. i think it is much better that you will use the values of the string1 and string2 for the value of Data1.Recordset.Fileds(“ResultString”). You have not yet save any the data so your values for Data1.Recordset.Fileds(“String1”) and Data1.Recordset.Fileds(“String2”) are both null.

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Data1.Recordset.Fileds(“ResultString”) = string1 + String2
Data1.Recordset.Fileds(“ResultString”) = string1 + String2

•

Join Date: Feb 2007

Posts: 2,104

Reputation: debasisdas will become famous soon enough

Solved Threads: 128

debasisdas debasisdas is offline

Offline

Postaholic

Re: Null errors in simple database, why?

Oct 14th, 2008

you need to update the third field by concatinating field1 and field2

Share your Knowledge.

•

Join Date: Jul 2007

Posts: 300

Reputation: jireh is an unknown quantity at this point

Solved Threads: 42

jireh

Offline

Posting Whiz

Re: Null errors in simple database, why?

Oct 14th, 2008

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Data1.Recordset.Fileds(“ResultString”) = Data1.Recordset.Fileds(“String1”) + Data1.Recordset.Fileds(“String2”)
Data1.Recordset.Fileds(“ResultString”) = Data1.Recordset.Fileds(“String1”) + Data1.Recordset.Fileds(“String2”)

AUGXIS is correct. If youre trying to save the records in the database use the existing data...

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
With Data1.Recordset
       .Addnew
       .Fields("String1") = "Big"
       .Fields("String2") = "Cat"
       .Fields("ResultString") = "Big" & "Cat"
       .Update
End With
 
or...
 
With Data1.Recordset
       .Addnew
       !String1 = "Big"
       !String2 = "Cat"
       !ResultString = "Big" & "Cat"
       .Update
End With
With Data1.Recordset
       .Addnew
       .Fields("String1") = "Big"
       .Fields("String2") = "Cat"
       .Fields("ResultString") = "Big" & "Cat"
       .Update
End With

or...

With Data1.Recordset
       .Addnew
       !String1 = "Big"
       !String2 = "Cat"
       !ResultString = "Big" & "Cat"
       .Update
End With

Last edited by jireh; Oct 14th, 2008 at 9:14 am.

A conclusion is the place where you got tired of thinking.
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4

•

Join Date: Apr 2008

Posts: 53

Reputation: hell_tej is an unknown quantity at this point

Solved Threads: 2

hell_tej

Offline

Junior Poster in Training

Re: Null errors in simple database, why?

Oct 15th, 2008

Just Try this i think it's works

Data1.Recordset.Fileds(“ResultString”) = Data1.Recordset.Fileds(“String1”) & "" + Data1.Recordset.Fileds(“String2”) & ""

•

Join Date: Jul 2007

Posts: 300

Reputation: jireh is an unknown quantity at this point

Solved Threads: 42

jireh

Offline

Posting Whiz

Re: Null errors in simple database, why?

Oct 16th, 2008

hell_tej it cant be... null value will be returned from

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Data1.Recordset.Fileds(“String1”) & "" + Data1.Recordset.Fileds(“String2”) & ""
Data1.Recordset.Fileds(“String1”) & "" + Data1.Recordset.Fileds(“String2”) & ""

because it's a new record and not yet inserted/saved in the database.

•

Join Date: Feb 2007

Posts: 2,104

Reputation: debasisdas will become famous soon enough

Solved Threads: 128

debasisdas debasisdas is offline

Offline

Postaholic

Re: Null errors in simple database, why?

Oct 16th, 2008

then why not insert the third field also by concatinating the 1st and the 2nd value . still you have to enter 2 values only.

Share your Knowledge.

•

Join Date: Oct 2008

Posts: 20

Reputation: rstkw is an unknown quantity at this point

Solved Threads: 2

rstkw

Offline

Newbie Poster

Re: Null errors in simple database, why?

Oct 25th, 2008

There's another problem you can run into that will give a Null error. If one field is empty there is nothing to concatenate. So how do you check for that? If you read the textbox into a text variable and check for Null, it will never be Null because it is a string type. IsNull only works with variants, I think. So assign the .text from the textbox to a variant and use IsNull. If the .text is not Null, you can use it as-is, or re-assign it to a string variable. If it IsNull, replace it with "" and go on.