Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql upate failure message
Message
 
 
À
18/10/2005 06:34:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01059862
Message ID:
01059869
Vues:
9
>
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform