Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Request for Proposal (RFP): Migrate Access 2002 db to MS IE 3.0

    This is a Request for Proposals (RFP) to do the work described in this post for pay.

    Description:
    Think Javascript arrays... I need to migrate the database I created with Microsoft Access 2002 on Windows XP to Pocket Internet Explorer (same as IE 3.0) on NEC Mobilepro 780 HPC.

    Target Platform:
    Pocket Internet Explorer (same as IE 3.0) on Windows Ce handheld (HPC) device. Javascript, JScript, and HTML 3.2 compatible. No support for Java, VbScript, CSS, DHTML, or frames. Screen dimensions are 640 pixels wide by 214 pixels tall. The OS of the handheld device (HPC) is Windows Ce 2.11. The system architecture is MIPS 4121.

    Source Prototype:
    The Access 2002 database prototype is fully functional and ready to email to you as a zip file. It has 14 fully normalized (optimized) tables, only 4 of which have relationships between them. It has 2 forms, with text boxes as the only controls except for 2 combo boxes and (many) labels. Each of the 2 forms have multiple pages (tabs).

    Specified Deliverables:
    I want to migrate the database, including the forms, their controls, the tables, and the (in-process) HTML help system to Pocket Internet Explorer on the H/PC by utilizing Javascript arrays and web-based forms and controls.

    Compensation:
    Please make me an offer, but be fair and reasonable. I am an individual, not a company. I'm doing this project to help myself on a trip this summer.

    Deadline:
    Completion of beta deliverable by mid May '04. Completion of final deliverable by the end of May.

    -Dave

  • #2
    Moderator
    Join Date
    May 2002
    Location
    Hayward, CA
    Posts
    1,459
    Thanks
    1
    Thanked 23 Times in 21 Posts
    Offtopic: I'm having a little trouble conceptualizing how this would be done. With JS and HTML alone, the database itself would be read-only. More to the point, JS doesn't really lend itself well to relational tables design.

    etalent: If you find someone to do this project for you, I'd appreciate finding out how they did it JS doesn't lend itself well to high-precision arithmetic either, but I did write a library to do that...
    Last edited by Alex Vincent; 04-30-2004 at 12:56 AM.
    "The first step to confirming there is a bug in someone else's work is confirming there are no bugs in your own."
    June 30, 2001
    author, Verbosio prototype XML Editor
    author, JavaScript Developer's Dictionary
    https://alexvincent.us/blog

  • #3
    Senior Coder Mhtml's Avatar
    Join Date
    Jun 2002
    Location
    Sydney, Australia
    Posts
    3,531
    Thanks
    0
    Thanked 1 Time in 1 Post
    A lil OT, I'm curious about that lib you mentioned (eg how you made and implement it) .. perhaps you can PM me with the details ..
    Omnis mico antequam dominus Spookster!

  • #4
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't understand what you are trying to do.
    I don't understand why the complete backend should be changed just because the generated html will be displayed by another user agent. If this IE 3.0 can display html, then you can just use a db at the backend, and dynamically build the html-pages with a server side language like PHP or ASP or JSP or ...

    This very same backend can then also be used to generate the same or similar html pages for another browser.
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #5
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clarification

    Thanks for your reply.

    I researched EXTENSIVELY regarding relational database development with forms and SQL on the target platform (Win Ce 2.11 handheld). PHP, ASP, JPS are not supported on Pocket IE (same as IE 3.0).

    The nearest thing I found that works for developing "native" databases in the target environment is Syware Visual Ce ($130), but the newest version does not support the target platform, so cab files would have to be downloaded from Syware to make Visual Ce backward compatible.

    That whole idea stopped making sense when I realized that I already have a development environment in Pocket IE, albeit version 3.0. Still, if IE 3.0 can do Javascript, which it can, it suffices.

    Pocket Access is the database included with Win Ce 2.11 on my handheld. If you're an Embedded Visual Basic programmer then that would be the obvious IDEAL solution. The biggest limitation I am aware of is that Pocket Access has a 67,000 record limit. Darn.

    Please understand that I am not trying to complicate things. On the contrary, I've learned enough about what I'm trying to do to be dangerous. My prototype database works great on my desktop. Life would be wonderful if all I had to do was drag and drop it using ActiveSync, but no such luck.

    Suggest away, please. Seeing my prototype Access 2002 database for yourself would clarify most everything, I bet. If you were just look to at it and then envision what it would take to emulate it on the target platform of Pocket IE or the equivalent IE 3.0.

    I really look forward to hearing back from you!

    -Dave

  • #6
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Are you saying that you want to use webtechnology, but only the client side technology (in casu javascript and HTLM) ? And that you need a datasctructure of more then 67 000 records without using a database ? So that you would like to have a few pages that include a javascript array of more then 67 000 elements ?
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #7
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Client side javascript and HTML only. Correct.

    I would rather not have a 67,000 record limitation.

    Correct me if I'm wrong, please, but my understanding of arrays is that they are simply Javascript's way of doing databases.

    If you can use Pocket Access as a backend rather than Javascript arrays, good. If you can get around the 67,000 record limtation, even better.

    As numbers of pages goes, the prototype Access 2002 database has two forms. Each form has multiple pages (tabs). However, all the controls are text boxes with the exception of exactly two combo boxes and a bunch of labels.

    Please keep asking me questions if I'm not being clear! -Thanks

  • #8
    Senior Coder
    Join Date
    Jun 2002
    Location
    Nashua, NH
    Posts
    1,724
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Why am I getting this feeling that you are trying to do something simple in a very complicated way. Maybe if you started by describing your application and required functionality......
    Vladdy | KL
    "Working web site is not the one that looks the same on common graphical browsers running on desktop computers, but the one that adequately delivers information regardless of device accessing it"

  • #9
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Quote Originally Posted by etalent
    Correct me if I'm wrong, please, but my understanding of arrays is that they are simply Javascript's way of doing databases.
    No not at all. An array in any language is simply a collection of related variables stored in memory. A database is a medium for storing data in files.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #10
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Simplified description

    True, it is simple. I sure don't want to make it complicated. If you were to see the Access 2002 database for yourself, you'd see how simple it really is. Then you could formulate your own ideal solution instead of contending with my hack explanations.

    As requested, here is a simplified description of what I need to pay someone to do for me. Before I get into it, I have to say that I have done this very thing, described my database, that is, on other discussion forums earlier in the development process. I found that doing so makes this simple database seem complicated. Seeing the database for yourself is much simpler, but I NEED THIS DONE! So, here I comply with your request...

    Purpose:
    Reference and data entry of the verbs and vocabulary of four languages (English, Spanish, Portuguese, and Kreyol).

    Functionality:
    Viewing or entering data with the use of one of two main forms at a time. Navigate each form with multiple pages (tabs). (1) Read the values populating the text boxes or (2) enter values into the textboxes.

    Table Structure:
    14 tables. 4 tables contain verbs data. The 4 verbs tables are related and fully normalized. The remaining 10 tables (fully normalized) contain vocabulary data and are not related.

    Controls:
    2 Forms, each with multiple pages (tabs). 14 text boxes. 2 combo boxes. Labels. A button on each form for toggling between each. A help button on each form to launch HTML help.

    -----------------------

    Please, please, please don't abandon this! Bear with me! I need this done! Propose away! Tell me something! Make me an offer! PLEASE!

    -Dave

  • #11
    Senior Coder
    Join Date
    Jun 2002
    Location
    Nashua, NH
    Posts
    1,724
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What I do not understand is:
    - Why do you need javascript and why do you care what the client is, when you can keep all the processing on the server and serve simple HTML forms (something IE3.0 can understand) to do the user interaction.
    Vladdy | KL
    "Working web site is not the one that looks the same on common graphical browsers running on desktop computers, but the one that adequately delivers information regardless of device accessing it"

  • #12
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the response as always...

    The database is to reside on a handheld computer, so it won't have any connectivity to a server or anything else. If you're thinking of making the handheld itself the server, great!

    Forgive me if this does not clarify

  • #13
    Senior Coder
    Join Date
    Jun 2002
    Location
    Nashua, NH
    Posts
    1,724
    Thanks
    0
    Thanked 0 Times in 0 Posts
    So you want it all to be a stand alone app on a hand-held... then why base it web technology in the first place??? Use VB, C++ or whatever to make an execuatable that runs in the target environment and works with your DB. You mentioned there is a limit to Access DB version - maybe the handheld can not handle your volume of data at all???
    Vladdy | KL
    "Working web site is not the one that looks the same on common graphical browsers running on desktop computers, but the one that adequately delivers information regardless of device accessing it"

  • #14
    New Coder
    Join Date
    Apr 2004
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I defer to your recommendations

    Yes, I want the database to be a stand along app on my handheld.

    Based on my understanding of Pocket Internet Explorer, which is the equivalent of IE 3.2, and Javascript is that they (IE and Javascript) could serve as the development environment to which my original Access 2002 database could be migrated to.

    By ALL MEANS, please propose your solution IN Embedded VB, C++, or, as you put it "whatever to make an executable that runs in the target environment and works" with my DB. I realize that I may have to accept the 76,000 record limitation.

    If you can code in Javascript/IE 3.2, Embedded VB, C++, your mamas' army boots, whatever, please propose a solution to me! (weak attempt at humor there. I hope you don't mind.)

    I'm not a programmer, so I defer to your recommendations! -Thanks!

  • #15
    Senior Coder
    Join Date
    Jun 2002
    Location
    Nashua, NH
    Posts
    1,724
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm not the best person to do the handheld DB programming - just was trying to make sense of your requirements....
    Good Luck in getting it done.

    Just curious, is it something that you are developing for sale, or just a hobby project. In latter case, instead of paying someone to do the custom programming for you - use this money to buy yourself a new notebook (the latest Sony VAIOs are pretty light and compact) and use what you have now on it, without thinking about restrictions imposed by the handheld.
    Vladdy | KL
    "Working web site is not the one that looks the same on common graphical browsers running on desktop computers, but the one that adequately delivers information regardless of device accessing it"


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •