fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #292] Dans lecture de mr_visite_data_text ajouter : and abandon is null #355

New Issue
Open
opened 2023-07-04 07:17:18 +02:00 by fbenoist68 · 4 comments
fbenoist68 commented 2023-07-04 07:17:18 +02:00
Owner

Assigned To: CLOSED
Project: Mobile Portal
Area: Divers
Category: Bogue
Priority: A fixer impérativement

Assigned To: CLOSED Project: Mobile Portal Area: Divers Category: Bogue Priority: A fixer impérativement
fbenoist68 commented 2023-07-04 07:17:21 +02:00
Poster
Owner

Event ID: 1281
Date: 2014-04-06T06:46:01Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 1281 Date: 2014-04-06T06:46:01Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-04 07:17:24 +02:00
Poster
Owner

Event ID: 1280
Date: 2014-04-06T06:46:01Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

dans gen_visite_pdf :
 
 BEGIN
         SELECT SUBSTR (mvdt.data_clob, 1, 32000)
           INTO v_synthese_gen
           FROM mr_visite_data_text mvdt
          WHERE mvdt.id_visite = pid_visite AND mvdt.id_visite_data_type = 1 AND mvdt.abandon IS null;
      EXCEPTION
         WHEN NO_DATA_FOUND
         THEN
            v_synthese_gen := NULL;
      END;
Event ID: 1280 Date: 2014-04-06T06:46:01Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist <div> dans&nbsp;gen_visite_pdf :</div> <div> &nbsp;</div> <div> &nbsp;BEGIN</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SELECT SUBSTR (mvdt.data_clob, 1, 32000)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;INTO v_synthese_gen</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM mr_visite_data_text mvdt</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE mvdt.id_visite = pid_visite AND mvdt.id_visite_data_type = 1 <strong>AND mvdt.abandon IS null;</strong></div> <div> &nbsp; &nbsp; &nbsp; EXCEPTION</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHEN NO_DATA_FOUND</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;THEN</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; v_synthese_gen := NULL;</div> <div> &nbsp; &nbsp; &nbsp; END;</div>
fbenoist68 commented 2023-07-04 07:17:30 +02:00
Poster
Owner

Event ID: 1279
Date: 2014-04-02T09:42:26Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 1279 Date: 2014-04-02T09:42:26Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 07:17:33 +02:00
Poster
Owner

Event ID: 1278
Date: 2014-04-02T09:42:25Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 1278 Date: 2014-04-02T09:42:25Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#355
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?