Results 1 to 3 of 3

Thread: Run VB Functions in SQL Code?

  1. Jul 23rd, 2003, 07:05 PM #1
    cnukem
    cnukem is offline

    Thread Starter
    New Member
    Join Date
    Jul 2003
    Posts
    1

    Run VB Functions in SQL Code?

    Hi guys, my first real database program and I'm just stuck on one thing:

    I have a table that has a generic birthdate for each member in the format mm/dd/yy. I have a vb function setup to do an age calculation based on today's date called Age(). How do I go about making sql use the function?
    Reply With Quote Reply With Quote
  2. Jul 25th, 2003, 07:20 AM #2
    ns-code
    ns-code is offline
    Addicted Member
    Join Date
    Jul 2000
    Location
    Novi Sad, Serbia and Montenegro (formerly known as Yugoslavia)
    Posts
    148
    You cannot use user functions in SQL. Sorry.
    ( : ns-code : )
    FCP Products
    Reply With Quote Reply With Quote
  3. Jul 25th, 2003, 08:24 AM #3
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    ns-code is right.... SQL itself cannot call VB functions, or C or C++, or C#.... or Java....
    * 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??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width