Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter cursor error
Message
De
11/04/2006 09:26:58
 
 
À
10/04/2006 08:27:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01111902
Message ID:
01112354
Vues:
18
Hi Geraldo,

I've read the other replies up till now.
You don't provide a whole lot of information...

Where does the sursor come from?... You say "a readwrite cursor" but you don't say how it is created in the first place. Is it from a SQL statement, a CREATE CURSOR or what?

You also say it is imtermittent. But you do not say it is always on the SAME cursor, with the SAME FIELDS.
In other words, are there different cursors possible and does it only fail on some of them?

You don't mention if there is buffering set for this 'cursor'. Is there?

You don't mention if there might be TRANSACTION processing involved. Is there?

Finally, in case it is relevant, a "cursor" will fail to update when an ALTER TABLE... is done if the cursor has field NAMES greater than 10 characters.

good luck


>Hi,
>
>Sometimes when I try to alter a readwrite cursor I get an error message.
>
>
>Create cursor curTest (Field1 Integer, Field2 Char(10))
>Alter table cursor curTest add column Field Char(10) && Program Error here
>
>Program Error
>Cancel
>Suspend
>Ignore
>Help
>File 'c:\docume~1\admini~1\config~1\temp\00000geh066r.tmp' does not exist.
>
>
>This error occours sometimes only. Don't occours aways.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform