Barry


Damit I'd forgotten that one. Now I see it I can say it has been posted before.

Roy Lambert

<<<Roy Lambert wrote:

Damit I'd forgotten that one. Now I see it I can say it has been posted before.>>>

It sure has, in this very thread

LOL

Peter

Peter

>It sure has, in this very thread


Can't have been - I didn't see anything

Roy

Roy Lambert wrote:

>Checking up I've realised I, and probably Barry, have misread the
>manual and it is WAD not a bug. Damn shame though.

Roy, what is a WAD?

--
Michael Riley
GySgt USMC Retired
http://capecodgunny.blogspot.com/

Michael

>Roy, what is a WAD?


Working As Designed

Roy

>>EDBQuery1.SQL.Clear;
>>EDBQuery1.SQL.Add('INSERT INTO Table1 (ID, Text1)');
>>EDBQuery1.SQL.Add('VALUES(:ID, :Text1)');
>>EDBQuery1.Prepare;
>>EDBQuery1.ParamByName('Text1').AsString:='Some text';
>>EDBQuery1.ExecSQL;
>>ShowMessage(EDBQuery1.ParamByName('ID').AsString);

Cool!

So the query behaves like a StoredProcedure with an "Out" param! You can access the params after an ExecSQL call. Very useful!

I wish Tim would include details of more of these brilliant features in the help. There's plenty in the Help already, but extra stuff keep's surfacing. Does he add it in minor releases & just not tell us??

Adam


>I wish Tim would include details of more of these brilliant features in the help. There's plenty in the Help already, but extra stuff keep's surfacing. Does he add it in minor releases & just not tell us??

Its more "how to" than technical manual. The simpler stuff is already in there but trying to cover everything is impossible. Just be grateful for these ngs (I know I am)

Roy