General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Does not accept null values
This code is giving the error "field 'fieldname' does not accept null values". Why not?
IF ! USED('inv_this_trans')
set null on
SELECT inventory.stocknum, ;
LEFT(SUBSTR(inventory.p_descript,1,AT("$",inventory.p_descript,2)+8),50) AS memotxt, ;
inventory.trans_id ;
FROM Tomparco!inventory AS inv_this_trans ;
INTO CURSOR tempcursor ;
ORDER BY stocknum
USE DBF("tempcursor") IN 0 AGAIN NODATA ALIAS inv_this_trans
USE IN tempcursor
ZAP IN inv_this_trans
ENDIF
Thanks
JD
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only