[Qt-interest] QSqlQuery and dotted column names

[Bill King]

We look forward to your bug-report/test/fix.

Seriously, there are so many combinations of behaviours due to the SQL 
standards lack of comprehensiveness. Decisions needed to be made. One of 
those was probably to not allow qualified names, tho without research, 
I'm not so sure that it's not allow, just that indexof may be not 
working as _you_ intend it.

On 11/01/2010 08:49 AM, ext TP wrote:
> Thanks Scott,
>
> Yes it works fine, but there may be several columns in the query with the
> same string on the right of the dot. So, it is a problem... IMHO, it is a
> bug in the SQLite driver.
>
> Julien
>
>
> Scott Aron Bloom wrote:
>
>    
>> Depending on the SQL driver, the column names returned may only return
>> the string to the right of the dot.
>>
>> Most likely query.record().indexOf( "firstname" ) works fine.
>>
>> Scott
>>      
>    


-- 
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty Ltd
Brisbane Office