Click here to Skip to main content
15,391,100 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: code for calculation of mark for agroup quiz Pin
Patrice T13-Jan-20 15:32
mvePatrice T13-Jan-20 15:32 
Questionvisual basic 6.0 Pin
Member 1469850023-Dec-19 20:26
MemberMember 1469850023-Dec-19 20:26 
AnswerRe: visual basic 6.0 Pin
Richard MacCutchan23-Dec-19 21:36
mveRichard MacCutchan23-Dec-19 21:36 
AnswerRe: visual basic 6.0 Pin
Dave Kreskowiak25-Dec-19 8:34
mveDave Kreskowiak25-Dec-19 8:34 
QuestionExcel Data Export Pin
RajaMohammed.A19-Dec-19 23:56
MemberRajaMohammed.A19-Dec-19 23:56 
QuestionRe: Excel Data Export Pin
Richard MacCutchan20-Dec-19 0:25
mveRichard MacCutchan20-Dec-19 0:25 
AnswerRe: Excel Data Export Pin
Johan Hakkesteegt27-Jan-20 21:54
MemberJohan Hakkesteegt27-Jan-20 21:54 
Questionhow to use a variable for sequencer Pin
nrdroque12-Dec-19 4:17
Membernrdroque12-Dec-19 4:17 
hi there.

im creating a label sequencer for 3 produts and i'm trying this but with no success

sql_query.CommandText = "insert into tablelabel02 with (tablockx) (nome_posto, ordemfabrico, serialnumber, referencia,dataetiqueta,qrgerado,data,operador,posx,posy,impressora,controlo)output inserted.qrgerado
    values (@posto, @ordemfabrico, next value for '" & sequenceID & "' , @refcode, replace(cast(convert(varchar,getdate(),5) as varchar(10)),'-','/'),
    @refcode+replace(cast(convert(varchar,getdate(),5)as varchar(10)),'-','')+right('000'+cast((next value for '" & sequenceID & "' )as varchar (4)),4), getdate(), @operador,@labelx,@labely, @impressora, 'xx' );"


for each product i have created a sequence in ms sql, so when i inserted the production order number, i can sort what sequencer to use but i cant use it as sequenceID variable.
i tried
next value for seq_a 
and it works.
with
next value for '" & sequenceID & "'
not working

in resume:
i want to use next value for @variable if possible
AnswerRe: how to use a variable for sequencer Pin
dan!sh 12-Dec-19 5:04
professional dan!sh 12-Dec-19 5:04 
GeneralRe: how to use a variable for sequencer Pin
nrdroque12-Dec-19 5:18
Membernrdroque12-Dec-19 5:18 
QuestionCount duplicates in a large richtextbox (1000+ lines) Pin
VBwolf11-Dec-19 9:23
MemberVBwolf11-Dec-19 9:23 
AnswerRe: Count duplicates in a large richtextbox (1000+ lines) Pin
Dave Kreskowiak11-Dec-19 12:16
mveDave Kreskowiak11-Dec-19 12:16 
QuestionHow can my app look the same on all machines? Pin
Member 146743679-Dec-19 14:17
MemberMember 146743679-Dec-19 14:17 
AnswerRe: How can my app look the same on all machines? Pin
CHill6010-Dec-19 1:46
mveCHill6010-Dec-19 1:46 
AnswerRe: How can my app look the same on all machines? Pin
Dave Kreskowiak10-Dec-19 4:59
mveDave Kreskowiak10-Dec-19 4:59 
AnswerRe: How can my app look the same on all machines? Pin
Gerry Schmitz10-Dec-19 8:14
mveGerry Schmitz10-Dec-19 8:14 
QuestionHow can I get an free installer that registers .dll and .ocx components as I install my app? Pin
Member 146743679-Dec-19 14:17
MemberMember 146743679-Dec-19 14:17 
AnswerRe: How can I get an free installer that registers .dll and .ocx components as I install my app? Pin
CHill6010-Dec-19 1:44
mveCHill6010-Dec-19 1:44 
AnswerRe: How can I get an free installer that registers .dll and .ocx components as I install my app? Pin
gvidali7-Feb-20 3:09
Membergvidali7-Feb-20 3:09 
Question[Solved] - How to retrieve value inserted to variable Pin
nrdroque5-Dec-19 23:26
Membernrdroque5-Dec-19 23:26 
AnswerRe: How to retrieve value inserted to variable Pin
dan!sh 6-Dec-19 0:41
professional dan!sh 6-Dec-19 0:41 
AnswerRe: How to retrieve value inserted to variable Pin
Richard Deeming6-Dec-19 1:05
mveRichard Deeming6-Dec-19 1:05 
GeneralRe: How to retrieve value inserted to variable Pin
nrdroque6-Dec-19 3:40
Membernrdroque6-Dec-19 3:40 
GeneralRe: How to retrieve value inserted to variable Pin
Eddy Vluggen6-Dec-19 8:49
professionalEddy Vluggen6-Dec-19 8:49 
QuestionMS Chart is adding extra X axis when doing multiple series. Pin
Member 1435926026-Nov-19 8:31
MemberMember 1435926026-Nov-19 8:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.