I created an alter table alter column sql statement using afields() and
called the sql looping through all of the tables and it worked great.
Thanks.
On 4/15/2015 11:58 AM, Richard Kaye wrote:
Just to be clear, are these DBFs created from SQL tables? If so, check the
ALTER TABLE...ALTER COLUMN syntax for existing tables where you want to remove
NULL support. Unlike SQL, I believe VFP will assign default values when you
remove NULL support. Otherwise you may need to do what Stephen mentioned and
first update your NULL columns with the appropriate default value.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson
Sent: Wednesday, April 15, 2015 2:44 PM
To: [email protected]
Subject: Nulls
I have a bunch of tables created by exporting from SQL Server and they allow
nulls on each field. Is there a way to not allow nulls for an existing table
other than unchecking each field?
TIA
--
Jeff
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
