Change Data Format In A Db Column On Next App Version

Let's say in version 1 of my app, i've got a x, with a column y, that lists integers:

Y 1 2 3 4 5.

The database version is also 1. Users can add or remove from y as they see fit (through the app).

Now, in the next version of my program-2-suppose i changed my mind, and now i want y to only contain roman numerals:

Y i ii iii iv v.

Again, users can add or remove rows from y as they want.

The problem, however, is that the version 1 information is still there. As a user inserts information, the database becomes a mix of old and new formats:

Y 1 2 3 4 5 vi vii viii

Am i totally screwed here? What i'm looking for, basically, is an upgrade script to run over the database, on the next install-but only if a prior install already exists. Users of version 2 won't need anything done, as their program is already set for the new version. Is it optimal to copy the database, change its version, and reinsert the rows, applying an algorithm on the column?

View Full Post With 2 Replies

Related Forum Messages:

Please Follow Index to Quick Jump to the Message.

Premium Version Of Mixzing Allow To Edit Tags On Songs In .wma Format

Does the premium version of mixzing allow you to edit tags on songs in the . Wma format? The free version gives me a message that only . Mp3 songs can be edited and i want to confirm whether i will be able to edit before i purchase.

Posted On: 10-21-2010, 01:13 PM . View Related Posts . . View 1 Replies .

Change Format Of Chronometer

One of my problem is of changing the format of chronometer in android.
I have the problem that chronometer shows its time in 00:00 format and i want it to come in 00:00:00 format. Does anyone knows the answer?

Posted On: Nov 11 at 8:33 . View Related Posts . . View 1 Replies .

Change Gmail Calendar Date Format From Us To Uk

I'm starting to use the gmail calendar more now i have a g1 - on the web my calendar is setup in uk date format (dd/mm/yyyy) but on my g1 it's showing in us format (mm/dd/yyyy). Is there a way to change the settings for the g1?

Posted On: 2009-03-26 . View Related Posts . . View 6 Replies .

Source Code To Display Data In Tabular Format In Droid?

I am new to android, now i am working on some database sample programs.
Now i have a problem in displaying the data retrived from database in
A tabular format. If anyone know the answer me with the source code.

Posted On: Jun 2 09 at 10:42 . View Related Posts . . View 1 Replies .

Layout - Making Three Tables With One Column

I need to represent the following diagram: each x will be an image button. I was thinking of making three tables with one column each and have each cell height be half the height of the table. The problem is that the table needs to be able to stretch or shrink because i am worried about getting everything on the screen and the tables are the only part that can change size and have the entire thing still look ok. The problem i am having is that the rows are only as big as the image buttons. While all the image buttons are the same size, the left and right table in particular, need to have some padding around the image buttons to make it alright. I would add margins to the buttons but that defeats the reshaping problem i am having. I think.

Posted On: Nov 5 at 18:32 . View Related Posts . . View 3 Replies .

Deal With Media _ Its File Format And Convert Into Dlna File Format?

We are developing plugins which convert media file as the source and convert in to other format that can be used by dlna compatible device in android.

Any help on how to deal with media and its file format and convert into dlna file format.

Posted On: Sep 10 at 5:29 . View Related Posts . . View 1 Replies .

Retriev Time Format (24h , 12h) From Within Droid App

Is there a nice way to retriev the time format e.g. 24h or 12h from within an android app?

Posted On: Oct 19 at 11:07 . View Related Posts . . View 1 Replies .

Current Version Of Floating Image (version 2.5.0, Code 36) Randomly Crashes Nexus 1 / Fix It

The current version of floating image (version 2. 5. 0, code 36) randomly crashes nexus one phones. Obviously i'm looking into fixing this problem, but i though it would be prudent for me to report this. It's always a problem if you can crash the phone. As i'm working with opengl i'm guessing this is the problem, as i'm working directly with the hardware. When the phone crashes it hangs for a couple of minutes, being very chatty in the log, and then reboots. I will post the log after the next crash.

