SELECT dbo.gene.gene_id, dbo.gene.SNPper_Gene_id FROM dbo.gene ; SNPper retrieval running
",SNPper_GeneHTML,1)#> UPDATE #table# SET gene_description='#left(mid(SNPper_GeneHTML,start+14,end-start-14),255)#', row_entered_date='#ACTIME#',row_entered_user='Wjst',row_active=1 WHERE #table#.gene_id=#gene_id#; INSERT INTO #table# ( dbsnp,gene_id,chrom,sequence_type,SNPper_Position,SNPper_Allele,SNPper_Relpos,SNPper_Role,SNPper_Function, row_entered_date,row_entered_user,row_active) VALUES ( '#DBSNP#','#gene_id#','#chrom#','SNP','#SNPper_Position#','#SNPper_Allele#','#SNPper_Relpos#','#SNPper_Role#','#AA#', '#ACTIME#','Wjst',1) UPDATE dbo.sequence SET dbSNP_submitter='#submitter#' WHERE dbo.sequence.dbSNP='#dbSNP#'; INSERT INTO #table# ( exon_nr,gene_id,SNPper_PositionStart,SNPper_PositionEnd,chrom, row_entered_date,row_entered_user,row_active) VALUES ( '#loop_count#','#gene_id#','#SNPper_PositionStart#','#SNPper_PositionEnd#','#chrom#', '#ACTIME#','Wjst',1) #gene_id# done