cancel
Showing results for 
Search instead for 
Did you mean: 

User Tables and fields

Former Member
0 Kudos

Hello everyone,

A customer had the following query installed in his database:

SELECT T2.[DocDate], T2.[NumAtCard], T2.[DocTotal], T1.[CardCode], T1.[CardName], T0.[Name], T1.[U_Ruta], T1.[U_Plantase] FROM [dbo].[@SEFA] T0 inner join [dbo].[OCRD] T1 on T0.[Code] = T1.[U_Chofer] inner join [dbo].[OINV] T2 on T1.[CardCode] = T2.[CardCode] WHERE T2.[DocDate] = [%0] and T0.[Name] = [%1]

What the query is supposed to do is this: the user enters the name of one of the company's messengers and a date. The query looks this name up in the @SEFA table which is user defined and linked to the OCRD table through the U_Chofer field. Once the query has arrived to the Business Partners assigned to this messenger, it selects all the invoices to this business partner's name which have the entered document date.

They query works fine. The problem is that in the 2007 version when the query was run and the parameters were prompted you could display a list of the possible names for the messengers by pressing tab in the Name prompt. In the 8.8 this does not happen and the customer has to enter the complete name of the messenger in order for the query to deliver results. The date field does have this functionality.

I have run tests and it seems that this is indeed the case. If instead of filtering with the Name field I use the U_Chofer list I do get the option of displaying a list however the list consists of the codes of the messengers and not their names. I would appreciate any help in understanding why this option is not present in the 8.8 version so I can explain to the customer and try to come up with a solution.

Thanks in advance and best regards,

HLB

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You may try this first:


SELECT T2.[DocDate], T2.[NumAtCard], T2.[DocTotal], T1.[CardCode], T1.[CardName], T0.[Name], T1.[U_Ruta], T1.[U_Plantase]
FROM [dbo].[@SEFA] T0
inner join [dbo].[OCRD] T1 on T0.[Code] = T1.[U_Chofer]
inner join [dbo].[OINV] T2 on T1.[CardCode] = T2.[CardCode]
WHERE T2.[DocDate] = [%0] and T0.[Name] LIKE '[%1]%'

Thanks,

Gordon

Former Member
0 Kudos

Thank you for your reply but the issue still persist. It seems to be a change in the way the system handles user defined tables. It is not a big deal but I would like to be able to explain to the client why it doesn't work in this version when it used to work fine in the previous one.

Best regards,

Horacio Lom Bonilla