Stack Overflow
Stack Overflow

Questions tagged [tadotable]

29 questions
5
votes
6 answers

Loading millions of records into a stringlist can be very slow

how can i load millions of records from tadotable into a stringlist very fast? procedure TForm1.SlowLoadingIntoStringList(StringList: TStringList); begin StringList.Clear; with SourceTable do begin Open; DisableControls; try …
Kamyar Kimiyabeigi
  • 51
  • 1
  • 2
5
votes
1 answer

using locate function on calculated field in delphi

How can we use locate function or a same operation function using a calculated field in delphi Tadotable? something like this SampleAdotable.locate('samplefield',text,[lopartialkey]); where samplefield is a calculated field in SampleAdotable.In…
nader
  • 71
  • 4
3
votes
3 answers

Reversing the Master-Detail connection in Delphi

I have 2 tables which are connected using master-detail connection. I need the connection reversed on creation of Form2 - so the master table becomes the detail table, and the detail table becomes the master table. I tried doing this, and the…
Radiant
  • 47
  • 2
  • 10
3
votes
2 answers

Calculated percentage in Delphi DBGrid

I'm maintaining a Delphi application since a few days. The customer wants to add a percentage column to a DBGrid, now showing a "Quantity" column. Of course the percentage would be the Row quantity / Total Quantity * 100 I cannot modify the…
Stefano Losi
  • 719
  • 7
  • 18
3
votes
1 answer

Call procedure on another form?

I'm sure this has been asked before, but I couldn't seem to find it. I use the code below to display an Image from a MS Access database. However, I would like know how to do the following: -Is it possible to take the procedure below and 'call' it in…
coder123
  • 67
  • 4
  • 10
2
votes
1 answer

TADOTable -- is it OK to use for inserts?

I'm working in an old Delphi 7 project and trying to get my bearings in it. I had heard that TADOTables are bad because they pull down entire tables. However I am looking at one bit of code and I'm wondering if it does the same thing. All it does is…
Earlz
  • 62,085
  • 98
  • 303
  • 499
2
votes
1 answer

TADOTable, Seek and clUseServer how to combine?

Is it possible to use the seek function when the cursor location is set to clUseServer in Delphi's ADOTable? I know that it is possible to use locate function instead but it is a lot slower than the seek function.
Raul
  • 656
  • 5
  • 17
2
votes
1 answer

How can I load column names from an Access table into a variable (I'm not sure which one to use)? I'm using an ADOTable in Delphi7

I'm trying to import the column names from an MS Access Table (named Learners) to some variable (not sure which one to use). The column's names are dates. When btnSave (TButton) is clicked the code should determine if the column with the current…
Armand Maree
  • 488
  • 2
  • 6
  • 21
2
votes
2 answers

AdoDB filter on merged columns

So I have an AdoTable connected to database (mdb) and DataSource using it. This DataSource is used by DBGrid... I tried to filter AdoTable based on user input. There are 3 important columns: name, surname and ID. I came up with something like this…
Radim Nyč
  • 102
  • 7
2
votes
1 answer

How Can I Sort an ADO Table on a Fieldname Containing a Space?

I am using Delphi, but this is a simple and general problem: I'm doing the following: var ArticlesTable: TADOTable; begin ArticlesTable.DisableControls; ArticlesTable.Sort := 'CITY'; ArticlesTable.First; while not ArticlesTable.Eof do…
lkessler
  • 19,819
  • 36
  • 132
  • 203
1
vote
5 answers

Class TADOConnection / TADOTable Not Found

Okay, so my application was working just fine until I decided to clean up the design-time form a bit by creating a DataModule form and moving all database components to it. I'm using Delphi XE2 Update 1 and these components, TADOConnection,…
James L.
  • 9,384
  • 5
  • 38
  • 77
1
vote
1 answer

ADOTable.Locate in Master-Detail Relationship

I have a Master-Detail Relationship between two Tables , I Select a Record in Master Table and its Details shows in Detail Table , next i want to Locate in Detail Table Only in Details about Master Table`s Selected Record but when I use…
Mahmood_N
  • 521
  • 9
  • 20
1
vote
1 answer

Problem with checking ADOTable field values

I'm having yet another problem with Delphi. I wrote a piece of code that should check if a field in a database table equals to 0, and if that is true, changes font color and caption of a certain button. It runs on creation of the main form. However,…
Radiant
  • 47
  • 2
  • 10
1
vote
4 answers

How do you apply a Delphi ADOTable filter to a date data type

in MS Access I am able to filter a date in a query like this: ex. SignUpDate > #31/12/2013# this will make the database only show records where SignUpDate is in 2014 or newer How will I do this in delphi? dmGym.tblMembers.filter := 'SignUpDate >…
RaymondSWalters
  • 189
  • 3
  • 5
  • 12
1
vote
1 answer

Delphi: TAdoTable.Insert not really an Insert?

I have two ADO Tables linked as master/details tables, tblCategory (master) and tblItems (details). Both tables have its own grid, and displayed in the same form. I also have data aware controls (dbedits). Say, currently I'm at: Category=Books, No…
Ethan
  • 21
  • 3
1
2