Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
Hi Russ.
Probably the quickest way is to create a cursor with a structure that matches your intended Select results, only with all the fields set to allow Nulls and them stick
union select * from FixStructure
into your select (assuming that you called the cursor FixStructure. Now when Fox gathers the structure information it will now that the output fields need to be able to hold Null, and because the FixStructure cursor is empty there isn't any extra data overhead like you would get if you tried to process the result and add Null support later.
Ian Simcock.
>I am trying to use a select statement to create an empty cursor into which I can write data, like:
>
>Select blah, blahh, blahhh FROM blaaaah INTO CURSOR myCursor READWRITE
>
>Unfortunately, I need the fields in the resulting cursor to accept nulls, which they do not. How can I make these fields accept nulls?
>
>TIA
>
>Russ
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