Error when creating a cursor

[Niki_S]

create cursor ReportCursor(cBatchNo c(20) NULL,nPoDtlID n(10,2) NULL,cBatchNo c(20) NULL,nBatchInvId n(10,2) NULL)

I used this and when I run this it says Field name is a duplicate or invalid.
Why is that?

 

[Chris Miller]

Yes, you have two cBatchNo fields, that's not possible, field names must differ.

Chriss

 

[Niki_S]

Thank you chriss, I stupidly missed that

 

[Dan Olsson]

Sometimes the error message actually says what is wrong

 

[Niki_S]

Can you please give me a solution for this too?

SELECT Batch_no
SCAN
TEXT TO stra NOSHOW
SELECT cBatchNo,nPoDtlID,cPoLine,nBatchInvId,nSuplID,cSuplName,cPaymentCurr,nInvValue,nConvRate,cTag FROM MAS.dbo.vAcp_All_InvDtl WHERE  nPoDtlID=?Batch_no.nPoDtlID  AND cBatchNo NOT in (select cBatchNo from MAS.dbo.Acp_FinalPayment)
ENDTEXT

Use In Select('tempOutstanding')

SELECT Batch_no 
SCAN 
	SQLEXEC(hndOps,stra,'_TempO') 
  If NOT Used('tempOutstanding')
     Select * From  _TempO Into Cursor tempOutstanding READWRITE 
  Else
     SELECT tempOutstanding
     APPEND FROM DBF('_TempO') 
  Endif
ENDSCAN 
ENDSCAN

This is my code and when I use this code it takes more time to get my output. How can I get my output in less time?
Thank you.

 

[TamarGranor]

Have you tested your query in the IDE for whichever server product you're using to see how fast it runs there? That is, is the issue in the query itself or in how you're processing the result when you get it back?

Assuming it's the server, use whatever tools it has for performance tuning to improve your query.

Tamar