Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New column of remote table
Message
From
01/04/2000 22:42:13
 
 
To
01/04/2000 21:03:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00353992
Message ID:
00353993
Views:
16
>I need to know how to insert a new column (or modify the structure) in runtime in a remote table from vfp6.0..
>
>thanks in advance

If by "remote table" you mean one in a backend database like SQL Server or Oracle, you would need to use SQL passthrough to do this. Use SQLCONNECT() to create a connection to the database, then SQLEXEC() to pass a command to the back end to add the column.

The exact syntax of the command you pass using SQLEXEC() depends on the backend you're using.

You also need permission in the remote database to modify the table(s).
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform