>-----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., "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") ...
>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 place of Browse(), in dbCloseAll()
have I GPF, and in hb_out.log I see :
----------------------------
Application Internal Error - C:\NOWEPROD\EXE\homar.exe
Terminated at: 2009.09.28 11:16:57
Nienaprawialny bŞŇd nr 6005: Exception error:
Exception Code:C0000005
Exception Address:00466D23
EAX:6E15000C EBX:00000000 ECX:00000000 EDX:5EA8000C
ESI:015FBE6C EDI:00000000 EBP:015FBE6C
CS:EIP:001B:00466D23 SS:ESP:0023:0022F600
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010246
CS:EIP: F6 04 18 02 74 EB 8B 04 9A 43 89 04 24 E8 5B F4
SS:ESP: 015FBE6C 00000000 7E3A396F 015FBE6C 00000002 015FBE6C 00000002
0046233D 015FBE6C 01367314 00000001 0040C2B3 0022F704 0082FACC 0082FACC 0067083E
C stack:
EIP: EBP: Frame: OldEBP, RetAddr, Params...
Modules:
0x00400000 0x00440000 C:\NOWEPROD\EXE\homar.exe
0x7C900000 0x000B4000 C:\WINDOWS\system32\ntdll.dll
0x7C800000 0x000FD000 C:\WINDOWS\system32\kernel32.dll
0x77DC0000 0x000AC000 C:\WINDOWS\system32\ADVAPI32.DLL
0x77E70000 0x00092000 C:\WINDOWS\system32\RPCRT4.dll
0x77FE0000 0x00011000 C:\WINDOWS\system32\Secur32.dll
0x5D520000 0x0009A000 C:\WINDOWS\system32\COMCTL32.DLL
0x77F10000 0x00049000 C:\WINDOWS\system32\GDI32.dll
0x7E360000 0x00091000 C:\WINDOWS\system32\USER32.dll
0x77C00000 0x00058000 C:\WINDOWS\system32\msvcrt.dll
0x74600000 0x0003D000 C:\WINDOWS\system32\ODBC32.dll
0x76380000 0x00049000 C:\WINDOWS\system32\comdlg32.dll
0x7C9C0000 0x0081E000 C:\WINDOWS\system32\SHELL32.dll
0x77F60000 0x00076000 C:\WINDOWS\system32\SHLWAPI.dll
0x774D0000 0x0013D000 C:\WINDOWS\system32\OLE32.dll
0x77110000 0x0008B000 C:\WINDOWS\system32\OLEAUT32.DLL
0x72F90000 0x00026000 C:\WINDOWS\system32\WINSPOOL.DRV
0x76360000 0x0001D000 C:\WINDOWS\system32\IMM32.DLL
0x773C0000 0x00103000
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83\comctl32.dll
0x1F840000 0x00018000 C:\WINDOWS\system32\odbcint.dll
0x76350000 0x00005000 C:\WINDOWS\system32\msimg32.dll
0x5B1D0000 0x00038000 C:\WINDOWS\system32\uxtheme.dll
0x10000000 0x00006000 C:\DOCUME~1\MHorodys\USTAWI~1\Temp\IadHide5.dll
0x746D0000 0x0004C000 C:\WINDOWS\system32\MSCTF.dll
0x75180000 0x0002E000 C:\WINDOWS\system32\msctfime.ime
0x014C0000 0x00008000 C:\Program Files\Gadu-Gadu\ggwhook.dll
0x4E4A0000 0x0006C000 C:\WINDOWS\System32\SQLSRV32.dll
0x6FF40000 0x00055000 C:\WINDOWS\System32\NETAPI32.dll
0x5C620000 0x0002D000 C:\WINDOWS\System32\SQLUNIRL.dll
0x77BF0000 0x00008000 C:\WINDOWS\system32\VERSION.dll
0x75910000 0x00008000 C:\WINDOWS\system32\NDDEAPI.DLL
0x1FA30000 0x00017000 C:\WINDOWS\System32\sqlsrv32.rll
0x5E3E0000 0x0001B000 C:\WINDOWS\system32\odbccp32.dll
0x6DA30000 0x0001B000 C:\WINDOWS\system32\DBNETLIB.DLL
0x71A70000 0x0000A000 C:\WINDOWS\system32\WSOCK32.dll
0x71A50000 0x00017000 C:\WINDOWS\system32\WS2_32.dll
0x71A40000 0x00008000 C:\WINDOWS\system32\WS2HELP.dll
0x71F30000 0x00004000 C:\WINDOWS\system32\security.dll
0x77C60000 0x00025000 C:\WINDOWS\system32\msv1_0.dll
0x76770000 0x0000C000 C:\WINDOWS\system32\cryptdll.dll
0x76D50000 0x00019000 C:\WINDOWS\system32\iphlpapi.dll
0x76780000 0x00013000 C:\WINDOWS\system32\ntdsapi.dll
0x76F10000 0x00027000 C:\WINDOWS\system32\DNSAPI.dll
0x76F50000 0x0002D000 C:\WINDOWS\system32\WLDAP32.dll
0x77A70000 0x00096000 C:\WINDOWS\system32\crypt32.dll
0x77B10000 0x00012000 C:\WINDOWS\system32\MSASN1.dll
0x55600000 0x0001D000 C:\Program Files\Microsoft Firewall Client\wspwsp.dll
0x719F0000 0x00040000 C:\WINDOWS\system32\mswsock.dll
0x66780000 0x00058000 C:\WINDOWS\system32\hnetcfg.dll
0x71A30000 0x00008000 C:\WINDOWS\System32\wshtcpip.dll
0x76FA0000 0x00008000 C:\WINDOWS\System32\winrnr.dll
0x66210000 0x00009000 C:\WINDOWS\system32\netware\NWWS2NDS.DLL
0x50D50000 0x00047000 C:\WINDOWS\system32\NETWIN32.DLL
0x50D00000 0x00015000 C:\WINDOWS\system32\CLNWIN32.DLL
0x50DF0000 0x00020000 C:\WINDOWS\system32\LOCWIN32.DLL
0x50DB0000 0x0002B000 C:\WINDOWS\system32\NCPWIN32.dll
0x66220000 0x0000C000 C:\WINDOWS\system32\netware\NWWS2SLP.DLL
0x1C000000 0x00007000 C:\WINDOWS\system32\NWSRVLOC.dll
0x16080000 0x00025000 C:\Program Files\Bonjour\mdnsNSP.dll
0x76FB0000 0x00006000 C:\WINDOWS\system32\rasadhlp.dll
0x767D0000 0x00028000 C:\WINDOWS\system32\schannel.dll
0x769A0000 0x000B5000 C:\WINDOWS\system32\USERENV.dll
0x68000000 0x00036000 C:\WINDOWS\system32\rsaenh.dll
0x68100000 0x00026000 C:\WINDOWS\system32\dssenh.dll
Called from DBCLOSEALL(0)
Called from (b)KOMPILATOR(0) in KOMPILAT.PRG
Called from BOSS(0) in BOSS.PRG
Called from (b)KOMPILATOR(0) in KOMPILAT.PRG
Called from BOSS(0) in BOSS.PRG
Called from KODKLAW(0) in KODKLAW.PRG
Called from OPCJA(0) in OPCJA.PRG
Called from (b)KOMPILATOR(0) in KOMPILAT.PRG
Called from BOSS(0) in BOSS.PRG
Called from MAIN(244) in homar.prg
------------------------------------------------------------------------
And what on screen can you see in atachment Schowek01.jpg.
Another example :
Work :
dbUseArea( ......, "Alias_Open")
Browse()
dbCloseAll()
And in syntax :
dbUseArea( ....., "Alias_Open")
Alias_Open->( Browse()) // here app hangs :(
dbCloseAll()
This happens only in sqlmix.
It's hard to describe, and probably Developers tests with real sql server are
needed.
Regards,
Marek Horodyski
<<attachment: Schowek01.jpg>>
_______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
