In your first example the project table is referning a table that does
not yet exist. You can do it but you must replace
SQLField("id_project_location",db.project_location))
with
SQLField("id_project_location","reference project_location"))
On Sep 2, 9:43 am, greenpoise <[email protected]> wrote:
> I have two samples here, one works, the other does not. They are
> pretty similar:
>
> Example#1
>
> DOES NOT WORK:
>
> db.define_table("project",
> SQLField("project_number", "text", notnull=True, default=None),
> SQLField("project_name", "text", notnull=True, default=None),
> SQLField("project_description", "text", notnull=True,
> default=None),
> SQLField("project_status", "integer", notnull=True,
> default=None),
> SQLField("contact", "integer", notnull=True, default=None)
> SQLField("id_project_location",db.project_location))
>
> """
> Table definition
> """
> db.define_table("project_location",
> SQLField("address_1", "text", notnull=True, default=None),
> SQLField("address_2", "text", notnull=True, default=None),
> SQLField("address_3", "text", notnull=True, default=None),
> SQLField("municipality", "integer", notnull=True, default=None),
> SQLField("country", "text", notnull=True, default=None),
> SQLField("zip_code", "text", notnull=True, default=None),
> SQLField("id_project", db.project))
>
> Example#2
> DOES WORK:
>
> db.define_table("project",
> SQLField("project_number", "text", notnull=True, default=None),
> SQLField("project_name", "text", notnull=True, default=None),
> SQLField("project_description", "text", notnull=True,
> default=None),
> SQLField("project_status", "integer", notnull=True,
> default=None),
> SQLField("contact", "integer", notnull=True, default=None))
>
> """
> Table definition
> """
> db.define_table("project_location",
> SQLField("address_1", "text", notnull=True, default=None),
> SQLField("address_2", "text", notnull=True, default=None),
> SQLField("address_3", "text", notnull=True, default=None),
> SQLField("municipality", "integer", notnull=True, default=None),
> SQLField("country", "text", notnull=True, default=None),
> SQLField("zip_code", "text", notnull=True, default=None),
> SQLField("id_project", db.project))
>
> If I do follow example#2, I would be creating a One-Many relationship,
> more locations per project which I do not want. Thanks
>
> dan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
