Prev: Date converting
Next: bBrowser and combobox
From: E®!k /!sser on 21 Apr 2008 02:30 And keep in mind not all options are supported by the OleDB provider and/or RDBMS. There is a nice sample that shows this in your VO2ADO smaple direcotory (RecordSet 6 Cursor.AEF) Erik "Geoff Schaller" <geoffx(a)softwareobjectivesx.com.au> schreef in bericht news:480c3188$1(a)dnews.tpgi.com.au... > Sure... and cursors can be your 'curse' <g>. > > Mostly, for VO style uses (particularly browsers), client side static > cursors are the go. But forward only, server side read only cursors can be > very fast for lookups. The degree of locking can have a huge impact on > performance. It all matters so it is all quite relevant. > > Geoff > > > > "Rob van Erk" <erk.v(a)hotmail.com> wrote in message > news:800f9edd-a459-449c-92fb-348867cc88fa(a)b1g2000hsg.googlegroups.com: > >> Geoff, >> >> Will have a look at BOL. Some months ago I purchased two dutch SQL >> books and basically I already made a lot of progression understanding >> the SQL logic (including DBMS). My app runs fine with information >> gathered from these books but in practise you will always find new >> challenges like the "cursor" thing. Will study further but as >> programmer you always like to practise/play in your >> applications too... >> >> Rob >
From: Geoff Schaller on 21 Apr 2008 03:43 Yes. Very true. "ER!k \/!sser" <nospam(a)nospam.com> wrote in message news:672qkiF2n1ka0U1(a)mid.individual.net: > And keep in mind not all options are supported by the OleDB provider and/or > RDBMS. > There is a nice sample that shows this in your VO2ADO smaple direcotory > (RecordSet 6 Cursor.AEF) > > Erik
From: jorgeaccinelli on 21 Apr 2008 22:22 On 21 abr, 04:43, "Geoff Schaller" <geo...(a)softwareobjectivesx.com.au> wrote: > Yes. Very true. > > "ER!k \/!sser" <nos...(a)nospam.com> wrote in message > > news:672qkiF2n1ka0U1(a)mid.individual.net: > > > > > And keep in mind not all options are supported by the OleDB provider and/or > > RDBMS. > > There is a nice sample that shows this in your VO2ADO smaple direcotory > > (RecordSet 6 Cursor.AEF) > > > Erik- Ocultar texto de la cita - > > - Mostrar texto de la cita - Hello I am learning Sql and I note that the technique "cursor static client side " plus customer processes (Store procedures, update insert, delete) you can do your work very well knowing very little about cursors (I found on the Web a lot about different kinds of cursores but really no need) I repeat, with the technical, very good for me, "cursor static client side " Jorge Accinelli
From: Geoff Schaller on 22 Apr 2008 04:05
Jorge, This is very true. You could easily live with client side cursors always. However, if you need to squeeze performance out or you need locking or dynamic cursors then you need learn a little about them first. They can be of use in special circumstances. Geoff "jorgeaccinelli(a)dextrasistemas.com.ar" <jorgeaccinelli(a)dextrasistemas.com.ar> wrote in message news:66010c90-e4c7-4f44-a362-027173ac7c5e(a)a70g2000hsh.googlegroups.com: > On 21 abr, 04:43, "Geoff Schaller" <geo...(a)softwareobjectivesx.com.au> > wrote: > > Yes. Very true. > > > > "ER!k \/!sser" <nos...(a)nospam.com> wrote in message > > > > news:672qkiF2n1ka0U1(a)mid.individual.net: > > > > > > > > > And keep in mind not all options are supported by the OleDB provider and/or > > > RDBMS. > > > There is a nice sample that shows this in your VO2ADO smaple direcotory > > > (RecordSet 6 Cursor.AEF) > > > > > Erik- Ocultar texto de la cita - > > > > - Mostrar texto de la cita - > > > Hello > I am learning Sql and I note that the technique > "cursor static client side " plus customer processes > (Store procedures, update > insert, delete) you can do your work very well > knowing very little about cursors (I found on the Web > a lot about different kinds of cursores but really > no need) I repeat, with the technical, very good for me, > "cursor static client side " > > Jorge Accinelli |