Hi,

i have found some problems when i can to build free fields at SELECT runtime.

THIS IS SIMPLE CODE ONLY FOR REPRO THE PROBLEM.

CREATE CURSOR MyTable ( A I )

APPEND BLANK

* POINT 1 : INTEGER not supported
CREATE CURSOR Dummy ( MyInt I NULL, MyChar73 C(73) NULL,MyCurrency Y NULL, MyMemo M NULL)

SELECT	Dummy.MyInt 		MyInt		;	&& <--- INTEGER GO TO N(11)
,	Dummy.MyChar73  	MyChar73	;
,	Dummy.MyCurrency 	MyCurrency	;
,	Dummy.MyMemo		MyMemo 		;	
FROM MyTable INTO CURSOR MyCursor1 READWRITE
DISPLAY STRUCTURE

* For build a INTEGER Field i need put Dummy Cursor on Query:
* - slow performance
* - reduce to 8 number of data tables

* Point 2 : SELECT not read NULL support on external values
SET NULL ON   && on help SET NULL not influence the SELECT behaviour, it would have to make it
INSERT INTO Dummy ( MyInt) VALUES (NULL)

* next report a error, Ignore and continue
SELECT	Dummy.MyInt 		MyInt		;
,	Dummy.MyChar73  	MyChar73	;
,	Dummy.MyCurrency 	MyCurrency	;
,	Dummy.MyMemo		MyMemo 		;	
FROM MyTable INTO CURSOR MyCursor2 READWRITE

*
SELECT	Dummy.MyInt 		MyInt		;
,	Dummy.MyChar73  	MyChar73	;
,	Dummy.MyCurrency 	MyCurrency	;
,	Dummy.MyMemo		MyMemo 		;	
FROM MyTable,Dummy INTO CURSOR MyCursor3 READWRITE
DISPLAY STRUCTURE

* Then, also for NULL is need to put external values in SELECT

Fabio