SQL Problem3

• • Reply

  19 years ago

  by azmh

  j

  , United States

  Joined 19 years ago

  For  James Crowley...
  hi James Crowley:
  I know all thing you said but i want to make a new function
  like "Format" Or "DateDiff" Or  else To use it in SQL Statment
  like
  db.excute "Select DateDiff(""n"",Time1,Time2) From tbl"
  db.excute "Select MyFunction(Time1,Time2) From tbl"
  Without Separate The SQl String Like You Said.
  I Want to Make SQl Drive Know my New Function defintion....To make My Program more Faster.......
  Do have a solution For this Or not????
  If you have What is......
                                   E. Ahmed Z.H.

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  I don't believe that is possible with Access or MySQL.... in MS SQL you could try a stored procedure.

  Report abuse
• • Reply

  19 years ago

  by hobbes68

  hobbes68

  Milan, United States

  Joined 19 years ago

  it is actually possible to write your own function in MYSql so that it it is the SQL engine to return you the values as you like. I do not know much more than redirecting you to the manual at:
  http://www.mysql.com/doc/C/R/CREATE_FUNCTION.html
  

  
  The problem though, is not of the SQL language, but of the additional features of the SQL engine environment, so you have to check in all the different tools ...
  

  
  cheers :-)

  Report abuse