Information générale
Catégorie:
Codage, syntaxe et commandes
Ok, now I've got a second question. Is there a limit to either the # of characters or parameters that can be sent with an sqlexec command? Here's what I've got so far.
vtest=sqlconnect('TESTSPAN','SPANFM','SPANFM')
dtoday=DATETIME()
vtest3=sqlexec(vtest,;
"insert into pmwrkord (pmwrkord_code,spbldinf_code,spbldrom_code,;
pmshop_code,pmpricd_code,pmactv_code,pmbldsys_code,pmfacprj_code,;
its_current_date,status,wo_type) ;
values (9200014,'ALKICC','101','SSS','2','EVEN',;
'SERV','WP31401',?dtoday,'O','D')")
vtest4=sqldisconnect(vtest)
If I add another field/value combination it fails by saying I have a syntax error and I've swapped the field/value so I know it's not a spelling issue. Is there something else I'm missing?
TIA
Laurisa Watkins
Seattle Parks Dept.
Précédent
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