Search found 36 matches: aduseserver

Return to advanced search

Re: Error in FW_ArrayAsRecordSet Seek - Please help

... supports "index" property and "seek" method only when the recordset opens a physical table as Serverside Cursor using adUseServer and with adCmdTableDirect option and all other kinds of RecordSets do not support Seek method. (Mostly RecordSets are open with adUseClient) ...
by nageswaragunupudi
Tue Aug 08, 2023 6:47 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error in FW_ArrayAsRecordSet Seek - Please help
Replies: 6
Views: 340

Re: Error from ADO

CursorLocation 1 adUseNone (Obsolete and does not work) 2. adUseServer (Can not navigate and is not useful for us) 3. adUseClient : This is the only choice we have LockType: 1. adLockUnspecified (not to be used for new recordsets) 2. adLockReadOnly : ...
by Horizon
Sat Aug 18, 2018 3:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error from ADO
Replies: 14
Views: 3467

Re: Error from ADO

CursorLocation 1 adUseNone (Obsolete and does not work) 2. adUseServer (Can not navigate and is not useful for us) 3. adUseClient : This is the only choice we have LockType: 1. adLockUnspecified (not to be used for new recordsets) 2. adLockReadOnly : ...
by nageswaragunupudi
Fri Aug 11, 2017 3:31 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error from ADO
Replies: 14
Views: 3467

Re: xBrowse improvement

... requirements are placed on each separate client and not on the server. Server-Side Cursors In ADO, call for a server-side cursor by using the adUseServer CursorLocationEnum. With a server-side cursor, the server manages the result set using resources provided by the server computer. The server-side ...
by Rick Lipkin
Wed Apr 13, 2016 1:06 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse improvement
Replies: 2
Views: 589

Re: bug xBrowse ADO

This error can be expected in two cases. 1) If the recordset is opened with adUseServer. 2) Recordset is closed in WHEN clause and there are still some buttons or controls that keep referring to the recordset. Advice: a) If the browse is on MDICHILD window, close ...
by nageswaragunupudi
Mon Jul 06, 2015 11:51 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: bug xBrowse ADO
Replies: 4
Views: 866

Re: ADO RDD xHarbour

... when the provider supports "scrollable server-side cursor", then adCmdTableDirect may be used after setting the cursor location to adUseServer and CursorType as adDynamic. In such cases the provider might even support adSeek In this case we need to adopt workarounds for recordcount()
by nageswaragunupudi
Wed Jul 01, 2015 4:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: How to combine use between ADO and ADORDD?

... is slow. 3. RecSize is 1,1 K. 4. Yes, Browse is no problem. Dutch, Thats a problem with ADO and SQL way of working. If you have a CursorLocaton := adUseServer it will be fast opening but then navigating it it will be quite slow. The best way is to create historic files to keep working tables small ...
by dutch
Mon Jun 29, 2015 10:30 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to combine use between ADO and ADORDD?
Replies: 8
Views: 1591

Re: How to combine use between ADO and ADORDD?

Dutch, Thats a problem with ADO and SQL way of working. If you have a CursorLocaton := adUseServer it will be fast opening but then navigating it it will be quite slow. The best way is to create historic files to keep working tables small but this will break compatibility ...
by AHF
Mon Jun 29, 2015 10:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to combine use between ADO and ADORDD?
Replies: 8
Views: 1591

Re: ADO SQL VISIBILITY

Severside queries (RecordSet with adUseServer) are *mostly* unidirectional and single pass, used mainly for fast single pass processing. Even this is not generally desirable and may result in wrong results because we lose the benefit of snap-shot ...
by nageswaragunupudi
Fri Jun 26, 2015 7:26 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO SQL VISIBILITY
Replies: 17
Views: 3473

Re: ADO SQL VISIBILITY

You can use: CursorLocation := adUseServer CursorType := adOpenDynamic Pros: Selects without where clause much faster because you dont load immediately all records You'll see new adds deletes changes by others. You will always have the last ...
by AHF
Wed Jun 24, 2015 5:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO SQL VISIBILITY
Replies: 17
Views: 3473

Re: ADO RDD xHarbour

... WHERE condition only to read the records you need might be only a few hundred but this will break code compatibility. Other alternative try to use adUseServer together with CacheSize and the property Maximum Opens Rows. CacheSize := 100 Maximum Opens Rows := 170 You will need to change the setup ...
by AHF
Thu Jun 18, 2015 8:46 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: ADO RDD xHarbour

Mr Rao, Lucas,

How can I use adUseServer cursor with MySql?

I can only work with adUseClient.
by AHF
Wed May 06, 2015 5:09 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: ADO RDD xHarbour

... it runs ok here. I ve found out that the problem is with cursorlocation because with ACCESS aduseclient you can not :update() so I've change it to adUseServer but with adOpenKeyset because with adOpenDynamic ACCESS also does not work correctly. In my tests with MYSql everything its ok. Also since ...
by AHF
Wed May 06, 2015 3:17 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: ADO RDD xHarbour

... field or a table to do it but we still didn't find how. Do you have any idea? Also using adUseclient seems not to work ok with our browses. adUseServer ok. But adUseServer doesnt work with Browse() in ACCESS. Dont know why.
by AHF
Wed Apr 29, 2015 8:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: ADO RDD xHarbour

Antonio, Enrico, Lucas, Do you have any experience use SELECT * FROM cTable with adUseServer and adUserClient ? Does ADO load all rows? Is there a way to avoid that? CacheSize? MaxRecords? I have now a new adordd version imitating 100% dbf behaviour, however Im ...
by AHF
Fri Apr 17, 2015 3:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927
Next

Return to advanced search