Database Develop

Can you create apps for G1 using Visual Basic?

Do any of you know if it is possible to use Visual Basic 2008 to create applications for the G1. I know it can make mobile apps but only for Windows mobile phones. I have the entire suite of Visual Basic 2008 so I can use a couple different languages I just don't know which will work.
thanks

No, the G1 apps are Java based and must be built on the Android API (at least so far). The easiest way to do this is to use Eclipse and the Eclipse add-in available from Google.

http://code.google.com/android/documentation.html

Mono (a cross-platform system for .NET) is available in the Android market. I know it supports C# but I'm not sure about VB and I'm not sure how usable it is. Check it out in the market and it has a link for directions.
Hope this helps!

Geniusdog254 said:
I know it supports C# but I'm not sure about VB and I'm not sure how usable it is.
Click to expand...
Click to collapse
.Net is .Net... it compiles down to IL which is what gets executed. If Mono is on Android, it might be possible to make something work. There would be some additional work to exposed the Android intents, etc. as "Forms" for VB.
I'd say that it is "possible", but it isn't very likely any time soon.

Chinpokomon said:
I'd say that it is "possible", but it isn't very likely any time soon.
Click to expand...
Click to collapse
Koush is making good progress on that front, it looks like.
http://www.koushikdutta.com/2009/02/monodalvik-interop.html
http://code.google.com/p/androidmono/

It would be so muhc more useful is you could develop android applications via Visual Basic, C#, or even C.
I would much rather prefer the android to be C/C++
Oh well.

Creating Applications...

Just thought I'd double check this before I buy, but it is possible to write applications for this phone using java? Soz if its a stupid question but thats kinda what am needing lol.

No, it's not.
However it should be possible to use the android SDK which sadly kinda looks like Java.
http://developer.android.com/sdk/1.5_r3/index.html

Thanks for the reply. Thats a bit guttin, I thought that android supported java (or a mobile version of java). To be honest I'm just really lazy and dont want to learn a new language lol.
Do you know if android does support java and its just this phone that doesnt? Or is this the case with all android phones?

Irregular Programming said:
No, it's not.
However it should be possible to use the android SDK which sadly kinda looks like Java.
http://developer.android.com/sdk/1.5_r3/index.html
Click to expand...
Click to collapse
What? It's probably not a good idea to go around spouting misinformation like this. "Irregular Programming" indeed.
Perhaps you may like to read through: http://developer.android.com/guide/basics/what-is-android.html#applications
To ExO_PoLiTiX: you won't need to learn a new language, you'll just need to be aware of how the Dalvik (basically the java virtual machine Android runs) system works, and what you do/don't have access to.
My advice would be to read the page I linked above and then go down through all the pages in the side menu. There are also a whole bunch of example projects available for download from that site, all of which can be imported directly into eclipse, provided you've installed the SDK and ADT plugin.
If you already know java you'll find Android development will be a breeze.

iammorris said:
To ExO_PoLiTiX: you won't need to learn a new language, you'll just need to be aware of how the Dalvik (basically the java virtual machine Android runs) system works, and what you do/don't have access to.
My advice would be to read the page I linked above and then go down through all the pages in the side menu. There are also a whole bunch of example projects available for download from that site, all of which can be imported directly into eclipse, provided you've installed the SDK and ADT plugin.
If you already know java you'll find Android development will be a breeze.
Click to expand...
Click to collapse
you dont know how good that is to hear! lol I will have a look through the pages you suggested. Thanks for that. I plan on writing a game which uses the network features of the phone alot. My only experience of creating games is through java so thats why I wanted to use android =-)
Thanks again

iammorris said:
What? It's probably not a good idea to go around spouting misinformation like this. "Irregular Programming" indeed.
Perhaps you may like to read through: http://developer.android.com/guide/basics/what-is-android.html#applications
To ExO_PoLiTiX: you won't need to learn a new language, you'll just need to be aware of how the Dalvik (basically the java virtual machine Android runs) system works, and what you do/don't have access to.
My advice would be to read the page I linked above and then go down through all the pages in the side menu. There are also a whole bunch of example projects available for download from that site, all of which can be imported directly into eclipse, provided you've installed the SDK and ADT plugin.
If you already know java you'll find Android development will be a breeze.
Click to expand...
Click to collapse
Yup, I was wrong.
I was sure I've read about android using its own brand "Java-lookalike" language.

blahzay blah

Irregular Programming said:
Yup, I was wrong.
I was sure I've read about android using its own brand "Java-lookalike" language.
Click to expand...
Click to collapse
You can actually import the main java (e.g. javamail) classes into your projects so android runs almost all of Java.

Follow this link to help you create iphone apps as easy as possible. http://6a7d57q12b9gmv46x4n7rh9m52.hop.clickbank.net/?tid=XDA

Follow this link to help you create iphone apps as easy as possible. http://6fc2862--76bqnb8pfz3nbugtd.hop.clickbank.net/?tid=XDA

Android Access Database

Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.

kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
Click to expand...
Click to collapse
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.

Thanks this is deffenetly a start, From what I can tell this This Looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Forms would be as simply as making a program, this is great thanks much

kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me....
Click to expand...
Click to collapse
I would like to say, "yes, please!" to this idea. I currently use Smart List to Go (the descendant of ThinkDB) on my Palm TX. The TX is dying, and I've been shopping for a replacement. HanDBase exists for the iPhone, but I don't want an iPhone. So I've been focused on WinMo - not by choice as much as by necessity.
And android option would be very welcome around my computers.

benmyers2941 said:
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
Click to expand...
Click to collapse
androids sqlite its for applications to access and store data using java code.
try the pocket office app

Freedomcaller said:
androids sqlite its for applications to access and store data using java code.
try the pocket office app
Click to expand...
Click to collapse
Exactly and we're talking about creating an app that would enable manipulation of an sqlite database. Essentially all that would be needed would be to create a ui framework wrapper for the existing api in android. Not the least monumental task I've heard of an individual taking on but not the most either.
The versions of pocket office that I've seen for android do not currently support Access databases as far as I'm aware. If I'm wrong could you post a link and save everyone some trouble?

aaaaaaaaaaaaaaaaaaa

kronos82 said:
Thanks this is deffenetly a start, From what I can tell this looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Click to expand...
Click to collapse
Jackcess library is now patched to support android (will be in 1.2.2 release). Also seems to support 2000, 2003 and 2007 formats now.
Works great for me.

View jackcess site. Couldn't find anything on support for android. I'm using htc desire and would really like to find program to view ms access file. Can you tell me how you do it?

As I remember reading worked as on PC, while writing had some problems.
This forum prevents me from linking directly, but if you click tracker/patches on Jackcess project, check Android Compatibility Fix - ID: 3101578
The changes are in trunk and will be in the 1.2.2 release. I've added some
notes which will eventually make it to the FAQ page on the website
detailing the compatibility steps:
- Set the system property "com.healthmarketscience.jackcess.broken
Nio=true"
- Set the system property "com.healthmarketscience.jackcess.resour
cePath=res/raw/"
- Copy the *.txt, *.mdb, and *.accdb files from the
"com/healthmarketscience/jackcess/" directory in the Jackcess jar to the
"/res/raw" Android application directory.
- Before executing any Jackcess code, set the current Thread's context
classloader, e.g.
"Thread.currentThread().setContextClassLoader(Database.class.getClassLoader())".
Click to expand...
Click to collapse
Until this version (1.2.2) is released you need to build lib yourself.
You also need commons-lang and commons-logging from apache commons.
Before you use Jackcess in Android code, you set
Thread.currentThread().setContextClassLoader(
getClass().getClassLoader());
System.setProperty(
"com.healthmarketscience.jackcess.brokenNio",
"true");
System.setProperty(
"com.healthmarketscience.jackcess.resourcePath",
"res/raw/");
Click to expand...
Click to collapse
and copy those resource files to res/raw
Then you can work as on PC, for example open /sdcard/yourprogram/file.mdb
Jackcess has no GUI, it's a library to read/write access files.

