I need a simple procedure that will take a recently sorted single field MS Access file (ADOTable1.Sort := 'FieldName ASC';) and copy its contents into an array. (The Delphi help menu is provin...
Hi guys,
How do I get the newly added records primary key when inserting a record?
I am using TBetterADODataset with LockType ltBatchOptimistic since I wanted to post the records to the db...
I have created a database like program in the language pascal / delphi. The program has been working yesterday, until today, when I started it, an error message appeared . is not a valid in...
I have this code that copies all data from a remote mysql database into a local ms access database.
This works like a charm, but......
Now what I want is to compact and repair the ms acces...
How can I open some text file (not specified), in adoquery. In the text file (saved form the same adoquery) are 2 seperate text items (seperated by a comma). Like songtext and genre.
I know...
I have a simple TreeView populated from a table that contains the following fields:
NodeID - Unique identifier
ParentID - Parent node, if any
Description - Label for display
Is there s...
would like to use the "show tables" SQL with ZEOS, how to do that ?
I have a small application in Delphi 7. I am doing a bulk insert in Sql Server2005. I have more than 2000 insert statements in a text file.
I load this text file in the TAdoQuery component a...
How can you have multiple table values in one cxGrid under separate bands ???
I have 4 tables from which I would like to have data in cxgrid under 4 bands.
I want to try to create a ms access database in realtime with delphi, and I used the example on about delphi (http://delphi.about.com/od/database/l/aa072401b.htm) to do so, but I get the follo...
i suffered some trouble with paradoix and bde , see http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Database/Q_24646483.html#a25248498
what would be the best recommendat...
In a database I use, I have 2 tables, songs and songs2. The main table is songs which contains all kinds of songtitles. The second tables (songs2) is a temporary table. In the app I created wi...
we run an application using the good old BDE and a paradox database, programming has been done using Delphi 7, OS = Win2K.
Now we got a database file with 300.000 records, we could run a que...
The application Iam building is almost finished, but I run into a problem, which I don't know what the solution is.
I have a connection to a online mysql database, and when I click button1,...
Hi experts,
I have a problem with a program writed in delphi that uses ADO to store data on a MDB (MS Access) database. The append/post operation works well, but suddenly, after some time a...
Dear Experts,
I have an example that loads and saves a treeview to a database.
I tried to figure out what those declared fields does, Some of them
I don't know what they mean. Who can ...
I want to try to have the adconnection (anydac component, not standard delphi), stored into a DLL.
The connection is to a msaccess database (local).
I already have the code which normally ...
Hi
I am using an excel file in delphi6 project through ADO database connection to read its data into a dataset.
At form closing time i close the query and connection both, but the phisic...
I have 2 projects. I can debug one of them. The other I can not get the debugger to function. What can be wrong in the code, so the debugger will not envoke at all?
Hi there,
I require a sample application of writing a client server solution, where the server app will run on a windows hosted environment that can receive multiple connections from the cl...
I have a Delphi 2007 client application that can connect to one or more databases that run on one or more SQL Server 2005 servers. Right now, the database and server to which the client conne...
Does Firebird support local temp tables? I'm not very familiar with Firebird, more familiar with SQLServer, but it's been a couple years since I did any serious work with SQLServer so I'm a b...
I have a simple MS Access database and need to program a button to do an index on a specified field. I can't find any examples. Thanks
Hi,
I have an application which is in a network drive. When i run thsi application through the network drive (N/w drive mapped Z:\) from one machine, it works fine.
but the same time when ...
Hey Guys & Gals,
I am designing an application which needs to pull data from a MySQL database table and put it in a combobox and have couple of questions.
1.) What TYPE should I use for...
