hi thereim using an old paradox file, and in a win98
SE system i get the aforementieoned error, whenever i
try to edit a record, this doesnt happen in either NT
nor 2k. im using ADO 2.5..
any comments are welcome
moises lopez
__
Do You Yahoo!?
Nirav, could you please turn off your receipt notification? I'm sure you
don't need to know when everyone on the list receives your messages.
--
Corey Murtagh
The Electric Monk
Quidquid latine dictum sit, altum viditur!
On 15 Jul 2001, at 23:26, Corey Murtagh wrote:
Nirav, could you please turn off your receipt notification? I'm sure
you don't need to know when everyone on the list receives your
messages.
Indeed. I've actually managed to get a bounce notification or two off
the receipt messages - caused a
Hi Corey and everyone,
I most definitely agree. For every mail I send to the group, I get
10 messages back which is very irritating. But I use only one email
client for both my formal and informal communication. And since I
do a lot of client interaction, it's neccessary that I enable
Hi all
I am having a small problem with the following bit of code in D4 and it is
still there in D6 but has created another problem, but this could be a small
D6 bug.
procedure TForm1.Button1Click(Sender: TObject)
var Buffer: String;
name : String[10];
BuffSize : DWORD;
begin
Neven wrote:
To be portable from D6 to Kylix you'd have to use the clx component
set - ie things like ttreeview and tdatetimepicker at this point don't
exist!
Indeed. And some others you'd expect to be there too (e.g.
TDriveComboBox, TDirectoryListBox, TFileListBox etc.) aren't there
Donovan,
If the
range of ID's are not too sparse then an array would be a very direct way of
looking them up.
Another way would be a linked list of records or a 2 dimensional
arrayholding ID and Code, and pre-sort the list by ID. then look it up
with a binary search or B-Tree or similar.
Hi
Donovan
I
assume you are trying to normalise out common data.
Question 1
The
simplest way is as a TStringList if the Player IDs are not contiguous - thsi
handles non-existant IDs and a lot of hastles. If the IDs are a contiguous
list and will always exist you can use an array of
Hi
Anyone know if its possible to get integers to come up in hexadecimal when
looking at variables using the tooltip evaluation feature while debugging ?
Paul Lowman
Lowman Consulting Ltd.
Embedded Systems Software
[EMAIL PROTECTED]
Are you doing batch updates? ie Lock type ltBatchOptimistic. Else if it's a
direct update maybe your SQL is not returning a live result set (due to
conditions you put on it). You can check this with the Canmodify method
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Hello All,
I have a form with my component on it. The component uses Indy's IdTCPClient
and runs series of transactions in threads (not TIdThread but TThread). For
testing purposes I need to be able to see the results of communication
between my client and a TCP/IP server. When I run the
VCL components should only be manipulated from the main thread context.
TThread.Synchronize() provides this service for thread methods.
From your thread, call Synchronize(DisplayResponse) rather than
DisplayResponse on its own.
Paul.
At 11:31 16/07/01 , you wrote:
Hello All,
I have a form
Paul Spain wrote:
VCL components should only be manipulated from the main
thread context.
TThread.Synchronize() provides this service for thread methods.
From your thread, call Synchronize(DisplayResponse) rather than
DisplayResponse on its own.
Thank you Paul.
Yes, Synchronize is good
Sergei
I'm not sure, but I think the problem is that
Lines.Add function works by sending a message
to the memo control and since you're in a critical
section that message won't get read until you go
noncritical.
One way around this is to create your own user
message (to pass the line to add)
You can have a uses clause in the Interface and implementation section of
the code.
So:
Form
Interface
Uses Component
...
Implementation
...
end.
Component
Interface
...
Implementation
Uses Form
...
end.
-Original Message-
From: Sergei Stenkov [mailto:[EMAIL
Thank you Nello, David I will definetely look at your suggestions.
In the meanwhile I think I found a quick and dirty solution (keeping in mind
that I only need this functionality to test the component and will remove it
later).
For that I have a global slResp: TStringList (gl... - yes, I know
hi..
usually I'd design components slightly differently. the example below
means the thread has no dependencies on the form (proper encapsulation
etc).. also needs no globals, critical sections, timers, circular
'uses' clauses...
something like this (delphi pseudocode):
TmyStringEvent =
I have application that uses single MASSIVE table (100 million records and
growing). Records get added to it in lots of few hudred thousand to 2-3 million at a
time. Needless to say its a problematic beast. Currently in Oracle which is struggling
with index re-enabling after bulk load. Interbase
Nothing is going to cope very well with that ...
It's sounds rather specialised - can you do it with disabling the indexes?
Sounds like you really need a different design to beat the problem, it's
either that or buy a very fast unix box ...
What speed trade offs can you accept??
eg Slow
It's sounds rather specialised - can you do it with disabling the indexes?
With Sqlldr - I disable (rather than drop) index, load, than reenable. This is
much faster than recreating the indices from scratch. (3 hours on fast unix).
However, running into an Oracle bug with this at moment.
Is the index and table useage suitable for any sort of partition scheme that
would allow the data to be broken up into multiple tables with the same
structure i.e. data buckets?
This would involve quite a bit more admin when adding and retrieving data,
but may delay the onset of the symptoms you
Has anyone worked with file lists in the millions? I'm having trouble
building an on-screen display of files once the number gets above 20K or so.
The TListView handles the numbers, but takes ages (15 mins per 100,000
files, getting slower as more files are added).
The TListBox is fast but
Phil
Have you considered bulk loading the new data into a temp table and then
merging it into the main database - overall the load would be slower
(indices being
updated constantly) but the database would be continually available (you
could use
a server side process to merge)
Neven
-
phil,
i'd suggest looking at partitioned tables. using this you can create
indexes that are local to each partition.
eg, you may partition a table based on BatchId (?), doing an
'alter table add partition '
for each import.
in theory (hehe) this should let you create a new partition, disable
So how long does an insert take if done on a blank/new table with the same
structure??
Where am I heading ...
2 Possible solutions - variations on a theme.
A. Insert into a logging table, then from this do a normal insert into the
main table without dropping indexes etc. Change all your queries
Earlier today I posted the following code which was creating an error for a
string filter and the TTable filter property.
procedure TForm1.Button1Click(Sender: TObject)
var Buffer: String;
name : String[10];
BuffSize : DWORD;
begin
Buffsize := 128;
SetLength(Buffer,
Heh, I wish it were that easy :-)
My app iterates through a list of files and generates MD5 checksums for
them. Some of my users wish to checksum entire HDDs which contain (I am
told) millions of files. Asside from simply displaying a progress (No reason
I coudn't except vanity) there's no way
I use a memo to show what is going on a server app. It's a standard TMemo
which only holds so much data - when it gets full, it deletes lines from
the top before appending to the bottom. Is that an option?
Also, I once created a grid that worked off an internal array. The
TStringGrid never
Hi Steve,
Depending on the amount of data you need to export into Excel you could use
different methods ( you could go cell by cell or you could make use of
Excel's methods that import text directly into Excel).
I've spent many more hours on tearing my hair too before I got it going. One
way to
Thanks Mark, I'll give that a go.
Luke Pascoe Delphi Programmer
enSynergy Consulting LTD
[EMAIL PROTECTED] +64-9-3551593 fax +64-9-3551590
Level 4, 10-12 Federal St, Auckland, New Zealand
You need this page:
http://www.djpate.freeserve.co.uk/AutoExcl.htm
which gives the following
(and stop calling Excel automation easy ;)
Assuming a _Worksheet variable, WS:
WS := Excel.ActiveSheet as _Worksheet;
WS.Range['A1', 'A1'].Value := 'The meaning of life, the universe, and
31 matches
Mail list logo
