Delphi Pages Forums  

Go Back   Delphi Pages Forums > Search Forums

Lost Password?

Showing results 1 to 50 of 314
Search took 0.19 seconds.
Search: Posts Made By: Marsheng
Forum: General 02-12-2019, 03:48 AM
Replies: 5
Views: 8,507
Posted By Marsheng
What DB are you running. Often the sorting is a...

What DB are you running. Often the sorting is a DB function.
Forum: General 09-19-2018, 08:53 PM
Replies: 2
Views: 7,312
Posted By Marsheng
I would have only expected this relationship to...

I would have only expected this relationship to be active while using the combobox.

So what I have to do is create a 2nd table copy table for the string list. This second table is used for...
Forum: General 09-19-2018, 10:53 AM
Replies: 5
Views: 7,609
Posted By Marsheng
I found a MyConnection.ping command. Now I use a...

I found a MyConnection.ping command. Now I use a ttimer and ping the server every 2 minutes.

Seems to have solved the problem.
Forum: General 09-19-2018, 10:50 AM
Replies: 2
Views: 7,312
Posted By Marsheng
DBLookupComboBox moves record pointer

I have 2 tables Master and Clubs.

On one form I have a DBLookupComboBox and it gets it data from Clubs for the Master.

From what I can see, it acts more like a master slave relationship. If I...
Forum: General 09-06-2018, 09:33 PM
Replies: 4
Views: 5,503
Posted By Marsheng
I'm not sure what 'sort of database' means. ...

I'm not sure what 'sort of database' means.

Anyway a search on your error brings up


See herehttps://www.youtube.com/watch?v=RMLss_oLtvQ

May have been a one off.
Forum: General 09-05-2018, 09:17 PM
Replies: 4
Views: 5,503
Posted By Marsheng
Which version of Delphi and what database access...

Which version of Delphi and what database access components are you using ?
Forum: General 08-31-2018, 12:50 AM
Replies: 5
Views: 7,609
Posted By Marsheng
Tried devart several times and submitted a ticket...

Tried devart several times and submitted a ticket but no joy.

When I run a local server, I don't get the problem. It would seem that when connected to Crazydomain's DB, it will drop the connection...
Forum: General 08-30-2018, 09:21 PM
Replies: 3
Views: 5,325
Posted By Marsheng
http://www.scalabium.com/faq/dct0103.htm ...

http://www.scalabium.com/faq/dct0103.htm

Looked at that before but must be an even earlier version than 6

The default font is MS Sans Serif so I searched through the registry to see if I could...
Forum: General 08-30-2018, 04:55 AM
Replies: 3
Views: 5,325
Posted By Marsheng
Set form default font and size.

Spent a few hours looking to see how I can set all forms in a project to the same font and size. I was hoping there was a setting for a default form designer font and size but nothing. Found some...
Forum: General 08-30-2018, 04:45 AM
Replies: 5
Views: 7,609
Posted By Marsheng
After many hours trying to find a solution, I'm...

After many hours trying to find a solution, I'm going back to Delphi 6.
Forum: General 08-11-2018, 11:35 AM
Replies: 0
Views: 1,424
Posted By Marsheng
Update 2 fields with DBlookupComboBox

I have ListField of names RaceClasses for a table racebike. The dbLookupComBox uses this RaceClasses list for the drop down.

The problem I have is, if the RaceClasses name is edited, the combobox...
Forum: General 07-31-2018, 09:50 PM
Replies: 5
Views: 7,609
Posted By Marsheng
Compliler options 6 vrs 10

I've migrated to ver 10 from 6. I do have one issue other than the
exceptionally busy IDE !!!

I use MydAC from Devart. In version 6, the connectionlost on the DB connection
was fired whenever...
Forum: General 07-31-2018, 09:48 PM
Replies: 8
Views: 2,345
Posted By Marsheng
Sorry I missed the last reply. You are correct...

Sorry I missed the last reply. You are correct to some extent. What I need to do is validate the form on close and double check noone else has added that number.

The numbers are decided by the...
Forum: General 07-23-2018, 09:26 PM
Replies: 2
Views: 1,332
Posted By Marsheng
Took me 10 years to find that running the IDE and...

Took me 10 years to find that running the IDE and EXE versions were 2 different operations.

Maybe this is the solution.

TOOLS
DEBUGGER
Bottom corner INTEGRATED DEBUGGING.

or under LANGUAGE...
Forum: General 07-21-2018, 09:37 AM
Replies: 1
Views: 1,310
Posted By Marsheng
_strlist[i]:=copy(_strlist[i],1,43)+'3'+copy(_strl...

_strlist[i]:=copy(_strlist[i],1,43)+'3'+copy(_strlist[i],45,length(_strlist[i])

Not tested but should be correct.
Forum: General 07-10-2018, 09:58 PM
Replies: 8
Views: 2,345
Posted By Marsheng
This is my solution. The main table is...

This is my solution.

The main table is tblMemMast and tblMemRaceNo is sorted on club.

Maybe not the most efficient way but I have all the control.

procedure TfMembers.FormShow(Sender:...
Forum: General 07-09-2018, 09:13 PM
Replies: 8
Views: 2,345
Posted By Marsheng
On connection lost is handled automatically with...

On connection lost is handled automatically with OnConnectionLost as part of MYConnection. Seems to work perfectly fine.

After a nights sleep I realized that unique may not work. I'm running...
Forum: General 07-09-2018, 10:04 AM
Replies: 8
Views: 2,345
Posted By Marsheng
Thanks I found the Unique setting by adding an...

Thanks I found the Unique setting by adding an index to the table.

Now I'm not sure how to handle the error !

There are several OnXXXerror on the table events. All my tables are in a Data...
Forum: General 07-08-2018, 09:29 PM
Replies: 8
Views: 2,345
Posted By Marsheng
Ensuring a unique number in table

When the user enters a race number, I need to ensure it is unique in that table.

I cant use a locate as that finds the first record and that maybe the current record so is valid.

There are...
Forum: General 06-24-2018, 01:00 AM
Replies: 1
Views: 1,482
Posted By Marsheng
Hmm something a bit more sinister is happening....

Hmm something a bit more sinister is happening. Nothing on that tab page is being written to the DB ??

Found it finally. Normally when editing grid type displays, moving between records causes a...
Forum: General 06-23-2018, 11:36 PM
Replies: 1
Views: 1,482
Posted By Marsheng
dbComboBox not updating

I've been round this a few times but no cigar.

I have a DB field XYZ in a database

The combobox has the datasource and datafield correctly specified.

In the Items list, I have the options...
Forum: General 06-13-2018, 10:59 AM
Replies: 6
Views: 1,858
Posted By Marsheng
Ok I found out that the Grey out is caused by not...

Ok I found out that the Grey out is caused by not running in Debug mode. I customized the screen and lost the debug option. Now fixed.

Still the app was hidden and still running so that was a...
Forum: General 06-12-2018, 09:02 PM
Replies: 6
Views: 1,858
Posted By Marsheng
Thanks Excellent reply. Just what I wanted.

Thanks Excellent reply. Just what I wanted.
Forum: General 06-12-2018, 09:00 PM
Replies: 6
Views: 1,858
Posted By Marsheng
The task manager did not list the program. Not...

The task manager did not list the program. Not even listed in running tasks. I tried to delete the exe and the message was, file in use.

Guess just another bug with Delphi 10.1 and some memory...
Forum: General 06-12-2018, 08:56 AM
Replies: 6
Views: 1,858
Posted By Marsheng
Close calling form.

I see this has been asked a few times on other forums but non have given me a solution I would like to use.

I have a login screen. Once the user has logged in with valid details, I want to...
Forum: General 05-24-2018, 10:31 PM
Replies: 7
Views: 2,046
Posted By Marsheng
I get "Raise and exception in MySqlException" in...

I get "Raise and exception in MySqlException" in the IDE mode only.

If I run the exe, no error. Is this normal ?
Forum: General 05-22-2018, 09:29 PM
Replies: 7
Views: 2,046
Posted By Marsheng
Thanks - Whoo - it works. I have emailed about...

Thanks - Whoo - it works. I have emailed about 20+ emails to forums to get this answer.

Ok, I have had a brief look but not found a solution as yet. Is it possible to change this setting at run...
Forum: General 05-22-2018, 09:07 AM
Replies: 7
Views: 2,046
Posted By Marsheng
No difference. See attached.

No difference. See attached.
Forum: General 05-21-2018, 09:59 PM
Replies: 7
Views: 2,046
Posted By Marsheng
SQL login and errors

I must admit I have never use try in my code before. I have always tried to write code that checks data before doing any function.

The problem and it may be my delphi understanding that is the...
Forum: General 04-25-2018, 10:01 PM
Replies: 3
Views: 1,877
Posted By Marsheng
I'm not even sure I understand the question. What...

I'm not even sure I understand the question. What is the application ? May help to understand what you are doing.
Forum: General 01-31-2018, 10:32 PM
Replies: 6
Views: 1,895
Posted By Marsheng
I have been using PHP prepared statements. Not...

I have been using PHP prepared statements. Not sure if anything can be transposed into Delphi.

https://www.w3schools.com/php/php_mysql_prepared_statements.asp
Forum: General 01-30-2018, 09:21 PM
Replies: 6
Views: 1,895
Posted By Marsheng
You might try V1:='SELECT FIRST '+NBROW+' *...

You might try

V1:='SELECT FIRST '+NBROW+' * FROM VW_MVT_LIV_FOURNISSEUR WHERE MVT_ID>='+NextRow+'AND MVT_ID<='+EndRow;

or something along this line. V1 must be a text line. Can't have embedded...
Forum: General 08-18-2017, 04:26 AM
Replies: 2
Views: 3,037
Posted By Marsheng
Often typing a question helps the grey matter...

Often typing a question helps the grey matter find a solution.

procedure TfMain.eQRKeyPress(Sender: TObject; var Key: Char);
var
sQR:string;
begin
if ord(Key) = VK_RETURN then begin
...
Forum: General 08-18-2017, 01:01 AM
Replies: 2
Views: 3,037
Posted By Marsheng
Not so simple, I read the data into a text box. I...

Not so simple, I read the data into a text box. I believe the terminating chars are CR and LF

However

procedure TfMain.eQRChange(Sender: TObject);
begin
if pos(#10,eQR.Text) <> 0 then
...
Forum: General 08-18-2017, 12:52 AM
Replies: 2
Views: 3,037
Posted By Marsheng
Reading barcodes and executing code

I have a new QR/barcode reader and it reads straight into a text field.

Once it reads a code, my PC bleeps like I had hit the carriage return button. I cannot find an associated event with this...
Forum: General 06-09-2017, 01:44 AM
Replies: 6
Views: 12,275
Posted By Marsheng
I sort of want to hijack this thread a bit which...

I sort of want to hijack this thread a bit which will help clarify a few things.

I'm in the same situation. I have a database running on a Raspberry PI with LAMP for the MYSql. I can access the...
Forum: General 04-11-2017, 10:58 PM
Replies: 2
Views: 2,776
Posted By Marsheng
To start with, look up dbedit in Delphi's help.

To start with, look up dbedit in Delphi's help.
Forum: General 02-09-2017, 07:38 AM
Replies: 9
Views: 2,940
Posted By Marsheng
Do you have a CONNECTION, TABLE and DATASOURCE...

Do you have a CONNECTION, TABLE and DATASOURCE setup as yet ?

Which SQL are you using ?
Forum: General 02-08-2017, 11:33 PM
Replies: 9
Views: 2,940
Posted By Marsheng
Once the file is opened, use the Delphi Command...

Once the file is opened, use the Delphi Command LOCATE. See Delphi Help.

This will place you on the record containing the match.

Cheers Wallace
Forum: General 01-05-2017, 09:18 PM
Replies: 6
Views: 5,859
Posted By Marsheng
Loop through the lines use Copy to get the 1st...

Loop through the lines
use Copy to get the 1st letter of each line
Check its ASCII valve and change if necessary.

Cheers Wallace
Forum: General 10-23-2016, 10:19 PM
Replies: 22
Views: 5,709
Posted By Marsheng
I use Heidi as well. Very good program and you...

I use Heidi as well. Very good program and you don't have to learn any SQL.

On that score, I run my MYSQL server on a Raspberry Pi. It runs 24/7 and uses around 5 watts. It is connected to my...
Forum: General 10-23-2016, 09:00 AM
Replies: 22
Views: 5,709
Posted By Marsheng
I presume you have made your own car to get to...

I presume you have made your own car to get to work !!
Forum: General 10-10-2016, 09:14 AM
Replies: 8
Views: 2,662
Posted By Marsheng
I have gone a long way since we last posted. ...

I have gone a long way since we last posted.

I'll post my code when finished.

I'm stuck on the syntax for the following

procedure FormScale (rHeiScale:real; rWidScale:real; sForm:String);...
Forum: General 10-05-2016, 08:27 PM
Replies: 8
Views: 2,662
Posted By Marsheng
Thanks I'll have a look at your suggestion. ...

Thanks I'll have a look at your suggestion.

What language do you use now ?
Forum: General 10-04-2016, 09:44 PM
Replies: 8
Views: 2,662
Posted By Marsheng
I tried Anchors but it does not work very well....

I tried Anchors but it does not work very well. If there was one DBGrid per form fine, but I have 4 and a few panes and it all moves all over the place.

One of the main problems is when ratio of...
Forum: General 10-04-2016, 09:42 AM
Replies: 8
Views: 2,662
Posted By Marsheng
Scaling pages

As there is no inherent page scaling on delphi or windows, I'm trying to do something custom.

I have a few DBGrids, buttons and labels on a form.

What I have tried with some success is to set...
Forum: General 10-04-2016, 01:18 AM
Replies: 4
Views: 2,161
Posted By Marsheng
Without going into all you code, I have a few...

Without going into all you code, I have a few thoughts.

Why 2 tables, have one with a completed flag.

If you need to run two tables that are linked, the ID field in the master needs to be...
Forum: General 09-29-2016, 07:41 PM
Replies: 22
Views: 5,709
Posted By Marsheng
Lookup ShowModal and Show

Lookup ShowModal and Show
Forum: General 09-29-2016, 09:35 AM
Replies: 22
Views: 5,709
Posted By Marsheng
Put your database tables connections etc in a...

Put your database tables connections etc in a DataModule.

If you go to the Fields Editor for a table, you can select multiple fields and copy/drag them to a from in one go.
Forum: General 09-29-2016, 09:33 AM
Replies: 22
Views: 5,709
Posted By Marsheng
On the form use DB aware controls. DBEdit....

On the form use DB aware controls.

DBEdit. They look directly at the database data.

On the main form, I have my child form conditions.

Eg append record
Delete

procedure...
Showing results 1 to 50 of 314

 
Forum Jump

All times are GMT. The time now is 05:58 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.