I had to create another table for 'reply', and it worked.
I appreciate your continuous support!!
Regards
On Sun, Apr 2, 2017 at 11:13 AM, Maurice Waka <mauricew...@gmail.com> wrote:
> Great Antony!. But wait, now I have a new issue:
> IntegrityError: NOT NULL constraint failed: post.message
>
> On Sat, Apr 1, 2017 at 10:49 PM, Anthony <abasta...@gmail.com> wrote:
>
>> It is not clear what you are trying to do. You can only insert values in
>> fields that exist -- there is no "name" field in your table, so you cannot
>> insert a value for a "name" field. If you want to insert a value for
>> "reply", then you must specify the "reply" field:
>>
>> db.post.insert(reply='report')
>>
>> Where does "name" come from in this scenario?
>>
>> Anthony
>>
>>
>> On Saturday, April 1, 2017 at 11:56:41 AM UTC-4, Maurice Waka wrote:
>>>
>>> I have this:
>>> Post =define_table('post'
>>> Field('message', 'text',
>>> requires=IS_NOT_EMPTY, notnull=True),
>>> Field('reply', 'text',
>>> requires=IS_NOT_EMPTY).
>>> auth.signatue
>>> )
>>> Post.is_active.readable=False
>>> Post.is_active.writable=False
>>>
>>> controller:
>>>
>>> def index():
>>> code....
>>> db.post.reply.insert(name='report').....to insert into the reply
>>> collumn
>>>
>>> I get error that:
>>> AttributeError:'Field' object has no attribute 'insert'
>>>
>>> If I use:
>>> db.post.insert(name='report')
>>>
>>> SyntaxError: Field name does not belong to the table
>>>
>>> I thought/Learned that to insert: you do e.g.
>>>
>>> db.person.insert(name="Luca")
>>>
>>> db.commit()
>>> What am i doing wrong, and how can i correct it?
>>> regards
>>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/web2py/u801DTQdpHE/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
