Board index » delphi » Needed: A Component that can create an SQL dump from TDataset

Needed: A Component that can create an SQL dump from TDataset

I am looking for a component can generate table generation and data
insertion code in SQL-92 from a TDataset. There surely must  be
something (free is better) in existence.

It would be nice if it can generate escape sequence for BLOBS as well.

 

Re:Needed: A Component that can create an SQL dump from TDataset


what is a probelm, this is simple

One idea :

select <your fields> from <table> where [ID] = 0
of course, you don't have id 0, this recordset will be empty

now
TDataSet.Insert;
//insert filelds...
TDataSet.Post;

Quote
"My Deja" <mydejam...@yahoo.co.uk> wrote in message

news:90acdc45.0206021438.7414d46d@posting.google.com...
Quote
> I am looking for a component can generate table generation and data
> insertion code in SQL-92 from a TDataset. There surely must  be
> something (free is better) in existence.

> It would be nice if it can generate escape sequence for BLOBS as well.

Other Threads