Information générale
Catégorie:
Codage, syntaxe et commandes
But that means that I still have to fill in the field after the main query is run (combaddr could be 75-375 characters long).
I'll have to use a replace command.
Thanks.
paul
>Hi Paul
>
>You can't do it directly in a SELECT statment but you could do your select and then:
>
>ALTER TABLE ALTER combaddr M
>
>
>
>>I'm using a VFP 5 database (not SQL server data).
>>
>>I'd like to run a query that returns a concatenated string in a memo field.
>>
>>Example:
>>select addr1+CRLF+addr2+CRLF+addr3+CRLF+city+CRLF+state+CRLF+zip as combaddr from address
>>
>>Where combaddr is a memo field. Is there any way to do this?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement