
Quote from Phil78 on November 2, 2026, 6:33 pmHi @luishp
I'm trying to rewrite an application originally written with another software program that is starting to have compatibility issues with PHP.
I'm managing two tables: a master table and a detail table.
neoTableConfigDB “cEntrainement” “dblpg” “entrainement” ‘Datesoir’ (master)
neoTableConfigDB “cPresence” “dblpg” “presence” “Nom” (detail)First, the primary key for the “presence” table is “Date, Nom” Whether I enter just ‘Nom’ or “Date, Nom” I get the error “Database does not exist or invalid query” when trying to insert data.
neoPhpExecSql "dblpg" "insertPresence" "[dtSelect]::[Nom]::[Heure]" "RechargePresence"
$sqlQuerys[3]="insert into presence values (?,?,?)
When debugging, we can see that the parameters are filled in correctly : parameters "2026-11-06::EXTERNE::18h".
Next, regarding the master entrainement, if I try to update the “Observation” field, I also get an error (inside config.zip).
neoPhpExecSql "dblpg" "selectEntrainement" "" "GetEntrainement"
neoTableEditColumnAsText "cEntrainement" "4" "inline" "" "" "" false "" true ""
neoTableSetColumn "cEntrainement" 1 "Nb" "Nb" "55px" false false false "FmtCol1"
neoTableSetColumn "cEntrainement" 2 "Jour" "Jour" "70px" false false false ""
neoTableSetColumn "cEntrainement" 3 "Datesoir" "Date" "75px" false false false "FmtDate"
neoTableSetColumn "cEntrainement" 4 "Observation" "Observation" "" false true false ""
neoTableInitTable "cEntrainement" "fr-FR" 0 "Table" false false false false false "EventEntr"
neoTableLoadData "cEntrainement" [Entr]I don't understand what is wrong ! Thanks for your help
Hi @luishp
I'm trying to rewrite an application originally written with another software program that is starting to have compatibility issues with PHP.
I'm managing two tables: a master table and a detail table.
neoTableConfigDB “cEntrainement” “dblpg” “entrainement” ‘Datesoir’ (master)
neoTableConfigDB “cPresence” “dblpg” “presence” “Nom” (detail)
First, the primary key for the “presence” table is “Date, Nom” Whether I enter just ‘Nom’ or “Date, Nom” I get the error “Database does not exist or invalid query” when trying to insert data.
neoPhpExecSql "dblpg" "insertPresence" "[dtSelect]::[Nom]::[Heure]" "RechargePresence"
$sqlQuerys[3]="insert into presence values (?,?,?)
When debugging, we can see that the parameters are filled in correctly : parameters "2026-11-06::EXTERNE::18h".
Next, regarding the master entrainement, if I try to update the “Observation” field, I also get an error (inside config.zip).
neoPhpExecSql "dblpg" "selectEntrainement" "" "GetEntrainement"
neoTableEditColumnAsText "cEntrainement" "4" "inline" "" "" "" false "" true ""
neoTableSetColumn "cEntrainement" 1 "Nb" "Nb" "55px" false false false "FmtCol1"
neoTableSetColumn "cEntrainement" 2 "Jour" "Jour" "70px" false false false ""
neoTableSetColumn "cEntrainement" 3 "Datesoir" "Date" "75px" false false false "FmtDate"
neoTableSetColumn "cEntrainement" 4 "Observation" "Observation" "" false true false ""
neoTableInitTable "cEntrainement" "fr-FR" 0 "Table" false false false false false "EventEntr"
neoTableLoadData "cEntrainement" [Entr]
I don't understand what is wrong ! Thanks for your help
Uploaded files: