-----BEGIN PGP SIGNED MESSAGE-----

Content-Type: text/plain; charset=us-ascii

In message <97Jan3.215558-0500_est.1603933-307+136@NetCreations.com> you write:
>I cannot for the life of me figure out how with msql2 I'm supposed to 
>specify that a field is the primary index, as in it should be unique.

It's all in the manual... :-)

In mSQL2, you make the table and the indexes for that table with
seperate SQL queries.

Here is how you create an index:
	(from http://Hughes.com.au/library/msql2/manual/spec.htm)

 CREATE [ UNIQUE ] INDEX index_name ON table_name (
          field_name
          [ , field_name ] **
   
   ) 

So, if I wanted to index the field 'person' in my 'people' table, and
make it unique, I would do:
 CREATE UNIQUE INDEX personindex ON people (
          person
 )

You can also index multiple fields.



	I hope this helps!
	- djg


- --
D.J. Gregor
dj@gregor.com


-----BEGIN PGP SIGNATURE-----
Version: 2.6.2

iQCVAwUBMs4Lakvw4EoOYRhdAQFKVQQAjYE5YBEKb38IH9TjseuLBIDmKVWmKHqL
dzNRNHzPHEVQmFZyP/23BkVcaa2guWveajDliyORMprbxIgSfWni76tc0TrkDLTF
SnaTBs/AjHqhPmxWtXI74r6XRMoqmzN8ZIlgYVuZn6PeOtyRSdoYlT77jNvYts3O
OwMpGvOhMJY=
=t5B8
-----END PGP SIGNATURE-----
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!