Delphi Single User Apps Topic

Hi 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

How can I display a field varbyte in a DBGrid in Delphi 4?

{Too Long!}

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

I 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?

Hi,, 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

I 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

{Too Long!}

{Too Long!}

I 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

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

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

Is there a utility that will convert Paradox 8 forms in to Delphi?, , Thanks

Hello 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.,

Hello 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!!! 

Can 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

I 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

Hi 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.

I 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.

How 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.

How 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.

I 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.

My 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.

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 :)

{Too Long!}