topic-23698

Board index FiveWin for Harbour/xHarbour What´s wrong on this index under ADS?

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

What´s wrong on this index under ADS?
Posted: Thu Mar 15, 2012 04: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.

FranciscoA

Posts: 2170

Joined: Fri Jul 18, 2008 01:24 AM

Re: What´s wrong on this index under ADS?
Posted: Thu Mar 15, 2012 04: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

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: What´s wrong on this index under ADS?
Posted: Thu Mar 15, 2012 05: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.

FranciscoA

Posts: 2170

Joined: Fri Jul 18, 2008 01:24 AM

Re: What´s wrong on this index under ADS?
Posted: Thu Mar 15, 2012 09:23 PM

Sorry, I don't use ADS.
Regards.

Francisco J. Alegría P.

Chinandega, Nicaragua.

Fwxh-MySql-TMySql

FiveTech Support Forums

Continue the discussion