🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.lang.vbasic
Article #200

Re: Recordset - pytanie

#200
From: Janusz Żukowski
Date: Tue, 25 Nov 1997 10:05
36 lines
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-mail
References: <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