Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql upate failure message
Message
 
 
To
18/10/2005 06:34:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01059862
Message ID:
01059869
Views:
8
>
>1)
>
>i just import data from vfp database to sql server,but some filed shows
>'< null >' values, how i will replace with some defalt value for this.


You can create DEFAULT constraint for that field. If it's to late or it doesn't work for you
UPDATE mytable 
    SET myfield = < some vaklue >
  WHERE myfiled IS NULL
>2) >while i m updating the data in sql server, some places the string
>lenght comes more than filed definition
>
>say eg. string lenght 'ABC1234'
>filed length (4), that time i m getting updation failure mesage.
>how will i solve this prob.


You can either increase the size of the field to acomodate data (varchar would be good) or truncate data to fit the field length.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform