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!

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

Recent content by bmeza

  1. bmeza

    how to select rows that not meet a join condition

    hi, how can i do to select those invoices that their numbers parts have rate "tlcan" and dont have a valid "tlcan" certificate of origin for the invoice date select claused have 3 tables and a just want those rows that not meet the join condition here its my code select invoice, date, part...
  2. bmeza

    filter select

    when the @p_depto its blanks i want to select all, wnen its different i just want to select that depto how can do it?
  3. bmeza

    filter select

    I have @depto beachible and I want to make a filter in "select" when @depto is different from blanks here its my code: declare @depto as varchar(12) set @depto='1500' if @p_depto!='' begin select distinct p_parte,p_depto from products where p_type in ('A', 'P') and p_status='A' and...
  4. bmeza

    bulk insert

    Hi, I have a text file and I want to use bulk insert, I now how to do it, but in the text file I have header record and detail record, how can I make a difference to insert in boot tables;the text file can have lot a heaaders and details example text file H^MP^319267228^17-FEB-06^^^^GXB...
  5. bmeza

    CR Change database location at run time vb6 help!!!!

    vidru thaks, im usigng cr8.5 and vb6, and i try before that solutions but i still comming the database set by default... do you now another solutions?
  6. bmeza

    Change Crystal report DB location at run time for VB6

    hi, im using cr 8.5 and vb6.0 and i have same problem ? and i try the solutions but still using the database defined in the .rpt file did you fine other solution? Here its my code: For Each crxDBTable In Reporte.Database.Tables crxDBTable.SetLogOnInfo GsServidor1, GsBaseDatos1...
  7. bmeza

    CR Change database location at run time vb6 help!!!!

    Hi I have a report that use Microsoft sql server to connect at data base and I want to change the data base at run time in vb6.0; But I always get the data base that I put in cr at set location here its my code: For Each crxDBTable In Reporte.Database.Tables...
See more

Part and Inventory Search

Back
Top