CREATE Client.Myd
USE Client.Myd IN 0
You can't change the extension of the .fpt file. You can use different extension instead of .cdx, but it can't be structural, meaning you have explicitly open the index file everytime you USE the table.
>Hi everyone
>
>How can i default the file extend form .DBF to .MYD
>
>then i can use 'USE CLIENT' to open a CLIENT.MYD file
>
>'CREATE PRODUCT' to create a PRODUCT.MYD file
>
>* .IDX and .CDX
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer