Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor and NULL
Message
 
 
À
25/06/2004 15:49:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00917363
Message ID:
00917375
Vues:
11
What's the error?
I've done this code without error.
CREATE CURSOR Temp (IID int)
FOR lnCounter=1 TO 100
  INSERT INTO temp VALUES(RAND()*10000)
ENDFOR

SELECT iid,.F. as Nullable FROM temp INTO CURSOR cTemp READWRITE
ALTER TABLE cTemp ALTER COLUMN nullable NULL
>Is there any way to make a column in a cursor NULLable? Let say I have this SELECT-SQL:

>SELECT Field1, .F. AS Field2 FROM MyTable INTO CURSOR curOption READWRITE

>I want to be able to assign NULL to the Field2 column. I've tried

>ALTER TABLE curOption ALTER COLUMN Field2 NULL

>but it give me an error.

>Any ideas?
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform