Alpha DevCon 2018
Results 1 to 7 of 7

Thread: sketches/drawings in database form

  1. #1
    Member
    Real Name
    david burnham
    Join Date
    Feb 2015
    Posts
    7

    Default sketches/drawings in database form

    I am employed in a local government agency (regulatory) and our staff performs various inspections. One of the inspections requires a drawing or sketch. I am interested in developing an app in-house and would like to know if there is a database field type that would accept a drawing with stylus (longBLOB?) or would I need to use a separate program and add as an attachment. I would like to develop forms for tablet/mobile use. New to database design, so any information would be appreciated.

  2. #2
    "Certified" Alphaholic CharlesParker's Avatar
    Real Name
    Charles Parker
    Join Date
    Dec 2012
    Location
    New Orleans, LA
    Posts
    1,869

    Default Re: sketches/drawings in database form

    I am fairly certain the signature control would allow you to doodle all you want then hit submit...not sure it is exactly what you would want though as it is not a "drawing tool"
    https://www.youtube.com/watch?v=CjDzTFM14vA

  3. #3
    Member
    Real Name
    david burnham
    Join Date
    Feb 2015
    Posts
    7

    Default Re: sketches/drawings in database form

    I will try this to see how it works. I guess do not really need as drawing tool, just basic sketch. Thank you for your help!

  4. #4
    "Certified" Alphaholic CharlesParker's Avatar
    Real Name
    Charles Parker
    Join Date
    Dec 2012
    Location
    New Orleans, LA
    Posts
    1,869

    Default Re: sketches/drawings in database form

    My guess is you will think its really difficult to draw anything, lol

  5. #5
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,575

    Default Re: sketches/drawings in database form

    David,

    My client does regulatory inspections up in the oil patch in Canada, so as long as you are not a competitor, I'd be happy to discuss what we've done...maybe get you off on the right foot.

    Feel free to send me a private message.
    Pat


    Pat
    Pat Bremkamp
    MindKicks Consulting

  6. #6
    Member
    Real Name
    david burnham
    Join Date
    Feb 2015
    Posts
    7

    Default Re: sketches/drawings in database form

    Pat,
    Thanks for offer. I sent you an email to describe the type inspections performed. Look forward to hearing from you. Thanks again.

  7. #7
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    167

    Post Re: sketches/drawings in database form

    Hello,

    You don't need to store an image in the actual database. You can save that image in the HD and have a pointer to that image in your table. A pointer like D:\A5V12Webroot\Avis\DocUpload\Drw1.Png. When you ran the report that image will be loaded on the fly.

    Regards,

    Doron
    The Farber Consulting Group, Inc.

    Main Web Site: http://www.dFarber.com
    MS SQL Blog: http://www.dfarber.com/computer-consulting-blog.aspx
    Convert Ms Access to Web
    Custom Software Development
    Alpha Five Development
    No Interest Loans Application
    MS SQL Remote DBA

Similar Threads

  1. Moving a form to another database
    By eblaschka in forum Alpha Five Version 10 - Desktop Applications
    Replies: 20
    Last Post: 05-27-2010, 10:16 AM
  2. Database and Form Setup
    By Mortie in forum Alpha Five Version 9 - Desktop Applications
    Replies: 13
    Last Post: 04-06-2009, 12:18 AM
  3. How to copy a form to another database?
    By mariusm in forum Alpha Five Version 8
    Replies: 7
    Last Post: 10-14-2007, 12:12 PM
  4. Form in one database calling Form in another Datab
    By Thomas Henkel in forum Alpha Five Version 5
    Replies: 1
    Last Post: 08-14-2003, 12:04 PM
  5. Copy form to different database
    By Louis Nickerson in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-14-2002, 06:35 PM

Bookmarks

Posting Permissions

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