using UPDATE returns error:Field does not accept null values

Forum for DBF Commander discussing.

using UPDATE returns error:Field does not accept null values

Postby yagihito » Wed Jan 25, 2017 12:19 am

I’m trying to copy the va_this_ye from a V-AUX2001 in to the current V-AUX va_last_ye with this statement:
UPDATE 'C:\DDMS\W1\V-AUX.dbf' SET VA_LAST_YE = (SELECT VA_THIS_YE FROM 'C:\DDMS\W1\V-AUX2011.dbf' WHERE 'V-AUX.keys' = 'V-AUX2011.keys' and NOT EMPTY('V-AUX2011.VA_THIS_YE'))

This is the data…
Untitled.png
data
Untitled.png (73.18 KiB) Viewed 6222 times


I have not been able to get past this error "Field VA_LAST_YE does not accept null values."

I’ve tried plugging in .00 or .0 in the current year file and also replacing any blanks in the previous year file with .00. Still no luck!
yagihito
 
Posts: 2
Joined: Tue Jan 24, 2017 10:54 pm

Re: using UPDATE returns error:Field does not accept null va

Postby Admin » Wed Jan 25, 2017 10:56 am

DBF Commander Free doesn't support UPDATE statement. Please use DBF Commander Professional version instead.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 116
Joined: Wed Apr 21, 2010 7:27 pm

Re: using UPDATE returns error:Field does not accept null va

Postby yagihito » Wed Jan 25, 2017 6:10 pm

well, that's embarrassing! thanks!
yagihito
 
Posts: 2
Joined: Tue Jan 24, 2017 10:54 pm


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 1 guest

cron