Code Datatype problem...

rajpatelbca

Hi Experts,

I have some strange problem. one of our client using space in customer code. eg. (REL TECH,WEB SOL). but actual problem occure when i used code like this one the codeunits :

CustRec.setrange(CustRec."No.",Mytable."Cust. Order No.");
if CustRec.Findfirst then
begin
.....
end;

as a result it cant found the records.

Thanks in advance..

Rajesh Patel

kapamarou

rajpatelbca wrote:

Hi Experts,

I have some strange problem. one of our client using space in customer code. eg. (REL TECH,WEB SOL). but actual problem occure when i used code like this one the codeunits :

CustRec.setrange(CustRec."No.",Mytable."Cust. Order No.");
if CustRec.Findfirst then
begin
.....
end;

as a result it cant found the records.

Thanks in advance..

Rajesh Patel

CustRec.setrange(CustRec."No.",Mytable."Cust. Order No.");

Do you mean Mytable."Cust. Order No." or some other field of MyTable?

rajpatelbca

#-o ooh its same field having customer no.

CustRec.setrange(CustRec."No.",Mytable."Cust. No.");

Savatage

yeah i can see where eg. (REL TECH,WEB SOL) would be really weird order numbers.

Experience Makes Man Perfect....

I don't think anyone can be perfect, better but not perfect

rajpatelbca

Thanks for your quick reponse..

my client is using space in Customer No. eg.FRAG DIR
i have one table called mytable in which that Customer No. is available that table actually contain a customer order information. "Customer No." Field of this table having customer No. in mytable. when, i have written some code like this.

CustRec.Setrange(CustRec."No.",mytable."Customer No.")
if CustRec.findfirst then
....


but its can't find such kind of customer. ](*,)

Thanks

idiot

Can you find anything with
CustRec.Setrange(CustRec."No.",'FRAG DIR')?

DenSter

Savatage wrote:

I don't think anyone can be perfect, better but not perfect

I saw someone yesterday at the airport luggage claim with a sticker on his suitcase that said "I am not perfect, but parts of me are incredible"