Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How indexes, triggers & stored procedures work with SQL?
Message
De
24/08/2006 00:03:39
Aye Mya Thida Kyaw
Ingenuity Microsystems Sdn Bhd.
Kuala Lumpur, Malaisie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How indexes, triggers & stored procedures work with SQL?
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01148112
Message ID:
01148112
Vues:
59
Dear All,

I converted the foxpro database to SQL Server 2000 Database. And I created the remote views either. As we all know, the SQL Server doesn't take the stored procedures and triggers when transforming the database, is there any programmatic way to put the triggers and stored procedures in sql tables same as Fox tables? And, previously, I was using a lot of "Indexseek" in my codings. So now it is not working with SQL Tables eventhough the table has that index. I tried to learn how the sql indexes work but still don't get idea yet. How should I call and use the SQL Indexes from Fox?

May I any help on this problem....

Thanks in advanced.

Regards,
Mya
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform