neophpexecsql - Forum

Forum Navigation
You need to log in to create posts and topics.

neophpexecsql

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: