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

Data Updating

Ali Rizwan
100+
P: 927
Hi,
I have build a software for a school.
I want to update students automatically after a year.
For example:
Play Group to Nursery
Nursery to Prep
Prep to One
One to Two
etc.
But the problem is that numeric are updated successfully but alphs like "Play Group" etc are directly updated to class one.
I don't understanding such problem.
Thanks.
Sep 20 '07 #1
Share this Question
Share on Google+
6 Replies


debasisdas
Expert 5K+
P: 8,127
Have you implemented the logic at database level or at VB itself ?
Sep 20 '07 #2

Ali Rizwan
100+
P: 927
Have you implemented the logic at database level or at VB itself ?
Actually i have made a kiddy code for this purpose, and it is on vb not to database. everything is going good but the classes named alphabetically updated directly to 1.
Sep 21 '07 #3

Expert 5K+
P: 8,434
I think you need to show us how you're doing the update. At a guess, your alphas are being converted to a numeric value, which would yield zero, then you're adding 1.
Sep 21 '07 #4

debasisdas
Expert 5K+
P: 8,127
It seems there is some logical error.

You need to recheck your code.
Sep 21 '07 #5

Ali Rizwan
100+
P: 927
I think you need to show us how you're doing the update. At a guess, your alphas are being converted to a numeric value, which would yield zero, then you're adding 1.
It sounds great converting or assigning a specific number to alphas.
I try this.
Thanks Killer
Sep 21 '07 #6

Ali Rizwan
100+
P: 927
It seems there is some logical error.

You need to recheck your code.
I have checked my code various time. But I have not found any error.
I think Killer's Idea is the great let me check that one, otherwise I'll tell you later.
Thanks a lot debasis.
Sep 21 '07 #7

Post your reply

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