Search Results - VBForums

Search:

Type: Posts; User: sapator

Page 1 of 13 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: private property of list of string will also display on calling object

    <DataMember()>
    Private m_seats As List(Of String)

    Solved. I've wrongly set it as datamember. Super blind mode on!
  2. Re: private property of list of string will also display on calling object

    I've set this as Protected Friend m_seats As List(Of String)
    but i still don't understand why it will show in the first place.
    Any opinions?

    EDIT! Nop it will still show!
  3. [RESOLVED] private property of list of string will also display on calling object

    Hi.


    <DataContract(), KnownType(GetType(List(Of String))), XmlSerializerFormat()>
    <Serializable()>
    Public Class setorder
    '.......
    <DataMember()>
    Public Property seats As...
  4. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Actually using select will bring 4 null columns! Suppose something is wrong here.
    Guys, let it go. I have reduced the job latency of the query and i think this has taken more than it's worth looking...
  5. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Yes it is a column name on table movie. I don't know, it works.
    The table is strange but here:


    USE [VT_External]
    GO

    /****** Object: Table [dbo].[MOVIE] Script Date: 16/2/2015 3:50:03 μμ...
  6. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    It will compare the id of prm_code and see if there are any same id's in Mov_director. But the run time is the same so, bleh!
    11200 lines in the table. It's not so big, if i remove the <> comparison...
  7. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Hi.
    First this is not my query. So i am not responsible for alias but as i see it the alias are there until the author did not use them in the where. Maybe he was trying to get the initial results?...
  8. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Well the initial question was if there is a way to do an not equal comparison without using the "<>".
    Apparently all the joins confused everyone. If there not an easy way i guess i will have to go...
  9. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    The right part anyhow, is because some codes are 12 chars and we need the first 6 and the trim is because of first and last name merger that (you've guessed it) join with the description table that...
  10. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Unfortunately i cannot change anything on the design. I can only add parametric tables. The company is having a contract with an international firm and they can change the DB's and Applications in...
  11. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Also trying like this


    select *
    FROM VEXTERNAL.dbo.MOVIE M
    RIGHT JOIN (SELECT Film_strCode,MAX(Person_strCode) as Person_strCode FROM VISTAHO.dbo.tblFilmPerson WHERE FPerson_strType='D' GROUP...
  12. Replies
    17
    Views
    433

    Re: trying to get rid of in a query

    Trying this but i get no results.

    WHERE (NOT EXISTS(select prm_code from movie inner join parametric on movie.mov_director = parametric.prm_code)
  13. Replies
    2
    Views
    154

    Re: greek character issue in xml

    Yep that did it.
    Thanks!
  14. Replies
    2
    Views
    154

    [RESOLVED] greek character issue in xml

    using this:


    <?xml version="1.0" encoding="utf-8" ?>
    <returnorder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    ...
  15. Replies
    17
    Views
    433

    trying to get rid of in a query

    select *
    FROM VTEXTERNAL.dbo.MOVIE M
    RIGHT JOIN (SELECT Film_strCode,MAX(Person_strCode) as Person_strCode FROM VISTAHO.dbo.tblFilmPerson WHERE FPerson_strType='D' GROUP BY Film_strCode) FP
    ON...
  16. Replies
    2
    Views
    115

    Re: create xml and xml schema

    Alright.
    Thanks.
  17. Replies
    2
    Views
    115

    [RESOLVED] create xml and xml schema

    Hi i am goggling around and all i can find is either create xml and either schema.
    Is it possible to do both and merge to an xml document?
    I suppose i can do it manually (yuck!) but i was looking...
  18. Re: How to pass value between classes.

    Well as i couldn't figure something out, i changed the transport security to use Certificate and not Username Password. That way i don't need the extra class as the Cert will take over and i could...
  19. Re: Unable to cast object of type 'System.Collections.Generic.List`1[System.String]'

    Actually, this does the trick as shown in the OP :


    <DataContract(), KnownType(GetType(List(Of String))), XmlSerializerFormat()>

    After that everything seems to fall into place and i don't...
  20. Re: Unable to cast object of type 'System.Collections.Generic.List`1[System.String]'

    Had to remove XmlSerializerFormat() from service contract.
    Seems if you declare this to 2 places it get crazy results! MS?!!!
  21. [RESOLVED] Unable to cast object of type 'System.Collections.Generic.List`1[System.String]' to t

    Unable to cast object of type 'System.Collections.Generic.List`1[System.String]' to type 'WindowsApplication1.ServiceReferenceVSAPI.ArrayOfString'.
    What is going on here? I cannot find a simple...
  22. Re: https custom validation will still use ssl?

    thanks.
  23. Re: How to pass value between classes.

    The validate overrides a WCF transport security call. So whn the client pass username and password the validate would get them. I'm not so sure on what you suggest.
    Should i make a class that holds...
  24. [RESOLVED] How to pass value between classes.

    Common question i know but i've been at work for 10 hours so i can't think.
    I have these"


    Imports System.IdentityModel.Tokens
    Imports System
    Imports System.ServiceModel
    ' NOTE: You can use...
  25. Replies
    5
    Views
    422

    Re: Going back to WCF, using SSL

    This has , as i am testing now, been resolved.
    There was an issue with the certificate so i requested a valid one from the company and it seems to work now.
  26. https custom validation will still use ssl?

    Hi.

    I am creating a custom validation, meaning something like:


    <basicHttpBinding>
    <binding name="defaultBasicHttpBinding">
    <security mode="TransportWithMessageCredential">...
  27. Replies
    5
    Views
    422

    Re: Going back to WCF, using SSL

    the issue is here:


    <configuration>
    <system.serviceModel>
    <behaviors>
    <serviceBehaviors>
    <behavior name="VSAPIBehavior">
    <serviceMetadata...
  28. Replies
    5
    Views
    422

    Re: Going back to WCF, using SSL

    Ok, i kinda fixed that i guess or it will come back. Anyhow now i have created 2 solutions. One wcf library and one wcf application. The library seems to work fine, meaning will open the wcf (then...
  29. Replies
    5
    Views
    422

    Re: Going back to WCF, using SSL

    Ok took care of the vs2010 issue (you don't wanna know @#$#$@#$@#$ Microsoft).
    So back to this ""An error occurred while making the HTTP request to https://localhost/servicemodelsamples/service.svc....
  30. Replies
    5
    Views
    422

    Re: Going back to WCF, using SSL

    P.S just migrated to VS2010 and nothing works! System servicemodel is not there?
    Got to look at this again.
  31. Replies
    5
    Views
    422

    [RESOLVED] Going back to WCF, using SSL

    Hey,


    <security mode ="TransportWithMessageCredential">
    <message clientCredentialType="UserName" />


    I am trying to work out an ssl - certificate site. This time the company has...
  32. Re: Do a "Isolation level" usage throough linked server.

    I though that nolcoks will not lock the data for your query but I've read that the can still lock other queries that do update or delete operations. I'm pretty sure that it does that at least with...
  33. Re: Do a "Isolation level" usage throough linked server.

    Will try and see. Have to find a "loose" day.
  34. Re: Do a "Isolation level" usage throough linked server.

    I don't know man i don't know. I mean this has a couple of million rows.Let alone that i have 5-10 joins to tables. I can try it in an early morning with minimal traffic but again....
    If i do a...
  35. Re: Do a "Isolation level" usage throough linked server.

    No lock actually don't make anything better here.Am i right to believe that no lock will make your select to ignore locks? If so then does the select lock other operations run by other t-sql...
  36. Re: Do a "Isolation level" usage throough linked server.

    Bear in mind that this is not your typical company. It has 10 back offices with millions of customers. The "remote" db's differs from site to site but it's from 5GB to 60GB. The remote tables are...
  37. Re: Do a "Isolation level" usage throough linked server.

    Have you ever tried it?
    Isolation got us into so much trouble as we locked customers down. So i cannot "go for it" without a confirmation. You wouldn't want me to come and visit you when you are in...
  38. Replies
    0
    Views
    173

    Link C# issue to VB

    I'm trying to convert this C# to VB.
    As i do not know jack about link i get an error that the table not declared. and another error specified below


    //C#
    protected static string...
  39. Do a "Isolation level" usage throough linked server.

    Hi.
    I am running a query that goes through multiple SQL server in other sites with linked server.
    The issue is that the query goes trough some heavy tables and is blocking other transactions.
    I...
  40. Re: ASP.NET Ajax numericUpDownExtender Problem

    Now i lost you.
    What command?
    How do you try to reset?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.