Not sure if this will be useful or not, but i thought i ought to report it.

Posted On: Aug 15 . View Related Posts . . View 5 Replies .

Htc Incredible - Camera App To Format 4x5 , 4x6 - 5x7 Crops

Is there a camera app that will take pictures in 4x5, 4x6 or 5x7 crops? This 4:3 and widescreen format for taking pictures is garbage and makes no sense to a professional photographer like me.

Posted On: 06-23-2010, 04:01 PM . View Related Posts . . View 1 Replies .

Best Practises To Have More Than One Version Of An App In Market

Any idea how to go about having a free version of an application in the market and a paid version also?

Is it advisable to use the same package name? Different package names would mean code changes just for the sake of the name. Using the same package name, if at all allowed by the market, would mean that queries to the market would show both versions. That would be confusing if the installed app shows that there is an update, but for both versions?!

Two branches in the repository and merging the restrictions of the free edition into the branch of the free edition?

How do you guys are doing it?

Posted On: Feb 11 2009 . View Related Posts . . View 2 Replies .

Determine Version Of Droid That An App Running On

Is there any way to determine the version of android that an app is running on?

The reason being my latest idea was to turn off my on-screen keypad when running on cupcake. The problem is the firmware version shown on the about screen comes from android. Os. Build. Version which appears to be a private api.

Does anyone know anywhere else it can be obtained from in an approved manner?

Posted On: Apr 3 2009 . View Related Posts . . View 8 Replies .

Get Installed App's Latest Version From Market

Are there any ways i could use to get the installed app's latest version from market? Just like some version tracking app.

Posted On: Aug 23 . View Related Posts . . View 8 Replies .

Start Droid Market With Full Version Of My App Displayed?

I'm developing a lite version for an app on the android. How can i start an intent to open the android market, preferably with the full version of my app displayed? This is difficult to test on an emulator (which is the closest thing to a device i have), as there seems to be no legal way of installing the market on it.

Posted On: Dec 27 09 at 0:57 . View Related Posts . . View 1 Replies .

Easymoney App Force Closes / Get It Back To Full Version

So i tried to log in to my easymoney app and it force closes. I log in again and all my data had been cleared and am now running the trial version again. I paid for the upgrade. Is there any way to get it back to the full version? I don't have the upgrade code anymore due to the fact that i bought months ago and didn't i would need it anymore.

Posted On: 10-13-2010, 09:44 PM . View Related Posts . . View 1 Replies .

Could Release New Version Of App Under New Name / Port Existing Users For Free

I ask this because my laptop was stolen along with my signing keys! I know i should have backed up - but the last thing i expected last friday was for burglars to break into my house and steal my laptop (and most of my other electronics & jewellery) - lesson learnt, but i need to plan what to do next!

Posted On: Mar 18 2009 . View Related Posts . . View 4 Replies .

Can Release Updated Version Of App With Lower Min Sdk

We have an app thats running on 1. 6 and higher but we want it to be able to run on 1. 5 also. So i tested the app with 1. 5 and everything works fine. So if i want to release this app can i release it as an update for my older app with just changing.

Posted On: Apr 1 . View Related Posts . . View 14 Replies .

Can't Sign Droid App Lite Version With Same Private Key / Create Another For It

I just signed my paid app and now i want to sign a lite version of it with the same private key. My problem now is that, am receiving this error:

Jarsigner: unable to open jar file.

Do i have to create another keystore for it? Or is the problem coming from the fact that i am saving it as a different file name? What can i do?

Posted On: Nov 19 at 18:57 . View Related Posts . . View 1 Replies .

Name Of App That Allows To Take (picture , Book Cover, E-book Format)

I know that there is this cool application out where it is possible to take a picture og e.g. A book cover and then the mobile finds the particular book for one in e.g. A e-book format. What is the title of this application?

