Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Interface - Online generator
SQL primary keys
  • Page:
  • 1

TOPIC:

SQL primary keys 17 Jul 2012 04:39 #2804

I don't find a way to define the primary keys for my SQL tables in order to make them linked between them. How do I achieve that ?
Can you drive me to the documentation on this particular point ?
Seems a real good documentation in missing in your tool.
Thanks..
You tool looks very promising.

Please Log in or Create an account to join the conversation.

Last edit: by e-struct.

Re: SQL primary keys 17 Jul 2012 10:16 #2807

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
The primary key is always 'id' for every table. You cannot redefine it for the moment.

When you want to create links, you need to instance a 'Foreign Key' data field
and then, drop a 'Table' in the drop zone of this FK field.

have a look on the videos if you don't understand.
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Re: SQL primary keys 17 Jul 2012 18:42 #2812

Does it matter to have more than one Foreign Keys linked to multiple tables ?
The videos are not so explicit on this particular point...
Is there any good pdf doc available describing this in detail ?
- Any good tool is always based on a strong documentation :whistle:
Can you also explain what is FK integrity in properties dialog ?
Thanks a lot.

Please Log in or Create an account to join the conversation.

Last edit: by e-struct. Reason: completing question....

Re: SQL primary keys 19 Jul 2012 09:53 #2819

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
If you want to create a many to many relation, you can. But it is not handled in forms or layouts if you want to see theses cross reference values.
Ex : multiple select, checkboxes, or list of all related datas. Not available for the moment.

Coding it is not difficult when you understand how the model works.

I will start to write a documentation when the V2.0 will be released. For the moment the source is a bit obsolete.

FK integrity means for example :
if you have items within a category.
When you delete a category, it will delete all contained items.
Or it can leave the items and reset category fk to 0 (null)
Or nothing happens (you must be careful when you delete objects that are referenced by others)
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Interface - Online generator
SQL primary keys
Time to create page: 0.059 seconds
“
”

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started

Log In Sign In