Getting an Access file into Android
I keep a lot of information on a Psion Revo, which has just turned its face to the wall and is giving up the ghost, and have always backed the information up on to my pc as an Access file. It looks easier to get this into a format acceptable to Android by converting the Access .mbx file into an Excel .xls file. This can be searched readily by Column and Values. Maybe this deals with too simple a need for most enquirers to the forum, but if it helps somebody then so much the better.

hi all i have beenlooking for something the same for some time now and just the other day i came accross this site cellica.com
the android app is free and the desktop application has a 5 day trial period or its $50 to buy it works great the only thing you can not do is create a report from the phone
i have emailed support team and they said they will be adding it on in the future.

Any Updates???
I currently build and use databases in MS Access and was wondering if there are any updates on this topic now that Tablets are in use now. Looking to get the Motorola Xoom (2nd version) in the future, but would love to be able to use a program that I would be able to access my MS Access databases while "on-the-go".
Anyone? This would be huge (I believe), since we now have tablets.
Thanks a bunch,
~Kilch~

Access to MS Access by Android
Hi,
I'm also looking to get on-the-go access to my Access databases on my Android HTC Tattoo.
The file is on it, I just need a tool to access it in read-only / search mode, but judging from the previous comments, there doesn't seem to be an oversupply in applications.
The "convert to Excel format" may be OK for me. I want to use a 3 language Access DB (dictionary) on my phone, so I'll try the Excel solution.
It would be nice if we had an ACCESS reader though...
John

Panacea Database
I know XDA frowns upon excessively hawking your own products here, but I do seem to be directly answering more than one of the reply questions, it just happens that the answer is an application my company released.
The Panacea Database application can handle Access from Access 2000 to Access 2007. It has also worked so far on every Access 2010 database we've tested, and we've received no complaints in that department yet. We release updates from time to time as we improve its functionality and features, often guided in our priorities by user e-mail and market comments. Our next update will be focused on improving screen layout for a variety of Android devices - from small QVGA smartphones, to large WXGA tablets. After that we may move onto other functionality.
In the interest of fairness, I'll point out arafa1209's post. He mentions Celicca Database, which is the only other application that I know of that deals with Access databases on Android. It has features Panacea does not have (yet) - ability to work with forms, ability to create and modify databases, ability to connect to your PC etc. Like us, they also send out updates improving their app regularly. So you can compare the apps, and use which one fits your needs better (or use both). If anyone knows of any others they can post here as well, but these are the only two I know of currently.

Just tried Panacea. Although it is more basic and annoyingly doesn't remember the last files you'be opened necessitating finding the file each time you open the app I prefer it for the simple reason you don't have to convert the Access database to another format.

amwebby said:
doesn't remember the last files you'be opened necessitating finding the file each time you open the app
Click to expand...
Click to collapse
If you update the app, this should be fixed, the last version should have this feature.

Got the update last week. Certainly goes a long way to making it more user-friendly. Keep up the great work!

Since the last update it seems to be broken. Although it remembers the last database I cannot open a table within any database.
Edit: It appears the file was corrupted. Loaded a new file and all working again.

Any news in this topic.
I tried panacea Database, works fine. But not very effective. Searching data is a must for me however I didnt manage to find a search option. When I search for tables, it cant even locate the tables by names.

Possible Tethering Hack?

So after that guy figured out the tethering hack for iOS by just changing a few lines of test, I decided to try to find one for Windows Phone 8. I have no idea how it would get on the phone (besides possibly flashing a new rom?), but I went and looked anyway. I mounted the VHD from the SDK and I think that I found something. If you use something like Visual Studio's Find in Files and search for ICSSVC, you'll find some interesting stuff.
First of all, in Microsoft,Net.NetCore.reg, I found this: puu.sh/3J9yS.png That's how I learned about ICSSVC. So then I searched for that and in Microsoft.Net.NetCore.policy.xml there is a bunch of capability stuff. I have no idea what to do past here, and the emulator doesn't have the Internet Sharing option. So, yeah.

