Delphi Single User Apps Topic

Non-distributed database applications including questions on single user, multi-user, BDE, non-BDE, TDataSet, TTable, TQuery, ADS, MyBASE, etc. |
<table style="BORDER-RIGHT: #800000 1px dotted; BORDER-TOP: #800000 1px dotted; BORDER-LEFT: #800000 1px dotted; BORDER-BOTTOM: #800000 1px dotted" cellspacing="0" width="100%" border="0"><tbody><tr> <td bgcolor="#dadada" class="darkcolor2" align="center" |
|
|
Thread 25 of 25 | Thread Starter | | |  Mido | Printing from DBGridHi all, , I have two forms .... the first one I used ADOQuery to search the Table and put the result in the DBGrid at the same form, when I press the button I should see the result of searching in the second form in the QReport ., any Idea ????  , , Thanx 4 replies. Last post: |  Christopher.3 | It is hard to understand how these searches and the backend of a server is working. You can use samedayessay to draw out the relations of different things. Since you use technology then you make your jobs easier.
|
|
 2081 Hits | |
Thread 24 of 25 | Thread Starter | | |  owen.moore | SQL with SQL CE Ver 4Hi all
I am having a problem with a program i have been working on and I have been filtering a database by date and client to produce records for a DBChar and it all works fine and as it should . As the record number grows thought I should perhaps use an sql query insted of filter and do you think I can get it to work
I have a SDF Database called CounterData.
I have a field in the database counterDate which is a datetime field and I have two datetimepickers one startdate and one enddate.
I not strong on sql and can usually make it do what I want but not with dates.
have tried many variants of this
select * from counterdata where countertranstype ='+quotedstr('D')+'and CounterDate >='+datetostr(startdate.date) +'and counterDate <='+datetostr(enddate.date).
I am using the Devart Sdac components to connect to the SDF Database
Thanks for any help
Owen Moore
|
 1369 Hits | |
Thread 23 of 25 | Thread Starter | | |  Raimundo | Varbyte in DelphiHow can I display a field varbyte in a DBGrid in Delphi 4? |
 8052 Hits | |
Thread 22 of 25 | Thread Starter | | |  AndreiT | Strange bookmark error{Too Long!} |
 3959 Hits | |
Thread 21 of 25 | Thread Starter | | |  bobkolb | How Can I Sort a Ttable Field with BLOB Entries?I am creating a database with a field that contains formatted memos (e.g., quotations from a variety of sources with bold, italic, and accented letters )and I want to alphabetize the entries. How can I do this?, , Bob Kolb 2 replies. Last post: |  Roman.R | You can claim these are quite just like the leo play card leoplaycard download its Apk documents is to download it from our website.
|
|
 1779 Hits | |
Thread 20 of 25 | Thread Starter | | |  Negative | Making a spectrogramI have written a program that does soundanalyses with a FFT-function. To view the data I want to display it in a spectrogram. The method I have applied now is drawing the frequencies on the vertical axis and time on the horizontal axis. The amplitude of the signal is displayed using different colors. To draw the colors on the bitmap I currently use the Pixel function of the Canvas, but this goes really slow., , My question is : Is there another, faster method to draw colors on the bitmap; keeping in mind that every pixel could have another color? |
 6215 Hits | |
Thread 19 of 25 | Thread Starter | | |  MerLiN | INI file problemHi,, Does anyone know how to make a program process every setting in an ini file?, , I have 2 problem settings in my program that can't seem to process the results from the ini file, one is "Always on top" and the other is "minimize to tray". My program can save the settings with no problems but when I run the program and it reads the ini file, if both settings are set to true the program only seems to process one of them., , My guess is because both settings relate to window functions. I tried Application.ProcessMessage but that didn't fix the problem., , Any help or suggestions would be appreciated., , Merlin 2 replies. Last post: |  Anonymous | these settings are process at application creation and cannot be set from ini file. They have already been set by the time the file is read and cannot be changed by then.
---
Dave
|
|
 4013 Hits | |
Thread 18 of 25 | Thread Starter | | |  Tom.L | Delphi -- Search an array for a coloured TpanelI have an array y=11 by x=20 array containing Tpanels they all have corresponding colours assined to them. i would like to be able to search through the arraay to find a cirtian colour and change it to another, i tried this but it didnt work.
procedure TFrmSeatLayout.BtnDeselectAllClick(Sender: TObject);, begin, ListSelectedSeats.Items.Clear; (ignore this), if ArPnl [x,y].color = clPurple then (the array is called Arpnl), ArPnl [x,y].color := clTeal;
end;
I want it to find the Purple panel and change it to Teal
Thanks for your help
Tom
1 Reply: |  Wes | {Too Long!} |
|
 4031 Hits | |
