>-----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. >> It's hard to describe, and probably Developers tests with >real sql server are needed. > >It would be very helpful if you can write a self contained sample. I guess I draw erroneous conclusions. App hangs when from ask is one record with structure after HB_VALTOEXP( DBSTRUCT()) : {{"ID_KLIENT", "I", 10, 0}, {"NIP", "C", 20, 0}, {"NIP_FMT", "C", 20, 0}, {"REGON", "C", 20, 0}, {"NAZWA", "C", 300, 0}, {"NAZWA_SUFFIKS", "C", 20, 0}, // null {"ULICA", "C", 200, 0}, {"NR_DOM", "C", 50, 0}, {"NR_LOK", "C", 50, 0}, // null {"MIASTO", "C", 200, 0}, {"KOD_POCZT", "C", 20, 0}, {"TELEFON", "C", 50, 0}, // null {"FAX", "C", 50, 0}, // null {"UWAGI", "C", 500, 0}, // null {"WSK_REJESTRU", "C", 3, 0}, {"ID_SYSTEM_ZRODLOWY","I", 10, 0},// null {"ID_GRUPA", "I", 10, 0}, // null {"ID_PKD", "I", 10, 0}, // null {"ID_ZEWNETRZNY", "I", 10, 0}, {"TELEFON2", "C", 70, 0}, // null {"WOJEWODZTWO", "C", 100, 0}, // null {"POWIAT", "C", 100, 0}, // null {"ZATRUDNIENIE", "C", 50, 0}, // null {"EMAIL", "C", 80, 0}, // null {"WWW", "C", 255, 0}, // null {"BRANZA", "C", 90, 0}, // null {"CENTRALA_ODDZIAL", "C", 1, 0}, // null {"ZRODLO_PROSPEKTU", "C", 1, 0}, // null {"BSA", "I", 3, 0}, {"HURT", "I", 3, 0}, // null {"STAT_PROSPEKTU", "I", 10, 0}} // null And in some fields are null contents. Pprobably, because code : for n := 1 to fcount() ? field( n), fieldget( n) end Work very nice ( NIL is displayed on NULL contents). Select from this table with another "where" I can correctly display with Browse(), even as they are null value.. But the phenomenon gpf with pair tbrowse()/dbCloseAll() is in my einwironment reproducible. Now I focus on how to get around it, because I do not know how to make a small example (self contained), without a sql server. Regards, Marek Horodyski _______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour