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 | | |  PS_3956 | Where to Order Quality Web Development Services?Want to create a new Internet project? Looking for useful web development https://www.shtudio.com.au/services/web-development/ services in Australia? Need a competent web designer? Shtudio will help you solve all these questions. Here you will get answers to all the questions related to the content of the website and will be able to change its design. Need to improve your visual identity and create a new or optimize old website? Whatever web design problems you have, Shtudio is the answer.
|
 819 Hits | |
Thread 24 of 25 | | Thread Starter | | |  PS_3956 | How to Find a Construction CompanyHi there! If you are right about to hire a construction company for your home improvement project, there is one service I'd like to recommend you. The company I'm talking about is Glamour Decor. They specialize in the installation of aluminium cladding Sydney https://goo.gl/maps/TiSnXn5ippsLwhMB7 panels and architectural cladding of feature walls and soffits to whole building facades, awnings, fascias and sun blades.
|
 477 Hits | |
Thread 23 of 25 | | Thread Starter | | |  PS_3891 | Importing Cars to Australia - Possible OptionsDo you need a car yet are pressed for budget? Then go ahead to find a dealer you can trust. Personally, I can recommend you Best People Movers - the company I personally dealt with. They believe that you don’t need to be loaded with money to own an upmarket family car. So, if you are interested in importing cars to Australia https://goo.gl/maps/8cnsa4Q3GHEbyeuX6, contact the managers anytime.
|
 528 Hits | |
Thread 22 of 25 | | Thread Starter | | |  PS_3784 | Best Worcester MA Roofing Contractors{Too Long!} |
 492 Hits | |
Thread 21 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 | 10 replies. Last post: |  dariy.m | {Too Long!} |
|
 3329 Hits | |
Thread 20 of 25 | | Thread Starter | | |  PS_3174 | Immigration Lawyers: Where to Find?Professionalism and dedication to success is what Schwalb Legal is known for. The company employs skilled, knowledgeable and experienced immigration lawyers https://g.page/SchwalbLegal, who are able to handle each case in the best way possible with utmost attention to the details. This eventually attests to the company‘s sense of respect, credibility and dedication to success.
|
 469 Hits | |
Thread 19 of 25 | | Thread Starter | | |  PS_3113 | Traffic Control Services: How to Find?It's not easy to find a trusted company that works closely with clients to identify their security, traffic control https://uvsgroup.com.au/traffic-control/ and needs for the most appropriate and cost effective solutions and then manages the entire process on their clients’ behalf, right up until the job is done and beyond. If you are looking for the one, UVS Group will certainly come up to your requirements.
|
 681 Hits | |
Thread 18 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
|
 2129 Hits | |
Thread 17 of 25 | | Thread Starter | | |  Raimundo | Varbyte in DelphiHow can I display a field varbyte in a DBGrid in Delphi 4? |
 9751 Hits | |
Thread 16 of 25 | | Thread Starter | | |  AndreiT | Strange bookmark error{Too Long!} |
 4543 Hits | |
Thread 15 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.
|
|
 2407 Hits | |
Thread 14 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? |
 6860 Hits | |
Thread 13 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
|
|
 4631 Hits | |
Thread 12 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!} |
|
 4858 Hits | |
Thread 11 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;
|
|
 8963 Hits | |
Thread 10 of 25 | | Thread Starter | | |  Ahmed.K | Desktop database applications withClient Datasets!{Too Long!} |
 4169 Hits | |
Thread 9 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.
|
|
 4024 Hits | |
Thread 8 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
|
 4343 Hits | |
Thread 7 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.
|
|
 4927 Hits | |
Thread 6 of 25 | | Thread Starter | | |  Myles Boyd | Paradox -> DelphiIs there a utility that will convert Paradox 8 forms in to Delphi?, , Thanks |
 2887 Hits | |
Thread 5 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.,
|
|
 3919 Hits | |
Thread 4 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!} |
|
 5862 Hits | |
Thread 3 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.
|
|
 4398 Hits | |
Thread 2 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!} |
|
 5098 Hits | |
Thread 1 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
|
|
 3335 Hits | |
 |
|
|