Thread 17 of 25 | Thread Starter | | |  Ron Roper | How to change sort to descending?{Too Long!} 5 replies. Last post: |  rdkram | If it is an index, then by default it is automatically ascending.
When selecting the data, include a SORT BY clause and then DESC for descending - it is automatically ascending by default. Here is an example: SELECT FieldA, FieldB, FieldC FROM Employee ORDER BY FieldB; SELECT FieldA, FieldB, FieldC FROM Employee ORDER BY FieldB DESC;
|
|
 8136 Hits | |
Thread 16 of 25 | Thread Starter | | |  Ahmed.K | Desktop database applications withClient Datasets!{Too Long!} |
 3519 Hits | |
Thread 15 of 25 | Thread Starter | | |  owen.moore | Server 2003 and BDEI have just thought I might move all my delphi stuff onto my 2003 server and then use remote desktop to access it however some of my apps give me a bdertl70 error when trying to open in delphi however the exe runs fine
I am Using Delphi 7 Enterprise
Is this an issue with server 2003 or do I need to look harder
It seems to be apps with multiple tables that give the trouble
all these came of a Windows XP Pro Box and worked just fine
Thanks
Owen
2 replies. Last post: |  mprestwood | Hi Owen,
I suspect a rights problem. The app/user needs full rights to the data folder and net dir.
|
|
 3419 Hits | |
Thread 14 of 25 | Thread Starter | | |  owen.moore | Can anybody help me with getti...Can anybody help me with getting a directory file listing into a listbox so that I can programatticlly go through the listbox and put the filenames into a database
they Database part is not causing me any trouble
I can get it into a dirlistbox but can not use that to then post certain of the file names to the Database
any help is most appreciated
Owen
|
 3664 Hits | |
Thread 13 of 25 | Thread Starter | | |  owen.moore | Can anybody help me with getti...Can anybody help me with getting a directory file listing into a listbox so that I can programatticlly go through the listbox and put the filenames into a database
they Database part is not causing me any trouble
I can get it into a dirlistbox but can not use that to then post certain of the file names to the Database
any help is most appreciated
Owen
4 replies. Last post: |  Wes | Hi Larry,
Thanks for the great post putting some meat on the bones of my suggestions. There's nothing like good sample code to get one started. I wanted to post some, but time didn't permit. Glad you did.
|
|
 4140 Hits | |
Thread 12 of 25 | Thread Starter | | |  Myles Boyd | Paradox -> DelphiIs there a utility that will convert Paradox 8 forms in to Delphi?, , Thanks |
 2424 Hits | |
Thread 11 of 25 | Thread Starter | | |  rocarobin | Display the clicked/selected filename in the formHello Delphi Users
Below is the result of the clicked/selected filename outside from delphi form.

I have a code but its complicated, from daddy of tek-tip.,
Is there any simple code to run the program?
Thanks.,
4 replies. Last post: |  rocarobin | Thanks for the infos.
I'm glad of it.,
|
|
 3274 Hits | |
Thread 10 of 25 | Thread Starter | | |  Daydreamer | Database ProblemsHello everyone! I am new to Delphi and I am picking it up really quickly by the way. My problem is I haven't seen a working Mysql database that worked from examples I have downloaded. I have gotten a few Access database running with Delphi. What I can't seem to do however is get a certain recordset. I can't find no information on pulling a specific recordset with Access/Delphi.
Here is what I am trying to do: when a person logs on to the chatroom server, I want them to have access to the information they entered in there personal record only?
If there is an easier way to do this besides using Access, can someone point me in the right direction please. I am using Delphi 7.
Thanking you all in advance!!!
9 replies. Last post: |  Wes | {Too Long!} |
|
 4986 Hits | |
Thread 9 of 25 | Thread Starter | | |  Owen | Storing Jpeg Files into Paradox DatabaseCan anyone help me, , How can I store Jpeg Camera files into my database, , I have a field in my database called image which is set to a graphic Type, , How can I store a jpg image into the database and then view it as i select the record from a table, , I can make it all work using mbp files but not using jpg files is there a trick to it or do you need to comvert them to bmp and if so how can I do that, , Thanks, , Owen 3 replies. Last post: |  mprestwood | Hi Owen,
Nice solution. Sure, I'd like to see the code. You can post it here if it's short or how about posting it as an article in our knowledge base? If you want, you can send it to me and I'll post it for you or you can post it.
|
|
 3733 Hits | |
Thread 8 of 25 | Thread Starter | | |  Ron.Roper | Slow access to ADO table on 2nd passI am having a speed problem when writing new values to a MS Access table via and ADO connection. On the first pass through the dataset there is no problem, with more than 1000 records per second being updated. But on the second pass through, it slows to about 10 records per second, even though the task is much simpler.
Just the fact that I try to update just one field seems to trigger the slow speed on the second pass. I am using a TADOConnection and a TADOTable to connect to the Acces table. To update the filed values I am using...
MyADOTable['MyFieldName'] := NewFieldvalue;
Some parameters for the connection include...
ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;Persist Security Info=False, CursorLocation = clUseServer, Provider = Microsoft.Jet.OLEDB.4.0
Can anyone suggest what might be causing the problem or any possible solutions.
Regards
Ron
1 Reply: |  Wes | {Too Long!} |
|
 4591 Hits | |
Thread 7 of 25 | Thread Starter | | |  Francisco Vazquez | SQL with Access and Delphi 6.0Hi everyone, I hope someone could help me solve this problem out, cause I'm stuck with this since a few days... I have this little script:, , procedure TForm1.Button1Click(Sender: TObject);, var, sBusca:string;, , begin, ADOQuery1.Close;, ADOQuery1.SQL.Clear;, sBusca := Edit1.Text;, ADOQuery1.sql.add('Select * from cobranza where nombre = '+QuotedStr(sBusca));, ADOQuery1.Open;, end;, , end., , I'm trying to search for a Name into table Cobranza, the problem is that when I compile the script, it runs, but when I push the button it does nothing... so, if I get no error how can I know what's wrong?, , I wish someone could throw a lite into my darkness. Oh, one thing, originally I was trying to use 'Select * from Cobranza where nombre LIKE "%cBusca%" ';, in order to find names that have some likeness with the search, but it doesn't work either..., , Thanks in advance., Francisco V. 1 Reply: |  Wes | Francisco,
I apologize for the tardy reply.
I think the QuotedStr function is causing your problem. Try just single quotes around your search string.
Wes
|
|
 2828 Hits | |
Thread 6 of 25 | Thread Starter | | |  kes103 | print preview codeI have some results in the form of tabulated text, numbers etc., that I would like to get print preview on. Can anyone point me in the right direction on this. Sample code would be appreciated. I think I will need to print to a bitmap and then provide an option to print or exit. , Thanks in advance. 3 replies. Last post: |  Wes | {Too Long!} |
|
 2823 Hits | |
Thread 5 of 25 | Thread Starter | | |  kes103 | How to Hide DOS Command prompt WindowHow do I hide the startup DOS Command prompt window? , I tried , , , procedure TForm1.formcreate(Sender: TObject);, var, start : TStartupInfo;, begin, start.wShowWindow := SW_HIDE; , end;, , , in my main form, but it makes no difference., , Thanks in advance. 2 replies. Last post: |  kesco | I solved the problem by adding:, , , {$APPLTYPE GUI}, , , directive to the main program unit. |
|
 5724 Hits | |
Thread 4 of 25 | Thread Starter | | |  kes103 | How toSimultaneously load a data file and applicatHow do you get an application to simultaneously load and load a data file that has been double clicked on or opened? Of course, I realize that you need to associate the file with the program first. 1 Reply: |  Wes | {Too Long!} |
|
 2358 Hits | |
Thread 3 of 25 | Thread Starter | | |  Nathan Lloyd | Delphi thick client to Paradox over webI have a client that needs to access Paradox tables over the Internet using a thick client developed in Delphi. This is an existing application which accesses the shared Paradox database over a network, but new requirements now make it necessary for multiple users to access the tables over the Internet., , Are there any suggestions on how this might be accomplished? I am having difficulty finding information on this. 1 Reply: |  Wes | Have a look at Asta:, http://www.astatech.com/products/asta3/ |
|
 2642 Hits | |
Thread 2 of 25 | Thread Starter | | |  Neophyte185 | Can someone help me with the implementation of KilMy original question was: How do I access menu commands in one program from a Delphi Form?, , I have figured out how to generate a simple Delphi 7 form with a button in it which will run an executable. , , procedure TForm1.Button1Click(Sender: TObject);, begin, ShellExecute (Form1.Handle, 'open', 'c:\E3238s\bin\E3238s.exe',, nil, nil, SW_SHOWNORMAL);, end;, end., , My problem is I need to know how to access the menus that are a part of this executable. For example how would I access the FILE menu in order to select EXIT., , In light of the lack of a simple solution I am considering a different approach. I will use the SHELLEXECUTABLE and a timer from Delphi in order to start the external program. After the timer runs out I would like to use KillProcessByName in order to exit the external program. So now can any one help me with the implementation and syntax for the KillProcessByName function? Thank You. 1 Reply: |  Wes | {Too Long!} |
|
 2516 Hits | |
Thread 1 of 25 | Thread Starter | | |  EMFrimbo | Database???Hello All,, A friend of mine has business and uses Excel , to track stuff. He wants to do things that Excel can't really do and would like to move it into a database. He's thinking of having me do it for him but I write regular old Delphi apps and have never used any of the dbase stuff. I'm certain I could write a custom database program but is this a wise choice? If not, which Database software goes good with Delphi?, , Thanks so much :) 2 replies. Last post: |  Rick Carter | Well, I'm not clear whether this is a "favor to a friend" or a "lucrative business contract." Probably somewhere in between? As Wes said, Delphi is great for database applications, but there's a real learning curve. There's more to be learned than can be covered in one or two newsgroup postings. Be prepared to invest in and work through a good book or two. |
|
 2418 Hits | |
 |
|
|