Tagged Questions
0
votes
4answers
105 views
Problems on using same field names in different tables, specially ID
I am developing a big data base, and from this situation I decided to think always twice at least on making decisions about the table and field layouts. My highest concern is about the primary keys.
...
1
vote
1answer
56 views
ODAC: nvarchar column value is truncated
I am using ODAC library version 8.6.12 to connect to oracle with Delphi 6, I have a nvarchar(32) column as you can see it has a maximum of 32 characters and lets say that I always use 32 character ...
0
votes
2answers
46 views
Delphi XE3: DBLookupCombo Dropdown side effect
We are porting a D6 application to XE3.
In D6 I inherited a complex code which used shared datasets and datasources everywhere.
This worked well in D6.
After we could run the XE3 version, we ...
0
votes
1answer
120 views
Delphi Solution for data replication between two remote sites loosely connected
I'm using Delphi XE4 Architect (Delphi Xe3 is ok as well)
I need to find a smart solution to the following problem
and I would like to use one of these frameworks: kbmMW or RemOjects SDK / ...
0
votes
1answer
71 views
Delphi: Return database names from MySQL using Metadata
I want to know if there is a way to return database names from MySQL using Delphi object TSQLConnection, I know that there is some methods that return table names or field names:
...
1
vote
1answer
94 views
Can db-aware and non-aware components be used simultaneously to insert/update databases?
I have a typical [Delphi] set-up for connecting to an external database--a Connection component hooked onto a Table, a DataSetProvider, ClientDataSet, and DataSource. I can successfully insert a new ...
1
vote
1answer
79 views
Inserting records with Nested ClientDataSet with autoincrementing link
I'm teaching myself Delphi database programming using a MySQL database. I'm trying to add a record from a nested ClientDataSet with the link between master and detail tables an autoincrement field in ...
2
votes
2answers
101 views
Why doesn't my query return any results when I add a WHERE clause?
My Delphi application is connected to SQLite successfully.
procedure TForm1.Button1Click(Sender: TObject);
begin
ZQuery1.Close;
ZQuery1.SQL.Clear;
ZQuery1.SQL.Text := 'SELECT Name FROM city;';
...
2
votes
1answer
107 views
Inserting records with autoincrementing primary keys
I created a MySQL database in phpMyAdmin, with an auto incrementing primary key ID. Within phpMyAdmin I can insert records via INSERT INTO MyTable VALUES (null,1,2,3) The null position is for ID.
...
0
votes
0answers
37 views
DelphiXE2 : How to Display Data From Database to NextGrid
I've searched around, ask my local teacher at my school. But there is no way i could find how to display data from database to NextGrid. I used SELECT * but it doesnt shown on the next grid.
...
3
votes
0answers
127 views
How do I write a database application that can be compiled in both Delphi and Free Pascal? [closed]
I'm writing a simple application which connects to MySQL, selects and updates some rows.
What is the standard or de-facto standard approach to working with databases so that the app compiles both on ...
1
vote
2answers
135 views
Comparing Tables in Delphi without SQL
I'm having problems while using Tables in a Paradox Data Base in Delphi.
I need to compare two tables and verify which fields are identical and which are different. At the end, both tables must ...
1
vote
2answers
163 views
Improve multiple synchronized access to data
At the beginning I would like to apologize for the excessive use of bold text. I wanted to simplify the understanding of the way my long questions.
I have a problem with multiple access to the data.
...
0
votes
1answer
60 views
How to change values of a mysql database via dbgrid?
Hey guys good morning,
i got a DBGrid and the UniDac components. I a use a popupmenu and select a row. I fill via the onclick event from the popupmenu a new form with my data in my TEdit.
Now the ...
1
vote
0answers
61 views
Firebird database connection set with TIBConnectionBroker Component
Does anyone know of any database component sets for connection to Firebird database's with a component similar to the TIBXConnectionBroker in the IBX connection Set?
I know the IBX can connect to ...
-1
votes
2answers
200 views
how to increase speed of loading treeview nodes from a table using delphi
It's simple to load treeview nodes from table using a recursive function, but it takes a long time for huge data.
I have a table with these fields: id, title, parentid : that keeps treeview nodes in ...
2
votes
2answers
147 views
Delphi - DB Refresh alternative
I am using Delphi with Firebird DB in a software that display many calculations and according to requirement I need to store and display the total whenever other dependent tables gets updated.
I am ...
0
votes
3answers
495 views
Efficient database access to various DBMS from Delphi XE2
My needs
I work with Delphi/C++Builder XE2.
I need to access at least these DBMSs:
Firebird
DB2/400
SQL Server
SAP HANA (a new in-memory DB, available interfaces: JDBC, ODBC, ODBO, SQLDBC)
I ...
-4
votes
1answer
230 views
how to display fields from different tables on a single db grid using delphi 7? [closed]
i have a dbgrid which displays content of one table only,
i would like it to display fields from different tables (e.g. 2 fields from table 1, 2 fields from table 2 and 1 from table 3). how can i do ...
0
votes
1answer
92 views
how can i make my search box jump from one keyword to another without it check every row of the database? [closed]
I got this code working for my app's search box, unfortunately when it search or filters, it checks every row on the database and then when the searched word is found, it will display it on the ...
0
votes
2answers
195 views
Delphi 5 DB Aware ComboBox ItemIndex Not Updating
So I have a DBAware combobox and my problem is this.
If I do:
ComboBox.ItemIndex := 0;
Then even though visually it shows an item in the combobox being selected, the following still returns true.
...
3
votes
1answer
337 views
how do i connect to a firebird database on delphi 7 from multiple clients spread across the internet?
i would like to create a program that can access my firebird database on 2 different computers via the internet. i would like to know what connection to use and what parameters to set.
thanks
0
votes
1answer
188 views
Using Delphi XE2 DBgrid how can I display a memo field
How to display a ADO Database memo field in a DBgrid using Delphi XE2?
Thanks.
0
votes
1answer
107 views
Delete and refresh a record in DBgrid where u maintain the same position
I have a small database I'm using dbgo, I have a DBgrid displaying my records, I need to know how to delete a record and refresh the database where the index arrow stays in the same position or at ...
4
votes
1answer
146 views
How to work with database and UI under threads?
I am interested in make better programs with more responsive design and capabilities. Nowadays, when I create my programs that access data remotely, my interface freezes and there is no animated GIF ...
-2
votes
2answers
129 views
creating tables and displaying without RAD components [closed]
my job gave me a challenge to do the following... I am still a rookie and learning as fast as I can but i have this curve ball and cant quite get my mind to it.
If it is not to much trouble... how ...
1
vote
1answer
151 views
Database Record Processing [closed]
How can I split the workload of records across multiple threads specifically Accuracer DB that has 169 records with 7 threads for example.
Because I could just split the number of records in ranges ...
0
votes
0answers
61 views
Delphi embedded database with network share support [duplicate]
I do not know if I'm doing the right question, but this is the situation:
I need to develop an application that will connect to a database.
This same application will be used on 2 computers on the ...
0
votes
1answer
80 views
Delphi xe2 , can't import Field of type varchar from mysql database
I just Create a connection to my Database ( MYSQL ) Using ODBC witch use The mysql API and i start using Tdatabase Component and Ttable Component and Datasource and Dbgrid and i notice that Fields ...
2
votes
0answers
144 views
Delphi XE3 / Multiple Connections for a single user
I am trying to figure the best / "correct" place to put the following logic in my delphi datasnap server.
A user connects to the server, and using the credentials provided I validate them using a ...
1
vote
2answers
280 views
Delphi SQL Date reading issue
I am currently creating a Delphi Application with SQL connections integrated.
SQL stores its date values in the format YYYY-MM-DD, however, when I read these values within my Delphi application, they ...
0
votes
1answer
690 views
Delphi Edit DBGrid and Update Database in Read Only Mode?
So I have a DBGrid filled with an SQL query. I want the query to be read only so the table isn't locked up while the program is running. The problem is when it is set to read only I can't edit the ...
2
votes
2answers
171 views
Tdbf/tdataset sorting multiple fields in delphi
I have a delphi application that uses tdbf which is based on tdataset with the advantage of not requiring bde engine. I needed the table to be sorted and I did this one a single field by adding an ...
0
votes
1answer
195 views
Strange behaviour of Delphi database components
I have a problem with the Delphi database components. I tried to add some functionality to a program, but was getting strange problems. I broke it down to a simple sample project and the behaviour is ...
4
votes
2answers
290 views
CoInitialize error working with database inside threads
Using Delphi 7, whenever I try to do any database work inside of a thread I get this error:
"CoInitialize has not been called"
I used a simple code containing an ADOConnection.Open inside the ...
-1
votes
1answer
48 views
Exception EZSQLExeption in module VDB1.exe at 002A7A5C. SQL Error: Host'Gareth-PC' is not allowed to connect to this MySQL server
I am using Delphi xe2 and I would like to know qhat this error is and by what means I need to get around this, I am attempting to connect my database application to a wamp server through a LAN ...
0
votes
1answer
191 views
Evaluating the performance of Absolute Database and comparing it to BDE [closed]
I'm in the process of dumping BDE as my database platform and evaluating similar alternatives. In this regard, after reading positive reviews about Absolute Database, i conducted some comparisons ...
1
vote
2answers
153 views
Firebird + Delphi - display joined fields value in dblabel
I use Firebird db and I have a table that display some fields from other tables using Join. in the software UI made with Delphi I used dblookup to change the ID and set foreign table value.
I want to ...
0
votes
0answers
138 views
The wrong encoding of the read value from database sqlite
There is sqlite a database - a descriptor, containing the list of tables, the list of domains, the list of fields, the list of restrictions (primary and foreign keys), the list of indexes. I am ...
2
votes
2answers
180 views
Where should I save a semi-temporary database?
I have an application where I would like to save some raw files in a folder structure on the client's computer. This EXE is completely stand-alone, and could possibly be running from a CD, or ...
1
vote
3answers
330 views
How to force update a DB grid?
I may have been too clever for my own good :-/
I have a table which holds some pressure measurements. These are always stored as PSI, but the user can select a radio group button to toggle between ...
0
votes
0answers
189 views
Unexpected behaviour of TTable and TDBGrid in Delphi XE2
I have a textbox and a grid on a form.
Functionality: When I enter an Emp ID (say 1, 2, 3 etc) in textbox, corresponding to that Emp ID, Emp Name should come in the Grid from database. When I again ...
1
vote
1answer
361 views
How to make database connection with oracle in delphi xe2 using TADOConnection?
I am trying to make database connection with oracle using TADOConnection. I took ADOConnection1 on the form. Then I set Provider property to SQLOLEDB. Consider username and password of database is 111 ...
0
votes
0answers
266 views
Occasional Blob not found error on a firebird database
I'm useing Firebird in conjunction with IBX (I know one should not do that but it's a legacy application I need to maintain...).
When running that application (an apache shared module) under heavy ...
1
vote
1answer
576 views
How can I refresh a TClientDataSet without applying pending updates?
Here is what I'm trying to accomplish:
Retrieve 1 record from the database through TSQLDataset's CommandText: SELECT * FROM myTable WHERE ID = 1
Use TClientDataset to modify the record. (1 pending ...
4
votes
3answers
1k views
How to auto fit/scale DBGrid's (or other similar) columns widths according to its contents?
I am trying to make a frame with a DBGrid that will serve for more than 10 tables with half of its fields as defaults, and other fields exclusive for each table.
As the space for the columns are ...
2
votes
2answers
563 views
How to delete selected database records from a TDBAdvListView?
I am testing out Absolute Database by ComponentAce
I have on my Form a TABSTable, TABSDatabase and a TDataSource and the data is being displayed in a TDBAdvListView, MultiSelect and RowSelect are ...
0
votes
1answer
401 views
Creation of SQL queries in mORMot
I using for access to SQLite from Delphi 7 mORMot http://synopse.info/fossil/wiki?name=Downloads. But thus I will use only connection to a database, but not ORM (Object and relational display) ...
0
votes
0answers
301 views
delphi 6 and ADO ms access db
I searched many forums and google on this, but I am still not sure how to find the answer.
I have Delphi 6 standard (personal edition), However, now I am getting into the database scene and I would ...
2
votes
3answers
469 views
Delphi - change text color based on current record value
using db controls connected to a FireBird database. and I have a simple dblabel I want to change text color based on current value for current record
The user navigate using the dbnavigator and I ...
