tag:blogger.com,1999:blog-217473632024-03-05T16:48:01.527-08:00ProgWdmPlein d'infos sur WinDev, WebDev et WinDev Mobile et d'autres choses aussi.
N'hésitez pas me laisser des commentaires ou des suggestions.progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.comBlogger68125tag:blogger.com,1999:blog-21747363.post-49561736052422949272014-03-19T05:14:00.001-07:002014-03-19T05:32:14.236-07:00WEBDEV 19 - Intégration d'une gallerie d'image avec JQueryOn trouve beaucoup de de gallerie d'image sur le web. La plus part utilise JQuery et d'autres bibliothèques JavaScript.<br />
J'ai choisi "Galleria", une version demo est téléchargeable sur le le site <a href="http://galleria.io/">http://galleria.io/</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn5dPwHvTMENG8yaObbWvPk0h9VZ8XSuHqJkl53WDPBL7H5yL2U4_FwogUGPtpAZDO4Xazfwo023nXoXCJhCtRpb3D9TyU_vJLYqr9apU98Dy_HbRStWT1IpdTkbvmHSwOiD3L/s1600/galleria_demo.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn5dPwHvTMENG8yaObbWvPk0h9VZ8XSuHqJkl53WDPBL7H5yL2U4_FwogUGPtpAZDO4Xazfwo023nXoXCJhCtRpb3D9TyU_vJLYqr9apU98Dy_HbRStWT1IpdTkbvmHSwOiD3L/s1600/galleria_demo.JPG" height="208" width="320" /></a></div>
<br />
Pour intégrer la gallerie d'image "galleria" dans WEBDEV 19, il faut commencer par télécharger sur le site de galleria le zip : galleria-1.3.5.zip. il contient les JS, CSS et une page HTML de démo.<br />
<br />mettre dans le répertoire _WEB/FR/gallerie , les fichiers suivants :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVdStjaEuxF2rDaKN6cayOKjynb2xJG-h1IG61bM4VcL7iRROenzc2lJ4kUFyzNBONmBHXh86kz_NUOcxrNAwQ6VeNYvCLiHcan1YIMroBb_IFezcMQZvGubH9yBdGePWwKJ3r/s1600/fichiers.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVdStjaEuxF2rDaKN6cayOKjynb2xJG-h1IG61bM4VcL7iRROenzc2lJ4kUFyzNBONmBHXh86kz_NUOcxrNAwQ6VeNYvCLiHcan1YIMroBb_IFezcMQZvGubH9yBdGePWwKJ3r/s1600/fichiers.JPG" /></a></div>
<br />
<br />
Dans WEBDEV, mettre un champ HTML puis dans le d'initialisation de la page :<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfrtb4NaxA02NZIB8KK9E1X8lmql_iju7ezzS06xyEcL1MaiEg7PbJ3boMdChzsJ7Iw1LdbY3_1d1gSz73fnql7cVCHihVsbcPxh-LbgI4BswpTqVjnAtqYrgAGC1sOjfdDk1L/s1600/code_init.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfrtb4NaxA02NZIB8KK9E1X8lmql_iju7ezzS06xyEcL1MaiEg7PbJ3boMdChzsJ7Iw1LdbY3_1d1gSz73fnql7cVCHihVsbcPxh-LbgI4BswpTqVjnAtqYrgAGC1sOjfdDk1L/s1600/code_init.JPG" height="249" width="640" /></a></div>
<br /><br />
ensuite mettre le code HTML de la demo de galleria<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVf5ZRb1FlxDJJeSVJCrx-uII8m3fnGuLYE6K8q7SDi0yxq-X8zo7TIvzw8-F6NGDyHB_EcP41Y2multJMVq0-SeMjVrhsHAxd8NRzRhPCB6GvDTFRRgOL3s7hJulf7EmJem7u/s1600/codehtml.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVf5ZRb1FlxDJJeSVJCrx-uII8m3fnGuLYE6K8q7SDi0yxq-X8zo7TIvzw8-F6NGDyHB_EcP41Y2multJMVq0-SeMjVrhsHAxd8NRzRhPCB6GvDTFRRgOL3s7hJulf7EmJem7u/s1600/codehtml.JPG" /></a></div>
<br />en fait il faut mettre tout le contenu de la div "galleria" du fichier classic-demo.html<br />
<br />
Pour finir mettre dans le code navigateur de chargement de la page (onload) l'appel de la fonction initialise() qui faut déclarer en procédure local navigateur (code en JS) :<br />
<br />
function initialise()<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// Load the classic theme<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Galleria.loadTheme('./gallerie/galleria.classic.min.js');<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// Initialize Galleria<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Galleria.run('#galleria', {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>height: parseInt($('#galleria').css('height')),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>wait: true<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>});<br />
}<br />
<br />
Il reste plus qu'à personnaliser le code HTML du champ HTML.<br />
<br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-5040294754416492562014-03-19T00:23:00.002-07:002014-03-19T00:23:40.194-07:00Modèle de champ avec Menu contextuelDans un modèle de champ si vous ajoutez un menu contextuel, ce dernier sera copié dans la fenêtre lors de l'insertion de champ modèle de champs. Or lorsque l'on supprime ce champ modèle de champ, le menu contextuel n'est pas supprimé de la fenêtre par conséquent, dans certain cas, des erreurs de compilation peuvent apparaître sur des variables globales du modèle champ.<br />
<br />
Astuce, dans le menu contextuel, dans le code des options de menu, ne pas utiliser directement les variables globales du modèle. Il faut mieux faire l'appel du procédure local au modèle qui effectuera le traitement.<br />
<br />
En cas de suppression du modèle de champs dans la fenêtre, ne pas oublier du supprimer également le menu contextuel.<br />
progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-1627238013225128842014-02-12T06:08:00.000-08:002014-02-12T06:08:02.109-08:00Variables de type date et heure initialisées avec la date et heure du jour !!!Avant une variable date ne contenait rien lors de la déclaration. J'en ai eu marre d'avoir mes variables de type date et heure initialisées avec la date et heure du jour, j'ai donc cherché et j'ai trouvé la fonction du va bien : <a href="http://doc.pcsoft.fr/fr-FR/?3027015" target="_blank">DateHeureParDéfaut</a><br />
<br />
Permet de définir la valeur par défaut des variables de type Date, Heure, et DateHeure (dixit l'aide)<br />
<br />
bien, mais on peut pas passer une chaine vide ou la valeur null....dommage<br />
<br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-6975937531299048932014-02-10T01:14:00.001-08:002014-02-10T01:14:27.413-08:00Permutation : Changer un bouton en lienJe viens de découvrir les permutations. Pouvoir passer d'un bouton à un lien sans avoir à le recréer.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wtf3Y06IYqX0GZ8X2tMvxsYgfTeVD3gSgcwqhgREDRMfCW4besr3J1jQAW9y1UUZhMkB9aDrv0zQePhknLqQRNHlFd0qWFF1l_6pe_Dsji_AZbYXvHxC2QmHOweZjwWHVw7q/s1600/WEBDEV_permutation.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wtf3Y06IYqX0GZ8X2tMvxsYgfTeVD3gSgcwqhgREDRMfCW4besr3J1jQAW9y1UUZhMkB9aDrv0zQePhknLqQRNHlFd0qWFF1l_6pe_Dsji_AZbYXvHxC2QmHOweZjwWHVw7q/s1600/WEBDEV_permutation.png" height="310" width="320" /></a></div>
<br />
<br />
<br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-53725006558133569182014-02-07T01:35:00.000-08:002014-02-07T01:35:21.275-08:00Imprimer des états dans une langue différente de l'application Si on veut faire une édition dans une langue différente de l'application sans modifier la langue de l'application, dans ce cas on utilise la fonction :<a href="http://doc.pcsoft.fr/fr-FR/?1000020968" target="_blank"> iNationImpression</a><br />
<br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-11621203673689191772014-02-07T00:16:00.000-08:002014-02-07T00:16:38.967-08:00WINDEV Mobile 19 : Android/iOS Réplication de données (Réplication Universelle Assistée)J'attendais la version 19 pour mettre la réplication en place sur des application Android/iOS. Au départ j'avais testé sur Android avec une base abonnée SQLite mais la réplication ne fonctionne qu'avec HFSQL. Pas grave et ça m'arrange.<br />
<br />
<i>Pourquoi la Réplication Universelle Assistée et pas la programmée ?</i><br />
<br />
Car la Réplication Universelle Assistée permet de faire de la réplication avec un minimum de code (une dizaine de ligne). La plupart de la configuration s'effectue avec des assistants.<br />
<br />
<i>Mise en place </i><br />
<br />
J'ai réalisé quelques tests en m'appuyant sur la documentation : http://doc.pcsoft.fr/fr-FR/?1000021071. Les étapes sont bien précisées. Juste quelques commentaires :<br />
<br />
<i>1 - Installation du serveur de réplication.</i><br />
<br />
L'aide en ligne sur le sujet est bien faite. Il cohabite très bien avec un Serveur d'application WEBDEV.<br />
Si on utilise une base HFSQL classic, il faut penser à donner les droits à "l'invité internet" sur le répertoire des données (base maître).<br />
Si les droits sont pas défini, un message pas très explicite apparaît sur le terminal du type "impossible d'accéder aux fichiers ....".<br />
<br />
A noter également, qu'il n'est pas nécessaire de créer des comptes. Celui par défaut est largement suffisant.<br />
<br />
Dans le volet publication, on peut ajouter une publication. Attention : le nom de l'application que l'on donne doit être identique au nom du fichier .wer (sans l'extension)<br />
<br />
<i>2 - Définition de la réplication. (ReplicEdit)</i><br />
<br />
Pas de problématique, a part pour les pamaètres. Dans la description d'un fichier de données, onglet "Filtre". Si on souhaite mettre un paramètre, il faut bien dans la combo seléctionner "Nouveau Paramètre" exemple :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMZIsGMsTgZhiSbrGYX2gbfBRDmTrF06T6eh4rtEaERYn2_BQiG4fw_KWCL0nDSEjqc3Lyp4gm2yEOxombxUJPlRNWV48TA03JMF40MVfRkigzPiK4jWWTSUSxZvUpFJrZh2cm/s1600/replicedit_parametre.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMZIsGMsTgZhiSbrGYX2gbfBRDmTrF06T6eh4rtEaERYn2_BQiG4fw_KWCL0nDSEjqc3Lyp4gm2yEOxombxUJPlRNWV48TA03JMF40MVfRkigzPiK4jWWTSUSxZvUpFJrZh2cm/s1600/replicedit_parametre.JPG" height="238" width="320" /></a></div>
<br />
Autre chose également, si utilisation d'une base HFSQL classic, ne pas oublier de définir le répertoire de la base maître dans le menu "Réplication...Description de la réplication" onglet "Fichiers maîtres"<br />
<br />
Si utilisation d'une base HFSQL client/serveur. Il faut avant même de lancer ReplicEdit avoir une connexion décrit dans l'analyse sinon c'est rapé.<br />
<br />
<i>3 - Publication</i><br />
<br />
On peut le faire dans l'administrateur du serveur de réplication ou depuis ReplicEdit. Attention à la fin de l'assistant on propose un code. celui-ci ne contient ni le nom de la réplication, ni le login, ni le mot de passe défini dans l'assistant.<br />
<br />
<i>4 - Programmation dans WINDEV Mobile.</i><br />
<br />
tout le code est donner dans l'aide. Attention à réplicSynchro dans le cas d'un replica immédiat, bien définir le deuxième paramètres <i>ReplicaImmédiat</i>. Sinon on a l'impression que ca marche pas.<br />
<br />
<i>Conclusion</i><br />
<br />
Le résultat est assez bleuffant. Ajout, modification, suppression (par swipe) depuis une même application avec deux configuration de projet Android et iOS. Un code unique. Pas testé avec WINDEV et WEBDEV mais d'après la doc le code ne change.<br />
<br />
Pour les tests j'ai utilisé que quelques fichiers avec 2 ou trois paramètres, on va voir à à l'usage...<br />
<br />
par contre si Modification automatique des fichiers de données ou modification du .wer, ben à priori rien de prévu. Je pense qu'il faut refaire un ReplicInitialise après avoir fait un HModifieStructure. Mais bon cette dernière focntion ne me dit pas si la structure à vraiment changer ou pas.<br />
<br />
Je sais pas comment vais faire pour l'instant. Mais on va tester....<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-10255547771396452062014-01-31T06:56:00.000-08:002014-01-31T07:24:45.672-08:00WINDEV Editeur de code : Sélection en colonneLa sélection en colonne dans l'éditeur de code est très pratique. Voici une petite vidéo rapide .<br />
voir aide : <a href="http://doc.pcsoft.fr/fr-FR/?2010031#NOTE4_1">http://doc.pcsoft.fr/fr-FR/?2010031#NOTE4_1</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI3MM8PwC7ySgkgKCZx-xX7OFWHE1tsK1bTQc3zr69SeYZSUxcihTQcaQIRrGPQORT7ogFVdU9LXngi6TbIqVCrf6EXxvGVgiwyJ_51qpMfPDHrwmEf25fEIdSMVgAUAuzi77u/s1600/Selection+colonne.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI3MM8PwC7ySgkgKCZx-xX7OFWHE1tsK1bTQc3zr69SeYZSUxcihTQcaQIRrGPQORT7ogFVdU9LXngi6TbIqVCrf6EXxvGVgiwyJ_51qpMfPDHrwmEf25fEIdSMVgAUAuzi77u/s1600/Selection+colonne.gif" height="268" width="320" /></a></div>
<span id="goog_889174938"></span><span id="goog_889174939"></span><br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-49427364265746492002014-01-30T01:53:00.002-08:002014-01-30T01:53:42.255-08:00WLangage : Opérateur Dans <div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">L'opérateur DANS permet de comparer une
valeur à une liste de valeurs. Son évaluation renvoie un booléen. très pratique
et évite les opérateur _OU_ ou _ET_.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Si Mavaleur <a href="http://doc.pcsoft.fr/fr-FR/?1512006" target="_blank">DANS</a>(5,6,7) alors<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"> //
trt<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Fin<o:p></o:p></span></div>
progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-60354943769574491712014-01-29T08:32:00.000-08:002014-01-29T08:32:00.916-08:00Zone Répétée et Rupture : Comment récupérer le premier élément de la rupture ?<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Dans une </span><span style="font-family: Verdana, sans-serif; font-size: 10pt;">Zone Répétée
avec rupture si on double clic sur une rupture l'indice renvoyé par <nom e="" p="" r="" t="" zone=""> (ou <a href="http://doc.pcsoft.fr/fr-FR/?3083024" target="_blank">ZoneRépétéeSelect</a>) est soit l'indice de la première ligne
ou l'indice de la ligne sélectionnée par l'utilisateur.<o:p></o:p></nom></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br />
Pour récupérer l'indice de la première ligne de la rupture, il faut :<br />
- Ajouter le code optionnel : </span><span style="font-family: Verdana, sans-serif; font-size: 10pt;">Bouton Gauche double-clic<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNqjXNnXqQIY5znon0FALWm8tagIsta6l-JD5zasIQC52L9pFKbF41srrBt35Mo1Nl2_x_mH25IWue7vrM_GUQn3bbGRxv_bKco9oo-bDDMXn-dxB2o799kvFwcJPPu9IMDb8e/s1600/ZoneR%C3%A9p%C3%A9t%C3%A9e_DBCK.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNqjXNnXqQIY5znon0FALWm8tagIsta6l-JD5zasIQC52L9pFKbF41srrBt35Mo1Nl2_x_mH25IWue7vrM_GUQn3bbGRxv_bKco9oo-bDDMXn-dxB2o799kvFwcJPPu9IMDb8e/s1600/ZoneR%C3%A9p%C3%A9t%C3%A9e_DBCK.PNG" height="113" width="320" /></a></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">avec le code suivant :<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;"><a href="http://doc.pcsoft.fr/fr-FR/?3083025" target="_blank">ZoneRépétéeSelectPlus</a></span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">(</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background: white; color: teal; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;">ZoneRépétée1</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">, </span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;"><a href="http://doc.pcsoft.fr/fr-FR/?3083022" target="_blank">ZoneRépétéeInfoXY</a></span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">(</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background: white; color: teal; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;">ZoneRépétée1</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">,</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><i><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;">tiNumLigne</span></i><i><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span></i><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">,</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;">SourisPosX</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">(),</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Lucida Console"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-highlight: white;">SourisPosY</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Verdana, sans-serif; font-size: 10pt;">()))</span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> <o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br />
Cela va forcer la sélection de la première ligne de la rupture<o:p></o:p></span></div>
progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-25027912557477100432014-01-29T05:23:00.000-08:002014-01-29T05:26:48.984-08:00Champ calendrier : Comment "déselectionner" toutes les dates sélectionnées par programmationLe <a href="http://doc.pcsoft.fr/fr-FR/?1016300" target="_blank">champ calendrier</a>, avec l'option "Sélection de période" dans l'onglet détail de la description du <a href="http://doc.pcsoft.fr/fr-FR/?1016300" target="_blank">champ calendrier</a>, permet de sélectionner une période. le code est alors du type :<br />
<br />
CAL_SansNom1..DateDébut = "20140115"<br />
CAL_SansNom1..DateFin = "20140129"<br />
<br />
Pour désélectionner une période il faut faire :<br />
<br />
CAL_SansNom1..DateDébut = ""<br />
CAL_SansNom1..DateFin = ""<br />
<br />
Si le calendrier est avec l'option : "Selection multiple" alors dans ce cas il faut utiliser la fonction <a href="http://doc.pcsoft.fr/fr-FR/?1000017340" target="_blank">CalendrierSelectMoins()</a> :<br />
<br />
Sélection de date :<br />
<a href="http://doc.pcsoft.fr/fr-FR/?1000017339" target="_blank">CalendrierSelectPlus</a>(CAL_SansNom1,"20140115")<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVS3AYXbmVsqqWwI8UyE8REXa9m3IwM4RVX1uPw-VFLQq4fMlQZPx0UZIqkul5t1ppsTuBNOnUqqpnA9OJQ9p6SYIKr6c6oYvi7LojRGI72m3goo3eiNDDVJWP3inZD0QbfSv3/s1600/champ_calendrier.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVS3AYXbmVsqqWwI8UyE8REXa9m3IwM4RVX1uPw-VFLQq4fMlQZPx0UZIqkul5t1ppsTuBNOnUqqpnA9OJQ9p6SYIKr6c6oYvi7LojRGI72m3goo3eiNDDVJWP3inZD0QbfSv3/s1600/champ_calendrier.png" /></a>CalendrierSelectPlus(CAL_SansNom1,"20140120")<br />
CalendrierSelectPlus(CAL_SansNom1,"20140122")<br />
<br />
Dé sélection de date :<br />
<br />
CalendrierSelectMoins(CAL_SansNom1,"20140115")<br />
CalendrierSelectMoins(CAL_SansNom1,"20140120")<br />
CalendrierSelectMoins(CAL_SansNom1,"20140122")<br />
<br />
Voir les fonctions de manipulations du champ calendrier : <a href="http://doc.pcsoft.fr/fr-FR/?1000015008" target="_blank">cliquer-ici</a><br />
<br />progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-19612579926964172632010-09-08T01:52:00.000-07:002010-09-08T03:13:16.841-07:00WEBDEV - Afficher une image dans un champ de saisie<div style="text-align: left;">Je viens de visiter une <a href="http://www.framablog.org/index.php">site</a> sympa ou le formulaire de<a href="http://www.framablog.org/index.php/contact"> contact</a> m'a plu. J'ai donc décidé de le refaire en WEBDEV.</div><div style="text-align: center;"><br /></div><div>Objectif réaliser ceci :</div><div><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrBh_Ad8Xq-IAt8OlCbQjT7DaO3_KYbmzE809EBTUmYEX9Yc7LtCLCO2rmCN5tDsnc2w-tx7MqZaM2yPRKjKifYbfBujJwShWUXUM_4GmLvSZQPQkHXoWemzbTqPmObmFP4bn_/s320/contact.png" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 182px;" border="0" alt="" id="BLOGGER_PHOTO_ID_5514464068248230642" /><div style="text-align: center;"><br /></div></div><div>Dans WEBDEV on commence par créer deux cellules. La première avec un fond blan uni et la seconde avec les paramètres suivants :<br /><div style="text-align: center;"><br /></div></div><div><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJD136wnSZilahNerHpmRnMmItkfTyadzyh_Xv7n26d7yoP3EcVtGIM13u3wTbEPDjy6cmG0LJVjMQnJsXVyHuTHbAu0VUpy03BbUbSoWnIkEEWIegGGv-jMJfQOerAd4wKAQq/s320/etape1.png" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 160px;" border="0" alt="" id="BLOGGER_PHOTO_ID_5514476260218622914" />Ensuite il faut définir la couleur de CEL_Form et mettre l'image à droite :</div><div style="text-align: center;"><br /></div><div><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgerbLkF0POdBNQi7m-NV9KSzyGtAhK1TTAq1oguIKJ9M2VuQQIvM1L6Hw4iFK1sTI7ZNP2IfV939X3emQC_DOogrQPGG4FTYAkRJyUa12ir9Bw0X81_XOM9DO5zWxqGVYGFjWf/s320/etape2.png" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 175px;" border="0" alt="" id="BLOGGER_PHOTO_ID_5514477204446721938" />Puis ajout des champs de saisie et pour chaque champ de saisie on créer un style au projet<br /><br /></div><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSbo1lQb-ijw897tjlxW-TRF7IPHEcSnW053_HLGcbUR0bfN3rN_IHAmoTYEfctX2aU0warq4dsrtPtbTe_WRbt3q_dh4shs2GgYzJvv0GMdV9W9MTWyMOUm1k59nSf9vIACl3/s320/etape3.png" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 126px;" border="0" alt="" id="BLOGGER_PHOTO_ID_5514477601970040018" /><div><br /></div><div>et on place le code CSS :</div><div style="text-align: center;"><br /></div><div><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjjAyDraCqeNOQtbEJEy3KnmmEKQKdrsvTAI9y4-MlBFEKPcoxXXhPwD2cvrxtSQEDL4dYN94lHHSEEC7VnQAvOIEFbaadw9YXb1xMhi6QcCZOSZG8NoygyOl4cc24GkUBWgyv/s320/etape4.png" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 298px;" border="0" alt="" id="BLOGGER_PHOTO_ID_5514478088063838738" /></div><div>dans chaque champ de saisie on aura le code css suivant :</div><div><br /></div><div><div>background-image: url(c-icons.png);</div><div><br /></div><div>background-repeat: no-repeat;</div><div>padding-left: 20px;</div><div>border: 1px solid #BFBFBF;</div></div><div><br /></div><div>puis pour chaque champ on ajoutera un code css spécifique :</div><div>Nom : background-position: 3px 4px;</div><div>Email : background-position: 3px -15px;</div><div>Site web : background-position: 3px -37px;</div><div>sujet : background-position: 3px -57px;</div><div><br /></div><div>cette ligne idique quelle partie de l'image il faut afficher dans le champ, car on fait référence qu'a une seule image c-icons.png :</div><div><br /></div><div style="text-align: center;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhd6kby09ZVvyrNHZgLiiu3MzSpeUnzv1Uire-bPoC15EBH4NcEnOmC92HoifuDwoVfgrhcvnoTOGDx9kuftwMYojknWJY_UtzzJZMbC-b_-d4Vi-qMXK6KuS7ffZk_6xpK9Bzi/s320/c-icons.png" /></div><div style="text-align: left;"><br /></div><div>C'est presque fini. Il reste le champ de saisie pour le messge. Pour celui-ci on aura qu'une ligne CSS à mettre :<br />border: 1px solid #BFBFBF;</div><div><br /></div><div>Et pour le bouton le style CSS sera le suivant :</div><div><div>color: white;</div><div>background: #2E6DA3;</div><div>border: none;</div><div><br /></div></div><div>On pourrait presque se passer du code CSS et mettre le tout dans les ongles texte et fond su style.</div><div><br /></div><div>ATTENTION : les modifications de style CSS ne seront visible qu'en exécution...</div>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com1tag:blogger.com,1999:blog-21747363.post-39423805352924540232010-08-20T05:36:00.000-07:002010-08-20T05:42:33.966-07:00comment géolocaliser une adresse et la centrer avec WEBDEV (Google Maps v3) ?<span class="Apple-style-span" style="font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: small; color: rgb(51, 51, 51); line-height: 18px; ">Voici une petit code javascript qui s'utilise avec le code déjà publier dans le billet suivant <a href="http://progwdm.blogspot.com/2010/07/webdev-15-google-maps-v3.html">"WEBDEV 15 - Google maps v3"</a> .</span><div><span class="Apple-style-span" style="font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: small; color: rgb(51, 51, 51); line-height: 18px; "><br /></span></div><div><span class="Apple-style-span" style="font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: small; color: rgb(51, 51, 51); line-height: 18px; ">Dans la collection de procédure : </span><span class="Apple-style-span" style="font-family: verdana; font-size: small; line-height: 17px; ">pGestionCartes ajouté la procédure suivante :</span></div><div><span class="Apple-style-span" style="font-family: verdana; font-size: small; line-height: 17px; "><br /><div>function RechercheCoordonneesDepuisAdresse(sAdresse, sNomFonction)</div><div>{</div><div><br /></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>// On a récupéré le nom de la fonction sous forme de chaîne, donc on récupère maintenant le pointeur sur cette fonction</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>var objFonction = eval(sNomFonction);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//alert(objFonction);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>var geo = new google.maps.Geocoder();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>geo.geocode({'address': sAdresse},objFonction);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div>}</div><div><br /></div><div>sNomfonction est une fonction WLangage navigateur local à la page par exemple. Voici un exemple de fonction :</div><div><div>function LocalRetourRecherche(res,stat) /</div><div>{</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>var coordonnee = null;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>if (stat == google.maps.GeocoderStatus.OK){</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>gObjCarte.setCenter(res[0].geometry.location);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>var coordonnee = res[0].geometry.location;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//Pour le debuguage de lappli</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>var marke = new google.maps.Marker({position: coordonnee, map: gObjCarte, title: "adress"<span class="Apple-tab-span" style="white-space:pre"> </span>}); </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}else {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>alert("Geocode was not successful for the following reason: " + stat);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div>}</div></div><div><br /></div><div>Les deux paramètres (res et stat) sont passés automatiquement par la méthode geo.geocode.</div></span></div>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com3tag:blogger.com,1999:blog-21747363.post-47581253752939892062010-07-21T01:01:00.000-07:002010-07-21T02:23:29.522-07:00WEBDEV 15 - Google maps V3<div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Pour afficher une carte Google maps v3 dans un site WEBDEV, je me suis inspiré de l'exemple WW_Cartes de la LST 72.</span></span><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Pour passer en v3 des APIs google maps, il faut bien évidement consulter la doc :</span></span></div><div><a href="http://code.google.com/intl/fr-FR/apis/maps/documentation/javascript/introduction.html"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">http://code.google.com/intl/fr-FR/apis/maps/documentation/javascript/introduction.html</span></span></a></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><a href="http://code.google.com/intl/fr-FR/apis/maps/documentation/javascript/introduction.html"></a>A partir de cette introduction et de la doc des API (</span></span><a href="http://code.google.com/intl/fr-FR/apis/maps/documentation/javascript/reference.html"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">http://code.google.com/intl/fr-FR/apis/maps/documentation/javascript/reference.html</span></span></a><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">) on peut commencer dans WEBDEV.</span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Dans l'onglet avancé de la description de la page mettre :<br /><br /></span></span></div></div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_xft50alljZY5Gbbn4UuhPXXf1qi4dButAppj7I61ffxl24IHeHVm0FEO62RUBG93SThkoqUUNj-fbsy_s-KubNDEWqbGXh-z_mwJKGUBc79tP0Z_OECR3k_hpauLFXNYsjcJ/s1600/descrip.png"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 96px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_xft50alljZY5Gbbn4UuhPXXf1qi4dButAppj7I61ffxl24IHeHVm0FEO62RUBG93SThkoqUUNj-fbsy_s-KubNDEWqbGXh-z_mwJKGUBc79tP0Z_OECR3k_hpauLFXNYsjcJ/s320/descrip.png" border="0" alt="" id="BLOGGER_PHOTO_ID_5496287462532542018" /></a><br /><div><div><span class="Apple-style-span" style="font-family: verdana; ">Dans cette page, mettre un champ libellé HTML et dans le code d'initialisation de ce dernier mettre le code suivant :</span></div><div></div></div><div><br /></div><div><br /></div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfGE0BxTK8t-vVM4ihL6ZmnuqA0TljPXYOM14iz4R7a9JvevLdF7teTVKR3VVWHzh17hovlq1vgRP4LDRakq4-oTR8IJ-7ezdIAotqo6a2NVzh_NxEu_6WpwFqWtPqiel9LaPS/s1600/LIBHTM.png"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 72px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfGE0BxTK8t-vVM4ihL6ZmnuqA0TljPXYOM14iz4R7a9JvevLdF7teTVKR3VVWHzh17hovlq1vgRP4LDRakq4-oTR8IJ-7ezdIAotqo6a2NVzh_NxEu_6WpwFqWtPqiel9LaPS/s320/LIBHTM.png" border="0" alt="" id="BLOGGER_PHOTO_ID_5496283744586453794" /></a><br /><span class="Apple-style-span" style=" ;font-family:verdana;">Ce code permet d'afficher la carte sur tous les navigateurs. Sans ce code sous chrome la carte prends tout le navigateur.</span><br /><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Ensuite dans le code Onload de la page mettre le code :</span></span></div><div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">gObjCarte est un entier </span></span></div></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">CreerCarte("CARTE", 0,180)</span></span></div><div><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"><br /></span></span></div><div><p class="MsoNormal"><span style="line-height: 115%; color:black;"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">La variable gObjCarte est utilisée dans plusieurs fonction de manipulation de la carte elle est donc déclarer en global navigateur.<o:p></o:p></span></span></span></p> <p class="MsoNormal"><span style="line-height: 115%; color:black;"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Pour une facilité d’utilisation et de réutilisation création d’une collection de procédure dans les procédures globales navigateur<o:p></o:p></span></span></span></p> <p class="MsoNormal"><span style="line-height: 115%; color:black;"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Nom de la collection : pGestionCartes<o:p></o:p></span></span></span></p> <p class="MsoNormal"><span style="line-height: 115%; color:black;"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">La procédure est écrite en javascript. Il faut donc cliquer sur WL après création de la procédure<o:p></o:p></span></span></span></p> <p class="MsoNormal"><span style="line-height: 115%; color:black;"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Création de la carte :<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// Résumé : Création de la carte google map<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// Syntaxe :<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">//CreeCarte (<snomchampcarte>)<o:p></o:p></snomchampcarte></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">//<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// Paramètres :<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">sNomChampCarte : Nom du champ HTML (<nomchamp>..alias ou id défini dans DIV)<o:p></o:p></nomchamp></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">//</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlat : latitude du centre de la carte<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">//</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlong : longitude du centre de la carte<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// Valeur de retour :<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Aucune<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">//<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><b><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background- background-position: initial initial; background-repeat: initial initial; "><o:p><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></o:p></span></b></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">function </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">CreerCarte</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">(</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">sNomChampCarte</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">,</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlat</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">,</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlong</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">)<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">{<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> if (</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlat</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">==</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">0</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">){<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlat</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> = </span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">48.856558</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">;<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> };<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> if (</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlong</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">==</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">0</span></span></span><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">){<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span lang="EN-US" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlong</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> = </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">2.350966</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">;<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> };<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> <o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">//</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> Création de la carte<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> var </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">latlng</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> = new </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">google</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">maps</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">LatLng</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">(</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlat</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">, </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">nlong</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">);<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> var </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">myOptions</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> = {<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">mapTypeControl</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: true,</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">zoom</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">5</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">, </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">center</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">latlng</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">, </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">mapTypeControlOptions</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: {</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">style</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">google</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">maps</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">MapTypeControlStyle</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">DROPDOWN_MENU</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">},</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">navigationControl</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: true,</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">mapTypeId</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">: </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">google</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">maps</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">MapTypeId</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">ROADMAP<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> }<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">// création de la carte<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">gObjCarte</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;"> = new </span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">google</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">maps</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">Map</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">(</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">document</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">.</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">getElementById</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">(</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">sNomChampCarte</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">),</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">myOptions</span></span></span><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">);<o:p></o:p></span></span></span></p> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none"><span style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; "><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:small;">}</span></span></span><b><span style="font-family:"System","sans-serif";mso-bidi-background:white;mso-highlight:whitefont-family:System;font-size:10.0pt;"><o:p></o:p></span></b></p></div>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com7tag:blogger.com,1999:blog-21747363.post-4388249420235733592008-12-22T00:26:00.000-08:002008-12-22T00:50:15.209-08:00WinDev 14 : Table avec colonne ConteneurLes colonnes de type conteneur permettent une plus grande liberté d'affichage :<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrD-w6g3GmRe9oaLgNpkYERZOnKFLxw0MAiwwBzQEXSwuWOCKXkxkpb_ehrt4P9TZm0vOYkv7dROJRQpFxrGK4KPUnYQAdg4VF0iwEtL6IfzBCNmThj_NsG9vFAfKq11TtUyLS/s1600-h/VisuChampTable.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 176px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrD-w6g3GmRe9oaLgNpkYERZOnKFLxw0MAiwwBzQEXSwuWOCKXkxkpb_ehrt4P9TZm0vOYkv7dROJRQpFxrGK4KPUnYQAdg4VF0iwEtL6IfzBCNmThj_NsG9vFAfKq11TtUyLS/s320/VisuChampTable.jpg" alt="" id="BLOGGER_PHOTO_ID_5282533844346677778" border="0" /></a><br />Dans la description du champ, il suffit d'indiquer dans la colonne concernée, son type et de définir un champ principal. Utile pour le tri sur la colonne.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjagoCMPFqvzWkoGxiUnlcpxK6QpGs-FboCc_UEBGzA57RJc3_ks0VpIsWlP8OYhZbPmNiFByyIFxl_ypEN2xIvsew_9NUFP2ozoLKNc61ASkjSG5XRrRMwUhISyI6r_tqfkzPE/s1600-h/DescriptionChampTable.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 202px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjagoCMPFqvzWkoGxiUnlcpxK6QpGs-FboCc_UEBGzA57RJc3_ks0VpIsWlP8OYhZbPmNiFByyIFxl_ypEN2xIvsew_9NUFP2ozoLKNc61ASkjSG5XRrRMwUhISyI6r_tqfkzPE/s320/DescriptionChampTable.jpg" alt="" id="BLOGGER_PHOTO_ID_5282532484927191074" border="0" /></a>Ensuite, il faire un Drag&Drop dans champs (disponibles dans la deuxième barre d'outil de l'éditeur de fenêtre) et de les placer dans la colonne de type conteneur.<br />Pour alimenter la colonne conteneur par programmation, il faut utiliser l'indice de l'élément ajouter dans la table :<br /><br />exemple de code :<br />i est un entier<br />POUR TOUT CLIENT SUR NomClient<br />i = TableAjouteLigne(MoiMême,0,"","")<br />TABLE_Table1.COL_Client[i].LIB_NOM_Prénom = CLIENT.NomClient<br />TABLE_Table1.COL_Client[i].LIB_Adresse1 = CLIENT.Adresse1<br />TABLE_Table1.COL_Client[i].LIB_Adresse2 = CLIENT.Adresse2<br />TABLE_Table1.COL_Client[i].LIB_CP_Ville = CLIENT.CodePostal+" "+CLIENT.Ville<br />FIN<br /><br />Les champs LIB_xx sont placés dans une colonne de type conteneur.progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-88251267879681557172008-12-20T09:32:00.000-08:002008-12-20T10:28:36.100-08:00Tracer un chemin avec les fonctions Google de Windev 14<span style="font-size:85%;"><span style="font-family:verdana;">Il est possible de tracer un chemin avec la fonction gglrecupèreCarte. Il faut pour cela utiliser tous les paramètres de la fonction. Quelques difficultés peuvent être rencontrées, voir astuces en bas de cet article.</span></span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPoAFVQvzVCob7nsiYZEWfQ2xlCIs1No4iqax2fkRB9G6VdkaX0M7PNheNGvt21i0XMTsR3VARV7CUafY1otEBl8A94PP3h1Y-egcxpONYAUWhcI-eLGTclcQwOuXdu85nU_I9/s1600-h/GoogleRoute.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 250px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPoAFVQvzVCob7nsiYZEWfQ2xlCIs1No4iqax2fkRB9G6VdkaX0M7PNheNGvt21i0XMTsR3VARV7CUafY1otEBl8A94PP3h1Y-egcxpONYAUWhcI-eLGTclcQwOuXdu85nU_I9/s320/GoogleRoute.jpg" alt="" id="BLOGGER_PHOTO_ID_5281927112750948178" border="0" /></a><span style="font-size:85%;"><span style="font-family:verdana;">Il faut déterminer les différents paramètres du trait de la structure gglParamètreCarte. De plus il faut déterminer un marqueur si vous utilisez le zoom automatique (la zone ne fonctionne pas contrairement au message d'erreur affiché dans le cas où aucun marqueur n'est défini)<br />Ici j'ai utilisé un tableau de structure pour les différents points du tracé. Ce qui a permis d'utiliser les [ ] pour le remplissage du tableau dynamique.<br />Le POUR TOUT ELEMENT est très pratique pour le parcours du tableau.<br />Remarquez également l'utilisation de la fonction Ajoute pour ajouter un élément à un tableau. On aurait pu aussi utiliser la fonction TableauAjoute.<br /><br />Voici le code utilisé lors du clic sur le bouton :</span><br /><span style="font-family:verdana;">point est une structure</span><br /><span style="font-family:verdana;"> lat est un réel</span><br /><span style="font-family:verdana;"> longi est un réel</span><br /><span style="font-family:verdana;">FIN</span><br /><br /><span style="font-family:verdana;">cléGoogle est une chaîne = "VotreClé"</span><br /><span style="font-family:verdana;">Chemin est un gglParamètreCarte</span><br /><span style="font-family:verdana;">stUnPoint est un point</span><br /><span style="font-family:verdana;">sCoord est un gglCoordonnée</span><br /><span style="font-family:verdana;">tabCoord est un tableau de 0 point</span><br /><span style="font-family:verdana;">Trajet est un gglChemin</span><br /><span style="font-family:verdana;">UnMarq est un gglMarqueur</span><br /><br /><span style="font-family:verdana;">// définition du trait</span><br /><span style="font-family:verdana;">Chemin.Chemin..Couleur = iRougeFoncé</span><br /><span style="font-family:verdana;">Chemin.Chemin..Epaisseur = 2</span><br /><span style="font-family:verdana;">Chemin.Chemin..Opacité = 100</span><br /><br /><span style="font-family:verdana;">//définition du tableau de point</span><br /><span style="font-family:verdana;">tabCoord = [[40.7078,-74.0021],[46.7140,-56.3968],[51.0165,-29.5967],[51.1067,-25.1016],</span><br /><span style="font-family:verdana;"> [49.8997,-6.1730],[48.9577,2.1423]]</span><br /><span style="font-family:verdana;">// définition des points du tracer</span><br /><span style="font-family:verdana;">POUR TOUT ELEMENT stUnPoint DE tabCoord</span><br /><span style="font-family:verdana;"> sCoord.Latitude = stUnPoint.lat</span><br /><span style="font-family:verdana;"> sCoord.Longitude = stUnPoint.longi</span><br /><span style="font-family:verdana;"> Ajoute(Chemin.Chemin..Point,sCoord)</span><br /><span style="font-family:verdana;">FIN</span><br /><span style="font-family:verdana;">Chemin.Format = gglJPG</span><br /><span style="font-family:verdana;">// quand on met un Zoom auto il faut préciser une Zone ou un marqueur</span><br /><span style="font-family:verdana;">// mais marche pas avec une zone alors on met un marqueur</span><br /><span style="font-family:verdana;">//chemin.Zone.Latitude = 40.7078</span><br /><span style="font-family:verdana;">//chemin.zone.Longitude = -74.0021</span><br /><span style="font-family:verdana;">// définition du marqueur</span><br /><span style="font-family:verdana;">UnMarq.Latitude = 40.7078</span><br /><span style="font-family:verdana;">UnMarq.Longitude = -74.0021</span><br /><span style="font-family:verdana;">UnMarq.Taille = gglPetit</span><br /><span style="font-family:verdana;">Ajoute(Chemin.Marqueur,UnMarq)</span><br /><span style="font-family:verdana;">IMG_Image1=GglRécupèreCarte(cléGoogle,40.7078,3.9483,gglZoomAuto,600,400,gglHybride,Chemin)</span><br /><br /><span style="font-family:verdana;">CAS ERREUR:</span><br /><span style="font-family:verdana;"> Erreur(ErreurInfo(errComplet))</span></span><br /><br /><span style="font-size:85%;"><span style="font-weight: bold;font-family:verdana;" >ASTUCES :</span><br /><span style="font-family:verdana;">Lorsque Google ne renvoie pas la carte, il n'y a pas de message d'erreur, rien ne se passe. Donc si lors du clic sur le bouton, vous avez tout de suite la main sur l'appli, c'est que vous avez trop de points.</span><br /><br /><span style="font-family:verdana;">Il faut faire attention au nombre de point du tracé. En effet on est limité à 100 points, sauf que celui-ci diminue si on met des marqueurs. Donc si la carte ne s'affiche pas, c'est que vous dépassez le nombre de points. Dans mes tests en mettant 7 marqueurs, je n'ai pu mettre que 70 points au tracé. </span><br /><br /><span style="font-family:verdana;">Le cas erreur, c'est la gestion automatique des erreurs, inutile de le saisir directement, vous aurez une erreur. Il faut cliquer sur le lien "Si erreur : par programme" du pcode pour avoir le "cas erreur".</span></span><br /><br /><span style="font-size:85%;">Attention :<br />Si vous utilisez la syntaxe Chemin.Chemin..Point, vous ne pouvez pas l'utiliser dans la fonction Ajoute, il faudra écrire Chemin.Chemin.point. (signaler au ST)<br /><br />Vous ne pouvez pas non plus utiliser les [] pour remplir un tableau de structure si vous avez déclaré votre tableau : tab est un tableau dynamique de 0 gglCoordonnées (signaler au ST).<br />C'est pour ca que dans le code il y a une déclaration d'une structure "Point".</span>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-85017017081842922702008-12-20T08:28:00.000-08:002008-12-20T10:28:16.594-08:00Utilisation des fonctions google en WinDev 14<span style="font-size:85%;"><span style="font-family:verdana;">Pour afficher une carte dans un champ image, il faut utiliser les fonctions gglRecupèreCarte et la structure gglCoordonnée. De plus une fonction bien utile pour trouver les coordonnées géographiques d'une ville ou une adresse : gglAdresseVersCoordonnées.<br /><br />Pour utiliser les fonctions google, il faut s'inscrire sur le site de Google afin d'obtenir la clé indispensable pour la récupération de carte.<br /><br /></span></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD-OzhvcPPAQX7KVqhtXQbxZamZSJMJUnNMGqYuOx362-iDevyry0oSIKsjd2E_LD4I81FuAHxvZel76JWBNagy58IZuEX_aeZqYZt8wIX2ebf1VrwkCrD6S1pq7QJW4skRh-F/s1600-h/GoogleMaps.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 241px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD-OzhvcPPAQX7KVqhtXQbxZamZSJMJUnNMGqYuOx362-iDevyry0oSIKsjd2E_LD4I81FuAHxvZel76JWBNagy58IZuEX_aeZqYZt8wIX2ebf1VrwkCrD6S1pq7QJW4skRh-F/s320/GoogleMaps.jpg" alt="" id="BLOGGER_PHOTO_ID_5281911470176387122" border="0" /></a><span style="font-size:85%;"><span style="font-family:verdana;">Voici les quelques ligne de code pour obtenir ce résultat :</span></span><br /><span style="font-size:85%;"><span style="font-family:verdana;">cléGoogle est une chaîne = "Votre clé"</span><br /><span style="font-family:verdana;">sCoord est un gglCoordonnée</span><br /><br /><span style="font-family:verdana;">sCoord = GglAdresseVersCoordonnées(cléGoogle,SAI_Adresse)</span><br /><br /><span style="font-family:verdana;">IMG_Image1 = GglRécupèreCarte(cléGoogle,sCoord.Latitude,sCoord.Longitude,12,631,408,gglHybride)</span><br /></span><br /><span style="font-size:85%;"><span style="font-family:verdana;">Astuce : attention au zoom, il va de 0 à 19, toutefois à 19, si google ne peut pas fournir ce niveau de détail, il se passera rien dans votre fenêtre. par conséquent indiquer un niveau de détail normal.<br /><br /></span></span>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com2tag:blogger.com,1999:blog-21747363.post-45633426489427847682008-05-16T07:47:00.000-07:002008-05-16T07:56:39.320-07:00Comment connaitre la taille en pixel d'une chaine de caratèreLa fonction TexteLargeur permet de connaitre la taille en pixel d'une chaine de caractère.<br />Toutefois, cette fonction admet en premier paramètre un champ de saisie.<br />De plus il faut faire attention à la police utilisé.<br /><br />Si par exemple vous créez la police suivante :<br /><br />polPolice est une Police<br />polPolice = PoliceCrée("Tahoma", 7, iNormal, iNoir)<br /><br />Il faut alors associé la police au champ de saisie :<br /><br />SAI_Saisie1..Police = polPolice<br /><br />Ensuite :<br /><br />NbPixel = TexteLargeur(SAI_Saisie1,"Ma chaîne")progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-27313726391856256752008-01-18T03:31:00.000-08:002008-01-18T03:34:02.774-08:00WinDev 12 – Splitter une chaîne dans un tableau<p><span style=";font-family:Verdana;font-size:9;" >Voici une procédure qui permet de mettre les valeurs d'une chaîne de caractères séparées par un séparateur défini, dans un tableau : <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// Résumé : Permet de remplir un tableau de chaine à partir d'une chaine et d'un séparateur<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// Syntaxe :<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//[ <résultat> = ] Split (<schainecara> est chaîne, <sseparateur> est chaîne [, <btrié> est booléen [, <ptype> est entier]])<o:p></o:p></ptype></btrié></sseparateur></schainecara></résultat></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// Paramètres :<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//</span><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:gray;" >sChaineCara (chaîne) : Chaine de caractères à splitter<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//</span><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:gray;" >sSeparateur (chaîne) : Le séparateur à utiliser<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//</span><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:gray;" >bTrié (booléen - valeur par défaut=0) : Faux (valeur par défaut) le tableau n'est pas trié, vrai pour avoir un tableau trié<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// </span><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:gray;" >pType (entier - valeur par défaut=1) : Type de trie : ttCroissant ou ttDécroissant<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// Valeur de retour :<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// </span><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:gray;" >tableau : // </span><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:gray;" >Tableau contenant les valeurs de la chaine passée en paramètre.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// Exemple :<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// tabSP est un tableau dynamique de 0 chaines<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >//<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:gray;" >// tabSP = Split("toto;abc;zoro;aab;tata",";",Vrai,ttCroissant)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" >PROCEDURE </span><span style=";font-family:";font-size:9;color:teal;" >Split</span><span style=";font-family:";font-size:9;color:black;" >(</span><span style=";font-family:";font-size:9;" >s</span><span style=";font-family:";font-size:9;color:green;" >ChaineCara</span><span style=";font-family:";font-size:9;color:black;" > est une chaîne, </span><span style=";font-family:";font-size:9;" >s</span><span style=";font-family:";font-size:9;color:green;" >Separateur</span><span style=";font-family:";font-size:9;color:black;" > est une chaîne,</span><span style=";font-family:";font-size:9;" >b</span><span style=";font-family:";font-size:9;color:green;" >Trié</span><span style=";font-family:";font-size:9;color:black;" > est un booléen = </span><i><span style=";font-family:";font-size:9;color:blue;" >Faux</span></i><span style=";font-family:";font-size:9;color:black;" >,</span><span style=";font-family:";font-size:9;color:green;" >pType</span><span style=";font-family:";font-size:9;color:black;" > est un entier = </span><i><span style=";font-family:";font-size:9;color:blue;" >ttCroissant</span></i><span style=";font-family:";font-size:9;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;" >tab</span><span style=";font-family:";font-size:9;color:green;" >Split</span><span style=";font-family:";font-size:9;color:black;" > est un tableau dynamique de </span><span style=";font-family:";font-size:9;color:purple;" >0</span><span style=";font-family:";font-size:9;color:black;" > chaînes<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:green;" >s</span><span style=";font-family:";font-size:9;color:black;" > est une chaîne </span><span style=";font-family:";font-size:9;color:gray;" >// variable de boucle<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style=";font-family:System;font-size:10;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" >POUR TOUTE CHAINE </span><span style=";font-family:";font-size:9;color:green;" >s</span><span style=";font-family:";font-size:9;color:black;" > DE </span><span style=";font-family:";font-size:9;" >s</span><span style=";font-family:";font-size:9;color:green;" >ChaineCara</span><span style=";font-family:";font-size:9;color:black;" > SEPAREE PAR </span><span style=";font-family:";font-size:9;" >s</span><span style=";font-family:";font-size:9;color:green;" >Separateur<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:blue;" >TableauAjouteLigne</span><span style=";font-family:";font-size:9;color:black;" >(</span><span style=";font-family:";font-size:9;" >tab</span><span style=";font-family:";font-size:9;color:green;" >Split</span><span style=";font-family:";font-size:9;color:black;" >,</span><span style=";font-family:";font-size:9;color:green;" >s</span><span style=";font-family:";font-size:9;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" >FIN<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" >SI </span><span style=";font-family:";font-size:9;" >b</span><span style=";font-family:";font-size:9;color:green;" >Trié</span><span style=";font-family:";font-size:9;color:black;" > ALORS <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span>SI </span><span style=";font-family:";font-size:9;color:green;" >pType</span><span style=";font-family:";font-size:9;color:black;" > = </span><span style=";font-family:";font-size:9;color:purple;" >0</span><span style=";font-family:";font-size:9;color:black;" > ALORS </span><span style=";font-family:";font-size:9;color:green;" >pType</span><span style=";font-family:";font-size:9;color:black;" > = </span><i><span style=";font-family:";font-size:9;color:blue;" >ttCroissant<o:p></o:p></span></i></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:9;color:blue;" >TableauTrie</span><span style=";font-family:";font-size:9;color:black;" >(</span><span style=";font-family:";font-size:9;" >tab</span><span style=";font-family:";font-size:9;color:green;" >Split</span><span style=";font-family:";font-size:9;color:black;" >,</span><span style=";font-family:";font-size:9;color:green;" >pType</span><span style=";font-family:";font-size:9;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" >FIN<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;color:black;" >RENVOYER </span><span style=";font-family:";font-size:9;" >tab</span><span style=";font-family:";font-size:9;color:green;" >Split</span><b><span style=";font-family:System;font-size:10;" ><o:p></o:p></span></b></p> <p><span style=";font-family:Verdana;font-size:9;" >Exemple d'utilisation :<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;" >tab</span><span style=";font-family:";font-size:9;color:green;" >SP</span><span style=";font-family:";font-size:9;color:black;" > est un tableau dynamique de </span><span style=";font-family:";font-size:9;color:purple;" >0</span><span style=";font-family:";font-size:9;color:black;" > chaîne<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style=";font-family:System;font-size:10;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:9;" >tab</span><span style=";font-family:";font-size:9;color:green;" >SP</span><span style=";font-family:";font-size:9;color:black;" > = </span><span style=";font-family:";font-size:9;color:teal;" >Split</span><span style=";font-family:";font-size:9;color:black;" >(</span><span style=";font-family:";font-size:9;color:purple;" >"toto;abc;zoo;aab;tata"</span><span style=";font-family:";font-size:9;color:black;" >,</span><span style=";font-family:";font-size:9;color:purple;" >";"</span><span style=";font-family:";font-size:9;color:black;" >,</span><i><span style=";font-family:";font-size:9;color:blue;" >Vrai</span></i><span style=";font-family:";font-size:9;color:black;" >,</span><i><span style=";font-family:";font-size:9;color:blue;" >ttCroissant</span></i><span style=";font-family:";font-size:9;color:black;" >)</span><b><span style=";font-family:System;font-size:10;" ><o:p></o:p></span></b></p>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-36574612187029806912008-01-15T23:44:00.000-08:002008-01-15T23:46:45.105-08:00WinDev 12 - Utilisation de MesParamètres<p><span style="font-size: 9pt; font-family: Verdana;">Cette instruction WLangage permet de passer autant de paramètres à une procédure que l'on souhaite grâce à l'opérateur *.<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">Exemple :<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">PROCEDURE Calcul(pParam1, *)<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">Dans cette procédure * représente les autres paramètres possibles.<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">Ces paramètres optionnels sont accessibles via l'instruction MesParamètres.<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">Le plus intéressant, avec cette instruction, c'est que l'on peut accéder à des propriétés d'un objet. Par exemple si on veut modifier la visibilité d'une colonne dans une procédure globale on peut passer en paramètre à la procédure le nom complet de la colonne :<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">Exemple code :<br /></span></p><p><span style="font-size: 9pt; font-family: Verdana;">// Code d'un bouton<br /><span style="color: rgb(0, 153, 0);">ModInterface(</span>Fen_Fenêtre1.Table1.Col_Colonne1, <span style="color: rgb(51, 51, 255);">faux</span>)<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">PROCEDURE <span style="color: rgb(0, 153, 0);">ModInterface</span>(*)<o:p></o:p></span></p> <p><span style="font-size: 9pt; font-family: Verdana;">MesParamètres[1]..visible = MesParamètres[2]<o:p></o:p></span></p>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-14071575636234316932007-10-17T04:30:00.000-07:002007-10-17T04:32:41.867-07:00WebDev - Récupérer le User name Windows de l'internaute<p>Si vous saisissez cette URL : <a href="http://localhost/?user=%25USERNAME%25">http://localhost/?user=%USERNAME%</a> vous verrez apparaitre le nom d'utilisateur du poste dans l'URL. (Seulement valable sous IE)</p><!--[if !supportEmptyParas]--><!--[endif]--><o:p></o:p> <p><span style=";font-family:Verdana;font-size:10;" >Il est donc possible grâce à une applet Java de récupérer cette information. Dans la LST 68 page 35, l'exemple WD Applet FTP permet de le faire.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:10;" >Dans l'applet la fonction </span><span style=";font-family:Verdana;font-size:10;color:blue;" >RéseauUtilisateur() </span><span style=";font-family:Verdana;font-size:10;" >permet de récupérer le nom d'utilisateur Windows.<o:p></o:p></span></p> <p class="MsoList" style=""><span style=";font-family:Verdana;font-size:10;" >Dans le site WebDev une fonction Javascript permet de récupérer la valeur de la variable.<o:p></o:p></span></p> <div style="border-top: 2px solid rgb(255, 0, 0); overflow: hidden; position: absolute; height: 2px; width: 694px; top: 103px; left: 3px; z-index: 2501; display: none;"></div><div style="border-top: 2px solid rgb(255, 0, 0); overflow: hidden; position: absolute; height: 2px; width: 696px; top: 119px; left: 3px; z-index: 2501; display: none;"></div><div style="border-left: 2px solid rgb(255, 0, 0); overflow: hidden; position: absolute; height: 16px; width: 2px; top: 103px; left: 3px; z-index: 2501; display: none;"></div><div style="border-left: 2px solid rgb(255, 0, 0); overflow: hidden; position: absolute; height: 16px; width: 2px; top: 103px; left: 697px; z-index: 2501; display: none;"></div><div style="border-style: solid; border-color: black; border-width: 0pt 2px 2px 1px; padding: 2px 5px; background-color: rgb(255, 240, 204); font-family: arial; text-align: left; color: rgb(0, 0, 0); font-size: 12px; position: absolute; -moz-border-radius-bottomleft: 6px; -moz-border-radius-bottomright: 6px; z-index: 2505; visibility: hidden; left: 5px; top: 121px; display: none;"><b style="color: rgb(0, 0, 0);">p</b>, class: MsoNormal</div><div style="border-style: solid; border-color: black; border-width: 1px 2px 2px 1px; padding: 2px 5px; display: none; background-color: rgb(204, 255, 204); font-family: arial; text-align: left; color: rgb(0, 0, 0); font-size: 12px; position: absolute; z-index: 2506;"></div>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com1tag:blogger.com,1999:blog-21747363.post-60513458869728535542007-09-12T00:21:00.000-07:002007-09-12T00:28:36.936-07:00Achat sur Internet : PCSOFT lance la commande en ligneJe viens de voir sur le site de PC SOFT, la possibilité d'acheter des produits en ligne.<br />Sur la page tarif, on peut se constituer un panier et régler par carte bancaire via paybox.<br /><br />Depuis le temps qu'on attendait cette possibilité, c'est enfin une réalité.progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-36539395491095809792007-09-10T02:55:00.000-07:002007-09-10T03:23:37.594-07:00Créer la database sur MySQL avec WinDev, WebDevN'ayant pas trouvé comment créer la database MySQL avec l'accès natif, je me suis reporté sur la connexion ODBC<br />Lors de la connexion avec l'accès natif, il faut préciser le nom de la base. Il est donc necessaire d'utiliser PHPMyAdmin ou SQLylog pour créer la base.<br />Je souhaitais créer par programmation la database puis lancer le script des tables.<br /><br />La fonction SQLConnecte permet d'effectuer ce traitement si on utilise la connexion ODBC.<br /><br />Voici le code permettant de créer la database :<br /><br />id est un entier = <span style="color: rgb(51, 51, 255);">SQLConnecte</span>("MysqlODBC","root","mdp","","ODBC ",hODBC)<br />SI id <> 0 ALORS<br /> sNomDatabase est une chaîne = "Database"<br /> // création de la base de données<br /> sSql est une chaîne = "CREATE DATABASE IF NOT EXISTS %1"<br /> sSql = <span style="color: rgb(51, 51, 255);">ChaîneConstruit</span>(ssql,sNomDatabase)<br /> // execution de la requête<br /> SI PAS <span style="color: rgb(51, 51, 255);">SQLExec</span>(ssql,"REQ") ALORS<br /> <span style="color: rgb(51, 51, 255);">SQLInfoGene</span>()<br /> <span style="color: rgb(51, 51, 255);">Erreur</span>("La Database n'a pas pu être créée. Code erreur : " + <span style="color: rgb(51, 51, 255);">SQL.Erreur </span>+RC+...<br /> <span style="color: rgb(51, 51, 255);">SQL.MesErreur</span>)<br /> FIN<br />SINON<br /> // La connexion a échoué : affichage d'un message explicatif<br /> <span style="color: rgb(51, 51, 255);">SQLInfoGene</span>()<br /> <span style="color: rgb(51, 51, 255);">Erreur</span>("La connexion à la source de données" + "localhost" + ...<br /> "a échoué."+RC+...<br /> "Code erreur : " + <span style="color: rgb(51, 51, 255);">SQL.Erreur</span> +RC+...<br /> <span style="color: rgb(51, 51, 255);">SQL.MesErreur</span>)<br />FIN<br />// Dans tous les cas (connexion OK ou pas)<br /><span style="color: rgb(51, 51, 255);">SQLDéconnecte</span>()<br /><br />Ensuite on peut utiliser les fonctions "H*" avec l'accès natif MySQL.<br />Un peut contraignant, car il faut le drivers ODBC d'installé sur le poste.progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com3tag:blogger.com,1999:blog-21747363.post-63179731550193834132007-08-13T08:49:00.000-07:002007-08-13T08:53:09.601-07:00Arrêt du support de PHP 4Une news paru sur <a href="http://www.phpindex.com/index.php/2007/07/13/3474-arret-du-support-de-php4">PHP index</a> indique l'arrêt du support de PHP 4 le 31 décembre 2007.<br />Il va falloir penser à passer à la version 5 de PHP.<br /><br />En espérant que la prochaine version de WebDev supporte la version 5 de php.progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-85921277963331793722007-08-09T05:11:00.000-07:002007-08-09T05:33:28.129-07:00WebDev 11. Image dynamique et répertoire des données.<p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Dans l'aide en ligne il est indiqué que pour une image de type dynamique, les images doivent se trouver dans le répertoire _WEB ou un sous répertoire de celui-ci.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Toutefois, en déploiement, l'invité internet n'a pas les droits en écriture dans le répertoire _WEB.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Par conséquent, lorsque une page d'administration permet au Webmaster de modifier et changer des images, il faut que celles-ci se trouvent dans le répertoires de données seul répertoire ou l'invité internet à les droits de lecture/écriture.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Malheureusement on ne peut pas accéder à ce répertoire en code navigateur, car la fonction WLangage fRepDonnées est disponible qu'en code serveur.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">De plus si le type d'image est défini en dynamique, même en code serveur, il faut un chemin relatif pour pouvoir afficher une image.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><br /></span></span></p><p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><span style="font-weight: bold;">Solution 1</span> : Créer un Alias ou répertoire virtuel sur le répertoire des données.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><!--[if !supportEmptyParas]--> <o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Sous Apache 2.2.x l'alias se créer de la façon suivante dans le fichier httpd.conf<o:p></o:p></span></span></p> <p class="MsoList"><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;"><</span><span style=";font-family:Verdana;font-size:85%;" lang="EN-GB" >Directory "C:/temp/Test_Image_Timer/Exe/DATA/"</span></span><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;">> </span></span></p><p class="MsoList"><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;">Alias /DATA/ "C:/temp/Test_Image_Timer/Exe/DATA/"<o:p></o:p></span></span></p> <p class="MsoList"><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;"><directory><o:p></o:p></directory></span></span></p> <p class="MsoList"><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;">Order allow,deny<o:p></o:p></span></span></p> <p class="MsoList"><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;">Allow from all</span></span></p><p class="MsoList"><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;"></</span><span style=";font-family:Verdana;font-size:85%;" lang="EN-GB" >Directory></span></span><br /><span style="font-size:85%;"><span lang="EN-GB" style="font-family:Verdana;"><o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">NOTE : Pour les tests j'ai créé un alias sur un sous répertoire du répertoire exe du projet. En déploiement se répertoire correspond au répertoire données décrit dans la création du compte WebDev.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">PS : pour ceux qui utilisent le CCHerbergement, il faudra dans IIS créer un répertoire virtuel supplémentaire depuis la console de configuration du serveur Web.<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Ensuite dans le code WebDev on peut écrire le code suivant :<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">Le champ Image est de type dynamique<o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;"><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></span></p> <p class="MsoList" style=""><span style="font-size:85%;"><span style="font-family:Verdana;">// Code initialisation de la page (serveur)<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size:85%;"><span style="">IMG_</span><span style="">Image1</span><span style=""> = </span><span style="">"../DATA/ImgAcc/ImgAcc01.jpg"</span></span></p><br /><p class="MsoNormal" style="">Solution 2 :<br /></p><p class="MsoNormal" style=""><span style="font-size:85%;">Modifier les droits sur un sous répertoire du répertoire _WEB. Cela signifie de demander à son hébergeur une modification.</span></p><p class="MsoNormal" style=""><br /><span style="font-size:85%;"><span style=""><o:p></o:p></span></span></p>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0tag:blogger.com,1999:blog-21747363.post-64849010578970805142007-08-06T05:57:00.000-07:002007-08-06T06:01:17.859-07:00WinDev 11 . Procédures Stockées MySQL 5.x<span style=";font-family:Verdana;font-size:85%;" >Pour utiliser les procédures stockées avec MySQL 5.x, il faut tout d'abord avoir l'accès natif MySQL dernière version. C'est à dire la version 46b.</span><span style=";font-family:Verdana;font-size:85%;" > <o:p></o:p></span> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >Vous trouverez l'accès natif à l'adresse suivante :<o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><a href="http://www.pcsoft.fr/st/telec/modules-communs-11/mysql.htm">http://www.pcsoft.fr/st/telec/modules-communs-11/mysql.htm</a><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >Soit un fichier client :</span></p><p class="MsoNormal"><span style="font-size:85%;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWz4ycAxtK31w0Wa66osWYR75Ij3lqUNY7rRX9GnHn-ntXhWqy6L4rFraQWR0fcE2hsUdRyWFS9SH7LeHb7KM5tZPOARtoNpOED4aEmKnPyEGTcb5yRAdSUaqpc4xAou6BJowj/s1600-h/table.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWz4ycAxtK31w0Wa66osWYR75Ij3lqUNY7rRX9GnHn-ntXhWqy6L4rFraQWR0fcE2hsUdRyWFS9SH7LeHb7KM5tZPOARtoNpOED4aEmKnPyEGTcb5yRAdSUaqpc4xAou6BJowj/s320/table.jpg" alt="" id="BLOGGER_PHOTO_ID_5095571480082108866" border="0" /></a></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >Version : Serveur MySQL 5.0.45</span><span style=";font-family:Verdana;font-size:85%;" ><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >- Exemple de procédure stockée avec passage de paramètres :<o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >1 – Création de la procédure stockées sur le serveur<o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="color: rgb(127, 191, 127);font-family:Verdana;font-size:85%;" >s</span><span style=";font-family:Verdana;font-size:85%;color:green;" >Proc</span><span style=";font-family:Verdana;font-size:85%;color:black;" > est une chaîne = [<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:purple;" lang="EN-GB" >"DROP PROCEDURE IF EXISTS `procstok`.`simpleproc1` ;<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:purple;" lang="EN-GB" ><span style=""> </span>CREATE PROCEDURE simpleproc1 (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM client; END;<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:black;" >]<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:green;" >scReq</span><span style=";font-family:Verdana;font-size:85%;color:black;" > est une Source de Données<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size:85%;"><b><span style=";font-family:Verdana;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></b></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:gray;" >// Exécution de la requête<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:black;" >SI PAS </span><span style=";font-family:Verdana;font-size:85%;color:blue;" >HExécuteRequêteSQL</span><span style=";font-family:Verdana;font-size:85%;color:black;" >(</span><span style=";font-family:Verdana;font-size:85%;color:green;" >scReq</span><span style=";font-family:Verdana;font-size:85%;color:black;" >,</span><span style=";font-family:Verdana;font-size:85%;color:teal;" >MaConnexion1</span><span style=";font-family:Verdana;font-size:85%;color:black;" >,</span><span style="font-size:85%;"><i><span style=";font-family:Verdana;color:blue;" >hRequêteSansCorrection</span></i></span><span style=";font-family:Verdana;font-size:85%;color:black;" >,</span><span style="color: rgb(127, 191, 127);font-family:Verdana;font-size:85%;" >s</span><span style=";font-family:Verdana;font-size:85%;color:green;" >Proc</span><span style=";font-family:Verdana;font-size:85%;color:black;" >) ALORS<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:Verdana;font-size:85%;color:blue;" >Erreur</span><span style=";font-family:Verdana;font-size:85%;color:black;" >()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:black;" >SINON<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:Verdana;font-size:85%;color:blue;" >Info</span><span style=";font-family:Verdana;font-size:85%;color:black;" >(</span><span style=";font-family:Verdana;font-size:85%;color:purple;" >"Procédure stocké créée"</span><span style=";font-family:Verdana;font-size:85%;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:Verdana;font-size:85%;color:black;" >FIN</span><span style="font-size:85%;"><b><span style=";font-family:Verdana;" ><o:p></o:p></span></b></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >2 – Exécution de la procédure stockée :<o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;" >sd</span><span style=";font-family:";font-size:85%;color:green;" >Req</span><span style=";font-family:";font-size:85%;color:black;" > est une Source de Données<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size:85%;"><b><span style=";font-family:System;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></b></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" >SI PAS </span><span style=";font-family:";font-size:85%;color:blue;" >HExécuteRequêteSQL</span><span style=";font-family:";font-size:85%;color:black;" >(</span><span style=";font-family:";font-size:85%;" >sd</span><span style=";font-family:";font-size:85%;color:green;" >Req</span><span style=";font-family:";font-size:85%;color:black;" >,</span><span style=";font-family:";font-size:85%;color:teal;" >MaConnexion1</span><span style=";font-family:";font-size:85%;color:black;" >,</span><span style="font-size:85%;"><i><span style=";font-family:";color:blue;" >hRequêteSansCorrection</span></i></span><span style=";font-family:";font-size:85%;color:black;" >,</span><span style=";font-family:";font-size:85%;color:purple;" >"call simpleproc1(@a);select @a;"</span><span style=";font-family:";font-size:85%;color:black;" > ) ALORS<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:85%;color:blue;" >Erreur</span><span style=";font-family:";font-size:85%;color:black;" >()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" >SINON <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:85%;color:blue;" >Info</span><span style=";font-family:";font-size:85%;color:black;" >(</span><span style=";font-family:";font-size:85%;color:purple;" >"Gagné"</span><span style=";font-family:";font-size:85%;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:85%;color:gray;" >// Lecture du résultat de la procédure</span><span style=";font-family:";font-size:85%;color:black;" ><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:85%;color:blue;" >HLitPremier</span><span style=";font-family:";font-size:85%;color:black;" >(</span><span style=";font-family:";font-size:85%;" >sd</span><span style=";font-family:";font-size:85%;color:green;" >Req</span><span style=";font-family:";font-size:85%;color:black;" >,</span><span style="font-size:85%;"><i><span style=";font-family:";color:blue;" >hSansRafraîchir</span></i></span><span style=";font-family:";font-size:85%;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" ><span style=""> </span></span><span style=";font-family:";font-size:85%;color:blue;" >Trace</span><span style=";font-family:";font-size:85%;color:black;" >(</span><span style=";font-family:";font-size:85%;" >sd</span><span style=";font-family:";font-size:85%;color:green;" >Req</span><span style=";font-family:";font-size:85%;color:black;" >.</span><span style=";font-family:";font-size:85%;color:green;" >@a</span><span style=";font-family:";font-size:85%;color:black;" >)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style=";font-family:";font-size:85%;color:black;" >FIN</span><span style="font-size:85%;"><b><span style=";font-family:System;" ><o:p></o:p></span></b></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:Verdana;font-size:85%;" >NOTE : la constante </span><span style="font-size:85%;"><i><span style=";font-family:";color:blue;" >hSansRafraîchir </span></i></span><span style=";font-family:";font-size:85%;" >permet de ne pas ré-exécuter la requête.<o:p></o:p></span></p> <p class="MsoNormal"><span style=";font-family:";font-size:85%;" ><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:85%;"><br /></span></p><p class="MsoNormal"><span style="font-size:85%;"><br /></span><span style=";font-family:Verdana;font-size:85%;" ><o:p></o:p></span></p> <span style=";font-family:Verdana;font-size:85%;" ><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" spt="75" preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:formulas> <v:path extrusionok="f" gradientshapeok="t" connecttype="rect"> <o:lock ext="edit" aspectratio="t"> </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style="'width:124.5pt;" ole=""> <v:imagedata src="file:///C:/DOCUME~1/FA/LOCALS~1/Temp/msoclip1/01/clip_image001.png" title=""> </v:shape><![endif]--><!--[if !vml]--><!--[endif]--><!--[if gte mso 9]><xml> <o:oleobject type="Embed" progid="" shapeid="_x0000_i1025" drawaspect="Content" objectid="_1247917434"> </o:OLEObject> </xml><![endif]--></span>progwdmhttp://www.blogger.com/profile/13495953742912036587noreply@blogger.com0