Project

General

Profile

Actions

Bug #1871

closed

fix SQL For chk_c2_placeSystemsUsed

Added by Michael Lee over 19 years ago. Updated over 19 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
vegbranch
Target version:
Start date:
01/11/2005
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
1871

Description

SELECT Z_USER_C2_plotNorm.PlaceSystem
FROM Z_USER_C2_plotNorm
WHERE (((Len([placeSystem]))>0))
GROUP BY Z_USER_C2_plotNorm.PlaceSystem;

Actions #1

Updated by Michael Lee over 19 years ago

fixed, previous query needed a nz() in it

Actions #2

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 1871

Actions

Also available in: Atom PDF