Hi,
DBUSEAREA( .T., "SQLMIX", "select * from klient", "KLIENT")
DBUSEAREA( .T., "SQLMIX", "select p.*, nazwa from PRODUKT p, klient k where p.id_klient =
k.id_klient and jed = '1234' and system = 1", "KLI_PROD")
And have error in second query :
oErr:severity_____ 2
oErr:osCode_______ 0
oErr:subsystem()__SDDODBC
oErr:subCode______ 1903
oErr:description__Błąd podczas otwarcia zbioru // Error while opening file
oErr:filename_____
oErr:operation____select p.*, nazwa from PRODUKT p, klient k where p.id_klient
= k.id_klient and jed = '1234' and system = 1
oErr:genCode______ 21
oErr:args_________U
When I open it as one ask, all is ok..
What is the error and what should I change?
RDDSQL error code are defined in hbrddsql.h:
#define ESQLDD_INVALIDQUERY 1903
The only place this eror is generated in SDDODBC is:
if ( ! SQL_SUCCEEDED( SQLExecDirect( hStmt, lpStr, strlen(
pArea->szQuery ) ) ) )
{
HB_TCHAR_FREE( lpStr );
SQLFreeStmt( hStmt, SQL_DROP );
hb_errRT_ODBCDD( EG_OPEN, ESQLDD_INVALIDQUERY, NULL,
pArea->szQuery, 0 );
return HB_FAILURE;
}
Sounds like syntax error. Try to execute this query using some ODBC
utility, or try to reduce query to find out a supported syntax.
Regards,
Mindaugas
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
