Search Results - CodeGuru Forums
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: RH+

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    612

    Re: MySql not using index with IN and subquery

    Maybe I didnt explain something right
    if I execute:

    SELECT CG FROM CODE
    WHERE sitio='AAA'

    the result is: '26022','26023','26024'
  2. Replies
    2
    Views
    612

    MySql not using index with IN and subquery

    I have a Mysql database with 2 tables:
    clientes and code
    clientes have a field called celda (index called CG)
    and code have a field called CG (index called CG)

    they have the same data type

    I...
  3. Replies
    1
    Views
    690

    Re: Get date of last appearance of value on table

    Don't answer this, im an idiot. After a long day making complex querys I couldnt resolve a simple:
    Select name,max(date)
    from table
    where number<>0
    group by name;
  4. Replies
    1
    Views
    690

    Get date of last appearance of value on table

    I didnt know how to title this thread...
    I have a table with name,a number and a date.
    I need to get the date in wich, that number changed from zero from end to start.

    For example:
    I have ...
  5. Thread: From VB6 to web

    by RH+
    Replies
    0
    Views
    685

    From VB6 to web

    Hi, im not sure if this is the best place to post this, if its wrong please move it.
    I've been doing some things in VB6 and veeeery little in VB.NET (using 95% VB6 stuff, and only changing things...
  6. Replies
    13
    Views
    1,272

    Re: Trouble with dates after reinstalling MSSQL

    Today they give me admin access for 5 minutes...they created the user and set "spanish" for language...it should be "English", corrected that. All working as it should.
    Obviously they have to pay...
  7. Replies
    13
    Views
    1,272

    Re: Trouble with dates after reinstalling MSSQL

    Before the re-installation and in all my projects it works with "/", I can edit all the SQLs statements, but Im trying to know what have change in the SQL server, and need to show that they triggered...
  8. Replies
    13
    Views
    1,272

    Re: Trouble with dates after reinstalling MSSQL

    I'm using yyyy/mm/dd:

    fechaInicio.Value = Format(DTPInicio.Value, "yyyy/MM/dd")
  9. Replies
    13
    Views
    1,272

    Re: Trouble with dates after reinstalling MSSQL

    Thanks viperbyte, I'll try that tomorrow.
    I Just look and see that they have change the collation too...I'll try resetting that to the previous value.
    I can change anything of my DB but not a lot...
  10. Replies
    13
    Views
    1,272

    Re: Trouble with dates after reinstalling MSSQL

    The problem seems to be that it needs now the dates in other format:
    dd/mm/yyyy instead of YYYY/mm/dd...for the type of application I have dates everywhere, SPs, lots of queries, etc. I figured that...
  11. Replies
    13
    Views
    1,272

    Re: Trouble with dates after reinstalling MSSQL

    Yes
  12. Replies
    13
    Views
    1,272

    Trouble with dates after reinstalling MSSQL

    I have one project running on a DB on MSSQL 2k, with other *big* 3rd party software.
    2 days ago they have a problem with MSSQL, and for some reason instead of looking for the problem they installed...
  13. Replies
    8
    Views
    1,997

    Re: How to create a view in access (from vb6)

    If I dont use the view the query is something like this, I know the view works and this query is VERY hard to follow =/


    SELECT Leg.leg_numero as legajo,month(liq.liq_fecha) as...
  14. Replies
    8
    Views
    1,997

    Re: How to create a view in access (from vb6)

    The query is:
    Create view NAME(field1,field2)
    AS select field1, field2 from table where condition

    I dont think im having an error there. The database is user locked because is from a software...
  15. Replies
    8
    Views
    1,997

    Re: How to create a view in access (from vb6)

    Im trying to use a system I developed for MSSQL in access doing the minimun amount of changes, in that SQL I have a view where I execute all queries, I'll try with other methods then...or just skip...
  16. Replies
    8
    Views
    1,997

    How to create a view in access (from vb6)

    I have a access file, and need to create a view from VB6.
    This isnt working:
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\SJA068.mdb;Persist Security Info=False"

    ...
  17. Re: Fill Datagridview intercalating data from 2 queries

    Sorry for the bump, first and last time...I'm stuck with this =/
    thanks!
  18. Fill Datagridview alternating data from 2 queries

    I have a Datagridview, It will have pairs of lines:
    first line: requested customer
    second line: assigned quantity for that item for that customer

    Something like:...
  19. How do I encrypt connectionString in app.settings

    I have this now:


    <connectionStrings>
    <add name="DataProject.My.MySettings.CobrosConnectionString"
    connectionString="Data Source=***.**.***.**;Initial Catalog=test;User...
  20. Re: How to copy data from a DB to other DB in different server

    Sorry, That is what I have now :S sorry about not telling that before
    I have the 2 connection strings, have the first query.
    But dont know what to do with the result of the first query (sorry Im...
  21. How to copy data from a DB to other DB in different server

    I have to query one table and insert the result in a table on another database in another server
    The query is "select ID, name from Table"
    The other table exists and have the same fields.
    How can...
  22. Re: How to update one table with the different elements of table1-table2

    I like the temp table because this process is done 1 time each month, I think it will be better than go thought a datareader looking for elements from another datareader to do the inserts.
    I'll try...
  23. Re: How to update one table with the different elements of table1-table2

    Databases are on different servers
    And I need to be sure that the table with more records (its always the same DB) is Read Only.
    So I need to copy the new items from that table to the other table....
  24. Re: How to update one table with the different elements of table1-table2

    That's works when the tables are from the same DB, this are from different DBs, so I have 2 connection strings and I cant do that in only one query (I think).
    The tables fields are: IDClient,...
  25. How to update one table with the different elements of table1-table2

    I have 2 databases.
    Table in database 1 has 5 fields
    Table in database 2 has 15 fields

    I made 2 querys that retrieve the 5 fields from the first and 5 fields from the second that are the same...
Results 1 to 25 of 199
Page 1 of 8 1 2 3 4


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center