Hi everyone,
My table:
CREATE TABLE `D_PREBILL` +
(`INVOICE_ID` INTEGER , +
`PRE_INVOICE_NB` INTEGER , +
`IEX_INV` TEXT (10) , +
`PRE_FLAG` TEXT (1) , +
`PRE_TS` DATETIME , +
`PRE_USER` TEXT (10) )
My eep:
set var vinvoiceid integer = 9999
set var v_header_carinv text = 'trouble001'
set var vtimestamp datetime = (datetime(.#date,.#time))
set var vuser text = (cval('netuser'))
SET VAR vpreinvnbr INTEGER = NULL
SET VAR vtextinvnbr TEXT = NULL
SELECT (MAX(pre_invoice_nb)+1) INTO vpreinvnbr FROM d_prebill
SET VAR vtextinvnbr TEXT = ((SGET((CTXT(.vpreinvnbr)),4,1)) + '-' +
(SGET((CTXT(.vpreinvnbr)),4,5)))
INSERT INTO d_prebill +
VALUES (.vinvoiceid,.vpreinvnbr,.v_header_carinv,'N',.vtimestamp,.vuser)
I get message "Incorrect number of values for this table"
I'm crossed-eyed from trying to figure this one out.
TIA,
Claudine :)
