This is an example of the problem I am encountering
package com.triplebande.upupdowndown;
import java.util.ArrayList;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import android.widget.Toast;
public class GameUtils {
public static String getDescription( Context context,
String inputGame ) {
String description = "";
SQLiteDatabase myDB = null;
Cursor c = null;
try {
/* Create the Database (no Errors if it already exists)
*/
myDB = context.openOrCreateDatabase(
Constants.DATABASE_NAME, 0,
null );
//title TEXT, cheats, console
String query = "SELECT _ID, cheats FROM games where
title =\"" +
inputGame + "\" LIMIT 1";
if (Constants.debug)
Log.d( Constants.TAG, "We query " + query);
c = myDB.rawQuery(query, null);
/* Check if our result was valid. */
if ( c != null ) {
/* Loop through all Results */
c.moveToFirst();
description = c.getString( c.getColumnIndex(
Constants.CHEATS ) );
}
} catch ( Exception e ) {
if (Constants.debug)
Log.e( Constants.TAG, "Exception on quering " +
e );
} finally {
if ( c != null ) {
c.close( );
}
if ( myDB != null ) {
myDB.close( );
}
}
return (description);
}
public static ArrayList<String> getGames(Context context, String
inputGame, String inputConsole) {
SQLiteDatabase myDB = null;
Cursor c = null;
ArrayList<String> gamesList = new ArrayList<String>( );
try {
/* Create the Database (no Errors if it already exists)
*/
myDB = context.openOrCreateDatabase(
Constants.DATABASE_NAME, 0,
null );
//title TEXT, cheats, console
String query = "SELECT _ID, title, console FROM games
where title
like \"" + inputGame + "\" ";
if (!"All platforms".equalsIgnoreCase(inputConsole))
{
query = query + " and console like '" +
inputConsole + "' ";
}
query = query + " LIMIT 100";
if (Constants.debug)
Log.d( Constants.TAG, "We query " + query);
c = myDB.rawQuery(query, null);
/* Check if our result was valid. */
String title ;
if ( c != null ) {
/* Loop through all Results */
c.moveToFirst();
// Loop through all Results
do {
// for loops over columns in a row
title = c.getString( c.getColumnIndex(
Constants.TITLE ) );
gamesList.add(title);
} while ( c.moveToNext() );
}
} catch ( Exception e ) {
if (Constants.debug)
Log.e( Constants.TAG, "Exception on quering " +
e );
} finally {
if ( c != null ) {
c.close( );
}
if ( myDB != null ) {
myDB.close( );
}
}
return (gamesList);
}
public static void showMessage(Context context, String message)
{
int duration = Toast.LENGTH_SHORT;
Toast toast = Toast.makeText(context, message, duration);
toast.show();
}
public static void showLongMessage(Context context, String message)
{
int duration = Toast.LENGTH_LONG;
Toast toast = Toast.makeText(context, message, duration);
toast.show();
}
}
On Jul 8, 8:55 pm, Miguel Morales <therevolti...@gmail.com> wrote:
> You might try further questions at the android-beginners
> group:http://groups.google.com/group/android-beginners?pli=1
> orhttp://stackoverflow.com/questions/tagged/android
> You might try right clicking and hitting refresh on the folder where
> the database file is (in eclipse) if something doesn't automatically
> appear. Other than that, you can't distribute any exe files to users
> via the android market.
>
>
>
> On Thu, Jul 8, 2010 at 7:50 PM, Edmund Higgins <ehiggins...@gmail.com> wrote:
> > Childish
>
> > On Jul 8, 2010 7:47 PM, "Edmund Higgins" <ehiggins...@gmail.com> wrote:
>
> > It's a database application built in Delphi I believe. It allows the user to
> > update an existing database but the database doesn't automatically refresh
> > in eclipse. That's where we are having the trouble.
>
> >> On Jul 8, 2010 7:42 PM, "metal mikey" <coref...@gmail.com> wrote:
>
> >> I'd be very warey of any ...
>
> >> On Jul 9, 12:19 pm, Official <ehiggins...@gmail.com> wrote:
>
> >> Ok so does anyone know of a newbie...
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Android Developers" group.
> > To post to this group, send email to android-developers@googlegroups.com
> > To unsubscribe from this group, send email to
> > android-developers+unsubscr...@googlegroups.com
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en
>
> --http://developingthedream.blogspot.com/,http://diastrofunk.com,http://www.youtube.com/user/revoltingx,
> ~Isaiah 55:8-9
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
