🚀 go-pugleaf

SELECT * FROM [Student_Information]
ORDER BY [Last], [First]

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Lee" <gobroski@elltel.net> �������/�������� � �������� ���������:
news:3f470a43@newsgroups.borland.com...
> I have created an Access Database using OLE automation.  In that database,
I
> have created some tables with this line of code:
>
>
>
>     Query->SQL->Text = "CREATE TABLE Student_Information([SID] Int,[Last]
> VarChar(15),[First] VarChar(15))";
>
>     Query->ExecSQL();
>
>
>
> I know I am missing my Index declarations, but I don't want any.  The data
I
> am entering could and probably will have duplicates.  I need to sort this
> Table ascending by last name then first name.
>
>
>
> I keep getting the message Query: Missing SQL Property.
>
>
> Any ideas?
>
>
>
> Thanks,
>
>
>
> Lee
>
>
>
>
>