MichaelC97 said:
So after that guy figured out the tethering hack for iOS by just changing a few lines of test, I decided to try to find one for Windows Phone 8. I have no idea how it would get on the phone (besides possibly flashing a new rom?), but I went and looked anyway. I mounted the VHD from the SDK and I think that I found something. If you use something like Visual Studio's Find in Files and search for ICSSVC, you'll find some interesting stuff.
First of all, in Microsoft,Net.NetCore.reg, I found this: puu.sh/3J9yS.png That's how I learned about ICSSVC. So then I searched for that and in Microsoft.Net.NetCore.policy.xml there is a bunch of capability stuff. I have no idea what to do past here, and the emulator doesn't have the Internet Sharing option. So, yeah.
Click to expand...
Click to collapse
Unfortunately, this involves dumping phone ROMs and modifying the policies (We don't know how crazy this process will be). Another set back involves the fact that the bootloaders for WP8 are signed which would require the the ROM to be signed with the correct cert, etc.
Basically, this will be extremely painful due to WP8 running a Windows NT Kernel (WP7 uses Windows CE) and all kinds of other obstacles that we haven't discovered yet.

snickler said:
Unfortunately, this involves dumping phone ROMs and modifying the policies (We don't know how crazy this process will be). Another set back involves the fact that the bootloaders for WP8 are signed which would require the the ROM to be signed with the correct cert, etc.
Basically, this will be extremely painful due to WP8 running a Windows NT Kernel (WP7 uses Windows CE) and all kinds of other obstacles that we haven't discovered yet.
Click to expand...
Click to collapse
Also while I was searching, I found a registry entry for 'DeveloperUnlock'. So when you run the program to dev unlock your phone, the program must modify the registry on the phone. I'm pretty sure that it would be possible to replicate that.

MichaelC97 said:
Also while I was searching, I found a registry entry for 'DeveloperUnlock'. So when you run the program to dev unlock your phone, the program must modify the registry on the phone. I'm pretty sure that it would be possible to replicate that.
Click to expand...
Click to collapse
As of now, we can't execute the native EXEs on the phone so we won't know whether we can replicate that or not. I know with talking with HeathCliff74, modifying the policy on WP7 took quite a long time and effort to figure out. I can almost guarantee the policies on WP8 are implemented completely different from WP7 and even a bigger pain to modify

snickler said:
As of now, we can't execute the native EXEs on the phone so we won't know whether we can replicate that or not. I know with talking with HeathCliff74, modifying the policy on WP7 took quite a long time and effort to figure out. I can almost guarantee the policies on WP8 are implemented completely different from WP7 and even a bigger pain to modify
Click to expand...
Click to collapse
I meant the program on your computer that comes with the SDK. I think that it modifies the phones registry to dev unlock it.

MichaelC97 said:
I meant the program on your computer that comes with the SDK. I think that it modifies the phones registry to dev unlock it.
Click to expand...
Click to collapse
You are correct, it does modify the registry to dev unlock it by connecting to a running service on the phone and executing native DLLs. The main DLL that interacts with the phone within the program's folder is an Win32 compiled .DLL rather than a .NET file which would require some disassembly to get an idea of what's going on. It also doesn't help that it is a signed DLL.

[Q] java vs javascript? diffrence?

so im coming from c++ and trying to learn to create apps. im interested in using android studio to create apps so now i need to learn java.
quick question about java, im assuming java is for application development , and javascript is for browser related apps? am i correct? close?
also were is the thread showing how to install android studio and all the programs required? i stumbled upon it earlier, but i cant remember where it was at.

You are correct, java is for application development , in your case for Android development, and javascript is for web development.

More specifically,
JavaScript:
Interpreted
Runs in the browser, works on mobile devices
Runs on the client side (NOT the server)
Sandboxed so you won't be able to do low level stuff
Cross platform
JAVA
Compiled
Runs on the client or on the server
To run in the browser it needs a plugin so won't work on mobile devices
You can do low level stuff
Cross platform
I won't get into personal preferences, but there are many other differences, most of which will come evident when you start making stuff. If you want to make cross platform mobile apps you might want to look into Apache Crodova that uses HTML and JavaScript but can interface with device hardware too.