Article View: pl.comp.lang.vbasic
Article #200Re: Recordset - pytanie
From: Janusz Żukowski
Date: Tue, 25 Nov 1997 10:05
Date: Tue, 25 Nov 1997 10:05
36 lines
1342 bytes
1342 bytes
Jan Piwowarczyk wrote: > > Wlasciwie to mam dwa pytania: > 1. Jak napisac zapytanie Sql, ktore pobiera dane z obiektu typu > Recordset Ad 1. Najpierw musisz stworzyc Workspace i Connection Public work As Workspace Public conn As Connection Set work = CreateWorkspace( i tu parametry ) Set conn = work.OpenConnection( j.w. ) a nastepnie Dim rs As Recordset s = "SELECT * FROM ... " Set rs = con.OpenRecordset(s, dbOpenDynamic) Do wartosci odwolujesz sie przez rs.Fields( index ) A tak prywatnie to polecam RDO ( rdoConnection ) - lepiej obsluzone bledy. > 2. Czy jest gdzies archiwum tej grupy ? Niestety nie wiem. Mam nadzieje, ze to pomoze. Zuk
Technical Details
Message-ID:
<347AA2F8.CC7C6656@mrowisko.mr.mr>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.nask.pl!ict.pwr.wroc.pl!not-for-mailReferences:
<347a9bbf.8756678@145.237.237.70>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.nask.pl!ict.pwr.wroc.pl!not-for-mail From: Janusz Żukowski <zuk@mrowisko.mr.mr> Newsgroups: pl.comp.lang.vbasic Subject: Re: Recordset - pytanie Date: Tue, 25 Nov 1997 11:05:44 +0100 Organization: - Lines: 36 Message-ID: <347AA2F8.CC7C6656@mrowisko.mr.mr> References: <347a9bbf.8756678@145.237.237.70> Reply-To: zuk@winuel.com.pl NNTP-Posting-Host: lin1.winuel.com.pl Mime-Version: 1.0 X-Mailer: Mozilla 4.01 [en] (WinNT; I) X-Priority: 3 (Normal) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit