SQL Select with non keys?

[Dan01]

Hi, I can successfully select records from and IMAGE dataset via ODBC using a key field. Is it possible to select records via SQL using non keys? Thanks, Dan.

 

[Cagliostro]

yes, but you can't distinct/group by/where image =/image like... Ion Filipski

filipski@excite.com

 

[Dan01]

Thanks for the message. IMAGE is a database on HP3000. It does not contain images. When I try to access a large dataset, the Windows operating system says visual basic project no longer responding. Dan.

 

[Cagliostro]

be patient, wait more time. Or switch to MySQL/SQL Server/Oracle... Ion Filipski

filipski@excite.com

 

[Dan01]

Ion, Minisoft technical support says if the field is defined as an OMNIDEX key, then the query will go quickly. You are right about the patience, technical support said it would complete evenually, but would be slow. Thanks for your comments. Dan.