>I use forward read only cursor in C# accessing VFP with OLE DB.
>When my command is "select * from mytable" without any order clause is reading records in recno() order guarantied. It seems to work in this way just wondering whether there is any formal confirmation.
>I guess, there is no difference between OLE DB internal implementation and SQL engine in VFP itself.
>
>
>TIA
>Michael
There is no guarantee that the output will be in recno() order, although this will usually be the case. If you depend on a specific order, I suggest that you add a field for this purpose, for instance a datetime() field. Especially if you at a later point must switch to for instance SQL server, where the record order is completely out of your hands, you will need this index.