Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace a field in a table using a master table
Message
De
21/04/2000 04:52:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
20/04/2000 14:47:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00361486
Message ID:
00362156
Vues:
16
>Back again,
>> It was a typo, all of the l's look like 1's(one's). Changed all that I thought were<
>> one's to lower L. Program works, but still doesn't update all of the records.<
>> I checked both tables for ssnumber's and group codes. <
>> the source table client has all its ssnumbers and group codes <
>> I then opened the policy table in ssnumber order, then i looked at the <
>> fields ssnumber , and group code in a browse mode . It appears to update <
>> two times then quit, leaving two to three updates undone. <
>> My client table has 2085 records <
>> " " " " no group code records without numbers. <
>> " " " " " ssnumber " " " <
>> My Policy Table has 3091 records <
>> " " " " 37 records without ssnumbers <
>> " " " " 1125 records without group code numbers <
>> Any ideas ? <
>> thanks john <


John,
I can't believe this turned out to be this hard :) I suspect ssnumber is type char and field sizes are different causing match errors. Would you pls give table structures for those fields and tags you have with their key expressions.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform