>>>>For the Generic class do not use CS, but for the instances, use it.
>>>>
>>>
>>>Why?
>>
>>Becuase that way you could be sure every time for the exact length of the fields.
>>You could set DEFAULT values for the fields.
>>You could easily transform DateTime to Date ....
>
>Good points. Maybe in the next revision of my code I will make my generic CA class to work with CursorSchema property in a generic way. I am making only baby steps.
>
>I have not noticed that when you initially creates test samples, you used ODBC (not ADO); I was under impression that using ADO is better. Is this correct?
Yes, for new SQL Servers (2005 and 2008).
ADO handles new data types better.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.