Hi,

for CREATE SQL VIEW MyremoteView REMOTE AS SelectCommand
i need to have a connection.

This give me problems:

1. I cannot create a view programmatically without a backend connection available.
2. I cannot create a view programmatically without a DSN or a CONNECTION defineded on DBC.
3. I cannot edit a view without the binded connection available;
the view property "ConnectName" is ReadOnly, and i cannot use DBSETPROP()
for redefine it.

Yes, VFP need this for build VIEW properties, but if i create view
only for use it with runtime CONNECTIONSTRING or ConnectionHandle
( for safety reasons ) this is a annoying behaviour.

A solution is CREATE CONNECTION - CREATE VIEW - DROP CONNECTION, but this
not resolve the safety problem, because i need to redefine the VIEW at runtime.

Exist a solution simple?

Exist a solution with DBC Table editing ( FAQ-link-Thread )?

Fabio