Re: Diff type of data fetching

sorry, i was try to ask whats the different between fetching data using
SQLStringConnect and ADO.


"Anders Altberg" <anders.altberg> wrote in message
news:e$6m9doeHHA.4916@xxxxxxxxxxxxxxxxxxxxxxx
VFP's SQLStringConnect function can only specify a ODBC driver in the
DRIVER parameter.
If you want to use ADODB you use the ConnectionString property of the
Connection class.
This string can refer to OLEDB drivers or ODBC drivers. You then create a
RecordSet object, sometimes by way of a Command object. VFP has the
CursorAdapter class for turning a RecordSet into a cursor before you can
work normally with a query result in VFP.
That's more work than getting a cursor in step 1 as we do with queries
through ODBC.
-Anders

"Den" <test@xxxxxxxxxx> wrote in message
news:Op4swhneHHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
what's the different of fetching data using SQLStringConnect() with ADO ?
what the pros and cons ? and speed different.?

Thanks!>




.

Relevant Pages

  • Re: Diff type of data fetching
    ... This string can refer to OLEDB drivers or ODBC drivers. ... a RecordSet object, sometimes by way of a Command object. ... CursorAdapter class for turning a RecordSet into a cursor before you can ... work normally with a query result in VFP. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Odd mouse cursor behavior in all games.
    ... I have a NVIDIA GO7300 and basically the same games described ... I have latest drivers and even tried some "tweaked" drivers from a ... World of Warcraft, and Black and White 2), the mouse cursor flashes rapidly. ... One thing I've found is if I start up a game again when this happens, ...
    (microsoft.public.windowsxp.general)
  • Re: Cursor Speed
    ... I'll see if I can try some different drivers and see if that helps. ... Maybe my reinstall was flawed somewhat. ... who should draw the cursor - when and where. ... "check for malware" recommended for these situations. ...
    (microsoft.public.windowsxp.basics)
  • Re: cross-hair cursors in PSpice4 and VIA 4in1 hardware drivers
    ... > Recent system hardware repair involved installing a new ... > The same hardware displays this cursor running the same rev of LTSpice ... ECS website 'latest' drivers for this MB do ...
    (sci.electronics.cad)
  • Re: cross-hair cursors in PSpice4 and VIA 4in1 hardware drivers
    ... >This is problem is due to the video card driver. ... The VIA 4in1 drivers are intended to handle the VIA KM400 Northbridge, ... >> The same hardware displays this cursor running the same rev of LTSpice ... >> Your cursor will become invisible only inside the schematic window. ...
    (sci.electronics.cad)