Sir Tom,
I'm adding a record on the network with only one access table (dummy-26 fields) and also i've tried using only one SQLExec statement but unluckily it adds a record but not all the data (sometimes not at all) on the form was inserted on the access table.
The statement goes like this:
lcsql="insert into dummy(fieldnames) values (?da, and so on ...)"
=sqlexec(filehandle,lcsql)
the first statement gets a syntax error due to its long statement but i have to resort on dividing those statements into 3 by concatenation
"+;" but still it cannot add the whole data from the input of a VFP form.
Expecting your reply. Thanks and more power.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement