[PyQt] Beginner troubles with QlineEdit & SQLite3

[Josh Flinner]

Hey Ryan I would like to thank you for your help with my code. I played
around with the function you filled out for me and got it working  just had
to change the -1 to a 0 and worked perfectly. I have then been able to use
it for multiple line edits and get it mapped to the correct columns in the
db. Again I just want to say thank you for your help and being patient with
me.


On Mon, Jun 10, 2013 at 1:32 PM, Ryan Hanson <crossrocker at gmail.com> wrote:

> I will reply to you on stackoverflow
>
>
> On Mon, Jun 10, 2013 at 1:21 PM, Josh Flinner <joshfokis at gmail.com> wrote:
>
>> Unfortunately There isn't anything listed under the section for that. I
>> still cannot get that with the right code to update that row.  this is my
>> post on StackOverflow and it is just the base code I have started with.
>> http://stackoverflow.com/questions/16974379/use-qlineedit-to-udpate-sqlite-database-in-pyqt
>>
>>
>> On Mon, Jun 10, 2013 at 11:11 AM, Ryan Hanson <crossrocker at gmail.com>wrote:
>>
>>> Look at the documentation for qlineedit.text() that should be what you
>>> need.
>>> On Jun 10, 2013 11:09 AM, "Josh Flinner" <joshfokis at gmail.com> wrote:
>>>
>>>> I am able to write to the database but I cannot get the text from my
>>>> lineEdit. My edit Strategy is on manual submit and then I call the
>>>> submitAll.
>>>>
>>>>
>>>> On Mon, Jun 10, 2013 at 10:55 AM, Ryan Hanson <crossrocker at gmail.com>wrote:
>>>>
>>>>> Are you having trouble getting the text from your lineEdit or are you
>>>>> having trouble submitting that text to your database?
>>>>>
>>>>> For the latter you might try looking at setEditStrategy from here
>>>>> http://pyqt.sourceforge.net/Docs/PyQt4/qsqltablemodel.html
>>>>>
>>>>>
>>>>> On Mon, Jun 10, 2013 at 9:04 AM, Josh Flinner <joshfokis at gmail.com>wrote:
>>>>>
>>>>>> I am new to both python and PyQt so forgive my ignorance if it is an
>>>>>> obvious solution. I have been trying to link a couple of line edits to
>>>>>> update a new row in a SQLite database when a push button is clicked. I can
>>>>>> create the new row but cannot submit the data from the line edits to the
>>>>>> row. I am also using a table model view to display the database. I have
>>>>>> searched over documents and example codes for the past week or so. Again I
>>>>>> do apologize if it is an easy fix I just cannot seem to figure it out.
>>>>>>
>>>>>> _______________________________________________
>>>>>> PyQt mailing list    PyQt at riverbankcomputing.com
>>>>>> http://www.riverbankcomputing.com/mailman/listinfo/pyqt
>>>>>>
>>>>>
>>>>>
>>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.riverbankcomputing.com/pipermail/pyqt/attachments/20130611/0195428f/attachment-0001.html>