Information générale
Titre:
PROBLEM: for create a View Remote is need a Connection
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement