Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Rows Affected |
Tue, Mar 21 2006 3:21 PM | Permanent Link |
"Allan Brocklehurst" | Hi ;
Why do I get 1 row affected when I run the following on an empty table SELECT MAX(EncounterNo) AS MaxBAse FROM "PatientEncounter" WHERE [PatientID] = '000057809'; Tia Allan |
Tue, Mar 21 2006 3:24 PM | Permanent Link |
"Allan Brocklehurst" | I forgot : stats v4.22 latest build
"Allan Brocklehurst" <brock@ns.sympatico.ca> wrote in message news:E53A3027-9084-460B-BC3D-65E9023E5453@news.elevatesoft.com... > Hi ; > Why do I get 1 row affected when I run the following on an empty table > SELECT MAX(EncounterNo) AS MaxBAse FROM "PatientEncounter" > WHERE [PatientID] = '000057809'; > > Tia > > Allan > > > |
Tue, Mar 21 2006 4:49 PM | Permanent Link |
Aage Johansen | Allan Brocklehurst wrote:
> Hi ; > Why do I get 1 row affected when I run the following on an empty table > SELECT MAX(EncounterNo) AS MaxBAse FROM "PatientEncounter" > WHERE [PatientID] = '000057809'; My guess: according to std. SQL. You'll get one row where MaxBase is Null. -- Aage J. |
Wed, Mar 22 2006 8:21 AM | Permanent Link |
"Allan Brocklehurst" | Thanks Aage. I 'll keep that in mind.
Allan "Aage Johansen" <aagjohan@offline.no> wrote in message news:25CA84EE-49C1-4DA8-9B20-2E21BFDCEFC6@news.elevatesoft.com... > Allan Brocklehurst wrote: > > Hi ; > > Why do I get 1 row affected when I run the following on an empty table > > SELECT MAX(EncounterNo) AS MaxBAse FROM "PatientEncounter" > > WHERE [PatientID] = '000057809'; > > My guess: according to std. SQL. > You'll get one row where MaxBase is Null. > > -- > Aage J. > |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |