Search the web
Sign In
New User? Sign Up
s-base · S-Base Users Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Query problem   Message List  
Reply | Forward Message #631 of 1020 |
Re: [s-base] Re: Query problem

In message <4c9ff6eac1robin@...> you wrote:
Hello,

> In article <49bf949f4c.B21306@...>,
> <B21306@...> wrote:
> > In message <Sc9cec05d0robin@...> you wrote:
> > snip
> > Hi Robin,
>
> > Thanks for your email - I,m sorry for the delay with my reply. Your proc
> > in the attachmend works fine. I have search for a solution many hours
> > over easter but this help too not in the query problem :-(. Your proc
> > give out at last a !!! string and I save this in the file.
>
> > Ok I can find in the query say 2D or 5M but when I try in the default
> > SAM query field >10M then I become 14D in use and this is not TRUE or ?
> > :-) Unfortunately in this time I have no new Idea :-(. A + with Your
> > proc is I can use J instead Y in germany.
>
> OK. I think I was misunderstanding the problem.
Or my Question was not the best...... :-)
>
> If I understand correctly (at last), you have a record with a field "age",
> containing information on difference in dates (in one form or another).
>
Yes True.
> You would like to search that field by allowing the user to specify
> strings such as "5M" for 5 months, "2Y/J" for 2 years/jars etc.
>
> For example, writing "> 5M" in the query form would search the file for
> all records where the "age" was more than 5 months.
So it is.
A Example is search for all calf is > 6 months , or search for a cow
<10 years , or in my new Apps search for food in my ice refrigerator >
8months.
>
> If that is correct then we are approaching the problem from the wrong
> direction. Before I send you lots of irrelevant code, let me know if I've
> now got the problem as it really is, and we can go from there.
>
> Hope this didn't spoil your whole Easter weekend ;O)
No,No I like learning and make my own Apps with SBase is my Hobby with
my Iyonix.
Before the greenland came not in use I have no weekend in my farm. I
hope in 2 or 3 weeks is all better. So I,am happy sitting some hours on
the computer.
>
> Regards,
>
I hope this problem is not a Hydra and a solution is nice for more
SBase user.

Best Regards

Hans-Juergen



Thu Apr 15, 2004 7:48 pm

B21306@...
Send Email Send Email

Forward
Message #631 of 1020 |
Expand Messages Author Sort by Date

Hello All, In one problem I can not found a solution. The problem is.... In a Query window createt with SAM I can found a Date Value eg. 05/04/2004 that is all...
B21306@...
Send Email
Apr 5, 2004
11:47 am

... Nah,... wenig zu tun hier nicht? Hallo Hans-Juergen, Habe mal gewartet ob einer etwas antworten wollte, scheint nicht so zu sein :-( Aber auf English: I've...
Wim Ekels
wimekels
Offline Send Email
Apr 6, 2004
11:42 am

... Hmmm... Yes I have see this but I think this is not the main problem. SBase SAM use in the Query the data typ from File without subtype or ? Ok I can use...
B21306@...
Send Email
Apr 8, 2004
5:42 pm

In article <a5a4659c4c.B21306@...>, ... It looks to me Hans, that with your formula of (@date - r_froster_card.g_date) you are trying to subtract one...
Robin Hampshire
robinsbase
Offline Send Email
Apr 9, 2004
12:32 pm

In message <Sc9cec05d0robin@...> you wrote: snip Hi Robin, Thanks for your email - I,m sorry for the delay with my reply. Your proc in the attachmend...
B21306@...
Send Email
Apr 14, 2004
4:20 pm

In article <49bf949f4c.B21306@...>, ... OK. I think I was misunderstanding the problem. If I understand correctly (at last), you have a record with a...
Robin Hampshire
robinsbase
Offline Send Email
Apr 15, 2004
11:34 am

In message <4c9ff6eac1robin@...> you wrote: Hello, ... Or my Question was not the best...... :-) ... Yes True. ... So it is. A Example is search for...
B21306@...
Send Email
Apr 15, 2004
7:48 pm

Hello Robin and Hans-Juergen ... [total snip] I followed your discussion and believe it might be the best for Robin to see the app you made. I've received from...
Wim Ekels
wimekels
Offline Send Email
Apr 16, 2004
8:38 am

Hi all, Someone (IP address 62.254.0.30) fetched the sample... In the meantime Hans-Jürgen has send me the newest version! Please follow the same link once...
Wim Ekels
wimekels
Offline Send Email
Apr 16, 2004
12:08 pm

In article <Marcel-1.53-0416120836-0b0tRkF@...>, ... Thanks Wim, I'll have a look. In the meantime, I have cobbled together something that Hans-Jurgen can...
Robin Hampshire
robinsbase
Offline Send Email
Apr 16, 2004
12:28 pm

In article <4ca086ecd3robin@...>, ... I've had a look at your app Hans-Jurgen, and I've managed to get the query working properly. What I've done is...
Robin Hampshire
robinsbase
Offline Send Email
Apr 16, 2004
3:36 pm

In message <Sca0981f1crobin@...> you wrote: Hello Robin, ... You have done big work with all Your proc and I think its a way become the Query for age...
B21306@...
Send Email
Apr 19, 2004
9:16 pm

In article <46622ca24c.B21306@...>, ... Don't mention it Hans-Jurgen, I am glad to be of help. ... I have your application here, which I downloaded...
Robin Hampshire
robinsbase
Offline Send Email
Apr 20, 2004
8:48 am

In message <4ca28216b9robin@...> you wrote: Hello Robin, with many snip... ... That can I understand. Now I have found, I think this is this rtn_str...
B21306@...
Send Email
Apr 20, 2004
12:24 pm

In article <d60796a24c.B21306@...>, ... Sent via email -- Robin Hampshire robin@......
Robin Hampshire
robinsbase
Offline Send Email
Apr 21, 2004
7:56 am

In article <48a52ba04c.B21306@...>, ... OK. I've been having a little think about this and I believe it will be possible, though a bit tricky. First of...
Robin Hampshire
robinsbase
Offline Send Email
Apr 16, 2004
12:17 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help