Recent content by meny21

Hi guys, I used to work with SP's since few months, but I would like to improve myself with SQL Server Managment Studio 2005. Do you know guys tips about how to debug SP's with this tool? I mean something that you use when this is needed or maybe a good tip that you find on this tool that you...

Hi Guys, I used to work with VB 6.0 but now for work reasons we need to use VB .Net 2005 or 2008. Some people told me that .Net is very different that the VB 6 Version and I would like to find a very good training course in order to lear this 2005 or 2008 version. Do you know guys about a...

Hi Guys, I almost finish an application but I missing the last part, maybe you can give me some suggestions about how to do this thing: My application creates a File on my Local Directory (For example... C:\Myfile.txt) I need to send this file to another server by FTP Conection. For example...

Hi Guys, I almost got it but I decided your opinion on this: I have a String Variable called "MyFileName" and I Would like to concatenate with date and Time, Example: MyFileName = MyFileName & "_" & Year(Date) & "_" & Month(Date) & "_" & Day(Date) With this I have two questions: 1 - It...

Hi guys, I would like to have suggestions about how to do this thing: I have two tables: HeaderTable: Index field1 (InvoiceNo) field2 (InvoiceDescription) DetailTable Index Field1 (ItemCode) Field2 (Item Description) it Can be only one header and "N" details For example: InvoiceNo...

Hi guys, Do you know if it is possible to do this on XML? somebody told me to verify this option. I have two tables: HeaderTable: Index field1 (InvoiceNo) field2 (InvoiceDescription) DetailTable Index Field1 (ItemCode) Field2 (Item Description) Can be one header and "N" details For...

Hi bborissov, I'm new in XML, what do you think? Will be easier? if yes how can I start about trying with XML for this issue? I was thinking in the programming by XML looks interesting... Regards!

Thanks TheSQL I will check the Programming option... Regards!

Thanks TheSql, I think with an example will be a better and understable view... HeaderTable: Index field1 (InvoiceNo) field2 (InvoiceDescription) DetailTable Index Field1 (ItemCode) Field2 (Item Description) Can be one header and "N" details For example: InvoiceNo: 1000...

Thanks, for example I have this table Created: TableHeader: HeaderField1 HeaderField2 HeaderField3 DetailTable: DetailField1 DetailField2 DetailField3 DetailField4 And I need to convert this SQL Tables on this Delimiter Text File...

Hi Guys, I Need Ideas about have to build this issue, maybe you got good sugestions... The thing is that I need to create a File using Pipes "|" delimiters, for example like this: CFD|2.0||5847|012345678901234567890|4598|2007|ABC|A|1|20/09/2007|15:12:03| First I thought in create a SQL Table...

Hi Guys, It works! Thanks!

Hi Guys, Do you know how can I do this in classic Select? I have a field in my table that has negative values and positive values, for example: -1 -4 5 6 343 -34 I need just to put this in my select: Select MyField From MyTable But MyField if the value is positive to put "Positive" and if...

Hi Guys, I'm using a ListBox Control on Visual Fox Pro 6.0 Does anyone knows how can I use this control to count the records that I have in the ListBox? Recordcount? ItemIndex? Thanks for any help <MR>

Hi Sunila, Thanks for the information, I think this is what I need... just when I tried to put the BCP in my SP on SQL 9.0 Version it doesn't recognize this command... did you use it before? Thanks! MR