dm.Q_next_node.Active:=False; dm.Q_next_node.SQL.Clear; dm.Q_next_node.SQL.Add('SELECT TRIM(TRAILING CONCAT( ',', TRIM(LEADING CONCAT(SUBSTRING_INDEX( NODE_ID,',', FIND_IN_SET( '0', NODE_ID ) -1 ) , ',' )FROM NODE_ID ) )FROM TRIM(LEADING CONCAT( SUBSTRING_INDEX(NODE_ID, ',', FIND_IN_SET( '0', NODE_ID ) -2 ) , ',' )FROM NODE_ID ) ) +0 AS lastnodevalue, CONCAT( CONCAT(SUBSTRING_INDEX(NODE_ID, ',', FIND_IN_SET( '0', NODE_ID ) -2 ) , ',' ) , TRIM(TRAILING CONCAT( ',', TRIM(LEADING CONCAT(SUBSTRING_INDEX(NODE_ID, ',', FIND_IN_SET( '0', NODE_ID ) -1 ) , ',' )FROM NODE_ID ) )FROM TRIM(LEADING CONCAT( SUBSTRING_INDEX(NODE_ID, ',', FIND_IN_SET( '0', NODE_ID ) -2 ) , ',' )FROM NODE_ID ) ) +1, SUBSTRING(NODE_ID, LOCATE( ',0', NODE_ID ) ) ) AS nextnodeid FROM node_id WHERE parent = '''+DBEdit31.Text+''' ORDER BY lastnodevalue DESC LIMIT 1 '); dm.Q_next_node.Active:=True; knapa tu query g jalan yah. dibilangnya too many actual parameter? please mohon bantuan nya

heheheh rumit yaa ? coba perhatikan tanda ' di setiap kutip.... contoh 'SELECT TRIM(TRAILING CONCAT( '+','+', TRIM(LEADING CONCAT(SUBSTRING_INDEX( NODE_ID,'+','+', <--- :)

makasih mas sudah saya coba tp tetep g mau dia. format nya sudah saya ganti jd : dm.Q_next_node.Active:=False; dm.Q_next_node.SQL.Clear; dm.Q_next_node.SQL.Text:='SELECT TRIM(TRAILING CONCAT( '+','+', TRIM(LEADING CONCAT(SUBSTRING_INDEX( NODE_ID, '+','+', FIND_IN_SET( "0", NODE_ID ) -1 )'; dm.Q_next_node.SQL.Text:=' , '+','+' )FROM NODE_ID ) )FROM TRIM(LEADING CONCAT( SUBSTRING_INDEX(NODE_ID, '+','+', FIND_IN_SET( "0", NODE_ID ) -2 ) , '+','+' )FROM NODE_ID ) ) +0 AS lastnodevalue, CONCAT( CONCAT(SUBSTRING_INDEX(NODE_ID, '+','+', FIND_IN_SET( '+'0'+', NODE_ID ) -2 ) , '+','+' ) ,'; dm.Q_next_node.SQL.Text:='TRIM(TRAILING CONCAT( '+','+', TRIM(LEADING CONCAT(SUBSTRING_INDEX(NODE_ID, '+','+', FIND_IN_SET( "0", NODE_ID ) -1 ) , '+','+' )FROM NODE_ID ) )FROM TRIM(LEADING CONCAT( SUBSTRING_INDEX(NODE_ID, '+','+', FIND_IN_SET( "0", NODE_ID ) -2 ) , '+','+' )FROM NODE_ID ) )'; dm.Q_next_node.SQL.Text:='+1, SUBSTRING(NODE_ID, LOCATE( '+',0'+', NODE_ID ) ) ) AS nextnodeid'; dm.Q_next_node.SQL.Text:='FROM node_id WHERE parent = '''+DBEdit31.Text+''' ORDER BY lastnodevalue DESC LIMIT 1'; dm.Q_next_node.Active:=True; muncul error : general sql error. [MySQL]you have an error in your SQL syntax ; check manual that coresponds to your MySQL server version for the right syntax to use near 'FROM node_id WHERE parent = '''+DBEdit31.Text+''' ORDER BY lastnodevalue DESC LIMIT 1' bingung saya mas heuheu. mohon bantuan nya para master

ok makasih semuanya, problem sudah clear. pk query table lalu dibikin parameter.