Recent

Author Topic: MySQL Connection ?  (Read 4027 times)

thaimann

  • Jr. Member
  • **
  • Posts: 84
MySQL Connection ?
« on: October 17, 2006, 10:06:50 pm »
I noticed that now on the mysql connection component the is a DeleteSQL, UpdateSQL and InsertSQL varibles of Tstrings.  How do I use them?

Thx,   Terry

HowardH

  • New Member
  • *
  • Posts: 16
    • http://www.celtic-fiddler.com
RE: MySQL Connection ?
« Reply #1 on: May 26, 2008, 03:36:13 am »
I have been wondering the same thing, and posted a similar question about 8 months ago. As far as I can tell, nobody actually knows how to use those properties, and I have been unable to find any mention of them in any documentation. I was able to "brute-force" my database updates using TMySQL50Connection.ExecuteDirect, although I am reasonably sure that is not what the designer intended. I got that far by poking around in the source code for unit db.

As for what the designer of the TSQLdb components actually intended for the DeleteSQL, UpdateSQL, and InsertSQL, that appears to be a deep, dark secret.
Howard Lee Harkness
The Celtic Fiddler http://www.celtic-fiddler.com
Violins and Accessories

 

TinyPortal © 2005-2018