Search found 28 matches

by Dmilpsu
Fri Jan 27, 2017 6:31 pm
Forum: General
Topic: Duplicate records on Insert to Detail grid.
Replies: 0
Views: 2222

Duplicate records on Insert to Detail grid.

I can't find a workaround for this. I have the key set, I have autoinc set to yes in the table component. The tables are set in a master-detail at table component level. I populate the link field which points to the parent record in the onrowinsert routine. A check of the SQL log shows two insert co...
by Dmilpsu
Tue Aug 23, 2016 9:08 am
Forum: General
Topic: Delete confirmation
Replies: 4
Views: 4239

Re: Delete confirmation

got it working as follows.

function JTPlatinumGrid1JSRowDeleting($sender, $params)
{
?>
//begin js
return confirm("Proceed with Removal?")
//end
<?php
}
by Dmilpsu
Tue Aug 23, 2016 9:06 am
Forum: General
Topic: Failure to Post trap
Replies: 4
Views: 4004

Re: Failure to Post trap

worked great, thanks
by Dmilpsu
Fri Aug 19, 2016 2:59 pm
Forum: General
Topic: Failure to Post trap
Replies: 4
Views: 4004

Re: Failure to Post trap

How do I test for edit mode for a grid or do I need to look at the dataset?
by Dmilpsu
Thu Aug 18, 2016 6:54 pm
Forum: General
Topic: Delete confirmation
Replies: 4
Views: 4239

Re: Delete confirmation

It is global, using html5builder
by Dmilpsu
Wed Aug 10, 2016 1:53 pm
Forum: General
Topic: Duplicate rows on insert
Replies: 3
Views: 3832

Re: Duplicate rows on insert -- Disregard

Looking more and more like some corruption in html5 build and MySQL files. Going to clear that out and reinstall on new computer.
by Dmilpsu
Tue Aug 09, 2016 2:43 pm
Forum: General
Topic: Duplicate rows on insert
Replies: 3
Views: 3832

Re: Duplicate rows on insert

i have rewritten this program multiple times. Every time i get to the point where I add an LookupCombobox editor in the program column (does not matter if I am using a table or query component), the duplicate rows start showing up. Even if I remove the column containing the LookupCombobox, it still ...
by Dmilpsu
Tue Aug 09, 2016 2:18 pm
Forum: General
Topic: Row select for read only grid
Replies: 8
Views: 8704

Re: Row select for read only grid

That did it, thanks
by Dmilpsu
Sun Aug 07, 2016 9:18 am
Forum: General
Topic: Row select for read only grid
Replies: 8
Views: 8704

Re: Row select for read only grid

my mistake, I do have a Javascript routine for OnSelect. Not sure how I missed it. function JTPlatinumGrid1JSSelect($sender, $params) { ?> //begin js var row = JTPlatinumGrid1.SelectedRow; document.getElementById("Edit1").value = JTPlatinumGrid1.getCellHTML(row,0); document.getElementById("Edit2").v...
by Dmilpsu
Fri Aug 05, 2016 9:46 am
Forum: General
Topic: Duplicate rows on insert
Replies: 3
Views: 3832

Re: Duplicate rows on insert

SQL for the query is select idStudent,SName, PName, Program,date_enrolled,date_completed, PIN from student, program where program=idProgram PName is the column form table program, all other columns are form student and I have set student as the Base table in the query. I have no issues on any other ...