RE: [Harbour] 2 ask on SQL Server in one time.

2009-09-28 Thread Horodyski Marek (PZUZ)
>-Original Message- >From: Mindaugas Kavaliauskas [mailto:dbto...@dbtopas.lt] >Sent: Monday, September 28, 2009 5:28 PM >To: Harbour Project Main Developer List. >Subject: Re: [Harbour] 2 ask on SQL Server in one time. ... >> This happens only in sqlmix. >>

Re: [Harbour] 2 ask on SQL Server in one time.

2009-09-28 Thread Mindaugas Kavaliauskas
Hi, Sounds like syntax error. Try to execute this query using some ODBC utility, or try to reduce query to find out a supported syntax. Probably no. This is a serious problem with SQLMIX. For example work : dbUseArea( . Browse() dbCloseAll() But when I use my_old_tBrowse_function() in p

RE: [Harbour] 2 ask on SQL Server in one time.

2009-09-28 Thread Horodyski Marek (PZUZ)
>-Original Message- >From: Mindaugas Kavaliauskas [mailto:dbto...@dbtopas.lt] >Sent: Monday, September 28, 2009 3:32 PM >To: Harbour Project Main Developer List. >Subject: Re: [Harbour] 2 ask on SQL Server in one time. > >Hi, > > >> DBUSEAREA( .T.

Re: [Harbour] 2 ask on SQL Server in one time.

2009-09-28 Thread Mindaugas Kavaliauskas
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___