Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combining fields with SQL?
Message
De
31/08/2000 12:17:05
 
 
À
31/08/2000 11:12:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00411282
Message ID:
00411355
Vues:
11
>When did that change? I've padded combined expressions like that for years to avoid a problem that seems not to exist anymore. Just tested it without the PADR and surprise -- no problem.

I dunno, but I had a problem yesterday that appeard out of nowhere. I was doing a Select with an JustFname(field) I think, and it was ending up with a 1 character long value. I added the PadR() to it and it turned out right. The wierd parts:

The SQL was INTO ARRAY and only one record matched, so you'd think those two facts would make it almost gaurantee to work like expected, huh?

Anyways, it worked for the longeset time, then started to fail yesterday for some reason.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform