Posts by Paulo Fernandes • 123 points
7 posts
-
0
votes1
answer77
viewsQ: VBA/VB6 Status transfer of a current account document
I am developing a routine to allow you to change status of a shopping document, existing in Pending, for example from Pending to Unapproved state. The code: Function…
vb.netasked Paulo Fernandes 123 -
-1
votes1
answer83
viewsQ: V10 - VB.NET >User Validation/Correct Password
I am trying to validate the user and password if they are correct. The Code is this: Dim adm As New AdmEngine100.clsUtilizadores Dim statusLogin As AdmEngine100.clsUtilizadores.EnumLogin statusLogin…
vb.netasked Paulo Fernandes 123 -
0
votes1
answer125
viewsA: Error inserting data into recordset with oraOLEDB
To add new records, the recordset cannot be opened with adOpenStatic Try replacing with adOpenKeyset Rst.Open sSql, cnn, adOpenKeyset, adLockBatchOptimistic, adCmdText…
-
0
votes1
answer45
viewsA: Error while searching for date greater than 1 year DATADIFF() and DATAADD() function
The difference between the two methods is that in the first it uses difference in days, and in the second returns a date/time at the age of one. In leap years there is a difference in the actual…
-
3
votes2
answers490
viewsA: Using case in null field
I’m not sure I fully understood the question... Is this what you want? select Cod ,boletim ,case when boletim='S' then dt_enviado else NULL END dt_enviado FROM tb_boletim /*WHERE BOLETIM='S'*/…
-
4
votes4
answers9972
viewsA: How to get the month and current year in SQL?
Try it like this: select case month(getdate()) when 1 then 'Janeiro' when 2 then 'Fevereiro' when 3 then 'Março' when 4 then 'Abril' when 5 then 'Maio' when 6 then 'Junho' when 7 then 'Julho' when 8…
-
1
votes1
answer213
viewsA: Composite primary key definition syntax in the H2 Database engine
Try it like this: CREATE TABLE CONTACORRENTE ( Agencia INT NOT NULL, Numero INT NOT NULL, CONSTRAINT [PK_CONTACORRENTE] PRIMARY KEY ( Agencia,Numero ) )…