Joseph J. Strout wrote:
At 8:30 AM -0500 2/24/05, Michel Dion wrote:
I have experienced with mySQL, SQL Server, Access, Filemaker. In all
of those, I know how to make a primary key auto increment, so that I
have a unique ID integer to call the record.
Stupid question, but how do I do that with the REAL database?
You simply use the _rowid field, which is built in for exactly that
purpose.
Best,
- Joe
So, the _rowid field is my primary key for all table, and the value of
the _rowid is what I would use in a related table to relate to that
record. No need to create primary key field like ProjectID,
TimesheetID, ClientID, etc.
There is a option "primary key" available for other field. I guess it
is useful only if I want as a primary key something else that an auto
increment number. right?
Just want to make sure before I start coding. I know I can do this
project quickly with Access, or Filemaker but I'd like to give it a shot
with REALbasic.
Thanks
Michel
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|