Here is what I am working with:
Palm Pilot (Havent purchased one, any suggestions?)
VB 6.0 (Some palm software says it supports this language which is ideal because I know it)
MySQL (Database)
CGI (Program developed in this language)
Here is what I have to do:
I have created a CGI program which collects data inputted by the user via online forms. I need to be able to create some basic forms on the PALM pilot and sync the results with the MySQL database.
Here is what I think I will have to do:
1. Get the software to create the forms for the PALM. (Any suggestions)?
2. Output the data that was inputted into the palm to a file (excel, notepad, access)? What can PALM output to?
3. Create a file upload for the user to upload the output file, Hash out the data and create some SQL statements to update the database.
Thats what I think I will have to do based on the PALM software I have researched. Maybe there is a way I can Sync to the MySQL database during the hot sync, provide a server path, and run some SQL quarries. That would be ideal, any less step the user has to take the better (These people are morons) I don't know...
I appreciate any help.
Palm Pilot (Havent purchased one, any suggestions?)
VB 6.0 (Some palm software says it supports this language which is ideal because I know it)
MySQL (Database)
CGI (Program developed in this language)
Here is what I have to do:
I have created a CGI program which collects data inputted by the user via online forms. I need to be able to create some basic forms on the PALM pilot and sync the results with the MySQL database.
Here is what I think I will have to do:
1. Get the software to create the forms for the PALM. (Any suggestions)?
2. Output the data that was inputted into the palm to a file (excel, notepad, access)? What can PALM output to?
3. Create a file upload for the user to upload the output file, Hash out the data and create some SQL statements to update the database.
Thats what I think I will have to do based on the PALM software I have researched. Maybe there is a way I can Sync to the MySQL database during the hot sync, provide a server path, and run some SQL quarries. That would be ideal, any less step the user has to take the better (These people are morons) I don't know...
I appreciate any help.