By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,095 Members | 1,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,095 IT Pros & Developers. It's quick & easy.

need to delete dataset

P: 7
I'm a vb newbie and I successfully added a dataset to my program, then I closed it down. Next day, I didn't realize I had to actually go in and start it, so when nothing was working, I entered a new connection. Then realized my error. Now I have 2 datasets in the program, both connections are pointing to the same thing. How can I get rid of one of them.

Also, while I have your attention. I added a column to the one dataset called fullName. I want to concatenate first name and last name together to fill this field. The book says go to the Expression property and add lastName+', '+firstName. That sounds easy enough, except the fields in this database seem to be Last Name and First Name. I've never worked with any database that allows spaces between words on a column. Is that allowed in VB? How can I fix that? I keep getting the error: Syntax error: Missing operand after 'name' operator.

Any help would be greatly appreciated.
Mar 22 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 5K+
P: 8,434
I'm a vb newbie and I successfully added a dataset to my program, then I closed it down. Next day, I didn't realize I had to actually go in and start it, so when nothing was working, I entered a new connection. Then realized my error. Now I have 2 datasets in the program, both connections are pointing to the same thing. How can I get rid of one of them.

Also, while I have your attention. I added a column to the one dataset called fullName. I want to concatenate first name and last name together to fill this field. The book says go to the Expression property and add lastName+', '+firstName. That sounds easy enough, except the fields in this database seem to be Last Name and First Name. I've never worked with any database that allows spaces between words on a column. Is that allowed in VB? How can I fix that? I keep getting the error: Syntax error: Missing operand after 'name' operator.
I can't help with the first problem, but the second one sounds as though (if it's an MS Access database) you probably need to put square brackets around the field names. For example...
[Last Name]+', '+[First Name]
Mar 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.