[wxCode-users] [ wxcode-Bugs-2888726 ] BUG: wxARG 1.2.0-rc3 & Firebird

[SourceForge.net <no...@so...>]

Bugs item #2888726, was opened at 2009-10-29 11:06
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=462816&aid=2888726&group_id=51305

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: wxARG
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Matías Szeftel (mszeftel)
Summary: BUG: wxARG 1.2.0-rc3 & Firebird

Initial Comment:
In wxActiveRecordGenerator when working with FireBird class wxActiveRecordGenerator in methods Prepare discovered bug: 
Run the query: 
===
wxString Query = wxString:: Format (wxT ( "SELECT * FROM% s LIMIT 1"), table. c_str ()); 
DatabaseResultSet * result = m_database-> ExecuteQuery (query); 
===

For FireBird leads to an error "-104: Invalid token", since the keyword LIMIT is not supported by the FireBird. 

For Corrections should: 
Lines 100 and 145 module wxActiveRecordGenerator line 
===
wxString Query = wxString:: Format (wxT ( "SELECT * FROM% s LIMIT 1"), table. c_str ()); 
/ / ..... and .... 
wxString Query = wxString:: Format (wxT ( "SELECT FIRST 1 * FROM% s"), node. m_tableName. c_str ()); 
===

Replace respectively 
===
wxString Query; 
if ((AR_FIREBIRD == m_dbType) 
| | (AR_FIREBIRD_EMBEDDED == m_dbType)) 
( 
Query = wxString:: Format (wxT ( "SELECT FIRST 1 * FROM% s"), table. c_str ()); 
) 
else 
( 
Query = wxString:: Format (wxT ( "SELECT * FROM% s LIMIT 1"), table. c_str ()); 
) 

/ / ..... and .... 

wxString Query; 
if ((AR_FIREBIRD == m_dbType) 
| | (AR_FIREBIRD_EMBEDDED == m_dbType)) 
( 
Query = wxString:: Format (wxT ( "SELECT FIRST 1 * FROM% s"), node. m_tableName. c_str ()); 
) 
else 
( 
Query = wxString:: Format (wxT ( "SELECT * FROM% s LIMIT 1"), node. m_tableName. c_str ()); 
) 
===

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=462816&aid=2888726&group_id=51305