I.T. Discussion Community!
-Collapse +Expand
Delphi
Search Delphi Group:

Advanced
-Collapse +Expand Delphi To/From
To/FromCODEGuides
-Collapse +Expand Delphi Store
PRESTWOODSTORE

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyPascal and Delphi Coding Board   Print This     

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"
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Raimundo
Varbyte in Delphi
How can I display a field varbyte in a DBGrid in Delphi 4?
14 years ago
3 replies. Last post:

charlos.j
This is very interesting content! I have thoroughly enjoyed reading your points and have come to the conclusion that you are right about many of them. You are great. stanozolol for sale
10 days ago
Nothing New Since Your Last Visit
6551
Hits

Thread 24 of 25
Thread Starter  

AndreiT
Strange bookmark error
{Too Long!}
16 years ago
1 Reply:

grish.m
Actual gamers who manage their own groups. Dream League Soccer You are needed to hire gamers for your group.
4 months ago
Nothing New Since Your Last Visit
3339
Hits

Thread 23 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
16 years ago
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.
4 months ago
Nothing New Since Your Last Visit
1316
Hits

Thread 22 of 25
Thread Starter  

Negative
Making a spectrogram
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?
17 years ago
Nothing New Since Your Last Visit
5504
Hits

Thread 21 of 25
Thread Starter  

owen.moore
SQL with SQL CE Ver 4
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
19 months ago
Nothing New Since Your Last Visit
514
Hits

Thread 20 of 25
Thread Starter  

MerLiN
INI file problem
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
15 years ago
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
56 months ago
Nothing New Since Your Last Visit
3549
Hits

Thread 19 of 25
Thread Starter  

Tom.L
Delphi -- Search an array for a coloured Tpanel
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
5 years ago
1 Reply:

Wes
{Too Long!}
5 years ago
Nothing New Since Your Last Visit
3162
Hits

Thread 18 of 25
Thread Starter  

Ron Roper
How to change sort to descending?
{Too Long!}
16 years ago
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;

 

7 years ago
Nothing New Since Your Last Visit
7121
Hits

Thread 17 of 25
Thread Starter  

Ahmed.K
Desktop database applications withClient Datasets!
{Too Long!}
8 years ago
1 Reply:

mikey_n
{Too Long!}
8 years ago
Nothing New Since Your Last Visit
3042
Hits

Thread 16 of 25
Thread Starter  

owen.moore
Server 2003 and BDE
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
8 years ago
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.
8 years ago
Nothing New Since Your Last Visit
2872
Hits

Thread 15 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
8 years ago
1 Reply:

Rodney.N
{Too Long!}
8 years ago
Nothing New Since Your Last Visit
3000
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
8 years ago
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.
8 years ago
Nothing New Since Your Last Visit
3499
Hits

Thread 13 of 25
Thread Starter  

Myles Boyd
Paradox -> Delphi
Is there a utility that will convert Paradox 8 forms in to Delphi?, , Thanks
17 years ago
2 replies. Last post:

mprestwood
If anyone is interested in a Paradox Object / Delphi Object Pascal cross reference gude, click below:
  • ObjectPAL and Delphi Cross Reference Guide
  • 8 years ago
    Nothing New Since Your Last Visit
    2009
    Hits

    Thread 12 of 25
    Thread Starter  

    rocarobin
    Display the clicked/selected filename in the form
    Hello Delphi Users Below is the result of the clicked/selected filename outside from delphi form. selected filename I have a code but its complicated, from daddy of tek-tip., Is there any simple code to run the program? Thanks.,
    9 years ago
    4 replies. Last post:

    rocarobin
    Thanks for the infos. I'm glad of it.,
    9 years ago
    Nothing New Since Your Last Visit
    2780
    Hits

    Thread 11 of 25
    Thread Starter  

    Daydreamer
    Database Problems
    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!!! 
    11 years ago
    9 replies. Last post:

    Wes
    {Too Long!}
    10 years ago
    Nothing New Since Your Last Visit
    4384
    Hits

    Thread 10 of 25
    Thread Starter  

    Owen
    Storing Jpeg Files into Paradox Database
    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
    16 years ago
    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.
    10 years ago
    Nothing New Since Your Last Visit
    3273
    Hits

    Thread 9 of 25
    Thread Starter  

    Ron.Roper
    Slow access to ADO table on 2nd pass
    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
    10 years ago
    1 Reply:

    Wes
    {Too Long!}
    10 years ago
    Nothing New Since Your Last Visit
    4145
    Hits

    Thread 8 of 25
    Thread Starter  

    Francisco Vazquez
    SQL with Access and Delphi 6.0
    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.
    13 years ago
    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 
    11 years ago
    Nothing New Since Your Last Visit
    2432
    Hits

    Thread 7 of 25
    Thread Starter  

    kes103
    print preview code
    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.
    12 years ago
    3 replies. Last post:

    Wes
    {Too Long!}
    12 years ago
    Nothing New Since Your Last Visit
    2343
    Hits

    Thread 6 of 25
    Thread Starter  

    kes103
    How to Hide DOS Command prompt Window
    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.
    12 years ago
    2 replies. Last post:

    kesco
    I solved the problem by adding:, , , {$APPLTYPE GUI}, , , directive to the main program unit.
    12 years ago
    Nothing New Since Your Last Visit
    5103
    Hits

    Thread 5 of 25
    Thread Starter  

    kes103
    How toSimultaneously load a data file and applicat
    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.
    12 years ago
    1 Reply:

    Wes
    {Too Long!}
    12 years ago
    Nothing New Since Your Last Visit
    1873
    Hits

    Thread 4 of 25
    Thread Starter  

    Nathan Lloyd
    Delphi thick client to Paradox over web
    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.
    12 years ago
    1 Reply:

    Wes
    Have a look at Asta:, http://www.astatech.com/products/asta3/
    12 years ago
    Nothing New Since Your Last Visit
    2156
    Hits

    Thread 3 of 25
    Thread Starter  

    Neophyte185
    Can someone help me with the implementation of Kil
    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.
    13 years ago
    1 Reply:

    Wes
    {Too Long!}
    13 years ago
    Nothing New Since Your Last Visit
    2124
    Hits

    Thread 2 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 :)
    13 years ago
    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.
    13 years ago
    Nothing New Since Your Last Visit
    2026
    Hits

    Thread 1 of 25
    Thread Starter  

    kam.lagan
    Wierdness! Beware!
    {Too Long!}
    16 years ago
    3 replies. Last post:

    pcwise
    I had the same problem, it turned out the code involved was old from Delphi 1. The variable involved in the condition was of type "Real" which is shorter than the newer "extended" type. It caused me a ton of grief until I replaced all the "reals" with "extendeds" and haven't had any problems since. :)
    13 years ago
    Nothing New Since Your Last Visit
    2275
    Hits

    New Thread
    -
       Contact Us!
     
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    1,996 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...


    ©1995-2018 PrestwoodBoards  [Security & Privacy]
    Professional IT Services: Coding | Websites | Computer Tech