SQLExpress - Xb2.NET     ot4xb  
   Announcement      Free XUG Meeting Toronto/Canada (May 25, 2008)       [ More Info ... ]
sqlexpress
oSqlSELECTcursor:SqlString: Ok to manipulate?
Thread Starter: Mahanimann Started: 12/20/2006 5:24 PM UTC
Replies: 1
12/20/2006 5:24 PM UTC
oSqlSELECTcursor:SqlString: Ok to manipulate?
Reply Quote

Mahanimann

Hi Boris,

I have subclassed SQLSelect and within that new class I manipulate ::SqlString, change ::SetPrimaryKey() and do a ::Refresh() to get a new (and/or reordered) set of data from the same table.

I've done this for a while now, and have found no trouble in any way.  But just to make sure, do you see any problem using this approach?  (I just have to ask because the :SqlString is not documented in the SQLSelect() section in the docs, only in SQLStatement() (from which SQLSelect is inherited from))

Best regards,
Mahanimann
12/20/2006 7:01 PM UTC
Re: oSqlSELECTcursor:SqlString: Ok to manipulate?
Reply Quote

Boris Borzic

"Mahanimann" <paaldalen@gmail.com> wrote in
news:kyqj7w1tad0j5jd.201220061826@ANDREA:  

I have subclassed SQLSelect and within that new class I manipulate ::SqlString, change ::SetPrimaryKey() and do a ::Refresh() to get a new
(and/or reordered) set of data from the same table.
I've done this for a while now, and have found no trouble in any way. But just to make sure, do you see any problem using this approach?  

Yes, :SQLString is an access/assign method which allows you to modify the SQL statement.

I just have to ask because the :SqlString is not documented in the
SQLSelect() section in the docs, only in SQLStatement() (from which
SQLSelect is inherited from)

All subclassed properties and methods are available in the higher level class.  

Best regards,
Boris Borzic
-- news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools