Information générale
Catégorie:
Applications Internet
>>>>>Hi, Naomi,
>>>>>
>>>>>Yes, I can, but it doesn't change the outcome - works locally and failed on server
>>>>>
>>>>
>>>>If you switch to VFPOleDB what error you're getting?
>>>>
>>>>Also, is directory with VFP tables is opened?
>>>>
>>>Directory is open and works fine for SQL SELECT. SQL UPDATE is an obstacle.
>>
>>Could it be that you don't have rights for UPDATE of this table under that particular login?
>No, field replacement(SQL SELECT, assignment and RSS.UPDATE) works fine.
Appears that by using
CN.EXECUTE SQLSTR
instead of
RS.OPEN SQLSTR ...
solving the issue with the error.
Thank you
Précédent
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