Search:

Type: Posts; User: leinad31

Page 1 of 13 1 2 3 4

Search: Search took 0.30 seconds.

  1. Re: Generating 10 unique random numbers from 1-50 in visual basic 2010

    Since it's a small set (almost like a deck of cards) you can just preload the 50 numbers into an array, "shuffle" the array (randomly swap), then "draw" or access the first ten array items.
  2. Replies
    43
    Views
    6,233

    Re: Apple's next big thing

    Fashion.. clothing and accessories to go with their devices hehehehe
  3. Replies
    9
    Views
    1,313

    Re: [Serious] Estimation methodologies.

    Don't ask the performers, they'll estimate based on their own pace but everyone else can't keep up (turn around time delays). Change the question, instead ask the performers which part of the...
  4. Replies
    1
    Views
    541

    Re: Getting different results

    Post sample data. People need to see how the data is organized in your table (data type included).
  5. Re: I want an alternative to SQL/MySQL Database

    You will have to learn server based solutions. If you can make it work over the network then it will work via a localhost connection (still over "network"). Your solution has to be scalable. What...
  6. Replies
    9
    Views
    1,366

    Re: How to check who is using the record

    Or you could re-architect the system so that rather than updating a row, you would perform inserts that can be summed later. This has the advantage of storing the history of the stock level.
  7. Replies
    1
    Views
    1,176

    Re: speed up to open recordset...

    Do you have indexes setup for the following?

    L_SI.DATA_ESECUZIONE <-- this helps reduce the number of rows returned, or reduces the number of intermediate rows that will be joined to CODICI...
  8. Replies
    12
    Views
    957

    Re: SQL: Is this possible?

    It would be best if you posted sample data for the tables... off the top of my head, what determines the number of rows returned per Name (how come there's always 4 rows per given Name)?
  9. Replies
    14
    Views
    3,238

    Re: High Volume Database Design Decisions

    You need to implement partitioning, you have no choice but to learn it.

    To add to what others have mentioned, you need to consider page/block level locking of indexes. Indexes cause locking,...
  10. Re: cascade delete with link table keeps getting error

    I suggest you post the script you use to create the cascade delete relationship
  11. Re: Insert decimal with dot instead of comma?

    Simply format the data upon display/presentation to user. How it is stored in the database (is it 1 byte per 2 digits like in oracle, or is storage to memory of numeric data type comparable to...
  12. Re: Multiple values in an OracleParameter (or SQLParameter)

    "Oracle Collections can be represented as an array of .NET Types. For example, an Oracle Collection type of NUMBER can be mapped to an int[]." --...
  13. Replies
    2
    Views
    1,012

    Re: Running Total Query

    http://stackoverflow.com/questions/664700/calculate-a-running-total-in-mysql

    It would have been better implemented via analytic functions but I don't think they are available in MySQL....
  14. Replies
    7
    Views
    1,407

    Re: Summing across fields.... not down rows...

    If this is SS2005 then you can use unpivot http://weblogs.sqlteam.com/jeffs/archive/2008/04/23/unpivot.aspx
  15. Re: Oracle - Create type not working

    What is the ORA error and where/when is it raised?
  16. Replies
    4
    Views
    2,342

    Re: SqlBulkCopy/Transaction/resume?

    Question is why the row insertion failed?

    Are you really doing bulk insertion in its purest sense (minimal validation/constraints or prevalidated such as data type guaranteed to be correct, and...
  17. Replies
    4
    Views
    532

    Re: Question about "Best Practice".

    You can use two name fields with the other editable for printing or whatever purposes; think alias.

    For audit purposes, e.g. document/receipt is reproducible as it was years ago, store copy of...
  18. Re: SQL query - can this be done without a loop?

    Just don't forget to handle cyclic redundancy (root/ancestor is also child)
  19. Re: SQL query - can this be done without a loop?

    What you need is support for hierarchical queries, unfortunately it is not supported by sqlite.

    Either you change your database to one that supports hierarchical queries, or build the tree in at...
  20. Replies
    34
    Views
    8,547

    Re: recommend a technoligical book

    Software Project Secrets - Why Software Projects Fail
    George Stepanek
    Apress


    Suggested non-techie book:
    A Peacock in the Land of Penguins
    BJ Gallagher and Warren H. Schmidt
  21. Replies
    5
    Views
    888

    Re: (+) in Sql

    I'm just guessing but it's probable related to tree view control: (+) to expand, (-) to collapse :)

    The table column in the join with the (+) is the one that can be thought of as "expandable" into...
  22. Replies
    1
    Views
    464

    Re: Online Database

    You shouldn't expose the database for security purposes. What you will do is find an online host for your database and the web application connected to it. Users will have access to the web app,...
  23. Thread: Select Query

    by leinad31
    Replies
    12
    Views
    1,263

    Re: Select Query

    If the query is correct in the database then the problem is at your front-end. Check the properties of your controls; maybe it is set to display distinct rows only. Check your triggered events;...
  24. Thread: Select Query

    by leinad31
    Replies
    12
    Views
    1,263

    Re: Select Query

    Try running your query dirctly on the database. Check if the result is correct. It's possible that query is correct but front end control property or code is filtering out the other rows.

    Divide...
  25. Thread: Select Query

    by leinad31
    Replies
    12
    Views
    1,263

    Re: Select Query

    if you want to retain all child records then do a left join on e.ITEM_NBR = a.ENFANT and remove validite condition.
  26. Thread: Select Query

    by leinad31
    Replies
    12
    Views
    1,263

    Re: Select Query

    Try querying the database directly for each table, then both tables using a DB tool to check that your query is logically correct before trying to implement it at your front-end.

    If parent table...
  27. Replies
    5
    Views
    892

    Re: Table Relationship question

    Design is similar to star-schema of data warehouse but was implemented incorrectly. Did the hosting company explain why you needed to reduce the number of tables? Denormalization leads to increased...
  28. Replies
    11
    Views
    1,282

    Re: Question about SQL

    The client determines the values that will be passed. If 1 wasn't passed by client when it should have been then there is a logical error at the client code.

    Writing the where criteria that way...
  29. Replies
    11
    Views
    1,282

    Re: Question about SQL

    It filters the result... either you retrieve records with attribute1 IS NULL ( 1=1 ) or you retrieve records that match another parameter. Without that, you will end up retrieving both and excluding...
  30. Replies
    2
    Views
    438

    Re: Join confusion - sql 2005

    If there is only one record in resultset then there is no point in sorting.

    You need to clarify what you meant by "I need this recordsset to display one record" as it can be suggested that you...
  31. Thread: Pivot query

    by leinad31
    Replies
    1
    Views
    465

    Re: Pivot query

    Why wait for an answer when you can read up on it immediately http://msdn.microsoft.com/en-us/library/ms177410.aspx
  32. Replies
    11
    Views
    1,282

    Re: Question about SQL

    Depends on the mapping of parameters at front-end to ? in query... it is possible that one particular value encoded by user corresponds to several questions marks rather than typical one parameter...
  33. Replies
    2
    Views
    489

    Re: Slow query for multi condition [WHARE]

    Not sure how predicate pushing occurs in SQL Server but inline query can be rewritten with condition LEFT(a.productcode,2) = 'AR' . Also everyone will have to guess because we don't know how your...
  34. Thread: Normalisation

    by leinad31
    Replies
    5
    Views
    752

    Re: Normalisation

    You can separate nationality, but if it will hardly be searched on then it won't be practical to do so and you're better of with existing column author.nationality.

    You can separate genre, and use...
  35. Replies
    3
    Views
    692

    Re: using if exists result?

    Just iterate through result of query, if iteration count is zero then there were no records.
  36. Re: Creating a Reverse Index on MS SQL Server

    You will need to add a column... see if a computed column is feasible http://msdn.microsoft.com/en-us/library/ms189292.aspx if not, then table trigger populates/updates value for additional column...
  37. Replies
    8
    Views
    1,212

    Re: simple database - need help plzzz...

    There are two types of knowledge... (1) knowing off the top of your head and (2) knowing where to look (references list).

    You need to develop both.
  38. Re: [vb6][ADODB] Detecting if there are records, if not then add

    The function simply returns True if there are rows in the recordset, false otherwise (rs state is not open or rs pointer either at BeginningOfFile=True or EndOfFile=True).

    The error is raised...
  39. Replies
    3
    Views
    539

    Re: Get latest logs query

    If you have relevant indexes then you can do a NOT EXISTS correlated query to ensure that the record is the latest for that particular user, app. If you don't have relevant indexes and will have to...
  40. Replies
    28
    Views
    10,561

    Re: why we use composite primary key?

    If the theoretical approach is so much better then why not direct your questions at people working in the academe? They are more qualified to give you the answers you want to hear.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width