Results 1 to 18 of 18

Thread: Database Development Forum: Add DB options

  1. #1

    Thread Starter
    Code Monkey wild_bill's Avatar
    Join Date
    Mar 2005
    Location
    Montana
    Posts
    2,993

    Database Development Forum: Add DB options

    Is there a possibility some commonly used databases could be added as options when creating a new thread in the database development forum? This would be similar to the visual studio options in the VB.NET forum.
    That is the very essence of human beings and our very unique capability to perform complex reasoning and actually use our perception to further our understanding of things. We like to solve problems. -Kleinma

    Does your code in post #46 look like my code in #45? No, it doesn't. Therefore, wrong is how it looks. - jmcilhinney

  2. #2
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Database Development Forum: Add DB options

    I like the idea but there are so many...

    MSSQL2000, MSSQL2005, MSSQL2008, MySQL4, MySQL5.1, PostgreSQL, Oracle, Sybase, SQLite, FoxPro, FileMaker, Firebird, Access, etc (not counting the different versions of Oracle and other databases I'm not as familiar with).

    See in VB.Net there are only so many options but in database.... phew.
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes

  3. #3
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Database Development Forum: Add DB options

    That is actually something we've discussed before (back when it was added to VB.Net), but unfortunately I don't think it would work too well as there are so many options.

    I can easily list about 10 different database systems (although I guess 5 would cover the majority of threads), and at least 3 active versions/editions of each - which means we would need a minimum of about 15 options (whereas VB.Net has 3), and that would only cover the most commonly used systems.

  4. #4

    Thread Starter
    Code Monkey wild_bill's Avatar
    Join Date
    Mar 2005
    Location
    Montana
    Posts
    2,993

    Re: Database Development Forum: Add DB options

    What if we made it version independent? Something like this:
    MS SQL
    Oracle
    Access
    MySql
    Other
    That is the very essence of human beings and our very unique capability to perform complex reasoning and actually use our perception to further our understanding of things. We like to solve problems. -Kleinma

    Does your code in post #46 look like my code in #45? No, it doesn't. Therefore, wrong is how it looks. - jmcilhinney

  5. #5
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Database Development Forum: Add DB options

    That is a possibility, but the version is often important too (and by having the DBMS there, people would assume they don't need to tell us).

  6. #6
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Database Development Forum: Add DB options

    For instance MySQL 4.0 doesn't have any type of stored procedure and different versions os MS SQL have different script components.

    Like I said I like the idea but I don't see it as feasible..... unless we can make it a drop down?
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes

  7. #7
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Database Development Forum: Add DB options

    Besides it would be just one more option people would fail to set... or if they did, then they wouldn't realize that it replaced the text in the subject line .... which is why there are threads titled [2005] or [2008] from time to time.... only now it would be [SQL] ... [mySQL]

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  8. #8
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Database Development Forum: Add DB options

    To be honest I think the best thing we can do is try to "train" people who don't give the information we need - the Before you post sticky gives an explanation of the things that are usually needed, so directing them to that (repeatedly if needed!) should help.

  9. #9
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Database Development Forum: Add DB options

    Quote Originally Posted by techgnome
    Besides it would be just one more option people would fail to set... or if they did, then they wouldn't realize that it replaced the text in the subject line .... which is why there are threads titled [2005] or [2008] from time to time.... only now it would be [SQL] ... [mySQL]
    Why was it coded that way? Why not add it before whatever text is in there?
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes

  10. #10
    WiggleWiggle dclamp's Avatar
    Join Date
    Aug 2006
    Posts
    3,527

    Re: Database Development Forum: Add DB options

    Quote Originally Posted by kasracer
    Why was it coded that way? Why not add it before whatever text is in there?
    Well i think it was made with the idea that people would go from top to bottom... Select Version, Add title, Post question/etc. And it probably wasnt taken into consideration.
    My usual boring signature: Something

  11. #11

    Thread Starter
    Code Monkey wild_bill's Avatar
    Join Date
    Mar 2005
    Location
    Montana
    Posts
    2,993

    Re: Database Development Forum: Add DB options

    Quote Originally Posted by techgnome
    Besides it would be just one more option people would fail to set... or if they did, then they wouldn't realize that it replaced the text in the subject line .... which is why there are threads titled [2005] or [2008] from time to time.... only now it would be [SQL] ... [mySQL]

    -tg
    Better than "URGENT HELP NEEDED!!!"

    Kind of off topic, in the vb.net forum, is there a way to require an option and title text?
    That is the very essence of human beings and our very unique capability to perform complex reasoning and actually use our perception to further our understanding of things. We like to solve problems. -Kleinma

    Does your code in post #46 look like my code in #45? No, it doesn't. Therefore, wrong is how it looks. - jmcilhinney

  12. #12
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Database Development Forum: Add DB options

    I think it is due to a technical limitation of some sort (perhaps due to usage in a particular browser?), but can't find the Mod forum thread where it was discussed - I can only find the original creation thread (March 06, with 271 posts!), and it would take quite a while to manually look thru the threads since then to find the actual explanation.

  13. #13
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Database Development Forum: Add DB options

    I wouldn't make both required.... sometimes the problem is version independant. Plus I don't think the option value is part of the form data that is posted... it jsut simply runs a client-side javascript that sets the subject line.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  14. #14
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Database Development Forum: Add DB options

    It would also be one more custom thing that would have to get redone each time the site when through a software upgrade.

  15. #15
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Database Development Forum: Add DB options

    would some thing like this be easier to implement/maintain?

    -tg
    Attached Images Attached Images  
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  16. #16
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Database Development Forum: Add DB options

    I would imagine so but I would also imagine no one would read it.
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes

  17. #17
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Database Development Forum: Add DB options

    Well, it's not going to get read any less than the option buttons...

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  18. #18
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Database Development Forum: Add DB options

    Yup I know. Perhaps the site should just read it to the user? Or yell it at the user
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes

Posting Permissions

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



Click Here to Expand Forum to Full Width