Hello Jean-Marc,
Here's how ...
There is a method to change the font within a
VARCHAR field using a DECLARE CURSOR loop and the SRPL function.
In your specific database with CHARacter settings as double quotes ...
The below will change the font from Arial to Tahoma in the table column.
SET VAR vSearchString VARCHAR = "ARIAL"
SET VAR vReplaceString VARCHAR = "TAHOMA"
SET VAR vObsTech VARCHAR = NULL
SET VAR vSrchReplDesc VARCHAR = NULL
SET VAR vChkCurs1 INTEGER = (CHKCUR("c1"))
IF vChkCurs1 = 1 THEN
DROP CURSOR c1
ENDIF
DECLARE c1 CURSOR FOR SELECT OBSTECH FROM LANCTECH
OPEN c1
FETCH c1 INTO vObsTech INDICATOR iv1
WHILE SQLCODE <> 100 THEN
-- Use search/replace value for font
SET VAR vSrchReplDesc = (SRPL(.vObsTech,.vSearchString,.vReplaceString,0))
UPDATE LANCTECH SET OBSTECH = .vSrchReplDesc
FETCH c1 INTO vObsTech INDICATOR iv1
ENDWHILE
DROP CURSOR c1
CLEAR VARIABLES iv%,vSearchString,vReplaceString,vObsTech,vSrchReplDesc
PAUSE 2 USING "Done!"
CLS
RETURN
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
With the above request aside, please note that it
would be polite, if that is the best word, to
send the email request to the RBASE-L list in one
message, and to the R:BASE Support Team in
another message. Please do not send a message to
the public list, and also to personal RBTI email
addresses (myself and John Minyo) all in one
message. We hope you understand this request.
--------------------------------------
Avec la demande ci-dessus de côté, veuillez noter
qu'il serait poli, si c'est le meilleur mot,
d'envoyer la demande par e-mail à la liste
RBASE-L dans un message, et à l'équipe de support
R:BASE dans un autre message. Veuillez ne pas
envoyer de message à la liste publique, ni aux
adresses e-mail personnelles de RBTI (moi-même et
John Minyo) dans un seul message. Nous espérons
que vous comprenez cette demande.
Very Best R:egards,
Razzak
At 04:25 AM 6/18/2021, Jean-Marc Massé wrote:
Bonjour à tous,
Pourriez vous me dire si vous avez une solution
pour changer la police de caractère d’un champ
« VARCHAR » pour toute une table ?
Dans la base test ci-joint il y a une table
LANCTECH avec un champ « VARCHAR » OBSTECH et
je souhaiterais pouvoir uniformiser
la police de ce champ pour toute la table.
Merci de votre aide précieuse
Amicalement
Traduction Google
Good evening everyone,
Could you tell me if you have a solution to
change the font of a "VARCHAR" field for a whole table?
In the attached test database there is a
LANCTECH table with an OBSTECH "VARCHAR" field
and I would like to be able to standardize
the police of this field.
Thank you for your precious help
Kindly
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0MhBdX-1lhPD71kuH-00MNsc%40mrelay.perfora.net.
