Good point. I forgot about that method. In the early beta this method had a lot of problems so the only reliable way of getting the schema was to use the where clause. Thanks for pointing it out.

>Just to get the schema of a table I use FIllSchema. Seems to work fine
>
>>In your select statement for retrieving your table from the backend, just add a where clause of "where 0=1". This will pull the table structure but without any data.
>>
>>>All,
>>>
>>>How do you fill a dataset for an empty table? I have an example of filling a DataSet and creating a NewRow() for the table and adding it to the table, but if I just want to add a new record, how do I get the DataTable structure so I can add the new record?
>>>
>>>TIA
>>>
>>>Rex