Edit data within a SQLite database

Completato Pubblicato Jun 29, 2011 Pagato alla consegna
Completato Pagato alla consegna

*** FYI, I already have a freelancer lined up for this project. Bids from others will not be considered, sorry.***

This project is fairly simple. I am using an application called Homebase which stores data in a SQLite database. Some time ago I upgraded Homebase from version 2.3 to version 3.0. I was able to import the data from the old version into the database for the new version but the invoice numbers were imported incorrectly. The old invoice #'s had 3 digits, they were numbered from 101 to 562. The invoice numbers in the new version of homebase have 6 digits ... since I've been using it I have entered invoices 000563 through 000811. What I need is for the three zeros to be added to the invoice numbers for invoice 101 to 562 so that they become 000101 through 000562.

Thank YOU

SQL

Rif. progetto: #1114129

Info sul progetto

4 proposte Progetto a distanza Attivo Jun 29, 2011

Assegnato a:

ajaymalloc

Got the expertise in SQLite. Pls check the PM. Regards,

$72 USD in 1 giorno
(0 valutazioni)
1.7

4 freelance hanno fatto un'offerta media di $41 per questo lavoro

polaris222

Hello, sir. It's quite easy. And I can do it. I'll wait for you. I'm ready. Please call me.

$50 USD in 0 giorni
(0 valutazioni)
0.0
CreditGroup

please check pm

$30 USD in 0 giorni
(0 valutazioni)
3.4
smohamedanis

Check my pm

$30 USD in 0 giorni
(0 valutazioni)
0.0
omarend

necesary implement a query for upgrade this problem.

$30 USD in 1 giorno
(0 valutazioni)
0.0