Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

CREATING SEGMENTED INDEX IN PERVASIVE

This works ok for me:
strSQL = "CREATE INDEX key_1 ON  MUT01 (MutNewkey)"
 dbconn.Execute (strSQL)

but what would be the syntax for a key wich has to be (now I created by hand) segmented?

tabel.jpg
index.jpg
0
BIAPRO
Asked:
BIAPRO
1 Solution
 
mirtheilCommented:
strSQL = "CREATE INDEX key_2 ON  MUT01 (MutKlant, MutBoek, MutDate)"

Full syntax of CREATE INDEX is at http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=sqlref/syntaxref.3.22.html
0
 
BIAPROAuthor Commented:
perfect,thanks
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now