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 08:37:48
 
 
To
24/08/2006 00:03:39
Aye Mya Thida Kyaw
Ingenuity Microsystems Sdn Bhd.
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01148112
Message ID:
01148164
Views:
18
>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

as in every translation context,
you can automate the "passive semantic part" = tables + data
but for "active semantic part" = code
you have to translate it manually.

Good work
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform