Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DataExplorer and Oracle query select on sequence error
Message
De
24/09/2005 13:22:04
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01052728
Message ID:
01052731
Vues:
7
>Hi All,
>
>I am using the DataExplorer Application to connect to an Oracle database. I want to select the sequence-value following the last sequence :
>
>select -seq_object_id.nextval from life311.fund
>
>
>I get the following error: Microsoft OLE DB Provider for ODBC Drivers : [Microsoft][ODBC driver for Oracle][Oracle]ORA-02289: sequence does not exist
>
>When I perform the same action in TOAD, I don't get an error.
>
>Could someone help me with this?
>
>Thanks beforehand.

How about:
select seq_object_id.nextval from life311.fund
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform