Normal Topic Undesired  ^j showing up. (Read 615 times)
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Undesired  ^j showing up.
Jun 21st, 2007 at 4:56pm
Print Post Print Post  
When I use @XLookupsourcelistAll() to get data and @AccessStringArray() to fill data to a particular element I get my data followed by a ^J. if I empty the field in my retrieve from db so it is empty, it returns ^j by itself. The one unique thing about this is the field I am getting the data from is a combo box.

My only thought is I am picking up a carriage return from my combo list, but I am just making a wild guess.

Is there a technique I need to use when using comboboxes with my @XLookupsourcelistAll() and @AccessStringArray()? Or do you think  this ^j is coming from something else I have done incorrectly?

Thanks
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Undesired  ^j showing up.
Reply #1 - Jun 21st, 2007 at 6:02pm
Print Post Print Post  
Hello Robert,

@XLookupSourceListAll() returns records separated by a carriage return. If you only need to get one record you will want use @XLookupSourceList().

-Ray
  

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


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Undesired  ^j showing up.
Reply #2 - Jun 21st, 2007 at 6:11pm
Print Post Print Post  
Once Again, Thanks Ray. Smiley

  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Undesired  ^j showing up.
Reply #3 - Jun 21st, 2007 at 6:15pm
Print Post Print Post  
No problem Robert. See you tomorrow night, right?

-Ray
  

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


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Undesired  ^j showing up.
Reply #4 - Jun 21st, 2007 at 6:21pm
Print Post Print Post  
Quote:
No problem Robert. See you tomorrow night, right?

-Ray


Plane gods willing,  I will see you there!  Smiley

  

Team – Together Everyone Achieves More
Back to top
 
IP Logged