Stack Overflow
Stack Overflow

Questions tagged [tadotable]

29 questions
1
vote
1 answer

Similar search in integer field by filter property

I have a ADODataSet where the "Filtered" property is set to True (Filtered:= True;) When I apply the filter: [No] like '2%' an error "Filter can't be opened" pops up. [No] is a field in the ADODataSet of integer type. When I apply a similiar…
Pejman Nikram
  • 570
  • 2
  • 11
  • 26
0
votes
1 answer

Is there any way to tell if the TADOTable I am looking for is in the database (MS Access)?

I use C++ Builder (Delphi 10.2 and C++Builder 10.2 Update 2) and I need a method that, in case there is no particular table, creates it using TADO objects (ADODB)? I mean TADOQuery, TADOTable, TADOConnection, etc. How can I do this? I tried looking…
breakou7z
  • 3
  • 3
0
votes
1 answer

how to connect dbgrid with adoquery with paramaters

I'm trying to use Adoquery with parameter (start day and end day ) in delphi 7 but the problem is when i click button filter (with suppose to filter the dbgrid using sdateedit1.date and sdateedit2.date) i got an empty rows , Please help me I try…
khichaya
  • 1
0
votes
2 answers

Apply multiple filters from multiple comboboxes

I have an adotable and i want to apply multiple filter from multiple coboboxes, each combobox applies a filter to that table. My problem is whenever i choose an item from combobox1 for example it applies its filter but when i choose another item…
Sal chocoeyes
  • 9
  • 1
0
votes
0 answers

Filtering ADOTable error - "could not convert type Null to type OleStr"

I am trying to filter an ADOTable for records with a field 'OwnerName' value matches the one in a edit on my GUI component. When entering a name that does not exist, i get the above mentioned error. When there are no names in the database that match…
Romans
  • 469
  • 1
  • 4
  • 17
0
votes
1 answer

How to refresh data in StringGrid when sorting DB using ADOTable.Sort

I have a TStringGrid in a Firemonkey app for Windows which I have used LiveBindings to connect to a DataSource. The DataSource is linked to an ADOTable. When I use ADOTable.sort the data in the Grid seems to only sort the first row and not the…
Robert Henning
  • 43
  • 5
0
votes
1 answer

Connecting to Excel 2016 with ADOConnection

I would like to parse a Excel 2016 (xlsx) file from RAD Studio in Delphi language using TADOConnection. I found a similar topic for Excel 2007 (xls) but it seems that it's different in my case. I'm using the following provider : Microsoft OLE DB…
VirussInside
  • 187
  • 17
0
votes
2 answers

insert to a different table onNewRecord

got an ADOQuery that has OnNewRecord event. on the procedure i try to add data automaticaly to another table. the data is a few rows that are needed and handled in clientDataSet in case of cancellation. at the loc OtherAdoQuery.insert; I get error…
none
  • 4,669
  • 14
  • 62
  • 102
0
votes
2 answers

Delphi ComboBox Access violation on combobox

I get Access violation error, but I know the code is correct, so where could be the problem? I'm trying to fill a ComboBox whit data from a local AccessDB. var i : integer; x : string; begin with DataModule3.ADOTable1 do begin if…
Mr.Pengu
  • 107
  • 1
  • 2
  • 10
0
votes
1 answer

ADOtable refresh

I have an ADOTable with 3 columns 'ID', 'Number' and 'Used'. The table contains some pre-generated numbers. When I use a number I just set the 'USED' to 1 and then I filter the table to get only the unused numbers. Now the small problem: say I pull…
Sardukar
  • 247
  • 6
  • 16
0
votes
1 answer

Select field from dbgrid

I have a DBGrid that is linked to DataSource (that is linked to TADOTable). All this runs through a TADOConnection and connects to a MS Access The grid contains various values and I would like to edit it when I click on a specific field. I'm not…
coder123
  • 67
  • 4
  • 10
0
votes
1 answer

DBImage with bitmap?

I am currently trying to read an Image from a MS Access database that has an OLE Object field and contains a valid bitmap (for test purposes, I created a image using MS Paint and saved it in 24bit bmp). I am linking to this via DBGrid. In theory…
coder123
  • 67
  • 4
  • 10
0
votes
1 answer

how to show parent category in delphi 2010?

OK, I'm using Embarcadero Delphi 2010. Currently I'm using an Access database file named flib.mdb within that file, I make a table named MCategory which has 4 (four) columns named: codecategory as Text and Primary Key, parentcategory as Text,…
Galvion
  • 1,353
  • 7
  • 23
  • 35
-1
votes
2 answers

How do I search for values in a DBGrid and use them for an equation?

I recently made a very basic "Client" DBGrid that shows info from an Access database (connected made with an ADOQuery, DataSource,ADOConnection and ADOTable). I would like to know if there is a way that I can search for spesific records (like just a…
L. Blue
  • 1
  • 3
1
2