Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memos/Text and SQL-Server
Message
De
09/03/1998 16:34:00
 
 
À
03/03/1998 10:43:25
Steve Camsell
Windmill Associates
Bath, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00082290
Message ID:
00083493
Vues:
31
>Thanks very much for responding. Using the Text datatype and allowing nulls sounds good to me, otherwise I could end up with overflows when I send my data back to the server. It was the mimimum 2K per record that I was really worried about.

I use a var255 field *and* a text field. The var 255 field catches most values, leaving the text field null so it doesn't use a 2k page. If the length of the data is > 255, I store the overflow in the Text field. I think this is the most efficient use of disk space, although it takes a little manipulation on your front end. Some people use 3 or 4 var255 fields instead of a text field.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform