Please read the attached file!
++++ Attachment: No Virus found
++++ Norton AntiVirus - www.symantec.de
[Non-text portions of this message have been removed]
I want to load from CSV but the thing is I may not know how many
fields there is. I can't seem to figure out how to do this. Seems I
must have field definitions but how am I supposed to put those if I
don't know what the fields are.
Thanks.
Hi,
Visit our site at www.components4developers.com
In the menu select Products/kbmMemTable/Download
In the left side menu, select the appropriate version (We only provide 3.14
in the 3.xx range, not 3.00f).
best regards
Kim Madsen
kbm@...
www.components4developers.com
The best components for the best developers
kbmMW - kbmMemTable - kbmWABD - kbmX10
> -----Oprindelig meddelelse-----
> Fra: memtable@yahoogroups.com [mailto:memtable@yahoogroups.com]P vegne
> af oh8ns
> Sendt: 14. januar 2006 21:45
> Til: memtable@yahoogroups.com
> Emne: [memtable] kbmMemTable 3.00?
>
>
> Hi,
>
> I have used ver 3.00f 1 Beta...
> I'm looking for files but not found... ?
>
> Greetings Erkki
>
>
>
>
>
>
>
>
> Latest release of kbmMemTable can be found at
> www.components4developers.com
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
********************************************************************************\
******
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender by return
e-mail and delete it from your system. Thank you.
Any opinions expressed are that of the individual and not necessarily that
of Components4Developers.
Although Components4Developers believe this email and any attachments are
free of any virus or defect that may affect a computer, it is the responsibility
of the recipient to ensure that this is so, and Components4Developers accepts
no responsibility for any loss, contamination or damage arising in any way
from its use.
********************************************************************************\
******
Setup: D7, MemTable 5.5, dbExpress, Oracle.
I have a table with about 10,000 records reasonably column density.
It takes just under a second to do this
SQLQueryPlus1.Open;
while not(SQLQueryPlus1.Eof) do SQLQueryPlus1.Next;
basically retrieving all records to the client.
Then a do this
kbmMemTable1.EmptyTable;
kbmMemTable1.LoadFromDataSet(SQLQueryPlus1,
[mtcpoStructure,mtcpoProperties]);
This takes about 4.5 seconds. Does this seem right (slow)?
Hi,
Transactions can still be used with 1SinceCheckpoint. It only means you cant
have nested transactions.
Just ensure that you have enabled versioning.
best regards
Kim Madsen
kbm@...
www.components4developers.com
The best components for the best developers
kbmMW - kbmMemTable - kbmWABD - kbmX10
> -----Oprindelig meddelelse-----
> Fra: memtable@yahoogroups.com [mailto:memtable@yahoogroups.com]P vegne
> af thalassainformatique
> Sendt: 6. december 2005 16:32
> Til: memtable@yahoogroups.com
> Emne: [memtable] TkbmMemTable vs TClientDataset
>
>
> Bonjour,
>
> I was used to work with TClientDataset and I would like to move to
> kbmMemTable.
> I've subclassed kbmMemTable to make it as close as possible to
> TClientDataset.
> No problem with Fields, Indexes, Filter, Locate but how to write an
> efficient CancelUpdates. I can't use transactions as I set
> VersioningMode to mtvm1SinceCheckPoint.
>
> Is there a way to cancel all the modifications since last CheckPoint ?
>
> TIA
>
> Olivier
>
>
>
>
>
>
>
>
>
> Latest release of kbmMemTable can be found at
> www.components4developers.com
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
********************************************************************************\
******
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender by return
e-mail and delete it from your system. Thank you.
Any opinions expressed are that of the individual and not necessarily that
of Components4Developers.
Although Components4Developers believe this email and any attachments are
free of any virus or defect that may affect a computer, it is the responsibility
of the recipient to ensure that this is so, and Components4Developers accepts
no responsibility for any loss, contamination or damage arising in any way
from its use.
********************************************************************************\
******
Bonjour,
I was used to work with TClientDataset and I would like to move to
kbmMemTable.
I've subclassed kbmMemTable to make it as close as possible to
TClientDataset.
No problem with Fields, Indexes, Filter, Locate but how to write an
efficient CancelUpdates. I can't use transactions as I set
VersioningMode to mtvm1SinceCheckPoint.
Is there a way to cancel all the modifications since last CheckPoint ?
TIA
Olivier
Hello,
You must set at True the option of the Memtable :
SortOptions->mtcoIgnoreLocale
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Tlchargez cette version sur http://fr.messenger.yahoo.com
I have this problem FREQUENTLY, and it really drives me
nutz. .FindKey will not find a record, even though it is there. In
this particular case, I have a single index with a single field,
InvNo. The value that the .FindKey is searching for IS THERE,
however, .FindKey returns False. I do not have Primary or Unique set
as options on the index. Many times when this happens, I can use
Locate instead, and that works, but recently, Locate wasn't working
properly either, it would find a record, but it wasn't the first one.
Even after doing a .First, it would find the 3rd record. Anyway,
that's not my problem now. Why would the FindKey fail, even though
the record IS THERE???
Currently I'm using the 5.0 beta, but I have this problem with version
3.3 too.
Thanks,
Jesse
In case you are interested, this is how I did it.
for i := 0 to mtFrom.IndexDefs.Count-1 do
begin
idxdef := mtFrom.IndexDefs.Items[i];
mtTo.AddIndex(idxdef.Name, idxdef.FieldExpression, idxdef.Options);
end;
It works for me, but I thought there might be a better way.
Adam
Hi Group,
I am using CreateTableAs and LoadFromDataset to duplicate a memory
table, however I would also like to copy the indexes from the original
to the new table.
I thought it would be a parameter in CreateTableAs but it doesn't
appear to be. I imagine I will have to walk through the indexdefs and
copy the values, but any help is definately appreciated.
Adam
Hello Group,
I have just experienced some strange behaviour on a findkey operation
in v3.05.
I have set my indexfield.
The index is on a integer field
I have a filter active
If mem.FindKey([1]) then
begin
// Do action 1
end
else
begin
// Do action 2
end;
In the visible rows, there is NO fields with value = 1, yet it still
returns true. The record it lands on has an ID of 12.
The following work around achieves the correct behaviour but this
false positive it is concerning.
If ((mem.FindKey([1])) and
(memid.Value = 1)) then
begin
// Do action 1
end
else
begin
// Do action 2
end;
There is one other index on a different field, but I have confirmed in
the debugger that the correct index is set, and the records with 1 are
in fact filtered out.
Any suggestions for what might cause this?
Adam
Adam
Hello,
I will be out of the office from Jun 4-Jun 12 at TechEd. I will have
limited access to the Internet during this time. I will reply as soon as
possible.
Thanks,
Eric Holton
AutomatedQA Corp.
HYPERLINK "HYPERLINK
"http://www.automatedqa.com/"http://www.automatedqa.com/"www.automatedQA.com
Debug! Test! Deliver!
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.4 - Release Date: 6/6/2005
[Non-text portions of this message have been removed]
Hello,
I use Locale ID 1036 (French) and I try to use locate for searching a
String like [L'AMIRAL]. It doesn't find it.
How can I solve this problem ??
Thanks
Hi,
I am using v2.33 on D5 and have a memtable with 4 records (golf scores) like
this:
Name Score Nett_Score Rounds
SMITH, Ian 303 264 3
SMITH, Brad 294 360 3
SMITH, Charles 300 237 3
SMITH, Jim 199 173 2
When I run a TxQuery on these, sorting by Rounds Desc, Nett_Score Asc it
works fine and I get this:
Name Score Nett_Score Rounds
SMITH, Charles 300 237 3
SMITH, Brad 294 360 3
SMITH, Ian 303 264 3
SMITH, Jim 199 173 2
but, when I run the same query:
Select * from memtable Order by Rounds Desc, Score Asc
With Score instead of Nett_Score, I get this:
Name Score Nett_Score Rounds
SMITH, Brad 294 360 3
SMITH, Brad 294 360 3
SMITH, Ian 303 264 3
SMITH, Jim 199 173 2
Brad Smith is repeated twice and Charles is missing ?!?! Both Score and
Nett_Score fields are integer and nothing is happening to the table in
between the queries. I have tried everything I can think of - help please!
thanks,
cj
See the file.
--------------------------------------------
bill.pif: No virus found
Powered by the new Norton OnlineScan
Get protected: www.symantec.com
[Non-text portions of this message have been removed]