Gerard,
>As ametter of interest, the Jury seems to be out on whether Stored Procedures are a better tool than code.. you are obviously in the SP camp.Count me in as being in the SP camp as well, although I don't think that the "jury's still out" on this subject. <g>
~~Bonnie
>Hi Kevin...
>I have that working now..thanks
>
>As ametter of interest, the Jury seems to be out on whether Stored Procedures are a better tool than code.. you are obviously in the SP camp.
>I dont rally know enough yet at this stage to make a decison
>I always kept away from them in VFP. as I thought it would be a limiting factor... having to update a full database (rather than just code) if any 'coding type' changes were mad.
>
>regards,
>
>Gerard
>
>
>
>
>>Hi, Gerard,
>>
>>If you want to construct your SQL syntax in your application layer, the syntax would be...
>>
>>
>>string lcSelect = lcSelect = "DOC_DATE BETWEEN '" + ldFrom.ToString() + "' AND '" + ldTo.ToString() + "'";
>>
>>
>>However, I don't advise this - you're better off building a stored procedure that accepts the 2 dates as parameters (the "@" symbol that you were using is for SQL parameters inside SQL server).
>>
>>Kevin