Hi Cetin
>Seeing ppl suggesting ways like this I wonder if FB doesn't support usual parameter passing? ie:
No Firebird is a beautiful thing. I had faced a similar problem to as Kerwam, so to get things working as of deadline I had gone this long way <g>. My advise give FireBird a try you won't regret it VFP and FB seems like they are cousins, if not real brothers/sisters <g>.
It will handle the following and more
>myDate = {^2005/1/1}
?sqlexec(nHandle,'INSERT INTO X (date) values ?m.myDate')>
Seems the bracket in my try was not required around ?m.myDate
>PS: RETURN "'" + TRANSFORM(dtoc(m.tdDate,1), "@R 9999/99/99") + "'"
Thanks for the correction to the function.