Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>If I have view1 and table1 in the DE (one of the tables in view1 is table1), view1 being the default between the two, what do I need to say to use table1? Order by? Select? Index on? Set order to? Use? Between tables and views, this really confuses me.
>>
>>Thanks
>>JD
>
>If table1 is a source table to view1, do NOT put table1 in the DE. Only put the view1 in the DE. When the view is opened, the table will automatically be opened.
>
>Once the view [and table] have been opened, you can simply SELECT TABLE1 and SET ORDER TO SOMEORDER. YOu do not have to SELECT TABLE1 to set the order for that table. You can issue a SET ORDER TO SOMEORDER IN TABLE1
Mark,
The index for that table is a .cdx, and the primary key is a field called stocknum. I put in this code:
SELECT inventory
SET ORDER TO stocknum
It still gives the error "Table has no Index Order set". Any ideas?
Thanks
JD
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement