I'm working through the Beginning Visual Basic SQL Server 7.0 book, and have stumbled across a problem with one of the exercises in chapter 10.

I'm trying to add the stored procedure for up_parmins_employer_information but SQL keeps giving me an error.

It's falling over on: Select @Continue = 1
The error message is: Msg 156, level 15, state 1, procedure up_parmins-employer_information, line 21 incorrect syntax near the keyword 'Select'

Can anyone help please? :(

no worries sorted it out, there was a , after the last declare.

HELP STILL Struggling with Chapter 10!!

I'm now having problems with the phone number and area code's not populating on the address details, when you action the cboLastName_Click()

I have the line's of code as per the book...

'Load phone number fields
   txtAreaCode.Text = m_objRSAddress!Area_Code_SI
   txtPhoneNumber.Text = _
      Format(m_objRSAddress!phone_number_in, "###-####")

but when you hover over m_objRSAddress!Area_Code_SI I'm getting the error message:
"Item cannot be found in the collection corresponding to the requested name or ordinal." The textboxes for Phone number and area code just aren't populating. What is wrong??

Thanks