i put the comment after the first rows procedures to indicate the text was the same for the rest of the rows. same goes for the comment after the first column of procedures. solving the problem for the first row/column i think will solve it for the rest of the rows/columns
77 2016-04-10 09:23:14
Topic: adding rows and column on a form (13 replies, posted in Script)
i have 5 rows of changing numbers and 5 columns of changing numbers, i use the script onchange to add the row and it works fine. the problem arises when trying to add the columns. i get erros sainf the on change has already been defined the scrips is somethinglike this:
procedure CalculateTotal1;
begin
Score.edit1.Value := Score.edit1.Value + Score.edit1.Value + Score.edit1.Value ;
end;
procedure Score_edit1_OnChange (Sender: string);
begin
CalculateTotal1;
end;
procedure Score_edit2_OnChange (Sender: string);
begin
CalculateTotal2;
end;
procedure Score_edit3_OnChange (Sender: string);
begin
CalculateTotal3;
end;
//the same for the rest of the rows
procedure CalculateColTotal1;
begin
Score.edit13.Value := Score.edit1.Value + Score.edit5.Value + Score.edit9.Value;
end;
procedure Score_edit1_OnChange (Sender: string);
begin
CalculateColTotal1;
end;
procedure Score_edit5_OnChange (Sender: string);
begin
CalculateColTotal1;
end;
procedure Score_edit9_OnChange (Sender: string);
begin
CalculateColTotal1;
end;
//the same for the rest or the columns
begin
end.
the first error would be edit one is redifined
78 2016-04-07 20:46:40
Re: saving to different table (19 replies, posted in General)
thanks for th resource. just downloaded their little course. that add script is one that i tried to make work for me. doesnt do anything. no errors. just kinda sits there and makes me look stupid. look forward to the delphi course. never too old to learn i guess. really appreciate the help. this place is terrific for the help provided.
lee
79 2016-04-07 17:07:18
Re: saving to different table (19 replies, posted in General)
good. what info is available on scripting. i do dl other projects and have tried to adapt some of the scripts. i have two that i am trying to get to work but i cant seem to be able to get them to do anything. they dont give any errors. they just dont work.
80 2016-04-07 01:21:19
Re: saving to different table (19 replies, posted in General)
sorry, i lost myself for a bit there. the filter is in the properties for a textbox. set to s% allow to search on first character. before i get any more vested in this project i need to find out how much i can do. a year in 8 ball consists of 2 seasons, each 2x weeks long. a players handicap is based on the average of the weekly score of each past 2 seasons plus all of the weeks of the current season. as he finishes the current season one past seasons scores drop off. am i going to be able to do that with this. on the scoresheet, the scores are manually put in. i found a script in the general forum to add the totals on the form but it doesnt seem to work. i dont get any errors, it just doesnt do anything.sorry for alll the questions and problems.
lee
81 2016-04-06 07:19:31
Re: saving to different table (19 replies, posted in General)
new version of mvd looks good. the new file you sent works fine also. i realy do appreciate all of the time and effort you put into helping me. i ope i can get pretty far without any more help but i anticipate i will probably need some when i get to printing out the reports. i did notice there used to be a filter in search that would allow you search on one character. that does not seem to be available any more. is there a work a round or fix for that. once again, thank you for your help
lee
82 2016-04-05 21:53:46
Re: saving to different table (19 replies, posted in General)
well, i had to download the new version before i could look at it. i was hoping to get by on my free version until i could see if this was going to work out for me. yours worked fine. i tried to copy any chnges to mine but still no luck there. guess i will have to use our version. i do need the names to show up instead of the id in the grid tho. how do i go about fixing that. man, this sure would have come a lot easier 50 years ago.
lee
83 2016-04-05 19:29:50
Re: saving to different table (19 replies, posted in General)
deleted that file. still get the error "table dteamsset has no column nammed dplayer" when i try to save. steps to run are: add my name only to address, go to team set up, put number 1 in team number, any name in team name and pick my name for player 1. then save. then i get above error.
lee
84 2016-04-05 16:59:16
Re: saving to different table (19 replies, posted in General)
unfortunately my version was too old to run that sample. i have the relationships set up as you said. i am enclosing my project, which is quite large and just getting started, so you can better see what i am trying to do. the forms i am currently talking about are ViewTeam and TeamSetup. the tables; are dplayer and dteamset. hope this helps
lee
85 2016-04-05 09:41:18
Re: saving to different table (19 replies, posted in General)
as a side note, as i get further on in this project i am going to run into this exact same problem with another form.
86 2016-04-05 08:37:28
Re: saving to different table (19 replies, posted in General)
the two tables are dplayer and dteamsetup. the fields in the player are the regular address information(name, address, phone,etc). the fields in teamsetup are team number, team name and player1 - player4.there are going; to be many teams. i have the relationshhip set up between the player fields and the name fields. i have the object inspector set the way you said. i save to dteamsetup. i get the error "there is no column dplayer in dteamsetup". it probably would work if i didnt try to save the team number and name but that is what i do my search on. i hope this was able to make it a little more clear what i am trying to do. thanks again for your help
87 2016-04-04 19:28:32
Topic: saving to different table (19 replies, posted in General)
how do i pick a name from a combo box (tied to a contact table) and want to save it to a team table as player1. would appreciate any and all help.
88 2014-10-25 16:42:34
Topic: img not in search (1 replies, posted in General)
i save an image to database and when i do a search later it doesnt show. i will print from the search form fine. i seem to be missing something or have something misnamed.
89 2014-10-21 08:09:40
Re: How to clear picture in a DBImage ? (4 replies, posted in Script)
same result
90 2014-10-20 18:24:52
Re: How to clear picture in a DBImage ? (4 replies, posted in Script)
i keep getting "undeclared identifier. "Clear"" . i am using the script in the "loadimagefrom data base"and trying to copy it over and make it useable for me.
91 2014-09-09 09:44:56
Topic: relationships (1 replies, posted in General)
i am making a magazxine collection database. i have the forms and tables set up correctly i think. the way its supposed to work is i can add a magazine name, all of the articles with descriptions and pictures. when i add a description i can add itto oneof the tables but not to the rest. i have tried changing things around every which way but all i seem to get are error messages of one sort or another. my tables are magazine, article, description and picture. article is related to magazine and description and picture are related to article.
92 2014-08-17 17:49:02
Topic: stop script (1 replies, posted in General)
being new i hit the script button and now i cant get out of it. how do i turn it off