Posted On: 01-08-2010, 10:34 AM . View Related Posts . . View 4 Replies .

Text Size Of Nba Gametime Lite(free Version) App Super Small / Why Is So

I just got my droid phone, i downloaded this app and it works fine but once you go try to look at stats for a exact team, the text size is super super small. Not sure why, my brother has g1 and its not like tat for em.

Posted On: 11-12-2009, 09:25 PM . View Related Posts . . View 1 Replies .

Samsung Behold 2 - Google Maps - Phone Won't Let Me Update App To Version Has Nav / Fix It

I had a my touch and used google maps for nav but my behold 2 wont let me update the app to the version that has the nav. Any help would rock!

Posted On: 01-07-2010, 12:38 PM . View Related Posts . . View 7 Replies .

Looking For An App To Change Backlight For A Certain Program

I have the droid, but i'm looking to see if there is a program out there that can change the backlight for a certain program. Example. When i stream pandora, i would like to have the backlight kept on (but not at full power) but i only want it to affect that app. Basically, i'm wondering if there is an app that can keep the backlight on and adjust brightness only on the apps that i want it to.

Posted On: 11-12-2009, 01:31 AM . View Related Posts . . View 1 Replies .

Change Password In K-9 Email App

I've looked over the forum and searched the web, to no avail.

Does any kind soul know how to change the password of an email account in the k-9 email app?

Posted On: 08-26-2010, 12:07 PM . View Related Posts . . View 2 Replies .

App To Change Sounds For Incoming Emails And Sms

Is there an app that can do that.

Posted On: 03-16-2010, 04:27 PM . View Related Posts . . View 5 Replies .

How To Use Of Camera App To Change Exif Information

Currently, i want to fix the camera apk to make the image attached the gps information. But i find there are some problems.

1. First, we can't change the exif information. According to, i modified some codes of libexif(external/jhead/main. C). Now, it will show the gps information.

2. But, when i try to modify the gps information of exif, i failed to update this information to that image.

"My questions is how i could use the exifinterface. Java of camera app to change the exif information. "Please give me some advices. Btw, does exifinterface. Java use the android/external/jhead/main. C over jni?

Posted On: Jun 19 2009 . View Related Posts . . View 5 Replies .

Motorola Droid - Uninstalled App But Marketplace Still Shows As Installed / Change It

I uninstalled dockrunner becasue after i downloaded it with a couple other programs my phone started to malfunction. However for some reason in the marketplace it still shows it as installed and i can't figure out how to change that.

Posted On: Dec 10, 2009 6:55 AM . View Related Posts . . View 1 Replies .

Set Custom Keyboard For Droid Application / Can App Change Settings

I know that there is the possibility to set a special keyboard with these attributes. But i need my own keyboard as default. How can i do that? How can my app change the settings?

As an example, let's say: i want the example softkeyboard as default for my app.

Is that even possible?

Posted On: Dec 7 09 at 9:50 . View Related Posts . . View 1 Replies .

Need Data Controller App

Been searching these forums for the last hour - can't seem to find a simple app, so i can basically turn data on and off?

Posted On: 08-28-2010, 06:02 AM . View Related Posts . . View 1 Replies .

App To Track Whats Using Your Data

Is there any app that can track whats using your dataż˝
Cause for me its just uselessly giving me a h but the only thing thats on is better keyboard or weather toggle widget

Posted On: 08-14-2010, 11:08 PM . View Related Posts . . View 1 Replies .

Use Facebook App Via Wi-fi Without Data Plan

Ok if i got an htc dream [running the android platform of course] would i be able to:use the facebook app via wifi without a data plan?And would i be able to browse the web using wifi?And yea im a noob to the android phones but since you need a data plan on blackberry to use facebook im starting to decide to switch to android if i can use wifi to use apps [or for most apps]

Posted On: 04-08-2010, 03:17 PM . View Related Posts . . View 1 Replies .