What´s wrong on this index under ADS?

What´s wrong on this index under ADS?

Postby lucasdebeltran » Thu Mar 15, 2012 4:36 pm

Hello,

I want to use those index under ADS:

FIELD NUMERO, PASADO

INDEX ON NUMERO TO (cMyPath+"PRESUA") FOR PASADO = "S" .AND. !Deleted()
INDEX ON NUMERO TO (cMyPath+"PRESUN") FOR PASADO != "S" .AND. !Deleted()


But when I try to do a backup, It says:

Error 3010: Unknown alias name used with field name in index key expression.



I can use in my APP the DBF wih PRESUA and PRESUN but not do a backup.

Any idea please?.

Thank you.
Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.
User avatar
lucasdebeltran
 
Posts: 1303
Joined: Tue Jul 21, 2009 8:12 am

Re: What´s wrong on this index under ADS?

Postby FranciscoA » Thu Mar 15, 2012 4:55 pm

Hi, maybe on this ways:

INDEX ON FIELD->NUMERO TO (cMyPath+"PRESUA") FOR FIELD->PASADO = "S" .AND. !Deleted()
INDEX ON (cAlias)->NUMERO TO (cMyPath+"PRESUA") FOR (cAlias)->PASADO = "S" .AND. !Deleted()

Regards.
Francisco J. Alegría P.
Chinandega, Nicaragua.

Fwxh-MySql-TMySql
User avatar
FranciscoA
 
Posts: 2158
Joined: Fri Jul 18, 2008 1:24 am
Location: Chinandega, Nicaragua, C.A.

Re: What´s wrong on this index under ADS?

Postby lucasdebeltran » Thu Mar 15, 2012 5:00 pm

Francisco,

In ADS Alias() can´t be used.

Do you use ADS?.

Thank you.
Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.
User avatar
lucasdebeltran
 
Posts: 1303
Joined: Tue Jul 21, 2009 8:12 am

Re: What´s wrong on this index under ADS?

Postby FranciscoA » Thu Mar 15, 2012 9:23 pm

Sorry, I don't use ADS.
Regards.
Francisco J. Alegría P.
Chinandega, Nicaragua.

Fwxh-MySql-TMySql
User avatar
FranciscoA
 
Posts: 2158
Joined: Fri Jul 18, 2008 1:24 am
Location: Chinandega, Nicaragua, C.A.


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 79 guests