Mindaugas, I try open 2 selects on MSSQL : 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? Regards, Marek Horodyski _______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour