Normal Topic [Solved] I need help with @XResultSetSearch (Read 1158 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
[Solved] I need help with @XResultSetSearch
Jun 19th, 2008 at 5:50pm
Print Post Print Post  
Hello!

Please tell me what is wrong in this Code:

the RecordNo exit in Form Fahrdienst . But my button starts, the file opens Fahrdienst only in Add Mode?


var vTmp as Int
var vRecordNo as String
var vRS as Int

vRecordNo = @Str(@Date) + @UserID

GlobalValue("RecordNo",vRecordNo)



vRS = @XResultSetSearch(@FN,"FAHRTDIENST", 1, 2,"RecordNo=" + vRecordNo)
If @XResultSetTotal(vRS) > 0



                       {
                             XResultSetOpenForm(vRS, "FAHRDIENST")
                             XResultSetClose(vRS)
                       }

else

{

       vTmp = @SelectTreeItem(@Application + "!Forms!Add Data!FAHRDIENST!FAHRDIENST")            
}

     
« Last Edit: Jun 24th, 2008 at 11:54am by Hammer »  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: I need help with @XResultSetSearch
Reply #1 - Jun 19th, 2008 at 6:21pm
Print Post Print Post  
Quote:
Please tell me what is wrong in this Code:


I'm not sure what else may be wrong, but you are missing the bang on the field name:
vRS = @XResultSetSearch(@FN,"FAHRTDIENST", 1, 2,"!RecordNo=" + vRecordNo)
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: I need help with @XResultSetSearch
Reply #2 - Jun 19th, 2008 at 8:23pm
Print Post Print Post  
Hello Erika!

Sorry it still not working!

writeln(vRS)
writeLn(vRecordNo)

I get:

-1
2008/06/19c


I muss say that i can īt  Trim a Form in This Application?  is the hole Application damaged?


Thanks.


  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: I need help with @XResultSetSearch
Reply #3 - Jun 19th, 2008 at 9:08pm
Print Post Print Post  
Trim is used to trim entire databases not forms. What is the exact error message you are getting when attempting to trim?

Do other X commands work in this Application?
Are you running in the DB or DSR?
Have you double checked that FAHRTDIENST is the name of the DATABASE you wish to search into?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: I need help with @XResultSetSearch
Reply #4 - Jun 19th, 2008 at 11:09pm
Print Post Print Post  

Hello Ray!

On Vista Trimming that Database (Sorry not a Form)  does nothing happen and i thank  without Error message.
On XP - machine the Trimming in the DB itīs OK!  but @XResultSetSearch is still does not work!

No other X commands work in this Application

I īm  running in the DB and  DSR

Please what my mean with :
Have you double checked that FAHRTDIENST is the name of the DATABASE you wish to search into?

Thank.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: I need help with @XResultSetSearch
Reply #5 - Jun 20th, 2008 at 1:03pm
Print Post Print Post  
Does the application have security?

If so is the X username and Password set to a valid login for that application?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: I need help with @XResultSetSearch
Reply #6 - Jun 20th, 2008 at 4:47pm
Print Post Print Post  
Yes, Ray!
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: I need help with @XResultSetSearch
Reply #7 - Jun 23rd, 2008 at 8:05pm
Print Post Print Post  
Is that a Yes to both questions?

Quote:
Have you double checked that FAHRTDIENST is the name of the DATABASE you wish to search into?


The XResultSet of commands uses Database and Field names as opposed to the other set of X commands that use Layout and Layout Element Names. The most common problem I see with the XResultSet() commands is the name of the Layout being used instead of the Database name, or the database named mis-spelled.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: I need help with @XResultSetSearch
Reply #8 - Jun 23rd, 2008 at 10:38pm
Print Post Print Post  
Ray!

this is my mistake.
It works fine now!

Thanks for the explanation!
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged