Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dido
  • Order by date
  1. dido

    case sensitive stored procedure

    When trying to import a SP it fails and says 'must declare the variables @day @month @year'. If I change these to @Day, @Month @Year then it's ok. However this procedure is still giving me problems that lead me to believe it is case sensitive. I had changed the collation of the db to...
  2. dido

    select record based on value of previous record?

    Thank you so much! I didn't know about that function and it works a treat. Thanks.
  3. dido

    select record based on value of previous record?

    does anyone know how to select a record based on the value of a previous record in the table. So if records where numbered 1,2,3,4,5,..... can I select a field for record 5 if the value of that field for record 4 is a certain value. EXAMPLE No. Name 1 river 2 tree 3 house Show...
  4. dido

    Change YearToDate start Date

    Thanks a lot I'll give it a go.
  5. dido

    Change YearToDate start Date

    Does anyone know if it is possible and if so how to change the start date for the YearToDate function. Say for example the year started on 1/03/02 how would one include any yearToDate records but only from 01/03/02 e.g. for a financial year?
  6. dido

    Hide Records?

    The formula is Increase = {@RunningSumTo}/{@RunningSumFrom} RunningSumTo = WhilePrintingRecords; Global NumberVar RunningSumTo := RunningSumTo + {@YearToAmount}; RunningSumFrom = WhilePrintingRecords; Global NumberVar RunningSumFrom := RunningSumFrom + {@YearFromAmount}; I have been able...
  7. dido

    Hide Records?

    I have a field called increase which is from a formula base on one formula over another. (i.e. Amount 1/Amount 2). This is placed in the group footer. How can I only show records where the increase is great than 10. The formula is not an option in the select expert.
  8. dido

    Exceptions

    I can't find where to disable the debug error exceptions at compile time.. I use BCB3 Standard.
  9. dido

    ActiveX Document Can't be viewed from another machine

    Well boys and girls finally the answer to how make your VBDocuments works on machines conected in a intranet or internet is to simply just sign yor .cabs files! how do that well.. write me for details

Part and Inventory Search

Back
Top