Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ADOCE SQL Question

    I hope this is the appropriate area to ask this question (when the search function is reinstated, I'll know better).

    I have a database I use to track my daily activities at work. One of the things I must track is my employee's times (breaks, lunches, overtime, etc.). I have a table that lists their last names, first names, and workstation, among other things. I'd like to make a drop down combo box where I can select an employee that worked a break that has their first and last name, ordered by last name. In Access, I'd simply use the following query:

    SELECT [LastName] & ", " & [FirstName] AS [Name]
    FROM tblEmployeeData
    ORDER BY [LastName];

    but ADOCE won't allow this. I use Sprint DB Pro 2.0 as my database program, by the way.

    Is there a way for me to do this? I'd sure appreciate any help. Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Windy Wellington, Wellington
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADOCE SQL Question

    This reply might be a bit late in the day but there is a SQL reference for ADOCE at:
    http://msdn.microsoft.com/library/default....ado30ref_83.asp
    Keith Rodgers
    <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADOCE SQL Question

    Thanks, Keith. I've checked out the site, and found a lot of good stuff. I'll see if I can actually use any of it now.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Windy Wellington, Wellington
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADOCE SQL Question

    Hi Tim

    I see you're using SprintDB. Did you look at HanDBase? Any opinions on the merits of the two? I'm trying to assess the different databases available for my iPaq and those two are on my short list.

    Go Vols!
    (Actually I don't know anything about American football and its various leagues but I was in Knoxville, TN on business recently and did the "been there, got the [bright orange] T-shirt" thing).
    Keith Rodgers
    <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADOCE SQL Question

    Yeah, Keith, I did look into HandDBase. It's a good database (I used it a lot when I used to have a Handspring). I ended up choosing SprintDB based on several users' comments, and also on the fact that it is a true relational database. HandDBase is actually "flatfile" that allows you to link databases. This limits its ability to work with MS Access--which was very important to me. Also, at the time I looked at it, it didn't have a very user-friendly (in my opinion) forms designer. SprintDB is truly relational, allows form design much like Access, and imports tables directly. It also includes the desktop designer at a price that's very reasonable.

    I am a little disappointed in SprintDB's inability to import/export forms and queries, and ADOCE (no fault of SprintDB) has a lot of limitations. Overall, however, I am very happy with SprintDB. It is responsive, intuitive, and affordable. I recommend it highly.

    As far as New Zealand teams, I only wish I could come up with one. Yours is a country I have only wished to visit.

Posting Permissions

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