|
Home > Archive > SQL Anywhere ultralite > March 2006 > Different retrieve-result on desktop and ppc
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Different retrieve-result on desktop and ppc
|
|
| Rolf Knaden 2006-03-08, 11:23 am |
| Hello.
I am using PK 2.0.3 Build 864 and an UL-Database.
My PPC is a HP-iPAQ with WM5.
Can anyone tell me, why the following select does not retrieve any data on
my PPC (without generating an error), whereas it retrieves them using in my
developement-environment on my desktop?
SELECT g.class_name, g.obj_path_desc, av1.complete
FROM geodaten g, attribute_values av1
WHERE av1.att_id in
(select min(av2.att_id)
from attribute_values av2
where av2.obj_id = av1.obj_id)
and av1.att_id in
(select al.att_id
from attribute al
where al.tab > 0)
and av1.util_id = g.obj_id;
The UL-database contains the same data on each platform!
Thanks.
--
Rolf Knaden
conject GmbH, c/o Business-Contor Philosophenweg 31-33, 47051 Duisburg
Fon: +49 (0203) 9414.138
Fax: +49 (0203) 9414.555
Rolf.Knaden@conject.com
www.conject.com
konsequent conject.
| |
| Breck Carter [Team iAnywhere] 2006-03-08, 8:23 pm |
| What is the error you are getting?
On 8 Mar 2006 10:21:42 -0800, "Rolf Knaden" <rolf.knaden@conject.com>
wrote:
>Hello.
>I am using PK 2.0.3 Build 864 and an UL-Database.
>My PPC is a HP-iPAQ with WM5.
>
>Can anyone tell me, why the following select does not retrieve any data on
>my PPC (without generating an error), whereas it retrieves them using in my
>developement-environment on my desktop?
>
>SELECT g.class_name, g.obj_path_desc, av1.complete
>FROM geodaten g, attribute_values av1
>WHERE av1.att_id in
> (select min(av2.att_id)
> from attribute_values av2
> where av2.obj_id = av1.obj_id)
>and av1.att_id in
> (select al.att_id
> from attribute al
> where al.tab > 0)
>and av1.util_id = g.obj_id;
>
>The UL-database contains the same data on each platform!
>
>Thanks.
--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
breck.carter@risingroad.com
| |
| David Fishburn 2006-03-08, 8:23 pm |
| "Rolf Knaden" <rolf.knaden@conject.com> wrote in
news:440f110d$1@foru
ms-2-dub of sybase.public.sqlanywhere.ultralite:
RK> I am using PK 2.0.3 Build 864 and an UL-Database.
RK> My PPC is a HP-iPAQ with WM5.
Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).
You didn't provide the UL version information.
RK> Can anyone tell me, why the following select does not retrieve any
RK> data on my PPC (without generating an error), whereas it retrieves
RK> them using in my developement-environment on my desktop?
RK> The UL-database contains the same data on each platform!
Well, first guess is the UL database does _not_ contain the same data as
the desktop. You would have to verify this step.
RK> SELECT g.class_name, g.obj_path_desc, av1.complete
RK> FROM geodaten g, attribute_values av1
RK> WHERE av1.att_id in
RK> (select min(av2.att_id)
RK> from attribute_values av2
RK> where av2.obj_id = av1.obj_id)
RK> and av1.att_id in
RK> (select al.att_id
RK> from attribute al
RK> where al.tab > 0)
RK> and av1.util_id = g.obj_id;
Second, you need to break the query down into separate parts and verify
each subselect is returning what you were expecting it to, or at least
what the desktop was returning.
Then you can determine where it is going wrong.
Remove one condition at a time from the main select and see what you end
up with.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Rolf Knaden 2006-03-09, 3:23 am |
| Sorry,
UL-Version is 9.0.1 (1922)
"David Fishburn" <fishburn_spam@off.ianywhere.com> schrieb im Newsbeitrag
news:Xns9780A9F35A20
Dfishburnsybasecom@1
27.0.0.1...
> "Rolf Knaden" <rolf.knaden@conject.com> wrote in
> news:440f110d$1@foru
ms-2-dub of sybase.public.sqlanywhere.ultralite:
>
> RK> I am using PK 2.0.3 Build 864 and an UL-Database.
> RK> My PPC is a HP-iPAQ with WM5.
>
> Please ALWAYS include version and MORE importantly BUILD number
> with EACH post (dbeng9 -v).
>
> You didn't provide the UL version information.
>
> RK> Can anyone tell me, why the following select does not retrieve any
> RK> data on my PPC (without generating an error), whereas it retrieves
> RK> them using in my developement-environment on my desktop?
>
> RK> The UL-database contains the same data on each platform!
>
> Well, first guess is the UL database does _not_ contain the same data as
> the desktop. You would have to verify this step.
>
> RK> SELECT g.class_name, g.obj_path_desc, av1.complete
> RK> FROM geodaten g, attribute_values av1
> RK> WHERE av1.att_id in
> RK> (select min(av2.att_id)
> RK> from attribute_values av2
> RK> where av2.obj_id = av1.obj_id)
> RK> and av1.att_id in
> RK> (select al.att_id
> RK> from attribute al
> RK> where al.tab > 0)
> RK> and av1.util_id = g.obj_id;
>
> Second, you need to break the query down into separate parts and verify
> each subselect is returning what you were expecting it to, or at least
> what the desktop was returning.
>
> Then you can determine where it is going wrong.
>
> Remove one condition at a time from the main select and see what you end
> up with.
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with
> EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
> [url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>
| |
| Rolf Knaden 2006-03-09, 3:23 am |
| I'm not getting any error. Only the number of retrieved rows is zero.
"Breck Carter [Team iAnywhere]" < NOSPAM__bcarter@risi
ngroad.com> schrieb im
Newsbeitrag news:vtdu02pcuokq30p
t96725li6o6e8eamtvn@
4ax.com...
> What is the error you are getting?
>
> On 8 Mar 2006 10:21:42 -0800, "Rolf Knaden" <rolf.knaden@conject.com>
> wrote:
>
on[color=darkred]
my[color=darkred]
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
> breck.carter@risingroad.com
| |
| Greg Fenton 2006-03-09, 11:23 am |
| Rolf Knaden wrote:
> I'm not getting any error. Only the number of retrieved rows is zero.
>
Have you checked the SQLCode after issuing the SELECT ?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Rolf Knaden 2006-03-15, 7:30 am |
| I check the sqlcode after the statement. It is 0.
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> schrieb im Newsbeitrag
news:44105d06$1@foru
ms-2-dub...
> Rolf Knaden wrote:
>
> Have you checked the SQLCode after issuing the SELECT ?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Michael Thode 2006-03-15, 11:23 am |
| Which API are you using. (eg. ESQL, C++, VB etc..)
Mike
"Rolf Knaden" <rolf.knaden@conject.com> wrote in message
news:440fea52@forums
-2-dub...
> Sorry,
> UL-Version is 9.0.1 (1922)
>
> "David Fishburn" <fishburn_spam@off.ianywhere.com> schrieb im Newsbeitrag
> news:Xns9780A9F35A20
Dfishburnsybasecom@1
27.0.0.1...
>
>
| |
| Rolf Knaden 2006-03-16, 9:23 am |
| I am using Pocketbuilder 2.0.3 Build 864.
"Michael Thode" < mthode_no_spam@sybas
e.com> schrieb im Newsbeitrag
news:44185691$1@foru
ms-1-dub...
> Which API are you using. (eg. ESQL, C++, VB etc..)
>
> Mike
>
> "Rolf Knaden" <rolf.knaden@conject.com> wrote in message
> news:440fea52@forums
-2-dub...
Newsbeitrag[color=da
rkred]
as[color=darkred]
end[color=darkred]
>
>
| |
| Michael Thode 2006-03-16, 1:23 pm |
| Can you post the schema for the referenced tables.
Mike
"Rolf Knaden" <rolf.knaden@conject.com> wrote in message
news:4419716f@forums
-2-dub...
>I am using Pocketbuilder 2.0.3 Build 864.
>
> "Michael Thode" < mthode_no_spam@sybas
e.com> schrieb im Newsbeitrag
> news:44185691$1@foru
ms-1-dub...
> Newsbeitrag
> as
> end
>
>
|
|
|
|
|