Search results for query: *

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...

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?

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...

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...

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?

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...

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...