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...
Message search is now enhanced, find messages faster. Take it for a spin.

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 #626 of 1020 |
Re: [s-base] Query problem

On Mon 05 Apr, B21306@... wrote:
>
> 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 right.
>
> But !!! when a another Query field is a Date Value with !! Subtype
> time/date interval for search age eg. 6d or 2y this work not :-(.
>
> I mean ?? in the second Query field must SAM use @datesi but it use
> @datesn so only Date Value without subtype works or ?
>
> Is there a Bypass available for a age search ?
> I can not become a time/date interval value in a string value.(error)

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 looked into some of my applications and have found the data types
of all fields in the queries to be a special 'system(xx)' type.

What you want to do is hard as the field is specially shown through the
@date.. command. I do not think the way you want to search for it is the
way the data is stored in the database...

Sorry...

>
> Can plaese everyone give me a Hint.
>
> Sorry for my bad english.
>
> Thanks for a answer and Regards say
>
> Hans-Juergen Barthelmehs
>

Gruß
Wim
--
wim ekels @ ekels zandvoort bv nederland
tel +31 (0)23 5714180 postbus 314
fax +31 (0)23 5718296 NL-2040 AH ZANDVOORT
mailto : wim@... on line : http://www.ekels.nl




Tue Apr 6, 2004 11:42 am

wimekels
Offline Offline
Send Email Send Email

Forward
Message #626 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