Alpha Video Training
Results 1 to 9 of 9

Thread: make a sql database?

  1. #1
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default make a sql database?

    Thanks now for any info.

    How would you make a scl database if you didn't have one. Is there another tool needed or can Alpha do this? What file format would it be? Is it feasible to use this db in a LAN with users coming in over the net also? Would it ba faster with our own DBF files locally? and/or over the web?

    Dave Mason
    Last edited by DaveM; 04-28-2007 at 01:35 PM.

  2. #2
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default make a sql database?

    Thanks now for any info.

    How would you make a scl database if you didn't have one. Is there another tool needed? what file format would it be? Is it feasible to use this db in a LAN with users over the net also?

    Dave Mason

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: make a sql database?

    Dave, I don't think there are tools in Alpha Five for creating SQL databases. Must use 3rd party database managers so far as I know. The format will vary depending upon which database manager is used. I don't know the answer to your last question, but I'd guess you would want the local network folks to access the data using their browser, rather than through Alpha Five, since the app would have to be running under the Web App Server, no?

  4. #4
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: make a sql database?

    Dave,

    I have no experience in this but there was a recent thread that may interest you with regard to using a desktop app over the net using an sql backend.. The thread.
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: make a sql database?

    Quote Originally Posted by DaveM View Post
    How would you make a scl database if you didn't have one.
    Google led me to SQL Databases.

  6. #6
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default Re: make a sql database?

    Tim,

    Yes, I have been following that thread too.

    Dave

  7. #7
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default Re: make a sql database?

    Stan,

    I did the same search to Mysql by way of google. I guess I will have to study it out. At least when doing clipper, basic, etc., I knew the direction(kinda) and file types to work with.

    Dave

  8. #8
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,628

    Default Re: make a sql database?

    Quote Originally Posted by DaveM View Post
    Stan,

    I did the same search to Mysql by way of google. I guess I will have to study it out. At least when doing clipper, basic, etc., I knew the direction(kinda) and file types to work with.

    Dave
    Dave

    The concept behind a relational database is that the database manager handles all of the issues with the underlying files and their types. It is a different model than the dbf file model.

    When you install the database and it's software, the tools that you'll need to deal with will be installed also. (At least one version of it anyway)

    Study and practice with these tools will increase your comfort level, but don't approach this with the same mindset as you would with any dbf system. All of the functionality is handled via the software. Trying to deal with the individual files will only cause harm and confusion.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  9. #9
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default Re: make a sql database?

    Al,

    I just found out how to make a database in sql along with tables. I guess I am back to some clipper/c/c+/??? stuff. LOL ok, maybe it is back to c:\ prompt, whatever. It is not all bad!

    Dave

Similar Threads

  1. make a sql database?
    By DaveM in forum Alpha Five Version 8
    Replies: 1
    Last Post: 04-28-2007, 10:02 PM
  2. Replies: 2
    Last Post: 03-27-2007, 02:24 PM
  3. Can't see fields in SQL Database
    By Louis Nickerson in forum Web Application Server v6
    Replies: 0
    Last Post: 02-17-2005, 12:09 PM
  4. query SQL database
    By EdwardTsai in forum Alpha Five Version 6
    Replies: 3
    Last Post: 10-23-2004, 10:19 AM
  5. Linking A5 to SQL Database
    By Willie Sagulo in forum Alpha Five Version 6
    Replies: 4
    Last Post: 10-12-2004, 12:31 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
  •