Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How indexes, triggers & stored procedures work with SQL?
Message
From
24/08/2006 00:03:39
Aye Mya Thida Kyaw
Ingenuity Microsystems Sdn Bhd.
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How indexes, triggers & stored procedures work with SQL?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01148112
Message ID:
01148112
Views:
60
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
Next
Reply
Map
View

Click here to load this message in the networking platform