Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter cursor error
Message
From
11/04/2006 09:26:58
 
 
To
10/04/2006 08:27:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01111902
Message ID:
01112354
Views:
19
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform