Ayuda coa adordd y Mysql (Error de alias)

Post Reply
User avatar
Ramon Paredes
Posts: 215
Joined: Fri Feb 02, 2007 3:38 pm
Location: Managua, Nicaragua

Ayuda coa adordd y Mysql (Error de alias)

Post by Ramon Paredes »

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
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

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
Post Reply