ups, i knew i had to copy that line properly. what i added to the lex.h was this { "GETUPDATE", SYM(FUNC_ARG1),0,CREATE_FUNC(create_func_getupdate)} i copied the line from the abs function. in fact, as you may see, all my function is nothing but a copy of the abs function with little modifications. > ----- Original Message ----- > From: "Sergei Golubchik" <[EMAIL PROTECTED]> > To: "Gustavo Castro" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; "Fortuno, Adam" <[EMAIL PROTECTED]> > Sent: Monday, September 08, 2003 10:30 PM > Subject: Re: Error 1064 in native function (?) > > > > Hi! > > > > On Sep 08, Gustavo Castro wrote: > > > Hello, > > > i?m using the 3.23.57 version and i?ve declared a native function, but > when > > > i call it (SELECT GETUPDATE(1);) i > > > get this line > > > > > > ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1; > > > > > > I think i?ve followed all the steps right: > > > > > > 1)added the line in lex.h > > > > > > {"GETUPDATE" ...) > > > > What did you add to lex.h, exactly ? > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > Btw, you may ask these questions on [EMAIL PROTECTED], instead > > of general mysql list. > > > > Regards, > > Sergei > > > > -- > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer > > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > > <___/ www.mysql.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]