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

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
wxCode-users mailing list
wxCode-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wxcode-users

Reply via email to