FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour Ayuda coa adordd y Mysql (Error de alias)
Posts: 215
Joined: Fri Feb 02, 2007 03:38 PM
Ayuda coa adordd y Mysql (Error de alias)
Posted: Tue May 08, 2007 11:29 PM

Saludes amigos del foro,

Gracias a la valiosa colaboracion de Fernando quien me envio las lib de adordd para xharbour compile sin problemas, pero al ejecutarse el browse no me reconoce el alias, yo tengo una BD en Mysql que se llama Personal1 y en ella una tabla que se llama maestro y el browse no la reconoce, alguna ayuda o aclaracion ?

el codigo que compilo es :

//===========================
static function browRST()
//===========================

Public oDlg,oBrw

USE "Personal1" VIA "ADORDD" TABLE "MAESTRO" MYSQL ;
FROM "localhost" USER "root" PASSWORD "1234"

DEFINE DIALOG oDlg FROM 1, 1 TO 25, 79

@ 1, 1 LISTBOX oBrw FIELDS MAESTRO->codigo, ;
MAESTRO->nombre, ;
MAESTRO->salario ;
HEADERS "Codigo","Nombre ","Salario" ;
FIELDSIZES 60,200,60 ;
SIZE 284, 137 OF oDlg

@154,08 BTNBMP LEFT PROMPT " Agregar" SIZE 50,19 OF oDlg FILENAME "NEW1.BMP" ACTION oDlg:End()
@154,67 BTNBMP LEFT PROMPT " Modificar" SIZE 50,19 OF oDlg FILENAME "CARDF00C.BMP" ACTION oDlg:End()
@154,125 BTNBMP LEFT PROMPT " Borrar" SIZE 50,19 OF oDlg FILENAME "BORRAR1.BMP" //ACTION BorraU(oLbx )
@154,184 BTNBMP LEFT PROMPT " Buscar" SIZE 50,19 OF oDlg FILENAME "FIND.BMP" //ACTION BuscaU(oLbx,3,"Color")
@154,242 BTNBMP LEFT PROMPT " Salir" SIZE 50,19 OF oDlg FILENAME "SALIR3.BMP" ACTION oDlg:End()

ACTIVATE DIALOG oDlg CENTERED

CLOSE DATABASES

RETURN NIL

y el error que me manda es el siguiente :

Application

Path and name: C:\sistemas\RRHH_32\personal.exe (32 bits)
Size: 1,460,224 bytes
Time from start: 0 hours 0 mins 6 secs
Error occurred at: 08/05/2007, 17:24:01
Error description: Error BASE/1002 Alias does not exist: MAESTRO

Stack Calls

Called from: personal.prg => (b)BROWRST(547)
Called from: WBROWSE.PRG => TWBROWSE:DEFAULT(0)
Called from: WBROWSE.PRG => (b)TWBROWSE:TWBROWSE(0)
Called from: WBROWSE.PRG => TWBROWSE:INITIATE(0)
Called from: => __OBJSENDMSG(0)
Called from: HARBOUR.PRG => OSEND(0)
Called from: HARBOUR.PRG => ASEND(0)
Called from: DIALOG.PRG => TDIALOG:INITIATE(0)
Called from: DIALOG.PRG => TDIALOG:HANDLEEVENT(0)
Called from: => DIALOGBOXINDIRECT(0)
Called from: DIALOG.PRG => TDIALOG:ACTIVATE(0)
Called from: => BROWRST(555)
Called from: personal.prg => (b)CREAMENU(121)
Called from: MENU.PRG => TMENU:COMMAND(0)
Called from: WINDOW.PRG => TWINDOW:COMMAND(0)
Called from: WINDOW.PRG => TWINDOW:HANDLEEVENT(0)
Called from: WINDOW.PRG => _FWH(0)
Called from: => WINRUN(0)
Called from: WINDOW.PRG => TWINDOW:ACTIVATE(0)
Called from: personal.prg => PRINCIPAL(74)

System

CPU type: Intel(R) Celeron(R) M processor 1.60GHz 1600 Mhz
Hardware memory: 447 megs

Free System resources: 90 %
GDI resources: 90 %
User resources: 90 %

Compiler version: xHarbour build 0.99.71 Intl. (SimpLex)
Windows version: 5.1, Build 2600 Service Pack 2

Agradezco como siempre la ayuda de todos los amigos del foro

Ramon Paredes
Managua, Nicaragua

... Desde la Tierra de lagos y Volcanes......
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Ayuda coa adordd y Mysql (Error de alias)
Posted: Tue May 08, 2007 11:55 PM

Te falta especificar la claúsula ALIAS:

USE "Personal1" VIA "ADORDD" TABLE "MAESTRO" MYSQL ;
FROM "localhost" USER "root" PASSWORD "1234" ALIAS "MAESTRO"

regards, saludos

Antonio Linares
www.fivetechsoft.com

Continue the discussion