>>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).
I already have a connection to the database created in ms Acces.
i use this commant to try to modify
=SQLEXEC(NHANDLE,"ALTER TABLE GROUPS ADD COLUMN fax c(20)")
obviously, the connection its working rigth but this command never modify the table or add a column
happy to learn of all the world