Naming Rows in DCT

[roboticstudent]

Hello,

Is there a way to name rows in Database Connectivity Toolset (DCT) like one can name columns?

Thanks in advance for help.

[tst]

No, because in a database there is a distinction between columns (fields) and rows (records) - fields are used to decide which data is held and records are the data. You can define one or more of the fields as a key, thus using it to uniquely identify a record - a specific combination can only appear once in the key column.

[Bob_Y.]

That's funny, i was just about to say "Yes, of course" with exactly the same reason.  The unique identifier that is the key IS the name of the row. 

Hope that this helps,
Bob Young

[Dennis_Knutson]

Rows cannot be named in the database. If you only want to retrieve certain rows, you do that in your SELECT query with the WHERE clause. For example, if you have columns x, y, and z in the table tablename and you want all rows where y is less than 10 and z is greater than 5, you can do a SELECT x FROM tablename WHERE y < 10 AND z > 5. Your WHERE clause could also be applied to x; i.e. WHERE x < 100 AND x > 50. You can design your database so that each row is numbered uniquely and this might be what you should do. Databases usually contain something of this sort. You can add an AutoNumber column. Make it a primary key and it wil be Indexed with no duplicates allowed. This column is not something you update, it is automatically incremented with every new record you place in the table. I don't think this forum is really appropriate for discussing all of the details of proper database design. You might want to check other resources.

You are not naming columns with the DCT, You are selecting columns that you have defined when you designed the database.