1. you don't need SQL in your palm os application. What you need is an interface in your server to comunicate with your app. Make it as simple as possible. This interface will handle all the sql stuff.
2. Do you really need to make this interaction with the server in real time? you could fetch the data you need from the server to work with your app (any catalogues? categories, products, stores, etc?). Then use it, capture data, set your orders or whatever your app will do. Then, when you are ready send all the captured information to the server. Your interface will handle all the synchronization between real data on the database and the information you are sending and could send a message back to your palm app to let it know if changes were possible and send updated data (if any) to your palm app.
If you don't want to create a protocol for your palm app and the program in the server to comunicate with, you can use http protocol or something else, you have to figure out how to overcome restrictions, and yes, you will have to learn lot of stuff from zero, but it's not impossible, and if your app is as simple as it seems to be, then you can do it on 4 weeks. Sure you can!
Just read, learn, think and keep reading.
Luciano Stertz wrote:
[EMAIL PROTECTED] wrote:
Thanks for all your frank responses;
Putting the cross platform issue aside, what I was envisioning was something like i have done before with VB where you have the front end query the database on the fly, but this would limit the use of this only if you are connected wirelessly.. unless you download the database and upload the database via the PC which would still have to have a connection to the dbase server.
Let's say in the App you would only have to enter the info of widgets as they come in and send this info to the server and get the inventory number back as real time as possible, is this just too complicated and would take more than 4 weeks? Then my question would be what kind of Apps are people writing out there for PDAs to make them useful for real time data application? I had thought that PDA had evolved more than what they actually have..
Two comments:
1. How many time did you take since the first time you saw VB and SQL to the point where you could easily create the application you want in a few weeks? Palm OS is a whole new world, you'll have to learn everything from (almost) zero.
2. There is no support for relational databases in Palm OS. There is no SQL. The simply act of getting data from your SQL server will require considerable efforts. Unless you manage to find a SQL library for PalmOS. I heard of one that works with MySQl, but I don't know about other DB servers.
I don't think it's impossible to accomplish what you're asked to, but it will be very hard.
Best regards, Luciano
-- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
