does this take care of my database structure? still looking for help on this.
lee
27 2016-07-18 16:50:58
Re: choose a heading (13 replies, posted in Reports)
hello Dmitry
thanks for the help. since i am new to this and i have no formal education on databases or programming could you point out the many structural mistakes for me so i can get this fixed and running properly? i would appreciate the info and help.
lee
28 2016-07-16 13:47:42
Topic: grouping (1 replies, posted in Reports)
howdo you do grouping in a report? how do you add new banners in the report?
29 2016-07-15 09:45:55
Topic: choose a heading (13 replies, posted in Reports)
i am trying to choose a heading (league) and then print all of the teams with their members belonging to the league. i have tried to follow the previous examples and havent been able to get it to work. dont know where i am going wrong with this.
30 2016-07-13 18:17:57
Re: Random error on development and preview (18 replies, posted in Reports)
hello Dmitry
it seems to be working fine. thank you. thank you. thank you i was really tired of the pop ups.
lee
31 2016-07-12 19:25:24
Re: Random error on development and preview (18 replies, posted in Reports)
hello Dmitry
there is still a bug in this method. when you pick the text object and place it the memo box comes up behind the report designer. it wont come to the front to enter text and with enough hidden gives the impression the project is locked up.
lee
32 2016-07-10 09:19:49
Re: Random error on development and preview (18 replies, posted in Reports)
i am really really getting tired of this problem when trying to work on reports. when are we going to get a fix please?
33 2016-07-01 10:30:52
Re: my code (2 replies, posted in General)
hello Dmitry
it looks like using a different event did fix it. thanks
lee
34 2016-06-28 09:31:11
Topic: my code (2 replies, posted in General)
procedure Form1_Edit1_OnChange (Sender: string);
begin
if (form1.edit1.value > 7) and (form1.edit1.Value < 10) or (form1.edit1.Value > 10) then
begin
showmessage('Value must be between 0 and 7 or 10.');
end
else
if form1.edit1.Value = 10 then
begin
form1.edit35.Value := form1.edit35.Value + 1;
form1.edit40.Value := form1.edit40.Value + 1;
form1.edit14.Value := form1.edit14.Value + 1;
end
else
begin
form1.edit40.Value := form1.edit40.Value + 1;
form1.edit14.Value := form1.edit15.Value + 1;
end;
recalculateall;
end;
is there something wrong with this block of code. i run it and when i change edit1 the other values; increment by 1 or more and values increment that arent supposed to and i get all kinds of wild results.
lee
35 2016-06-22 20:57:34
Re: Grouping records in a tablegrid (5 replies, posted in Script)
that would be a REALLY nice feature
lee
36 2016-06-18 10:56:35
Re: x=x+1 (6 replies, posted in General)
Hi Derek
is there anything around about using sql in the script/forms environment used by mvd? i read/watch as much as my ancient mind will take but find nothing about the way we use it. i get the commands to work in sqlite browser and sqlite studio but not it a script. then i start grasping at every permutation of what might or might not look like a command. by the time i get on here people wonder what in the world i was thinking.. then when i get the solution its nothing like the original command that worked.
lee
37 2016-06-17 09:20:04
Re: x=x+1 (6 replies, posted in General)
hello Derek
Thank you. You saved me and my project. i was tired of asking for help and not getting what i needed so this was my last try before scraping the whole thing and moving on to some of my more enjoyable hobbies.
i must be learning something in sql as i actually do understand what you were saying ;-) it works great and i hope i keeps me going for awhile. please dont go too far away though;-)
again, thank you for your help
lee
38 2016-06-15 09:14:03
Topic: x=x+1 (6 replies, posted in General)
in my script i have a statement to get a value from the record, add 1 to it and save it back each time a team plays (line 4). when i run the program the first time and pick the team 'holy cow', i get the value 1. when i run the program the second time and pick the team 'holy cow', i get the value 2. when i run the program every time after that and pick the team 'holy cow',i get the same value of 2. since the same team can play up to 20 - 25 times it should add 1 up to 20 - 25 times. can anyone fix this or help me fix it.
39 2016-06-09 15:22:46
Re: sqlexecute notworking (16 replies, posted in SQL queries)
if i pick a team then save it, the first time it adds 1. if i pick the same team again, it wont add the 1. it needs to add it every time the team plays not just the first time.
lee
40 2016-06-08 13:12:17
Re: sqlexecute notworking (16 replies, posted in SQL queries)
now i dont get the error but it doesnt add the 1
lee
41 2016-06-07 18:06:38
Re: sqlexecute notworking (16 replies, posted in SQL queries)
i get the same error
lee
42 2016-06-06 14:55:03
Re: sqlexecute notworking (16 replies, posted in SQL queries)
i want to take the value in wksplayed, add 1 to it and save it back to wksplayed using form1.edit22
thanks for the response
lee
43 2016-06-06 09:28:56
Re: sqlexecute notworking (16 replies, posted in SQL queries)
ok, so maybe that one was too tough. i have simplified my project and attached it. i have the same problem in line 5 of the script. i am trying to add 1 each time the team plays. the sql command seems to work in sqlite studio but when i run it here i get "could not convert variant of type (UniCodeString) into type (double)". any help would be appreciated.
lee
44 2016-05-26 20:30:15
Re: sqlexecute notworking (16 replies, posted in SQL queries)
can someone help with this problem?
lee
45 2016-05-25 17:07:10
Re: sqlexecute notworking (16 replies, posted in SQL queries)
Hi Dmitry
at this point ;i was grasping at straws trying to find anything to work. i had tried eerything i could think of and nothing worked so i posted here looking for help. what you see is my last attempt.
thanks
lee
46 2016-05-25 09:38:48
Re: sqlexecute notworking (16 replies, posted in SQL queries)
Hello Dmitry
all of them except the datetimepicker one. they are all basically the same so if this one
works, the rest should work as well.
line 68:
form1.edit42.Value := sqlexecute('select wksplayed from matches where id =' +inttostr(playersform.combobox1.dbitemid))+1;
thanks
lee
47 2016-05-24 21:02:15
Re: sqlexecute notworking (16 replies, posted in SQL queries)
Hi JB
sorry about that. thats what i get for not being more clear about my problems. the rptmene form is just something i work on a bit at a time when i cant; get other stuff to work. the sqlexecute problems i am having are in the script. trying to increase the count in fields every time a match is played.
lee
48 2016-05-24 09:42:58
Topic: sqlexecute notworking (16 replies, posted in SQL queries)
i am not able to get my sql statements to execute properly. i am sure it has to do with the id i am picking or syntax. is there any documentation available anywhere on using the sqlexecute in scripts, with forms, syntax etc. i dont seem to be able to find anything around. i have dl most of the samples but they dont explain the what and why of the statement.
thanks
lee
49 2016-05-20 07:53:11
Re: combobox questions (16 replies, posted in General)
hello again Derek
its nice to know that there wasnt a solution i was missing for lack of knowledge. i will have to think about your solution to decide which way i want to go with it.
the search button got put in by someone else. i dont use it so i just didnt pay any attention to it.
i did do an easier project acoupleof years ago. i did a magazine cataloging program that i thought came out fairly decent. otherwise i dont usually go for easy first, i justjumt in with both feet. been working on a visual basic program on and off for about 15 years. starting to get close to the end of it when i was asked to try this one.
thanks again for the help
lee
50 2016-05-19 07:44:28
Re: combobox questions (16 replies, posted in General)
i can get the teams to show up by adding a teams1 to the scorecard and teamplayers tables but cant get the team members to show up on the visitor side of the scorecard. tried every way i could think of for the last 30 or so hours. could use some help please.
thanks
lee