Posts by pnet • 14,727 points
909 posts
-
2
votes3
answers52
viewsA: I did a project using the VS2015 SPA template. I want to take the start login page
I managed to remove. I did so: In Controller Homecontroller, I removed the attribute [Authorize] and in the View Index I Commented/Removed these lines: @Scripts.Render("~/bundles/knockout")…
-
-2
votes1
answer89
viewsQ: Sql server error on the hosting server
I’m making a website, through the Visual Studio template. With me it works, but when I go up to the server and when I soon, it gives me the error below. I used as template the SPA and Visual Studio…
-
1
votes3
answers52
viewsQ: I did a project using the VS2015 SPA template. I want to take the start login page
I made a project and when I rotate it is the login page that is the first to be shown. I would like to know how I make to leave the home page as main and not login. How I do this?
-
1
votes4
answers54
viewsQ: Doubt about the use of the VS2015 SPA Template
I need to do a routine to send email, through a form I made, using the VS2015 SPA Template. I put two buttons, Cancel and Send. The question is not in the code of the email, but how to assign the…
-
1
votes1
answer27
viewsQ: C#(SPA) template does not run
I was auditioning with the Single Page Application, using the visual studio template. Well, I created the project and did nothing, nothing at all, I just created the project and I circled and…
-
0
votes1
answer3342
viewsQ: Generate database script with structure and data
Backup is not possible to do, because it depends on permission from France and etc. So, the solution we found here was to try to generate a script that copies not only the structure of the tables, I…
-
0
votes1
answer23
viewsQ: Radiobutton is loose in the form
I took a project and the screen has 3 radiobuttons. I needed to add a room. I went in the component palette and gave two clicks. Making the appropriate changes, like caption, position I ran the…
visual-basic-6asked pnet 14,727 -
0
votes1
answer73
viewsA: Update and maintain update code when it repeats
I decided to put a top 1, as the colleague Ismael had told me. I put in the subquery that is inside the while and solved. Thanks to all.
-
0
votes1
answer73
viewsQ: Update and maintain update code when it repeats
I did this update: declare @rx_num varchar(20), @id_oit_max int, @id_exm_rea int, @id_xfc_novo int, @id_xfc int = 0 declare oit_cur cursor for select pl.rx_num, er.id_exm_rea, er.id_xfc from…
-
2
votes1
answer236
viewsQ: Debug Proc in sql server 2014 database
I use Sql Server 2014. I am having problems with Stored Procedure, because when running with certain filters, it triggers this error: Message 512, Level 16, Status 1, Procedure…
-
1
votes1
answer351
viewsQ: To show the project’s open Forms in the VB6 IDE in tabs
How to show in the VB6 IDE on tabs, the project’s open Forms? In Delphi it already shows all, but in VB6 I don’t know, I’ve never seen VB6, it’s the first time. How to close open Forms? This in time…
-
1
votes2
answers950
viewsQ: If an int variable does not receive anything from select it is zero or not
Let’s say I have this block: declare @teste int declare teste_cur cursor for select campo1 from tabela ..... while @@fetch_status = 0 begin set @teste = 0 select @teste = campo1 from tabela where…
-
0
votes1
answer59
viewsA: Condition(if) does not work for entering data
Changed and solved. I did so: set nocount on declare @id_novo_rea int, @id_exm_rea int, @id_oit int, @i int declare exame_cur cursor for select distinct er.id_exm_rea from t_cmo_Exame_Realizado er…
-
0
votes1
answer59
viewsQ: Condition(if) does not work for entering data
I did this query to insert data. I should only insert data if there is nothing in the OIT1980 table. Then I mounted a cursor and walked and put an IF. If I remove the IF, it works, but if I leave it…
-
1
votes1
answer667
viewsQ: Assign a cursor value to a table column
I have a cursor. I need an Insert to insert the value of each cursor position into a table. How do I do this? I need to enter the cursor value exame_cur. My code below: set nocount on declare…
-
3
votes3
answers8033
viewsQ: Do not repeat records in a Join
I have two tables: one with 1009 records and another 11949. When I do a Join, I have 11949 records, of which 1009 table records are repeated several times. I need to select with Join, but bring only…
-
1
votes1
answer28
viewsQ: My executable is still in an old version
I compile the VB project and when I open the folder to get the generated exe, it is still with old date, which in this case is 18/03/2017 and not 20/04/2017. Is there anything I should do? I compile…
-
0
votes1
answer707
viewsQ: Bulk insert into a table
I have two proc’s that my VB system already uses. One for Insert and one for Update. I need to use it now, directly in the database. The target table has a composite key, as follows. A field called…
-
0
votes0
answers228
viewsQ: Error compiling project in Visual Basic 6
When I try to compile my project gives this error: I don’t know if it’s a problem with the Crystal Reports (See the background in blue), or if it’s really the problem of Visual Basic 6. I have never…
-
1
votes4
answers11284
viewsQ: How to create temporary mirror table in another
It is possible to create a mirror temporary table in another? Example: Let’s say I have in my bank a table with 60 fields. I would like to create a temp with the name #table with the same table…
-
6
votes2
answers43536
viewsQ: Error doing Insert - String or Binary data > would be truncated
By making this Internet: INSERT INTO t_cmo_oit1980_leitura(id_oit_let,id_oit,rx_num, dt_rx) SELECT (1), (SELECT id_oit FROM t_cmo_oit1980 WHERE id_oit = 6574), (SELECT rx_num FROM…
-
2
votes1
answer763
viewsQ: Insert with two different selects
That one of mine insert is not working. insert into t_cmo_oit1980 (id_oit, id_exm_rea) select max(id_oit) + 1 from t_cmo_oit1980, select id_exm_rea from t_cmo_Exame_Realizado where id_exm = 3936 and…
-
0
votes1
answer1553
viewsQ: Popular table in sql server with data coming from an excel spreadsheet
How I create a script or via DTS, a popular form of a table in the sql server 2014, with information from a spreadsheet of excel? The worksheet has several columns, but only two columns will be…
-
3
votes3
answers419
viewsQ: How to know if a key in sql server is Identity
How do I know if a key in sql server is Identity? How do I find out? The version is 2014.
-
2
votes2
answers121
viewsQ: Error compiling project with VB 6. Pass to . Net
I am not a developer in VB. I took a project for 5 days, through a consulting, but it should be all in SQL Server. Well, it turns out, that some changes on screen should be made. I opened VB 6…
-
0
votes1
answer40
viewsA: Error trying to create a Proc in the bank
Following Motta’s guidelines, which I attribute to him the resolution of my problem, I did the following to solve it. I commented GRANT at the end of PROC and surrounded the PROC in development…
-
0
votes1
answer40
viewsQ: Error trying to create a Proc in the bank
I’m trying to run a stored procedure in the bank and it’s giving this message: Cannot Grant, Deny, or revoke Permissions to sa, dbo, Entity Owner, information_schema, sys, or yourself How do I fix…
-
2
votes1
answer48
viewsQ: Only spend a year in a proc of sql server 2014
I made a filter in a PROC of my own and I’m not getting any results. Running proc did not give any error, but it does not bring any result and I do not know if it is correct. The colleague said I…
-
0
votes0
answers373
viewsQ: Changing data fields and label in a Crystal Report
I have a report and need to change the layout, IE, remove a label and a data and change another label and other data. I have move, but it does not work. See image and even Crystal version. I need to…
-
0
votes1
answer352
viewsQ: Error trying to recreate a table with code first(Migration)
I’m following Eduardo Pires' tutorial on DDD + Asp.Net MVC 5 + Ioc and so on. Well, in the first attempt to create the bank and the client table, it was a gem. It turns out, Eduardo made some…
-
1
votes1
answer1495
viewsQ: When opening Solution, folders with projects do not appear
I created a Solution, based on the video of Eduardo Pires. I saved and went to do something else. Well, when you reopen Solution, the folders with the projects do not appear, leaving only the…
-
3
votes1
answer980
viewsQ: meaning of Redim in classical Asp
What does that mean? redim preserve VetRede(iCont) Vetrede is a variable declared in Asp(I put this, otherwise the body of the question is outside the standards, few words), eheheheh!…
-
0
votes3
answers1971
viewsQ: Calling javascript function from within a Classic ASP block
How do I run a javascript function from inside a classic Asp block. The js function is not in the same file, it is out, in another file. <% if(MINHA_FUNÇÂO_JS_AQUI) response.write "<img…
-
7
votes4
answers2310
viewsQ: I cannot disable a checkbox with enable = false
I need, in certain situations, to enable a checkbox or not. I made a Javascript function and I can’t enable/disable it. Here is the function: function ValidaCampoInserirAutorizacao(){ var vTussMed =…
javascriptasked pnet 14,727 -
1
votes1
answer31
viewsQ: Javascript function is giving error
This function is not even being called and is giving error. It does not say exactly the error, but it gives error when entering the form: function ChangeSituacao(){ var vRads =…
javascriptasked pnet 14,727 -
15
votes2
answers310
viewsQ: Go with a ";" at the beginning of the loop, which means
I picked up a code with a code like this: for (; indField > 0 && indMask > 0; ) What does that mean ";" at the beginning and end of the command?…
-
1
votes0
answers34
viewsQ: I don’t have the option to delete from the project to a Folder and its files
We used to have our own Nuget to install our DLL’s and so on. Well, now we no longer use Nuget. It turns out I downloaded a project from the repository to fix a bug, it asks for Nuget.exe. As I…
-
0
votes1
answer51
viewsQ: Write to oracle without repeating name
I have this block inside a record label that records a representative, which comes from a screen in ASP Classic. v_qtd_rep := ts_obtem_dados_no_xml(v_no_completo,'QTD_REP'); for i in 1..v_qtd_rep…
-
1
votes1
answer959
viewsQ: How I list the Packages in the oracle
How do I query(PL/SQL) to list a specific Package existing in the database(Oracle)?
-
1
votes1
answer355
viewsQ: I cannot close a tab(tab) with javascript
My universe is as follows: The attendant is with an open guide, making, obviously, a service. To end this service, URA already starta a second service. Turns out IVR opens another tab. By closing…
-
0
votes2
answers110
viewsA: Problem with regular expression in Asp.net with Angularjs(1)
I resolved so: <label for="celular" class="col-sm-1 control-label">Celular</label> <div class="col-sm-2"> <input id="celular" class="form-control input-sm" name="celular"…
-
1
votes2
answers110
viewsQ: Problem with regular expression in Asp.net with Angularjs(1)
On this site, I got this regex: @"^\(?\d{2}\)?[\s-]?[\s9]?\d{4}-?\d{4}$" Then I tried to adapt to my reality, my rule which is: Only accept digit(number) in the input. I’m not there those things…
-
0
votes1
answer190
viewsQ: Write to bank only chekbox checked at angular
How do I record only checkboxes that are checked. Check this out, I have this example and when I record is recording the 22 items. <li> <label class="requerido">Profissoes</label>…
-
0
votes2
answers738
viewsA: Paging with Angularjs and Webapi
I was able to make the Slice with this code. I’m just not able to bring the navigation buttons between the pages: var app = angular.module('app', []);…
-
0
votes2
answers738
viewsQ: Paging with Angularjs and Webapi
I need to make a pagination using AngularJS. Well, I made a controller for a popular one Table HTML. This is now working. My next step is to page this table. I picked up an example on the internet,…
-
0
votes1
answer334
viewsA: Error while trying to consume Webapi service
I added these lines to my web.config and solved: <system.webServer> <httpProtocol> <customHeaders> <clear /> <add name="Access-Control-Allow-Origin" value="*" />…
-
4
votes1
answer4462
viewsQ: Change port or something on IIS Express. Is there a way?
How can I change a port or something in Visual Studio 2013’s IIS Express.
-
4
votes1
answer334
viewsQ: Error while trying to consume Webapi service
since this morning I try to catch a JSON that a WebAPI available. I first tried with insira o código aquiAngularjs and was not evolving, so I went to the classic Jquery/Ajax and yet I did not…
-
0
votes2
answers737
viewsQ: Angular Controller does not render on my Index
I can’t render a script on my _Layout page. I put in _Layout, together with the Bundles declarations and Chrome debug, in the Network Tab comes with 304 status. I put it at the top of the…
-
4
votes1
answer62
viewsQ: Doubt regarding good practices with virtual properties
I have a project that contains my classes that represent my entities in my BD. So, as an example goes there: On the table Endereco, I get a FK of Bairro(IdBairro). To play better in mine POCO, what…